Completed Parallel Nested Query Trasform