Игры и головоломки

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (25778,
44856,
43630,
42740,
36167,
34939,
33896,
32157,
25782,
25781,
25780,
25779,
5725,
25777,
25082,
19975,
19970,
19965,
17139,
13062,
13058,
6989,
6987,
6983) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername