South Australia, Australia


Interactive Map

Result Pages:
Club NameClub HeadContact PersonCityState/ProvinceCountryClub Logo
Adelaide Comets Football Club Adelaide South Australia Australia Adelaide Comets Football Club
Adelaide Hellenic Lions Club Inc Adelaide South Australia Australia Adelaide Hellenic Lions Club Inc
Adelaide Imbros Partors Soccer Club Goodwood South Australia Australia Adelaide Imbros Partors Soccer Club
Adelaide Omonoia Soccer Club-Cobras Marleston South Australia Australia Adelaide Omonoia Soccer Club-Cobras
Argonafpliakon Ass.Of Sa- Palamidi Inc Torrensville South Australia Australia Argonafpliakon Ass.Of Sa- Palamidi Inc
Ass. Of Friends Of Byzantine Ecclesiastical Music, Sa Torrensville Plaza South Australia Australia Ass. Of Friends Of Byzantine Ecclesiastical Music, Sa
Australian Greek Society For Care Of The Elderly Adelaide South Australia Australia Australian Greek Society For Care Of The Elderly
Brotherhood Of Karitsa, Sa Inc Adelaide South Australia Australia Brotherhood Of Karitsa, Sa Inc
Castellorizian Brotherhood S.A. Inc Torrensville South Australia Australia Castellorizian Brotherhood S.A. Inc
Chios Associaton Of S.A. "O Korais" Inc. Adelaide South Australia Australia Chios Associaton Of S.A. "O Korais" Inc.
Constantinople Hellenic Association Of South Australia Inc. Kensington Gardens South Australia Australia Constantinople Hellenic Association Of South Australia Inc.
Corinthian Association Of Sa Adelaide South Australia Australia Corinthian Association Of Sa
Council For The Greek Cultural Month Adelaide South Australia Australia Council For The Greek Cultural Month
Cretan Association Of S.A. Daw Park South Australia Australia Cretan Association Of S.A.
Cyprus Community Of Sa Αguas Santas South Australia Australia Cyprus Community Of Sa
Elion Society Of Sa "The Olympic Flame" Adelaide South Australia Australia Elion Society Of Sa "The Olympic Flame"
Flambouron Philanthropic Society Of S. Australia Inc. Brooklyn Perk South Australia Australia Flambouron Philanthropic Society Of S. Australia  Inc.
Genadian Charitable Ass Evangelismos Inc Kent Town South Australia Australia Genadian Charitable Ass Evangelismos Inc
George Gronthos Colonel Light Gardens South Australia Australia George Gronthos
Greek Community & Parish Of Prophet Elias Aabyhoj South Australia Australia Greek Community & Parish Of Prophet Elias
Result Pages:
By Type
  |--> Club
  |--> Club
  |--> Club
  |--> Club
  |--> Club
  |--> Club
  |--> Club
  |--> Club
  |--> Club
  |--> Other
  |--> Other
  |--> Other
  `--> Other
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 = '13' and pa.entry_state = 'South Australia' and pa.entry_city = 'Marleston' group by clubs_type order by clubs_type asc

[TEP STOP]