 AND other is not null
 and a.agent_pk_id = fe14.functionalizing_entity_pk_id
 ;
-
-
-
-/*
-insert into canano.activation_method
-(
-	activation_method_pk_id,
-	type
-)
-SELECT distinct  pf.particle_function_pk_id,
-	pf.activation_method
-FROM cananolab.particle_function pf,
-	cananolab.linkage l,
-	canano.functionalizing_entity fe14
-Where fe14.functionalizing_entity_pk_id = l.linkage_pk_id
-and l.function_pk_id = pf.particle_function_pk_id
-and pf.activation_method is not null
-and pf.activation_method != ""
-;
-*/
 
 
 -- nano_function using cananolab.linkage.function_pk_id as function_pk_id

WHERE a.agent_pk_id = l.linkage_pk_id
AND l.function_pk_id = pf.particle_function_pk_id
AND pf.nanoparticle_pk_id = c14.particle_sample_pk_id
AND a.discriminator != 'ImageContrastAgent'
;


WHERE a.agent_pk_id = l.linkage_pk_id
AND l.function_pk_id = pf.particle_function_pk_id
AND pf.nanoparticle_pk_id = c14.particle_sample_pk_id
AND a.discriminator != 'Other'
AND a.discriminator != 'ImageContrastAgent'
;

