1055. Query Error 1055: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ft28.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(68,4,42,66,58,59,55,56,57,63,64,60,67,69,73) GROUP BY p.id ORDER BY cp1.sort ASC LIMIT 30