Подарки на День Победы 9 мая

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (1162,
2884,
2581,
2579,
1424,
1386,
1385,
1384,
1197,
1195,
1166,
1164,
1163,
405,
1050,
1049,
1004,
1003,
1001,
968,
924,
801,
800,
665,
406) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername