Yay - just a little more googling.
Query was fine. DB needed to be compacted and repaired as I had just removed about 20000 records prior to this.
Hope it helps someone else some day.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.