Наушники

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (7690,
1321,
26941,
26942,
26943,
2881,
2882,
2378,
2379,
28246,
13912,
28249,
13916,
23156,
35505,
3509,
24504,
24505,
30176,
3577) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername