I was able to get it to work by creating a new page and starting the query very simply, one step at a time and then it worked... But it's still odd tha tif you go back to edit, the query window sets Limit 1 without being prompted to do so.
I'll add a screen shot.
One screen shot shows how it was when submitted and the other shows what is present on reopening the query.