Mercy Cancer Network

select ref,username,firstname,lastname,license,email,description,'1' AS isEnabled,password from enAuthUsers  where username = '_guest' 

			INSERT INTO hpUserSession
			(ticket1, ticket2, siteid, username, userid, licenselevel, logintime, lastrefreshtime,ipaddress)
			VALUES
			('259ED75E-C464-AB21-CD7DC9079D018E32','259ED76D-0E0C-7E29-BD2566E7B2F8DB1E','10187','_guest','10187:U:1','0',{ts '2012-01-28 12:41:01'},{ts '2012-01-28 12:41:01'},'199.117.41.86')
		

				BEGIN TRANSACTION
				UPDATE hpUserSession
				SET lastrefreshtime = {ts '2012-01-28 12:41:01'}
				WHERE ticket1 = '259ED75E-C464-AB21-CD7DC9079D018E32' and ticket2 = '259ED76D-0E0C-7E29-BD2566E7B2F8DB1E' and logouttime is NULL
				COMMIT TRANSACTION
			

select siteid,username,ref,lastrefreshtime from hpUserSession  where ticket1 = '259ED75E-C464-AB21-CD7DC9079D018E32' and ticket2 = '259ED76D-0E0C-7E29-BD2566E7B2F8DB1E' 

select ref,username,firstname,lastname,license,email,description,'1' AS isEnabled,password from enAuthUsers  where username = '_guest' 

select ref from esWebPage  where ref = 287 

select * from esWebPage  where ref = 287 

select webpagetype from esWebpage  where ref = 287 

select keyname,keyvalue from esWebpageProperties  where esWebPageRef = 287 

select keyname from esWebpagePropertyMeta  where webpagetype = 'static' and isSpecialHandling = 1 

select keyname from esWebpagePropertyMeta  where webpagetype = 'all' and isSpecialHandling = 1 

select top 1 ref from esWebpage  where webpagetype='homepage_mobile' 

select top 1 ref from esWebpage  where len(treeposition)=0 

select top 1 treeposition from esWebpage  where ref=373 

select top 1 treeposition from esWebpage  where ref=287 

					SELECT top 1 pagecontent
					FROM smCache
					WHERE siteid = 10187 AND 
						cacheid = '287' AND
						cachekey = 'http:///home_cancer.cfm?id=287&iirf_redirect=1' AND
						gooduntil >= {ts '2012-01-28 12:41:01'} 

select ref from esWebPage  where ref = 1 

select * from esWebPage  where ref = 1 

select webpagetype from esWebpage  where ref = 1 

select keyname,keyvalue from esWebpageProperties  where esWebPageRef = 1 

select keyname from esWebpagePropertyMeta  where webpagetype = 'homepage' and isSpecialHandling = 1 

			SELECT ec.strExtensionClass
			FROM esSystemBaseClasses bc, esSystemExtClasses ec
			WHERE (bc.strBaseClass = 'enWebPage') AND (bc.ref = ec.intBaseClassRef)
				AND ((1 = 0)
			
				OR (ec.bolActive = 1)
			
			)
			ORDER BY ec.strExtensionClass
		

select ref from esWebPage  where ref = '287' 

select workflowprocess from esWebpage  where ref = 287 

select extRef from esModuleRegistryproperties  where propertyName = 'tableName' and propertyValue = 'esWebpage' 

select * from esWorkflowSubscribers  where extModuleID = 178 AND enabled = 1 

select wfUniqueID from esWorkflowZZZesWebpage  where ref = 287 

select scratchpad from esWebPage  where ref = 287 

select ref from esWebPage  where ref = 287 

select webpagetype from esWebpage  where ref = 287 

select content from esWebPage  where ref = 287 

select ref,parentitemid from esWebpage  where ref = 287 

select ref,parentitemid from esWebpage  where ref = 34 

select ref,parentitemid from esWebpage  where ref = 30 

select ref,parentitemid from esWebpage  where ref = 29 

select ref,parentitemid from esWebpage  where ref = 17 

select ref,parentitemid from esWebpage  where ref = 1 

select ref,parentitemid from esWebpage  where ref = 0 

	SELECT	m.TidbitKey, m.TidbitValue, m.PageID, m.charlimit
	FROM	smm_tidbit m LEFT OUTER JOIN smm_tidbit_placement p ON m.PlacementRef=p.ref
	WHERE	(m.pageid=0 or m.pageid=-1 or m.pageid=?)
	
		AND p.PlacementName = ? 
		AND m.ref in
			(SELECT	TidbitRef
			 FROM	smm_tidbit_template
			 WHERE	(TemplateName='0' OR TemplateName=?))
	ORDER BY m.pageid desc

 select top 1 treeposition from esWebpage  where ref=373 

				SELECT w.itemid, w.sectionname, w.parentitemid, w.pagetemplate, LTRIM(RTRIM(w.graphic5)) as urltarget,
					w.pagekey, w.graphic1, w.graphic2, w.graphic3, w.graphic4, w.graphic5, 
					w.graphic6, w.graphic7, w.graphic8, w.metakeywords, w.metadescription, w.logographic, w.createdate, w.moddate, 
					CASE w.pagetype
						WHEN 'dynamic' THEN 1
						WHEN 'outsidelink' THEN 0
						WHEN 'include' THEN (SELECT CASE WHEN (thecontent is NULL or DATALENGTH(thecontent) = 0) THEN 0 ELSE 1 END FROM webpages WHERE itemid = w.itemid2)
						WHEN 'link' THEN (SELECT CASE WHEN (thecontent is NULL or DATALENGTH(thecontent) = 0) THEN 0 ELSE 1 END FROM webpages WHERE itemid = w.itemid2)
						ELSE (CASE WHEN (w.thecontent is NULL or DATALENGTH(w.thecontent) = 0) THEN 0 ELSE 1 END)
					END AS hasContent,
					CASE WHEN len(wpp.keyvalue) > 0 THEN wpp.keyvalue ELSE 
					CASE w.pagekey 
					WHEN 'outsidelink' THEN w.description 
					ELSE (w.pagetemplate + '?id=' + CAST(CASE w.pagekey WHEN 'link' THEN w.itemid2 ELSE w.itemid END AS varchar) + 
							CASE LEFT(w.graphic1, 1)  WHEN '&' THEN LTRIM(RTRIM(w.graphic1)) ELSE '' END) 
					END
					END AS urllink,
					CASE 
						WHEN ((w.makepublic = 'T') AND (w.makepublicdate <= '01/28/2012') AND (w.expiredate >= '01/28/2012')) THEN 1
						ELSE 0 
					END as isPublished,
					CASE
						WHEN (w.pagetype in ('static','dynamic','link','outsidelink','include')) THEN pagetype
						WHEN (w.sectiontype = 'homepage') THEN 'homepage'
						WHEN (w.sectiontype = 'homepage_mobile') THEN 'homepage_mobile'
						WHEN (w.sectiontype = 'defaultbuttonbar') and (w.sectionname = 'Library') THEN 'library'
						WHEN (w.sectiontype = 'defaultbuttonbar') THEN 'buttonbar'
						ELSE 'unknown'
					END as webPageType 
				FROM webpages as w
				INNER JOIN esWebpage as e ON w.itemid=e.ref
				left outer JOIN esWebpageProperties AS wpp ON w.itemid = wpp.esWebPageRef AND wpp.KeyName = 'directurl'
				WHERE (1 = 1)
				
					AND ((1 = 0)
						OR (w.pagetype = 'static') OR (w.pagetype = 'dynamic') OR (w.pagetype = 'link') OR (w.pagetype = 'outsidelink') OR (w.sectiontype = 'homepage') OR (w.sectiontype = 'homepage_mobile') OR (w.sectiontype = 'defaultbuttonbar' and w.sectionname <> 'Library') OR (w.pagetype = 'include')
						)
				
						AND (w.itemid = 287)
					
					AND (w.makepublic = 'T')
					AND (w.makepublicdate <= '01/28/2012')
					AND (w.expiredate >= '01/28/2012')
									
					AND ((w.whoaccess is null) OR (w.whoaccess like 'Everyone') OR (w.whoaccess like 'Everyone,%') OR (w.whoaccess like '%,Everyone') OR (w.whoaccess like '%,Everyone,%')
					)
				
				AND left(e.treeposition,7) != '/     2'
				ORDER BY w.pageorder, w.sectionname, w.itemid 

 select workflowprocess from esWebpage  where ref = 287 

 select wfUniqueID from esWorkflowZZZesWebpage  where ref = 287 

 select scratchpad from esWebPage  where ref = 287 

 select extRef from esModuleRegistryproperties  where propertyName = 'pagekey' and propertyValue = 'smm_google' 

 select top 1 uiSEO.DisplayName, uiSEO.City, uiSEO.State, uiSEO.MarketCity, uiSEO.MarketState, uiSEO.DisplayOrder from uiSEO, metamultiselect mms, metaselect ms  where mms.metatablename = 'uiSEO' AND mms.metafieldname = 'Template' AND ms.keyvalue = 'home_cancer.cfm' AND mms.userrecordref = uiSEO.ref AND ms.ref = mms.exttableref 

	SELECT	m.TidbitKey, m.TidbitValue, m.PageID, m.charlimit
	FROM	smm_tidbit m LEFT OUTER JOIN smm_tidbit_placement p ON m.PlacementRef=p.ref
	WHERE	(m.pageid=0 or m.pageid=-1 or m.pageid=?)
	
		AND p.PlacementName = ? 
		AND m.ref in
			(SELECT	TidbitRef
			 FROM	smm_tidbit_template
			 WHERE	(TemplateName='0' OR TemplateName=?))
	ORDER BY m.pageid desc

select keyvalue from esWebpageProperties  where KeyName = 'directurl' and esWebPageRef = 287 

	SELECT	m.TidbitKey, m.TidbitValue, m.PageID, m.charlimit
	FROM	smm_tidbit m LEFT OUTER JOIN smm_tidbit_placement p ON m.PlacementRef=p.ref
	WHERE	(m.pageid=0 or m.pageid=-1 or m.pageid=?)
	
		AND p.PlacementName = ? 
		AND m.ref in
			(SELECT	TidbitRef
			 FROM	smm_tidbit_template
			 WHERE	(TemplateName='0' OR TemplateName=?))
	ORDER BY m.pageid desc

	SELECT	m.TidbitKey, m.TidbitValue, m.PageID, m.charlimit
	FROM	smm_tidbit m LEFT OUTER JOIN smm_tidbit_placement p ON m.PlacementRef=p.ref
	WHERE	(m.pageid=0 or m.pageid=-1 or m.pageid=?)
	
		AND p.PlacementName = ? 
		AND m.ref in
			(SELECT	TidbitRef
			 FROM	smm_tidbit_template
			 WHERE	(TemplateName='0' OR TemplateName=?))
	ORDER BY m.pageid desc

		SELECT 	w.parentitemid, w.refnum, w.graphic3,w.itemid, wpp.keyvalue, 
				CASE w.pagekey WHEN 'link' THEN w.itemid2 ELSE w.itemid END AS LinkID,  
				LTRIM(RTRIM(w.sectionname)) as LinkText, 
				LTRIM(RTRIM(w.graphic1)) as AdditionalURLParams, 
				CASE LTRIM(RTRIM(w.graphic5)) 
	  					WHEN '' THEN '' ELSE ' target="' + LTRIM(RTRIM(w.graphic5)) + '"' END AS Target,
				CASE WHEN len(wpp.keyvalue) > 0 THEN wpp.keyvalue
					ELSE CASE w.pagekey
					WHEN 'outsidelink' THEN w.description 
					ELSE (w.pagetemplate + '?id=' + CAST(
						CASE w.pagekey 
						WHEN 'link' THEN w.itemid2 ELSE w.itemid 
						END AS varchar) + 
						CASE LEFT(w.graphic1, 1) 
	  						WHEN '&' THEN LTRIM(RTRIM(w.graphic1)) ELSE '' END) 
	  				END
				END AS LinkURL, 		
				LTRIM(RTRIM(w.buttongraphic)) as buttongraphic,
				w.whoaccess, 'Child' as LinkType, w.pagekey
				,
				(SELECT TOP 1 refnum FROM webpages WHERE parentitemid =  w.refnum) AS childrenLinks
			FROM webpages AS w left outer JOIN
	                      esWebpageProperties AS wpp ON w.refnum = wpp.esWebPageRef AND wpp.KeyName = 'directurl'
			WHERE w.parentitemid = ?
			AND w.pagekey <> ?
			AND ((w.sectiontype <> ?
				AND w.sectiontype <> ?) 
				OR w.sectiontype IS NULL)
			AND w.sectionname NOT IN (?,?,?)			
		
			AND w.makepublic = ? 
			AND ((w.makepublicdate IS NULL OR w.makepublicdate <?) 
				AND (w.expiredate IS NULL OR w.expiredate > ?))
		
			AND (w.whoaccess IS NULL OR w.whoaccess LIKE ? OR w.whoaccess LIKE '')
		
			ORDER BY w.pageorder
	

select propertyValue from esModuleRegistryproperties  where extRef = 0 and propertyName = 'google_appliance' 

select propertyValue from esModuleRegistryproperties  where extRef = 0 and propertyName = 'google_appliancetype' 

select propertyValue from esModuleRegistryproperties  where extRef = 0 and propertyName = 'google_collection' 

select propertyValue from esModuleRegistryproperties  where extRef = 0 and propertyName = 'google_enabled' 

select extRef from esModuleRegistryproperties  where propertyName = 'pagekey' and propertyValue = 'modMSFTSearch' 

select propertyValue from esModuleRegistryproperties  where extRef = 0 and propertyName = 'modMSFTSearch_Enabled' 

select extRef from esModuleRegistryproperties  where propertyName = 'struserscript' and propertyValue = 'smm_search.cfm' 

select distinct wp.ref,wp.isprotected,wp.sectionname from esWebPage wp, esWebPageProperties wpp  where makepublic = 1 and (makepublicdate <= {ts '2012-01-28 12:41:01'} or makepublicdate is NULL)  and (expiredate >= {ts '2012-01-28 12:41:01'} or expiredate is NULL)  and webpagetype = 'dynamic' and keyname = 'ModuleRef' and keyvalue = '196' and wp.ref = wpp.esWebPageRef order by wp.sectionname 

select ref from esWebPage  where ref = 136 

select * from esWebPage  where ref = 136 

select webpagetype from esWebpage  where ref = 136 

select keyname from esWebpagePropertyMeta  where webpagetype = 'dynamic' and isSpecialHandling = 1 

select top 1 ref from esWebpage  where webpagetype='homepage_mobile' 

select top 1 ref from esWebpage  where len(treeposition)=0 

select top 1 treeposition from esWebpage  where ref=373 

select top 1 treeposition from esWebpage  where ref=136 

		SELECT p.parentitemid AS pParentitemID, pwpp.keyvalue, 
			CASE p.pagekey
				WHEN 'link' THEN p.itemid2 ELSE p.itemid END AS pLinkID,
			LTRIM(RTRIM(p.sectionname)) as pLinkText,
			CASE WHEN len(pwpp.keyvalue) > 0 THEN pwpp.keyvalue
				ELSE CASE p.pagekey
				WHEN 'outsidelink' THEN p.description
				ELSE (p.pagetemplate + '?id=' + CAST(
					CASE p.pagekey
					WHEN 'link' THEN p.itemid2 ELSE p.itemid
					END AS varchar) +
					CASE LEFT(p.graphic1, 1)
								WHEN '&' THEN LTRIM(RTRIM(p.graphic1)) ELSE '' END)
  				END
			END AS pLinkURL,
			LTRIM(RTRIM(p.buttongraphic)) AS pbuttongraphic,
			p.pageorder AS pPageorder,
			p.description AS pDescription,
			LTRIM(RTRIM(p.graphic5)) AS pTarget,
			c.parentitemid AS cParentitemID,
			CASE c.pagekey
				WHEN 'link' THEN c.itemid2 ELSE c.itemid END AS cLinkID,
			LTRIM(RTRIM(c.sectionname)) as cLinkText,
			CASE WHEN len(cwpp.keyvalue) > 0 THEN cwpp.keyvalue
				ELSE CASE c.pagekey
				WHEN 'outsidelink' THEN c.description
				ELSE (c.pagetemplate + '?id=' + CAST(
					CASE c.pagekey
					WHEN 'link' THEN c.itemid2 ELSE c.itemid
					END AS varchar) +
					CASE LEFT(c.graphic1, 1)
								WHEN '&' THEN LTRIM(RTRIM(c.graphic1)) ELSE '' END)
  				END
			END AS cLinkURL,
			LTRIM(RTRIM(c.buttongraphic)) AS cbuttongraphic,
			c.pageorder AS cPageorder,
			c.description AS cDescription,
			LTRIM(RTRIM(c.graphic5)) AS cTarget
		FROM webpages p LEFT OUTER JOIN webpages c
			ON p.itemid = c.parentitemid
			AND c.pagekey <> ?
			AND c.sectionname NOT IN (?,?,?)
		
			AND c.makepublic = ?
			AND ((c.makepublicdate IS NULL OR c.makepublicdate <?)
				AND (c.expiredate IS NULL OR c.expiredate > ?))
		
			AND (c.whoaccess IS NULL
				OR c.whoaccess LIKE ?
				OR c.whoaccess LIKE '')
		
			LEFT OUTER JOIN esWebpageProperties AS pwpp ON p.refnum = pwpp.esWebPageRef AND pwpp.KeyName = 'directurl'
			LEFT OUTER JOIN esWebpageProperties AS cwpp ON c.refnum = cwpp.esWebPageRef AND cwpp.KeyName = 'directurl'
		
		WHERE p.parentitemid = ?
		AND p.pagekey <> ?
		AND p.sectionname NOT IN (?,?,?)
		
			AND p.makepublic = ?
			AND ((p.makepublicdate IS NULL OR p.makepublicdate <?)
				AND (p.expiredate IS NULL OR p.expiredate > ?))
		
			AND (p.whoaccess IS NULL
				OR p.whoaccess LIKE ?
				OR p.whoaccess LIKE '')
		
		ORDER BY p.pageorder, c.pageorder
	

		SELECT 	w.parentitemid, w.refnum, w.graphic3,w.itemid, wpp.keyvalue, 
				CASE w.pagekey WHEN 'link' THEN w.itemid2 ELSE w.itemid END AS LinkID,  
				LTRIM(RTRIM(w.sectionname)) as LinkText, 
				LTRIM(RTRIM(w.graphic1)) as AdditionalURLParams, 
				CASE LTRIM(RTRIM(w.graphic5)) 
	  					WHEN '' THEN '' ELSE ' target="' + LTRIM(RTRIM(w.graphic5)) + '"' END AS Target,
				CASE WHEN len(wpp.keyvalue) > 0 THEN wpp.keyvalue
					ELSE CASE w.pagekey
					WHEN 'outsidelink' THEN w.description 
					ELSE (w.pagetemplate + '?id=' + CAST(
						CASE w.pagekey 
						WHEN 'link' THEN w.itemid2 ELSE w.itemid 
						END AS varchar) + 
						CASE LEFT(w.graphic1, 1) 
	  						WHEN '&' THEN LTRIM(RTRIM(w.graphic1)) ELSE '' END) 
	  				END
				END AS LinkURL, 		
				LTRIM(RTRIM(w.buttongraphic)) as buttongraphic,
				w.whoaccess, 'Child' as LinkType, w.pagekey
				,
				(SELECT TOP 1 refnum FROM webpages WHERE parentitemid =  w.refnum) AS childrenLinks
			FROM webpages AS w left outer JOIN
	                      esWebpageProperties AS wpp ON w.refnum = wpp.esWebPageRef AND wpp.KeyName = 'directurl'
			WHERE w.parentitemid = ?
			AND w.pagekey <> ?
			AND ((w.sectiontype <> ?
				AND w.sectiontype <> ?) 
				OR w.sectiontype IS NULL)
			AND w.sectionname NOT IN (?,?,?)			
		
			AND w.makepublic = ? 
			AND ((w.makepublicdate IS NULL OR w.makepublicdate <?) 
				AND (w.expiredate IS NULL OR w.expiredate > ?))
		
			AND (w.whoaccess IS NULL OR w.whoaccess LIKE ? OR w.whoaccess LIKE '')
		
			ORDER BY w.pageorder
	

select ref from esWebPage  where ref = 303 

select webpagetype from esWebpage  where ref = 303 

select ref from esWebPage  where ref = 303 

select * from esWebPage  where ref = 303 

select webpagetype from esWebpage  where ref = 303 

select content from esWebPage  where ref = 303 

 select ref from esWebPage  where ref = 287 

 select webpagetype from esWebpage  where ref = 287 

 select content from esWebPage  where ref = 287 

		SELECT	userscript
		FROM	metahead
		WHERE	modulename=? 

 select extRef from esModuleRegistryproperties  where propertyName = 'struserscript' and propertyValue = 'smx_news1.cfm' 

 select distinct wp.ref,wp.isprotected,wp.sectionname from esWebPage wp, esWebPageProperties wpp  where makepublic = 1 and (makepublicdate <= {ts '2012-01-28 12:41:01'} or makepublicdate is NULL)  and (expiredate >= {ts '2012-01-28 12:41:01'} or expiredate is NULL)  and webpagetype = 'dynamic' and keyname = 'ModuleRef' and keyvalue = '228' and wp.ref = wpp.esWebPageRef order by wp.sectionname 

 select ref from esWebPage  where ref = 323 

 select * from esWebPage  where ref = 323 

 select webpagetype from esWebpage  where ref = 323 

 select top 1 ref from esWebpage  where webpagetype='homepage_mobile' 

 select top 1 ref from esWebpage  where len(treeposition)=0 

 select top 1 treeposition from esWebpage  where ref=373 

 select top 1 treeposition from esWebpage  where ref=323 

	SELECT whatdatatable,header_all,header_list,header_search,
		header_detail,header_custann,isPublicNew,isPublicEdit,list_type,
		isuserdetailpage, isheader_custann
	FROM metahead
	WHERE modulename='smx_news1'

		SELECT metafieldname, metadisplayname, metafieldtype, isListDisplay, isDetailDisplay, metafieldparam, metafieldparam2
		FROM metatable
		WHERE MetaTableName = 'smx_news1' and (isEnabled='T' or MetaFieldType = 'Hidden')
		ORDER BY metasortorder
	

		SELECT metafieldname, customsort, isListHeader FROM metatable
		WHERE MetaTableName = 'smx_news1' and isEnabled='T'
			and (CustomSort = 'ASC' or CustomSort = 'DESC')
		ORDER BY customsortorder
	

		select top 4 ref,m_username,title,m_date_mod,m_date_create,m_date_activate,m_date_expire,description,isPublic,ShowTeaser 
		from smx_news1 
		where 0=0 
			 and ((1=0)  or (isPublic = 'T') ) and ((1=0)  or (ShowTeaser = 'T') ) and ((m_date_activate is null) or (m_date_activate <= {ts '2012-01-28 12:41:01'})) and ((m_date_expire is null) or (m_date_expire > '01/28/2012')) order by m_date_activate DESC,m_date_mod ASC,title ASC 

 select ref from esWebPage  where ref = '323' 

 select keyname,keyvalue from esWebpageProperties  where esWebPageRef = 323 

select ref from esWebPage  where ref = 302 

select webpagetype from esWebpage  where ref = 302 

select ref from esWebPage  where ref = 302 

select * from esWebPage  where ref = 302 

select webpagetype from esWebpage  where ref = 302 

select content from esWebPage  where ref = 302 

select ref from esWebPage  where ref = 301 

select webpagetype from esWebpage  where ref = 301 

select ref from esWebPage  where ref = 301 

select * from esWebPage  where ref = 301 

select webpagetype from esWebpage  where ref = 301 

select content from esWebPage  where ref = 301 

		SELECT 	w.parentitemid, w.refnum, w.graphic3,w.itemid, wpp.keyvalue, 
				CASE w.pagekey WHEN 'link' THEN w.itemid2 ELSE w.itemid END AS LinkID,  
				LTRIM(RTRIM(w.sectionname)) as LinkText, 
				LTRIM(RTRIM(w.graphic1)) as AdditionalURLParams, 
				CASE LTRIM(RTRIM(w.graphic5)) 
	  					WHEN '' THEN '' ELSE ' target="' + LTRIM(RTRIM(w.graphic5)) + '"' END AS Target,
				CASE WHEN len(wpp.keyvalue) > 0 THEN wpp.keyvalue
					ELSE CASE w.pagekey
					WHEN 'outsidelink' THEN w.description 
					ELSE (w.pagetemplate + '?id=' + CAST(
						CASE w.pagekey 
						WHEN 'link' THEN w.itemid2 ELSE w.itemid 
						END AS varchar) + 
						CASE LEFT(w.graphic1, 1) 
	  						WHEN '&' THEN LTRIM(RTRIM(w.graphic1)) ELSE '' END) 
	  				END
				END AS LinkURL, 		
				LTRIM(RTRIM(w.buttongraphic)) as buttongraphic,
				w.whoaccess, 'Child' as LinkType, w.pagekey
				,
				(SELECT TOP 1 refnum FROM webpages WHERE parentitemid =  w.refnum) AS childrenLinks
			FROM webpages AS w left outer JOIN
	                      esWebpageProperties AS wpp ON w.refnum = wpp.esWebPageRef AND wpp.KeyName = 'directurl'
			WHERE w.parentitemid = ?
			AND w.pagekey <> ?
			AND ((w.sectiontype <> ?
				AND w.sectiontype <> ?) 
				OR w.sectiontype IS NULL)
			AND w.sectionname NOT IN (?,?,?)			
		
			AND w.makepublic = ? 
			AND ((w.makepublicdate IS NULL OR w.makepublicdate <?) 
				AND (w.expiredate IS NULL OR w.expiredate > ?))
		
			AND (w.whoaccess IS NULL OR w.whoaccess LIKE ? OR w.whoaccess LIKE '')
		
			ORDER BY w.pageorder
	

	SELECT	m.TidbitKey, m.TidbitValue, m.PageID, m.charlimit
	FROM	smm_tidbit m LEFT OUTER JOIN smm_tidbit_placement p ON m.PlacementRef=p.ref
	WHERE	(m.pageid=0 or m.pageid=-1 or m.pageid=?)
	
		AND p.PlacementName = ? 
		AND m.ref in
			(SELECT	TidbitRef
			 FROM	smm_tidbit_template
			 WHERE	(TemplateName='0' OR TemplateName=?))
	ORDER BY m.pageid desc

	SELECT	m.TidbitKey, m.TidbitValue, m.PageID, m.charlimit
	FROM	smm_tidbit m LEFT OUTER JOIN smm_tidbit_placement p ON m.PlacementRef=p.ref
	WHERE	(m.pageid=0 or m.pageid=-1 or m.pageid=?)
	
		AND p.PlacementName = ? 
		AND m.ref in
			(SELECT	TidbitRef
			 FROM	smm_tidbit_template
			 WHERE	(TemplateName='0' OR TemplateName=?))
	ORDER BY m.pageid desc

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=F:\MedSeek\SiteMaker\websitefiles\trinitycon10187\home_cancer.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=deflate, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.mercycancernetwork.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/home_cancer.cfm
PATH_TRANSLATED=F:\MedSeek\SiteMaker\websitefiles\trinitycon10187\home_cancer.cfm
QUERY_STRING=id=287&iirf_redirect=1
REMOTE_ADDR=199.117.41.86
REMOTE_HOST=199.117.41.86
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/home_cancer.cfm
SERVER_NAME=www.mercycancernetwork.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=10385568
cftoken=83335414
hitcount=1
lastvisit={ts '2012-01-28 12:41:01'}
timecreated={ts '2012-01-28 12:41:01'}
urltoken=CFID=10385568&CFTOKEN=83335414

Cookie Variables:
BOLISMOBILEBROWSER=false
CFID=10385568
CFTOKEN=83335414
STRMOBILETYPE=unknown

Session Variables:
cfid=10385568
cftoken=83335414
groups=Everyone
name=Trinity Health - Consumer Site Guest
sessionid=TRINITYCON10187_10385568_83335414
showstage=F
urltoken=CFID=10385568&CFTOKEN=83335414
userid=1
username=_guest

URL Parameters:
ID=287
IIRF_REDIRECT=1