 |
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 = '223' and pa.entry_state = 'Virginia' and pa.entry_city = 'Charlottesville' group by clubs_type order by clubs_type asc
[TEP STOP]
|
