Спортивная одежда

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (1324,
1663,
1664,
1725,
1726,
1729,
1734,
1735,
1736,
1737,
1746,
1747) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername