Всего выполнено запросов: 14 шт. за 0.0025 сек. Развернуть Закрыть
Ошибка в 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,IFNULL((SELECT pv.price_course FROM mg_product_variant AS pv WHERE pv.product_id = p.id AND count != 0 ORDER BY pv.price_course ASC LIMIT 1), 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, pv.count)) AS varcount FROM `mg_product_variant` AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE p.recommend = 1 and p.activity=1 GROUP BY p.id ORDER BY sort ASC LIMIT 0, 60
Can't create/write to file '/var/tmp/#sql_835_1.MAI' (Errcode: 28)

/var/www/ascompany/data/www/ascompany.kz/mg-core/lib/navigator.php (line 73)

/var/www/ascompany/data/www/ascompany.kz/mg-core/models/catalog.php (line 413)

/var/www/ascompany/data/www/ascompany.kz/mg-core/controllers/group.php (line 52)

/var/www/ascompany/data/www/ascompany.kz/mg-core/lib/moguta.php (line 0)

/var/www/ascompany/data/www/ascompany.kz/mg-core/mg-start.php (line 0)

/var/www/ascompany/data/www/ascompany.kz/index.php (line 90)