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