Бумажные и эко ручки с логотипом

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (34207,
35551,
35550,
35549,
35548,
35547,
35546,
34212,
34211,
34210,
34209,
34208,
902,
34206,
34205,
10881,
7154,
7151,
7149,
5188,
5187,
5186,
5185,
5184) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername