Turns out my original query was dumb, though perfectly legal SQL. MySQL
couldn't handle the 'dumb' which is kinda surprising but there you go.