select parent_id from cr_items where item_id=:file_id select name from cr_items where item_id=:file_id update cr_items set live_revision=:revision_id where item_id=:item_id