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

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