getContentObjects() is awesome

gistfile1.cfm

<!--- get speakers by category; year --->
<cfset qSpeakers = application.fapi.getContentObjects(typename="mxSpeaker", lProperties="objectid, label", orderBy="label", catspeaker_eq=stobj.metadata) />

<!--- or old and busted get speakers by category; year --->
<cfquery datasource="#application.dsn#" name="qSpeakers">
	SELECT type.objectID, type.label, refobj.typename
	FROM refObjects refObj 
	JOIN refCategories refCat ON refObj.objectID = refCat.objectID
	JOIN mxSpeaker type ON refObj.objectID = type.objectID  
	WHERE refObj.typename = 'mxSpeaker' 
		<cfif trim(len(stObj.metadata))>
		AND refCat.categoryID IN ('#ListChangeDelims(stObj.metadata,"','",",")#')
		</cfif>
		AND type.status IN ('#ListChangeDelims(request.mode.lValidStatus,"','",",")#')
	ORDER BY type.label ASC
</cfquery>