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(773,774,777,776,775,780,779,789,791,797,798,790,800,785,803,805,804,792,796,795,793,781,787,784,783,782)
GROUP BY p.id
ORDER BY cp1.sort ASC
LIMIT 30
