apply all filters as a single filter (rather than a chain) to avoid unnecessary or problematic joins