Самокаты и гироскутеры

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (25378,
25379,
25380,
25381,
25382,
25383,
25390,
25391,
25392,
25393,
25394) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername