Подарочные наборы с термокружками

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (26082,
36405,
35349,
34909,
34906,
34905,
34016,
34015,
34012,
34011,
34007,
26083,
10280,
25873,
25872,
24475,
23602,
23601,
23600,
23599,
21135,
21133,
21132,
16431) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername