SQL Hiba: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'serpenti_db.regions.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT regions.id, regions.title region_title FROM regions INNER JOIN viszonteladok ON viszonteladok.region_id = regions.id GROUP BY region_title ORDER BY region_title