Всего выполнено запросов: 23 шт. за 0.0057 сек. Развернуть Закрыть
Ошибка в SQL запросе: SELECT DISTINCT p.id, CONCAT(c.parent_url,c.url) AS category_url, c.unit AS category_unit, p.unit AS product_unit, c.weight_unit AS category_weightUnit, p.weight_unit AS product_weightUnit, p.url AS product_url, p.*, pv.product_id AS variant_exist, rate, (p.price_course + p.price_course * (IFNULL(rate,0))) AS `price_course`, IF(p.count <0, 1000000, IF(varcount, IF(p.count 0, -10, p.cat_id) AS cat_id,p.price_course AS `price_course_sort` 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, round(pv.count,2))) AS varcount FROM `mg_product_variant` AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE p.id IN (NULL) and p.activity=1 GROUP BY p.id ORDER BY sort ASC('',' LIMIT 0, 9999
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '('',' LIMIT 0, 9999' at line 22

/home/admin/web/shop.royalcosmetics.ru/public_html/mg-core/lib/navigator.php (line 75)

/home/admin/web/shop.royalcosmetics.ru/public_html/mg-core/models/catalog.php (line 427)

/home/admin/web/shop.royalcosmetics.ru/public_html/mg-core/controllers/favorites.php (line 72)

/home/admin/web/shop.royalcosmetics.ru/public_html/mg-core/lib/moguta.php (line 0)

/home/admin/web/shop.royalcosmetics.ru/public_html/mg-core/mg-start.php (line 0)

/home/admin/web/shop.royalcosmetics.ru/public_html/mg-core/index-start.php (line 126)

/home/admin/web/shop.royalcosmetics.ru/public_html/index.php (line 4)