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


Ошибка в SQL запросе: SELECT distinct p.id, CONCAT(c.parent_url,c.url) as category_url, 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`, p.currency_iso FROM `sfs_product` p LEFT JOIN `sfs_category` c ON c.id = p.cat_id LEFT JOIN `sfs_product_variant` pv ON p.id = pv.product_id WHERE ( cat_id IN (5771,5772,5773,5775,5776,5777,5778,5779,5780,5781,5782,5783,5784,5786,5787,5788,5789,5790,5791,5792,5793,5794,5795,5796,5797,5798,5799,5800,5801,5802,5803,5804,5805,5806,5807,5808,5809,5810,5811,5812,5813,5814,5815,5816,5817,5818,5819,5820,5821,5822,5823,5824,5825,5826,5827,5828,5829,5866,5831,5832,5833,5834,5835,5836,5837,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5839,5840,5841,5842,5843,5844,5850,5851,5848,5852,5853,0) or FIND_IN_SET(0,p.`inside_cat`) ) AND p.`activity` = 1 ORDER BY `sort%7C-1` asc
Unknown column 'sort%7C-1' in 'order clause'


/var/www/safework/data/www/shop.safework.ru/mg-core/lib/navigator.php (line 99)


/var/www/safework/data/www/shop.safework.ru/mg-core/lib/navigator.php (line 50)


/var/www/safework/data/www/shop.safework.ru/mg-core/models/catalog.php (line 217)


/var/www/safework/data/www/shop.safework.ru/mg-core/models/catalog.php (line 99)


/var/www/safework/data/www/shop.safework.ru/mg-core/controllers/catalog.php (line 108)


/var/www/safework/data/www/shop.safework.ru/mg-core/lib/moguta.php (line 35)


/var/www/safework/data/www/shop.safework.ru/mg-core/mg-start.php (line 52)


/var/www/safework/data/www/shop.safework.ru/index.php (line 100)