Ошибка в 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 1=1 AND ((IFNULL(ABS((SELECT SUM(ABS(count)) FROM mg_product_on_storage WHERE product_id = pv.id)), 0)
+ ABS((SELECT SUM(ABS(count)) FROM mg_product_on_storage WHERE product_id = p.id AND p.image_url != "no-img.jpg"))) > 0) AND (p.old_price > p.price) AND ( ((p.price_course + p.price_course * (IFNULL(rate,0))) BETWEEN '14400' AND '556000')OR ((pv.price_course + pv.price_course * (IFNULL(rate,0))) BETWEEN '14400' AND '556000') ) AND ( ( cat_id IN ('25','37','22','45','23','48','2','41','42','39','44','46','49','3','40','47','4','5','6','7','35','8','36','9','14','10','11','12','50','19','20','38','21','24','15','17','18','16','1') or FIND_IN_SET(1,p.`inside_cat`))) AND p.`activity` = 1 ORDER BY `price_course_sort` desc LIMIT 0, 24
Disk full (/tmp/#sql_413_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")/var/www/unico/data/www/femmeretail.kz/mg-core/lib/navigator.php (line 73)
/var/www/unico/data/www/femmeretail.kz/mg-core/models/catalog.php (line 431)
/var/www/unico/data/www/femmeretail.kz/mg-core/models/catalog.php (line 103)
/var/www/unico/data/www/femmeretail.kz/mg-core/controllers/catalog.php (line 172)
/var/www/unico/data/www/femmeretail.kz/mg-core/lib/moguta.php (line 0)
/var/www/unico/data/www/femmeretail.kz/mg-core/mg-start.php (line 0)
/var/www/unico/data/www/femmeretail.kz/index.php (line 98)