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

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