update cr_items set live_revision = :latest_revision_id where live_revision = :live_revision_id update cr_revisions set publish_date = now() where revision_id = :latest_revision_id update acs_objects set modifying_user = :user_id, last_modified = now() where object_id = :latest_revision_id