Рюкзаки с принтом

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (31278,
22838,
17983,
20096,
18820,
20101,
24458,
24459,
23715,
29875,
8629,
29899,
29900,
29901,
29902,
29903,
25046,
8676,
25319,
24301,
24816,
24818,
24820,
24828) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername