Стаканы

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (24626,
39047,
37856,
34147,
34146,
33428,
33127,
32961,
26712,
25080,
25022,
25021,
24627,
5253,
20840,
20834,
20826,
20824,
17731,
17726,
7360,
6843,
6836,
6835,
6834,
5254) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername