[Ciandlah]

I had the same problem a while back, I just done this. INstead of having one huge Query,

Split everything into two querys, for example

FIrst query you will have from IP - Job and the rest you would have in a second query from Job to the bottom.

If I understood your question properly this is what worked for me when my pawno crashed while attempting to understad a large query