 			#bdy#
 			#emailFooter#
 		</cfmail>
-
-
-
-
-		<cfdump var=#cc#>
-
-
-
-
-#bdy#
-
-
-
-
-		<cfdump var=#d#>
-
-
-
-
-
 
 
 

		<cfquery name="totLC" dbtype="query">
			select distinct(locality_id) locality_id from d
		</cfquery>

		<cfdump var=#totLC#>


		<cfquery name="cln" dbtype="query">
			select guid_prefix from d group by guid_prefix order by guid_prefix
		</cfquery>


		<cfdump var=#cln#>


		<cfquery name="chgcnt" dbtype="query">
			select sum(numChanges) c from d
		</cfquery>

		<cfquery name="allusr" dbtype="query">
			select whodunit from d group by whodunit order by whodunit
		</cfquery>

		<cfdump var=#chgcnt#>


		<cfsavecontent variable="bdy">
			Localities used by a collection for which you are a contact have changed.


			<table border>
				<tr>
					<th>Collection</th>

						where
							guid_prefix='#guid_prefix#'
					</cfquery>
					<cfquery name="cchgcnt" dbtype="query">
						select sum(numChanges) c from rc
					</cfquery>
					<cfquery name="callusr" dbtype="query">
						select whodunit from rc group by whodunit order by whodunit
					</cfquery>
					<cfquery name="ctotLC" dbtype="query">
						select distinct(locality_id) locality_id from rc
					</cfquery>
