Бытовая техника

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (38841,
43390,
43389,
43388,
42834,
42833,
42832,
42749,
40814,
40813,
40812,
14296,
38207,
37293,
37292,
36412,
36145,
34918,
33834,
32893,
21858,
21809) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername