Сумки для документов

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (4871,
33135,
26660,
26659,
19038,
18056,
18053,
18048,
8762,
8759,
8757,
7808,
4872,
1035,
4870,
4099,
4098,
4097,
3524,
3523,
2604,
1040,
1039,
1038,
1037,
1036) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername