select content from cr_revisions where revision_id = :live_revision