(Datasource=ICOM, Time=17ms, Records=1) in /www/www.internet.com/Sparky/cps/components/contentManager/loadContent.cfm @ 06:36:23

SELECT co.content_ID, co.activeVersion, co.title, co.abstract, co.contentType_ID, co.contentOwner_ID, 
				co.contentSource_ID, co.overrideTemplate, co.overrideDisplay, co.contentVersion_ID, co.CLOB,
				co.modificationDate, co.dateFirstPublished, co.priorPublishDate, co.versionNum, co.secureRequired, isNull( n.node_id, 0 ) as primaryCategory,
				dbo.getResourceType(co.content_id) as resourceType, dbo.getContentNodeList( co.content_id ) as nodeList, dbo.getContentNodeRatingsList (co.content_id) as nodeRatings,
				dbo.contentNodeIndex( content_id ) as contentNodeIndex,co.hits,co.popularity,co.overrideAdString
			FROM 	ActiveContentObjects co
			 LEFT OUTER JOIN
			 cobjNodes n ON co.content_id = n.contentObject_id AND n.primaryNode = 1 	WHERE co.content_ID in (7048)

(Datasource=ICOM, Time=0ms, Records=0, Cached Query) in /www/www.internet.com/Sparky/cps/components/contentManager/loadContent.cfm @ 06:36:23

SELECT cr.role_id
		FROM contentObjectRoles cr		
		WHERE cr.content_ID = 7048
			AND ((cr.startDate IS NULL) OR (getDate() >= cr.startDate AND expirationDate IS NULL) OR (getDate() >= startdate AND getdate() <= expirationDate))

(Datasource=ICOM, Time=1ms, Records=2) in /www/www.internet.com/Sparky/cps/components/contentManager/loadContent.cfm @ 06:36:23

select name, cast((percentage*100) as int) as [percent] from contentcategories where content_id = 7048 and tax_id = 1