Query Error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'and_autorazbor.sp1.sort' which is not in SELECT list; this is incompatible with DISTINCT
Query: SELECT DISTINCT p.*,p.id
FROM shop_product p
JOIN shop_set_products sp1
ON p.id = sp1.product_id
WHERE p.status = 1
AND sp1.set_id = 'promo'
ORDER BY sp1.sort ASC
LIMIT 500