Filtrovat výrobce

Špatný dotaz: Unknown column 'middle' in 'where clause'
select distinct sk.poradi,flt.id,cf.id as id_filtr,flt.nazev,flt.id_skupina,sk.nazev as skupina from (filtr flt,katalog_filtr kf) left join katalog k on k.id = kf.id_katalog left join skupina sk on sk.id = flt.id_skupina left join cc_filtr cf on cf.nazev = flt.nazev where flt.id = kf.id_filtr and flt.id_kategorie in(middle) and kf.prirazen="A" and k.zobrazovat = "A" order by sk.poradi,flt.id_skupina,flt.poradi,flt.nazev