 				'Has causative agent',
 				'Has interpretation',
 				'Occurs after',
-				'Has due to',
-				'Has occurrence'
+				'Has due to'
 			)
 	left join concept_relationship r1 on --refers to morphologies that are not neoplasms
 		r1.relationship_id = 'Has asso morph' and

update concept_stage
set standard_concept = 'S'
where
	domain_id = 'Condition' and
	standard_concept is null and -- not 'C'
	invalid_reason is null and
	concept_code not in
		(
			select concept_code_1
			from concept_relationship_stage
			where relationship_id = 'Maps to'
		)
;
--24. Since our relationship list is cannonically complete, we deprecate all existing relationships if they are not reinforced in current release
--24.1. From ICDO3 to SNOMED

	'ICDO3',
	'SNOMED',
	'Maps to',
	TO_DATE ('19700101', 'yyyymmddd'),
	TO_DATE ('20991231', 'yyyymmddd')
from r_to_c_all
join monorelation on concept_code = code1
left join code_replace on
