Настольные аксессуары

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (42776,
43588,
43587,
43586,
43585,
43584,
43583,
43582,
43240,
43239,
42991,
42835,
1529,
42449,
39189,
39163,
39162,
35606,
35558,
35532,
35531,
34977,
34913,
34912) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername