Товары для путешествий

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (24856,
22043,
22044,
22045,
22046,
22047,
22048,
4678,
4680,
4685,
4686,
4687,
24687,
7303,
7305,
7307,
7309,
22414,
24744,
1205,
1206,
18109,
18114,
18116,
18121) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername