Медали

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (23085,
8281,
5729,
23412,
23414,
23415,
23416,
23417,
23418,
23419,
26289,
13503,
23751,
23752,
23753,
23755) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername