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

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (34977,
40834,
40833,
36142,
35606,
35557,
35556,
35555,
35554,
35553,
35552,
35531,
1529,
34913,
34912,
26825,
26824,
26823,
26822,
12619,
7961,
7959,
3274) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername