By Type
By Country
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'greek_communities.c.countries_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select countries_id, countries_name, count(countries_id) as countries_total from clubs_address_book pa, clubs p, countries c where pa.clubs_id = p.clubs_id and p.clubs_status = 1 and pa.entry_country_id = c.countries_id and c.continents_code = 'SA' group by countries_name