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 = '84' and pa.entry_state = 'Thessaloniki' and pa.festival_id = p.festival_id group by festival_type order by festival_type asc