Новогодний мерч

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (26298,
35846,
35845,
35844,
35843,
35842,
35841,
35574,
31895,
26828,
26799,
5138,
23962,
18805,
18005,
9801,
9796,
9793,
9789,
9781,
8813,
7055) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername