subquery removed