Yorkshire, United Kingdom

Interactive Map

Result Pages:
Result Pages:
By Type
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 = '222' and pa.entry_state = 'Yorkshire' and pa.festival_id = p.festival_id group by festival_type order by festival_type asc