Well, this has proven to be a bit of a wild goose chase so far!
I've had a few offline discussions with Richard Ridings as well, and I now have a query that works fine (thanks Richard!) - as long as it is run manually. I can run all three - manually…