logo wikipedals
Search Brands Types Collections Pedalboards Sign Up Follow Us
Error in MySQL
Query: SELECT *, COUNT(*) as tot FROM fx_brands f LEFT JOIN brand_to_fx b ON b.brand_id = f.id WHERE b.brand_id IS NOT NULL GROUP BY b.brand_id ORDER BY tot DESC,brand_name ASC LIMIT 48
Error
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wikipedals_db.b.brand_to_fx_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by