select c_root_folder_id as parent_id from content_item_globals update cr_items set live_revision = :revision_id, latest_revision = :revision_id where item_id = :item_id