Электроника

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (854,
855,
856,
857,
983,
1041,
1042,
1043,
1044,
1045,
1055,
1091,
1108,
1109,
1110,
1111) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername