Problem found. Maybe this should be addressed in the MySQL visual query designer?
I created my query in PhpMyAdmin and tested to confirm it worked.
Next my DW query was created and I cut n paste the same query which created the recordset without issue... BUT this create the LIMIT 1 twice since it is also in the WA_MySQLi_RS function.
Reopening the Query Editor and closing it sorted the problem and now things work as expected.