select parent_id from cr_items where item_id = :file_id delete from acs_permissions where object_id in (select revision_id from cr_revisions where item_id = :file_id) select name as title from cr_items where item_id = :file_id