# Запрос номер 1: SET names utf8 (0.0001 msec ) /var/www/www-root/data/www/teplovoi.com/mg-core/lib/db.php (line 241)
# Запрос номер 2: SELECT `value` FROM `mg_setting` WHERE `option` = 'useDefaultSettings' (0.0003 msec ) /var/www/www-root/data/www/teplovoi.com/mg-core/lib/mg.php (line 0)
# Запрос номер 3: SELECT `option`, `value` FROM `mg_setting` (0.0004 msec ) /var/www/www-root/data/www/teplovoi.com/mg-core/lib/mg.php (line 0)
Ошибка в 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(variantsExists > 0, varcount, IF (p.`count` < 0, 1000000, p.`count`)) AS `count_sort`, p.currency_iso, IF(IFNULL(c.url, "") = "" AND p.cat_id <> 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, 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.old_price>p.price_course || pv.old_price>pv.price_course) and p.activity=1 AND (p.count != 0 || pv.count != 0) GROUP BY p.id ORDER BY p.price_course ASC, p.`id` ASC LIMIT 0, 6/var/www/www-root/data/www/teplovoi.com/mg-core/lib/navigator.php (line 75)
/var/www/www-root/data/www/teplovoi.com/mg-core/models/catalog.php (line 478)
/var/www/www-root/data/www/teplovoi.com/mg-core/controllers/group.php (line 65)
/var/www/www-root/data/www/teplovoi.com/mg-core/lib/moguta.php (line 0)
/var/www/www-root/data/www/teplovoi.com/mg-core/mg-start.php (line 64)
/var/www/www-root/data/www/teplovoi.com/mg-core/index-start.php (line 126)
/var/www/www-root/data/www/teplovoi.com/index.php (line 4)