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

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (26297,
41492,
39097,
38917,
38916,
38898,
37968,
37967,
36873,
36872,
36871,
36870,
34612,
9167,
26296,
26295,
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