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

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