 
 create table temp_new_class_temp as select * from CF_TEMP_CLASSIFICATION where 1=2;
 
+-- huge bit of duplication caused by terms coming from lots of sources - ignore that for now, but keep it around in case it's useful later
+
+create table temp_new_names_nos as select SCIENTIFIC_NAME,SOURCE_RANK  from temp_new_names group by SCIENTIFIC_NAME,SOURCE_RANK;
+alter table temp_new_names_nos add status varchar2(4000);
+
 
 ----------->
 

	select * from  temp_new_class_temp where 1=2
</cfquery>
<cfquery name="d" datasource="uam_god">
	select * from temp_new_names_fd where status is null and rownum <= 2
</cfquery>
<cfoutput>
	<cfloop query="d">

			</cfquery>
			<cfdump var=#temp#>
			<cfquery name="g" datasource="uam_god">
				update temp_new_names_nos set status ='k' where scientific_name='#scientific_name#'
			</cfquery>
		</cftransaction>
	</cfloop>
