Подарки на День строителя

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (4326,
34831,
34830,
33361,
33360,
25785,
25300,
25288,
24051,
15910,
6658,
4792,
1051,
4325,
4238,
3357,
2955,
2954,
2953,
2952,
2887,
1369,
1065,
1063) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername