Всего выполнено запросов: 24 шт. за 0.2167 сек. Развернуть Закрыть

# Запрос номер 1: SELECT @@sql_mode (0.0001 msec ) /home/i/infomuvn/moguta.muzton.com/public_html/mg-core/lib/db.php (line 47)

# Запрос номер 2: SET @@sql_mode='' (0 msec ) /home/i/infomuvn/moguta.muzton.com/public_html/mg-core/lib/db.php (line 57)

# Запрос номер 3: SET names utf8 (0 msec ) /home/i/infomuvn/moguta.muzton.com/public_html/mg-core/lib/db.php (line 241)

# Запрос номер 4: SELECT `value` FROM `mg_setting` WHERE `option` = 'useDefaultSettings' (0.0002 msec ) /home/i/infomuvn/moguta.muzton.com/public_html/mg-core/lib/mg.php (line 0)

# Запрос номер 5: SELECT `option`, `value` FROM `mg_setting` (0.001 msec ) /home/i/infomuvn/moguta.muzton.com/public_html/mg-core/lib/mg.php (line 0)

Ошибка в SQL запросе: SELECT count(distinct p.id) AS count FROM mg_product p LEFT JOIN mg_category c ON c.id = p.cat_id LEFT JOIN mg_product_variant pv ON p.id = pv.product_id LEFT JOIN ( SELECT pv.product_id, SUM(IF(pv.count <0, 1000000, pv.count)) AS varcount, COUNT(pv.`id`) as variantsExists FROM mg_product_variant AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE ((p.cat_id IN ('191') or FIND_IN_SET(191,p.`inside_cat`))) AND p.activity = 1 AND (SELECT DISTINCT `count` FROM mg_product_on_storage WHERE product_id = p.id) AND ((SELECT SUM(ABS(count)) FROM mg_product_on_storage WHERE product_id = p.id) != 0)
Subquery returns more than 1 row

/home/i/infomuvn/moguta.muzton.com/public_html/mg-core/models/catalog.php (line 226)

/home/i/infomuvn/moguta.muzton.com/public_html/mg-core/controllers/catalog.php (line 176)

/home/i/infomuvn/moguta.muzton.com/public_html/mg-core/lib/moguta.php (line 0)

/home/i/infomuvn/moguta.muzton.com/public_html/mg-core/mg-start.php (line 64)

/home/i/infomuvn/moguta.muzton.com/public_html/mg-core/index-start.php (line 126)

/home/i/infomuvn/moguta.muzton.com/public_html/index.php (line 6)