 				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 
+				select count(*) cnt from publication,citation where
 				publication.publication_id=citation.publication_id and
 				publication_type='#publication_type#'
 			</cfquery>

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

<script src="/includes/sorttable.js"></script>
<cfoutput>
	<cfquery name="pt" datasource="uam_god" cachedwithin="#createtimespan(0,0,60,0)#">
		select
			publication_type,
			count(*) c
		from
			publication
		group by publication_type
		order by publication_type
	</cfquery>

	<strong>Publications by type, reviewed status, and citations:</strong>
	<table border="1" id="a" class="sortable">
		<tr>
