 		select count(*) c from project
 	</cfquery>
 	<cfquery name="accn_projects" datasource="uam_god" cachedwithin="#createtimespan(0,0,60,0)#">
-		select 
+		select
 			count(distinct(project.project_id)) c
-		from 
+		from
 			project
 		where
 			project_id in (
-				select project_id from project_trans,cataloged_item 
+				select project_id from project_trans,cataloged_item
 				where project_trans.transaction_id=cataloged_item.accn_id)
 			and project_id not in (
-				select project_id from project_trans,loan_item 
+				select project_id from project_trans,loan_item
 				where project_trans.transaction_id=loan_item.transaction_id)
 	</cfquery>
 	<cfquery name="loan_projects" datasource="uam_god" cachedwithin="#createtimespan(0,0,60,0)#">
-		select 
+		select
 			count(distinct(project.project_id)) c
-		from 
+		from
 			project
-		where 
+		where
 			project_id in (
-				select project_id from project_trans,loan_item 
+				select project_id from project_trans,loan_item
 				where project_trans.transaction_id=loan_item.transaction_id)
 			and project_id not in (
-				select project_id from project_trans,cataloged_item 
+				select project_id from project_trans,cataloged_item
 				where project_trans.transaction_id=cataloged_item.accn_id)
 	</cfquery>
 	<cfquery name="both_projects" datasource="uam_god" cachedwithin="#createtimespan(0,0,60,0)#">
-		select 
+		select
 			count(distinct(project.project_id)) c
-		from 
+		from
 			project
 		where
 			project_id in (
-				select project_id from project_trans,loan_item 
+				select project_id from project_trans,loan_item
 				where project_trans.transaction_id=loan_item.transaction_id)
 			and project_id in (
-				select project_id from project_trans,cataloged_item 
+				select project_id from project_trans,cataloged_item
 				where project_trans.transaction_id=cataloged_item.accn_id)
 	</cfquery>
 	<cfquery name="neither_projects" datasource="uam_god" cachedwithin="#createtimespan(0,0,60,0)#">
-		select 
+		select
 			count(distinct(project.project_id)) c
-		from 
+		from
 			project
-		where 
+		where
 			project_id not in (
-				select project_id from project_trans,loan_item 
+				select project_id from project_trans,loan_item
 				where project_trans.transaction_id=loan_item.transaction_id)
 			and project_id not in (
-				select project_id from project_trans,cataloged_item 
+				select project_id from project_trans,cataloged_item
 				where project_trans.transaction_id=cataloged_item.accn_id)
 	</cfquery>
 	<strong>Projects by activity:</strong>

			<cfset cr="">
			<cfif numLoaned is 0 and cited.tot is 0>
				<cfset cr=0>
			<cfelseif numLoaned gte cited.tot and numLoaned gt 0>
				<cfset cr=cited.tot/numLoaned>
			</cfif>
			<td><strong>#decimalFormat(cr)#</strong></td>
		</tr>
	<cfloop query="c">
		<cfquery name="loaned" datasource="uam_god" cachedwithin="#createtimespan(0,0,60,0)#">
			select 
				sum(items_loaned_by_collection)	tot
			from (
				select 
					guid_prefix,
					count(*) items_loaned_by_collection
				from

				select count(*) cnt from publication where IS_PEER_REVIEWED_FG=1 and publication_type='#publication_type#'
			</cfquery>
			<cfquery name="ctn" datasource="uam_god" cachedwithin="#createtimespan(0,0,60,0)#">
				select count(*) cnt from publication,citation where
				publication.publication_id=citation.publication_id and
				publication_type='#publication_type#'
			</cfquery>
