Наборы с ручками под логотип

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (34934,
43595,
43594,
43593,
40514,
37523,
37522,
36225,
36223,
36222,
36221,
36220,
36219,
4145,
22891,
22890,
22889,
12623,
9074,
9053,
9051,
9048,
9046,
9043,
8027) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername