Часы и метеостанции

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (17939,
17940,
17943,
17944,
22051,
3623,
22063,
1362,
1363,
19835,
11133,
1165,
19086,
22418,
22423,
6873,
10738) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername