Sorry for the delay I have now attached the query.

Query 1 and query 2 takes approximately two minutes to run but query 3 takes around 9 hours which was running under 30 minutes before.

Nothing has changed in recent times from the In-depth I can only see high CPU usage for query 3