Unknown column 'DFA__THS_T' in 'SELECT': SELECT country,MAX(anno) as anno_max, `DFA__THS_T` FROM eu_production_data WHERE country IN ('AT','BE','BG','CY','HR','DK','EE','FI','FR','DE','GR','IE','IT','LV','LT','LU','MT','NL','PL','PT','CZ','RO','SK','SI','ES','SE','HU') AND (`DFA__THS_T`IS NOT NULL OR (`DFA__THS_T` IS NULL AND `DFA__THS_T_flags` LIKE '%c%')) AND country NOT LIKE 'LU' GROUP BY country