Database Query Failed: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'spellanywhere.core_leas.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - (SELECT schools.id AS id, schools.name AS name, core_leas.name AS lea, count( spelling_lists.id ) AS n FROM spelling_lists LEFT JOIN schools ON spelling_lists.school_id = schools.id LEFT JOIN core_leas ON schools.lea = core_leas.number WHERE spelling_lists.active = 1 AND schools.id != 218 AND schools.username != 'admin' GROUP BY school_id ORDER BY n DESC) Spellanywhere