MAX ID of Twitter / FB post IDs

getMaxExternalItemID.cfm

<cfquery name="local.rsGetMaxExternalItemID"
	datasource="#variables.settings.DSN_master#"
	timeout="#variables.settings.databaseTimeout#">
<!--- below are samples of old MAX() statements that ran slower than ORDER BY --->
<!--- SELECT		MAX( REPLACE(ExternalItemID, '_', '') ) AS ExternalItemID --->
<!--- SELECT 		MAX( CAST(ExternalItemID AS UNSIGNED) ) AS ExternalItemID --->
SELECT		ExternalItemID
FROM		StreamItems
WHERE		UserID = <cfqueryparam value="#arguments.UserID#" cfsqltype="cf_sql_integer" />
AND			FilterID = <cfqueryparam value="#arguments.FilterID#" cfsqltype="cf_sql_integer" />
AND			Source = <cfqueryparam value="#arguments.Source#" cfsqltype="cf_sql_varchar" />
<cfif StructKeyExists(arguments, "ExternalIsMention")>
	AND		ExternalIsMention = <cfqueryparam value="#arguments.ExternalIsMention#" cfsqltype="cf_sql_bit" />
</cfif>
<cfif StructKeyExists(arguments, "ExternalIsDM")>
	AND		ExternalIsDM = <cfqueryparam value="#arguments.ExternalIsDM#" cfsqltype="cf_sql_bit" />
</cfif>
ORDER BY	ExternalCreatedDate DESC
LIMIT 1
</cfquery>