Антистрессы

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (42768,
42769,
42794,
11325,
42815,
43329,
43330,
4677,
42829,
20558,
32120,
36985,
26241,
26244,
26246,
26247,
44711,
26538,
11459,
11463,
45007,
45008,
40418,
23268,
8683,
42992) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername