I totally agree. Until now I had some doubt that content_item__get_live_revision does something else, e.g. checking for the publish_status and returning null if it's not live, but I just looked it up and it doesn't - it just retrieves the live_revision column value. It's fair enough after all to assume that an item is live as soon as it has an entry in live_revision.