anchor.diff:  		<cfquery name="count_query" username="#application.database.user#" password="#application.database.pass#" datasource="#application.database.source#">
   			SELECT COUNT(<cfif arguments.distinct>DISTINCT </cfif>#arguments.select#) AS total
   			FROM #from_clause#
  -			<cfif arguments.where IS NOT "">
  +			<cfif arguments.where IS NOT "" AND listFindNoCase(variables.column_list, "deleted_at") IS 0>
   				WHERE #preserveSingleQuotes(arguments.where)#
  +			<cfelseif arguments.where IS NOT "" AND listFindNoCase(variables.column_list, "deleted_at") IS NOT 0>
  +				WHERE #preserveSingleQuotes(arguments.where)# AND deleted_at IS NULL
  +			<cfelseif arguments.where IS "" AND listFindNoCase(variables.column_list, "deleted_at") IS NOT 0>
  +				WHERE deleted_at IS NULL
   			</cfif>
   		</cfquery>
   	
  
positive.code: 	
  		<cfset var local = structNew()>
  		
  		<cfif structKeyExists(arguments, "where") AND arguments.where IS NOT "">
  			<cfset local.where_clause = arguments.where>
  		<cfelse>
  			<cfset local.where_clause = "">
  		</cfif>
  
negative.code: 		<cfquery name="average_query" username="#application.database.user#" password="#application.database.pass#" datasource="#application.database.source#">
  			SELECT AVG(<cfif arguments.distinct>DISTINCT </cfif>#arguments.field#) AS average
  			FROM #from_clause#
  			<cfif arguments.where IS NOT "" AND listFindNoCase(variables.column_list, "deleted_at") IS 0>
  				WHERE #preserveSingleQuotes(arguments.where)#
  			<cfelseif arguments.where IS NOT "" AND listFindNoCase(variables.column_list, "deleted_at") IS NOT 0>
  				WHERE #preserveSingleQuotes(arguments.where)# AND deleted_at IS NULL
  			<cfelseif arguments.where IS "" AND listFindNoCase(variables.column_list, "deleted_at") IS NOT 0>
  				WHERE deleted_at IS NULL
  			</cfif>
  		</cfquery>
  		
  