>Break this query to smaller pieces (CTEs) and it would be much easier to manage.
>
>Say,
>
>;with cte1 (my Inner query), cte2 as (select Something from cte1 inner join ...), cte3 as (second query joined with something else), cte4 as (select *, row_number() from cte3)
>
>select * from cte4 where RowNum = 1

That's what I already have.