By Type
1054 - Unknown column 'pt.types_name' in 'group statement'

select festival_type, count(festival_type) as type_total from festivals_address_book pa, festivals p, countries c where pa.festival_id = p.festival_id and p.festival_status = 1 and pa.entry_country_id=c.countries_id and c.continents_code = 'EU' group by p.festival_id, festival_type, pt.types_name order by festival_type asc

[TEP STOP]