Can you post the table sizes ?

I do not understand the construction around Table_G.
This looks 'nondeterministic' which could cause problems. The number of different results that this subquery can give, can be very limited (is my impression).
So what is the size of Table_G.

If there are multiple rows in Table_G for 'Status 1' or for 'Status 2' etc, I do see a problem and probably a solution.

Ben