Error in MySQL
Query: SELECT *, COUNT(fx_id) as tot FROM fx_to_bucket b LEFT JOIN fx_effects f ON f.id = b.fx_id WHERE f.fx_approved = 1 GROUP BY b.fx_id ORDER BY tot DESC LIMIT 100
Error
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wikipedals_db.b.ftb_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by