 delete from match_blob m
 where exists
 	(
-		select
+		select 1
 		from snomed_ancestor a
 		join match_blob b on
 			b.s_id != m.s_id and

						(
							'111941005',	--Familial disease
							'255051004',	--Tumor of unknown origin
							'255054007',	--Tumor of ill-defined site
							'363357005',		--Malignant tumor of ill-defined site
							'127332000',	--Fetal neoplasm
							'115966001',	--Occupational disorder
							'10749871000119100',	--Malignant neoplastic disease in pregnancy
							'765205004',	--Disorder in remission
							'302817000',	--Malignant tumor of unknown origin or ill-defined site
							'127274007', --Neoplasm of lymph nodes of multiple sites
							'448563005',	--Functionless pituitary neoplasm
							--BROKEN IN CURRENT SNOMED: CHECK THIS NEXT RELEASE!
							'96901000119105' --Prostate cancer metastatic to eye (disorder)
						)
			)
)

					'109851002', --Overlapping malignant neoplasm of retroperitoneum and peritoneum
					'254388002', --Overlapping neoplasm of oral cavity and lips and salivary glands
					'109919002', --Overlapping malignant neoplasm of peripheral nerves and autonomic nervous system
					'109948008', --Overlapping malignant neoplasm of eye and adnexa, primary
					'188256008' --Malignant neoplasm of overlapping lesion of urinary organs 
				)
			
		) and 
