Брюки и шорты

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (36525,
26555,
26556,
33642,
34872,
34873,
36522,
36523,
36524,
25438,
36526,
36527,
36528,
36529,
40613,
42577,
42578,
5509,
25437,
25436,
25435,
25225,
25224,
25216,
25215,
25213,
25212,
25179,
23881,
5513,
5512,
5511,
5510) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername