Пивные бокалы с логотипом

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (43016,
5955,
24942,
5251,
5252,
17284,
24966,
24967,
26771,
14495,
14499,
32677,
29113,
29115,
29116,
6846,
5848,
17384,
17395,
17399,
25081,
8189) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername