Akita-ken, Japan


Interactive Map

Result Pages:
Club NameClub HeadContact PersonCityState/ProvinceCountryClub Logo
Akita International University Akita-shi Akita-ken Japan Akita International University
Result Pages:
By Type
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'alumni_associations.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, 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 entry_country_id = '107' and pa.entry_state = 'Akita-ken' and pa.clubs_id = p.clubs_id group by clubs_type order by clubs_type asc

[TEP STOP]