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

Ошибка в SQL запросе: SELECT DISTINCT p.id, CONCAT(c.parent_url,c.url) AS category_url, c.unit AS category_unit, p.unit AS product_unit, 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 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.code IN('07286','09104','08814') ORDER BY FIELD(p.code,'07286','09104','08814') LIMIT 0, 18
Got error 28 from storage engine

/var/www/u0375880/data/www/uniel.shop/mg-core/lib/navigator.php (line 73)

/var/www/u0375880/data/www/uniel.shop/mg-plugins/group-prices/index.php (line 682)

/var/www/u0375880/data/www/uniel.shop/mg-plugins/group-prices/index.php (line 540)

/var/www/u0375880/data/www/uniel.shop/mg-core/lib/eventhook.php (line 82)

/var/www/u0375880/data/www/uniel.shop/mg-core/lib/pm.php (line 0)

/var/www/u0375880/data/www/uniel.shop/mg-plugins/minimal-count/index.php (line 75)

/var/www/u0375880/data/www/uniel.shop/mg-core/lib/eventhook.php (line 82)

/var/www/u0375880/data/www/uniel.shop/mg-core/lib/pm.php (line 0)

/var/www/u0375880/data/www/uniel.shop/mg-core/lib/mg.php (line 0)

/var/www/u0375880/data/www/uniel.shop/mg-core/mg-start.php (line 0)

/var/www/u0375880/data/www/uniel.shop/index.php (line 98)