Any query optimizer worth its salt will push the filters below the join.