 |
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 = 'ME' group by countries_name
[TEP STOP]
|
Clubs
Communities
Cultural Associations
Social Associations
State Offices
