I am not sure why did they use no lock hint. They use without blocking. Might be they don't need accurate data. The dev lead think that we can do some changes and bring some more optimization to the query.

They want to me create the a temptable or table variable for the main query output and then try to avoid the left outer join.