Ежедневники и блокноты

select distinct filters.filterid, filters.filtername, filters.filtertypeid
from filters, filters_in_products 
where filters_in_products.product_id in (2929,
26602,
4471,
4470,
4468,
4332,
4124,
4123,
4121,
3722,
3327,
2932,
2930,
782,
2928,
2927,
2926,
2925,
2260,
2258,
2257,
2256,
2255,
1536,
1531) and 
filters.filtertypeid = filters_in_products.fitertype_id and
filters.filterid = filters_in_products.filter_id 
 order by filters.filtername