Very Slow Query with CTE inner join

I hadn't tried due to the size of the result set, 3.5 million rows when I only need a few rows. I will try it as a test shortly, thanks.