 |
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'greek_festivals.p.festival_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select p.festival_id, festival_title, festival_type, count(festival_type) as type_total from festivals_address_book pa, festivals p where pa.festival_id = p.festival_id and p.festival_status = 1 and entry_country_id = '73' and pa.entry_state = 'Aquitaine' and pa.festival_id = p.festival_id group by festival_type order by festival_type asc
[TEP STOP]
|
