cr_items.latest_revision is the most recent edit. cr_items.live_revision is the "approved" revision.
This should do what you need, I think, should the currently displayed version, and the most recently edited version.
