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

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (36871,
43071,
42379,
42377,
41492,
39097,
38917,
38916,
38898,
37968,
37967,
36873,
36872,
9167,
36870,
34612,
26079,
26078,
26077,
26076,
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