Инструменты

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (2480,
2481,
2482,
2485,
2486,
3596,
3597,
5949,
6616,
6656,
13430,
34601,
34602) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername