Interestingly, and rather annoyingly, by adding a hint as per Michaels post, it shaves half a second off by joining in the order we specified. It's now running at 1.5...

Thanks for all your quick responses.

I've hopefully attached the execution plan. I've had to change all the table and column names as per company policy, sorry.

Basically, query 1 is it...