Подарочные наборы с чаем

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (26517,
42204,
34402,
34401,
34400,
33536,
33534,
33533,
33532,
33531,
33003,
26520,
8453,
26516,
26515,
26269,
24499,
24498,
8602,
8601,
8462,
8459,
8458,
8455) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername