1055. Query Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'supergifts_new.cp1.sort' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query: SELECT 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(853,917,918,919,920,921,922,923,924,926,927,978,979,980)
GROUP BY p.id
ORDER BY cp1.sort ASC
LIMIT 30
