Зажигалки

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (6161,
6162,
2835,
2836,
6164,
2837,
6165,
2838,
6167,
6168,
2610,
3140,
2913,
2914,
2915,
20872,
20873,
20874,
20875,
20877,
20879,
20883,
20886,
1210,
1211,
1212) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername