West Midlands, United Kingdom

Interactive Map

Result Pages:
Club NameClub HeadContact PersonCityState/ProvinceCountryClub Logo
Hellenic Honorary Consulate in Birmingham Birmingham West Midlands United Kingdom Hellenic Honorary Consulate in Birmingham
Result Pages:
By Type
By City
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'greek_communities.p.clubs_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.clubs_id, p.clubs_name, clubs_type, count(clubs_type) as type_total from clubs_address_book pa, clubs p where pa.clubs_id = p.clubs_id and p.clubs_status = 1 and pa.entry_country_id = '222' and pa.entry_state = 'West Midlands' and pa.entry_city = 'Birmingham' group by clubs_type order by clubs_type asc