Panama, Panama

Interactive Map

Result Pages:
Club NameClub HeadContact PersonCityState/ProvinceCountryClub Logo
Πανελληνιο Ιδρυμα Κοινοτητας Παναμα Ciudad De Panama Panama Panama Πανελληνιο Ιδρυμα Κοινοτητας Παναμα
Result Pages:
By Type
---> Panama
  `--> Club
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 = '164' and pa.entry_state = 'Panama' and pa.entry_city = 'Ciudad De Panama' group by clubs_type order by clubs_type asc