Визитницы

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (598,
627,
727,
1030,
1365,
1611,
2461,
2462,
2463,
2464,
2466,
2978,
2999,
4112,
41592,
41593) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername