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

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (25777,
34939,
33896,
32709,
32539,
32209,
32208,
25782,
25781,
25780,
25779,
25778,
5725,
25082,
23798,
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