Элементы брендирования и кастомизации

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (2574,
2576,
25365,
32576,
32577,
32578,
32579,
32588,
32589,
32590,
32591,
32604,
32605,
32606,
32607,
33141,
33142,
25768,
25770) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername