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