Конфеты, сладости, печенье

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (35648,
34126,
33117,
34405,
34407,
41833,
41834,
41836,
41837,
41838,
40596,
40597,
40598,
24500,
33989,
43717,
42205,
42206,
42207,
42208,
20720,
34040,
34041,
40701,
40702,
24575) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername