ООО "Грифон" - официальный дилер ПАО "КАМАЗ"
Ростовская область, х. Маяковского, ул. Заводская, д. 49
info@kamaz61.ru
+7 (863) 303-00-77

3065. Query Error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'kamaz61.ru.cp1.sort' which is not in SELECT list; this is incompatible with DISTINCT Query: SELECT DISTINCT p.*,p.id FROM shop_product p JOIN shop_category_products cp1 ON p.id = cp1.product_id WHERE p.status = 1 AND cp1.category_id IN(7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25) ORDER BY cp1.sort ASC LIMIT 30

Запрашиваемый ресурс недоступен.