update cr_items set live_revision = :revision_id, latest_revision = :revision_id where item_id = :item_id select revision_id from cr_revisions where item_id = :item_id and revision_id > :revision_id order by revision_id