Барные аксессуары

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (32794,
38743,
36180,
36133,
36132,
36037,
34919,
34727,
34686,
32927,
32838,
32835,
32832,
5045,
32308,
25074,
23723,
21881,
21722,
20013,
16657,
7492,
6741,
6474,
5206) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername