Кубки

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (4354,
4355,
4356,
4947,
26250,
30874,
30875,
30876,
30877,
30881,
30882,
30883,
30884,
30885,
26283,
26288,
4530,
23237,
23238) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername