PHOENIX-943 Handle pushed down post-filters for subquery in joins with limit and non-groupby aggregation