MySQL 3.x doesn't support nested queries, so it's not legal. The CVS for MySQL 4 should.