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
Запрашиваемый ресурс недоступен.