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

# Запрос номер 2: SELECT `value` FROM `mg_setting` WHERE `option` = 'useDefaultSettings' (0.0001 msec ) /home/c7603/armastock.ru/docs/mg-core/lib/mg.php (line 0)

# Запрос номер 3: SELECT `option`, `value` FROM `mg_setting` (0.0003 msec ) /home/c7603/armastock.ru/docs/mg-core/lib/mg.php (line 0)

Ошибка в SQL запросе: SELECT 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 FROM `mg_product` AS p LEFT JOIN `mg_category` AS c ON c.id = p.cat_id LEFT JOIN `mg_product_variant` AS pv ON p.id = pv.product_id LEFT JOIN ( SELECT pv.product_id, SUM(IF(pv.count <0, 1000000, pv.count)) 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.cat_id IN ('36') or FIND_IN_SET(36,p.`inside_cat`))) AND p.activity = 1 GROUP BY p.id ORDER BY `count_buy%7C1` ASC, p.`id` ASC LIMIT 0, 48
Unknown column 'count_buy%7C1' in 'order clause'

/home/c7603/armastock.ru/docs/mg-core/lib/navigator.php (line 75)

/home/c7603/armastock.ru/docs/mg-core/models/catalog.php (line 254)

/home/c7603/armastock.ru/docs/mg-core/controllers/catalog.php (line 176)

/home/c7603/armastock.ru/docs/mg-core/lib/moguta.php (line 0)

/home/c7603/armastock.ru/docs/mg-core/mg-start.php (line 64)

/home/c7603/armastock.ru/docs/mg-core/index-start.php (line 126)

/home/c7603/armastock.ru/docs/index.php (line 6)