select revision_id from cr_revisions where item_id = :item_id select org_id from ims_cp_organizations where man_id = :man_id delete from ims_cp_items_map where man_id = :man_id and org_id = :org_id and community_id = :community_id