Спортивный инвентарь

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (26296,
43071,
42379,
41492,
39097,
37968,
37967,
36873,
36872,
36871,
36870,
34612,
26297,
9167,
26295,
26079,
26078,
26077,
26076,
25381,
25380,
20692,
20690,
19730,
19725,
9169) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername