Well, it has been a while since I was able to get back to this project. I had been side tracked by another.
To my surprise this has been a very active thread. Wow! You are all so amazing. Thank you!
I used your advice and moved parts of the sub query to the outer query. Then I removed references to the outer query in the sub query. I also broke out the second sub query into its own query and passed it's results into the main query.
I am happy to say the execution time of this page is now instant!
