The subquery should be run once we have all the filters in place -- fixes unit-tests