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

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (33003,
42204,
37813,
36410,
36409,
36354,
34402,
34401,
34400,
8453,
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