By Type
---> Cairo
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 = '63' and pa.entry_state = 'Cairo' and pa.entry_city = 'Cairo' group by clubs_type order by clubs_type asc