update cr_items set live_revision = :revision_id where item_id = :template_id