That is because you're recordset was set to use inner join. I set it to use left join instead to fix the problem.
with inner join, it will return a result if there is a match on both sides, where no revision record existed yet, it would not return a result.
see this page for more details o the join types:
http://www.sitepoint.com/understanding-sql-joins-mysql-database/