Подарочные наборы изделий из кожи с логотипом

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (16884,
24238,
24236,
24234,
22883,
21945,
19746,
19745,
19740,
19735,
4051,
16875,
16838,
16291,
16290,
16282,
16280,
16265,
16261,
10485) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername