Сувениры к 23 февраля

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (2950,
42344,
3637,
3386,
3356,
3244,
3074,
3005,
3004,
3003,
3002,
536,
2887,
2594,
2578,
2577,
2467,
1954,
1669,
1667,
1225,
928) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername