Total Time	Avg Time	Count	Template
9968 ms	525 ms	19	E:\web\commonspot\cache\cached-render.cfm
5611 ms	5611 ms	1	E:\web\pcsd\pcsd404.cfm
5595 ms	5595 ms	1	E:\web\commonspot\master.cfm
5517 ms	5517 ms	1	E:\web\commonspot\master-render.cfm
5298 ms	5298 ms	1	E:\web\commonspot\render-page-meat.cfm
5298 ms	5298 ms	1	E:\web\commonspot\render-page.cfm
4717 ms	248 ms	19	E:\web\commonspot\utilities\ct-render-element.cfm
3485 ms	3485 ms	1	E:\web\pcsd\templates\template-basepage.cfm
3469 ms	248 ms	14	E:\web\commonspot\utilities\ct-render-named-element.cfm
1782 ms	1782 ms	1	E:\web\commonspot\controls\dhtmlmenu\cpe-menu.cfm
1578 ms	789 ms	2	E:\web\commonspot\controls\layout\cpe-layout.cfm
1437 ms	479 ms	3	E:\web\commonspot\controls\layout\render-cell.cfm
797 ms	797 ms	1	E:\web\commonspot\controls\dhtmlmenu\menu-get-data.cfm
765 ms	45 ms	17	E:\web\commonspot\controls\tabbar\restrict-item-list.cfm
625 ms	313 ms	2	E:\web\commonspot\controls\linkbar\cpe-linkbar.cfm
501 ms	251 ms	2	E:\web\commonspot\controls\linkbar\lbar-standard-render.cfm
422 ms	422 ms	1	E:\web\commonspot\controls\tabbar\cpe-tabbar.cfm
422 ms	84 ms	5	E:\web\commonspot\controls\textblock\cpe-textblock.cfm
281 ms	281 ms	1	E:\web\commonspot\site-application.cfm
281 ms	281 ms	1	E:\web\commonspot\startup\site-application-meat.cfm
281 ms	40 ms	7	E:\web\commonspot\utilities\ct-limit-inheritance.cfm
281 ms	281 ms	1	E:\web\pcsd\Application.cfm
266 ms	67 ms	4	E:\web\commonspot\controls\image\cpe-image.cfm
266 ms	10 ms	27	E:\web\commonspot\utilities\ct-render-text.cfm
251 ms	63 ms	4	E:\web\commonspot\controls\upfront-generic.cfm
125 ms	31 ms	4	E:\web\commonspot\controls\image\sic-default-params.cfm
110 ms	6 ms	19	E:\web\commonspot\utilities\cp-cfdirectory.cfm
94 ms	19 ms	5	E:\web\commonspot\tb-data-upfront-queries.cfm
94 ms	47 ms	2	E:\web\commonspot\utilities\cp-cffile.cfm
79 ms	79 ms	1	E:\web\commonspot\utilities\cp-cffile-charset.cfm
63 ms	63 ms	1	E:\web\commonspot\controls\customcf\cpe-customcf.cfm
63 ms	16 ms	4	E:\web\commonspot\controls\image\image-upfront.cfm
63 ms	16 ms	4	E:\web\commonspot\controls\image\sic-standard-render.cfm
63 ms	63 ms	1	E:\web\commonspot\controls\schedule\cpe-schedule.cfm
63 ms	13 ms	5	E:\web\commonspot\controls\textblock\tb-default-params.cfm
63 ms	63 ms	1	E:\web\commonspot\tb-param-upfront-queries.cfm
63 ms	2 ms	26	E:\web\commonspot\utilities\cp-cfwddx.cfm
63 ms	8 ms	8	E:\web\commonspot\utilities\ct-extract-wddx-data.cfm
62 ms	62 ms	1	E:\web\commonspot\controls\date\cpe-date.cfm
62 ms	62 ms	1	E:\web\commonspot\controls\search\cpe-searchform.cfm
62 ms	62 ms	1	E:\web\commonspot\controls\tabbar\tbar-standard-render.cfm
62 ms	62 ms	1	E:\web\commonspot\controls\tabbar\tbar-style-3.cfm
62 ms	62 ms	1	E:\web\commonspot\generate-usage-stats.cfm
48 ms	3 ms	18	E:\web\commonspot\controls\control-setup.cfm
48 ms	0 ms	144	E:\web\commonspot\utilities\ct-decipher-linkurl.cfm
47 ms	5 ms	9	E:\web\commonspot\approve\ct-render-approval-icon.cfm
47 ms	24 ms	2	E:\web\commonspot\controls\linkbar\lbar-get-params.cfm
47 ms	9 ms	5	E:\web\commonspot\controls\textblock\tb-standard-render.cfm
47 ms	5 ms	9	E:\web\commonspot\utilities\ct-render-edit-icon.cfm
32 ms	32 ms	1	E:\web\commonspot\controls\date\date-get-data.cfm
32 ms	11 ms	3	E:\web\commonspot\controls\linklist\linklist-itempos-upfront.cfm
32 ms	0 ms	131	E:\web\commonspot\utilities\item-visible.cfm
31 ms	31 ms	1	E:\web\commonspot\controls\tabbar\tbar-get-params.cfm
16 ms	1 ms	16	E:\web\commonspot\controls\default-mode.cfm
16 ms	16 ms	1	E:\web\commonspot\controls\dhtmlmenu\menu-get-props.cfm
16 ms	16 ms	1	E:\web\commonspot\controls\search\sf-get-params.cfm
16 ms	16 ms	1	E:\web\commonspot\sic-param-upfront-queries.cfm
16 ms	16 ms	1	E:\web\commonspot\startup\core-application-meat.cfm
16 ms	16 ms	1	E:\web\commonspot\utilities\add-multiple-images-to-image-cache.cfm
16 ms	8 ms	2	E:\web\commonspot\utilities\ct-limit-inheritance-modebased.cfm
16 ms	4 ms	4	E:\web\commonspot\utilities\ct-render-image.cfm
16 ms	16 ms	1	E:\web\pcsd\cache\s1-n7-p2838-c0-t0-mr-blame.cache
15 ms	15 ms	1	E:\web\commonspot\controls\date\date-get-params.cfm
15 ms	15 ms	1	E:\web\commonspot\render-head.cfm
15 ms	1 ms	18	E:\web\commonspot\security\security-control.cfm
15 ms	15 ms	1	E:\web\commonspot\security\security-detail-queries.cfm
15 ms	15 ms	1	E:\web\commonspot\sic-data-upfront-queries.cfm
15 ms	8 ms	2	E:\web\commonspot\utilities\ct-render-edit-icon-subitem.cfm
15 ms	3 ms	6	E:\web\commonspot\utilities\handle-in-list.cfm
0 ms	0 ms	2	E:\web\commonspot\approve\ct-render-approval-icon-subitems.cfm
0 ms	0 ms	1	E:\web\commonspot\controls\ct-get-inheritance.cfm
0 ms	0 ms	4	E:\web\commonspot\controls\ct-include-once.cfm
0 ms	0 ms	2	E:\web\commonspot\controls\layout\layout-rowcol-actions.cfm
0 ms	0 ms	3	E:\web\commonspot\controls\layout\layout-setcellvars.cfm
0 ms	0 ms	2	E:\web\commonspot\controls\layout\layout-settablevars.cfm
0 ms	0 ms	2	E:\web\commonspot\controls\linkbar\lbar-ghost-text.cfm
0 ms	0 ms	1	E:\web\commonspot\controls\schedule\schedule-get-params.cfm
0 ms	0 ms	91	E:\web\commonspot\controls\set-caller-vars.cfm
0 ms	0 ms	1	E:\web\commonspot\menu\core-js.cfm
0 ms	0 ms	1	E:\web\commonspot\menu_ie_style.cfm
0 ms	0 ms	1	E:\web\commonspot\metadata\init-cache.cfm
0 ms	0 ms	1	E:\web\commonspot\pagemode\newpagemodeui.cfm
0 ms	0 ms	1	E:\web\commonspot\pagemode\pagemodeui.cfm
0 ms	0 ms	1	E:\web\commonspot\render-body-tag.cfm
0 ms	0 ms	1	E:\web\commonspot\render-metatags.cfm
0 ms	0 ms	1	E:\web\commonspot\security\security-page.cfm
0 ms	0 ms	1	E:\web\commonspot\security\session-user-approvals.cfm
0 ms	0 ms	1	E:\web\commonspot\set-page-vars.cfm
0 ms	0 ms	1	E:\web\commonspot\startup\handle-head-request.cfm
0 ms	0 ms	1	E:\web\commonspot\startup\handle-request-timeout.cfm
0 ms	0 ms	1	E:\web\commonspot\startup\session-first-global.cfm
0 ms	0 ms	1	E:\web\commonspot\startup\session-first-site.cfm
0 ms	0 ms	1	E:\web\commonspot\static\do-replacements.cfm
0 ms	0 ms	1	E:\web\commonspot\static\get-feature-enabled.cfm
0 ms	0 ms	1	E:\web\commonspot\static\replacement-wrapper.cfm
0 ms	0 ms	1	E:\web\commonspot\utilities\build-dynamic-page-list.cfm
0 ms	0 ms	1	E:\web\commonspot\utilities\build-pagedata.cfm
0 ms	0 ms	1	E:\web\commonspot\utilities\build-user-struct.cfm
0 ms	0 ms	2	E:\web\commonspot\utilities\capture-text.cfm
0 ms	0 ms	1	E:\web\commonspot\utilities\cp-setencoding.cfm
0 ms	0 ms	2	E:\web\commonspot\utilities\ct-render-input.cfm
0 ms	0 ms	2	E:\web\commonspot\utilities\define-upfront-vars.cfm
0 ms	0 ms	11	E:\web\commonspot\utilities\edit-mode-get-valid.cfm
0 ms	0 ms	8	E:\web\commonspot\utilities\get-image-given-pageid.cfm
0 ms	0 ms	19	E:\web\commonspot\utilities\handle-cache-flags.cfm
0 ms	0 ms	1	E:\web\commonspot\utilities\load-template-stub.cfm
0 ms	0 ms	1	E:\web\commonspot\utilities\newwindow-js-meat.cfm
0 ms	0 ms	2	E:\web\commonspot\utilities\newwindow-js.cfm
0 ms	0 ms	1	E:\web\commonspot\utilities\upload\get-upload-filename.cfm
0 ms	0 ms	1	E:\web\commonspot\utilities\upload\is-anon-upload.cfm
0 ms	0 ms	1	E:\web\commonspot\utilities\validation\render-info.cfm
0 ms	0 ms	2	E:\web\commonspot\utilities\verify-stub-data.cfm
0 ms	0 ms	1	E:\web\pcsd\OnRequestEnd.cfm
0 ms	0 ms	1	E:\web\pcsd\customcf\ShowHelpButton.cfm
0 ms	0 ms	1	E:\web\pcsd\template-1x1-Base.cfm
125 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
6017 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

			SELECT HitCount
			  FROM UsageData
			 WHERE PageID = ?
				AND UserID = ?
				AND DateAccessed = ?
				AND SiteID = ?
				AND ServerID = ? 

				INSERT INTO UsageData
					(ServerID,SiteID,PageID,UserID,DateAccessed,HitCount)
				VALUES
					(?,
					 ?,
					 ?,
					 ?,
					 ?,1)
			

				SELECT *
				  FROM Param_Page
				 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				   AND VersionState=2
	 		 ORDER BY PageID DESC
			

   SELECT PageID,VersionState,AuthorID
     FROM Data_Menu_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

		SELECT *
		FROM Param_WDDX
		WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
			AND ElementTypeID = ?
			AND ControlID > 0
		ORDER BY ControlID, PageID DESC
	

	SELECT *
	  FROM Data_Menu_Items
	 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) AND ControlID IN (3305,3313,3314,3315,3316,3359,3368,3372,3376,49286,49287,49290,49296,56156,56157,56158,56170,56434)
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC 

		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_Menu_Items
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) AND ControlID IN (3305,3313,3314,3315,3316,3359,3368,3372,3376,49286,49287,49290,49296,56156,56157,56158,56170,56434)
	 GROUP BY PageID,ControlID,ItemID
	

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND ElementTypeID = 47 AND (VersionState = 2) AND PageID IN (2838,7,2,1)
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

		SELECT DateLastCacheClear
		  FROM SitePages
		 WHERE ID=? 

			SELECT SubSiteID, PageType, publicreleasedate, expdate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT expdate, publicreleasedate
			  FROM sitepages
			 WHERE id = ?
				AND (publicreleasedate <= ?
					OR publicreleasedate = ''
					OR publicreleasedate = NULL)
		

	SELECT ud.publicfilename
	  FROM uploadedDocs ud
	 WHERE ud.pageid = ?
		AND ud.versionstate = 2

			SELECT ControlID,ControlName
			  FROM ControlInstance
			 WHERE (PageID IN (1,2,7,2838)) 
		 ORDER BY PageID DESC
		

			SELECT DISTINCT ControlID
			  FROM ItemSecurity
			 WHERE ((PageID = ? AND ApplyTo=0)
						OR ( (PageID IN (1,2,7,2838)) 
							AND ApplyTo = 1))
			   AND ControlID <> 0
			   AND pRead=0
				AND pAuthor=0
				AND pEdit=0
				AND pDesign=0
				AND pApprove=0
				AND pAdmin=0
		

			SELECT *
			  FROM RestrictedSecurity
			 WHERE PageID IN (7,2,1) 

		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (7,2,1)))
			)
			AND ControlID<>0
	

			SELECT ControlID,
					 Max(pRead) AS maxRead,
					 Max(pAuthor) AS maxAuthor,
					 Max(pEdit) AS maxEdit,
					 Max(pDesign) AS maxDesign,
					 Max(pStyle) AS maxStyle,
					 Max(pAdmin) AS maxAdmin,
					 Max(pApprove) AS maxApprove
			  FROM ItemSecurity
			 WHERE ( (UserGroupID = ?) )
		      AND
				(
					((ApplyTo=?)
						AND (PageID=?))
					OR
					((ApplyTo=?)
						AND (PageID IN (7,2,1)))
				)
				AND ControlID<>0
		 GROUP BY ControlID
		

			
			SELECT *
			  FROM Param_ImageWithCaption
			 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ControlID,PageID Desc, VersionID Desc 

	SELECT *
	  FROM Data_Image
	 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC 

		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_Image
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
	

	SELECT PageID, SubSiteID, FileName, OrigWidth, OrigHeight
	  FROM ImageGallery
	 WHERE (PageID = ?) 
		AND (VersionState = 2)
		AND SubSiteID IN (SELECT ID FROM SubSites WHERE SiteState=1)

		
		SELECT *
		  FROM Data_ImageWithCaption
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 ORDER BY ControlID, PageID Desc, VersionID Desc 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

   SELECT PageID,VersionState,AuthorID
     FROM Data_LinkList_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID Desc, VersionID Desc 

	SELECT *
	  FROM Data_LinkList_Items
	 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC 

		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_LinkList_Items
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
	

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

   SELECT PageID,VersionState,AuthorID
     FROM Param_WDDX
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT PageID
	  FROM ControlInstance
	 WHERE (pageid IN (1,2,7,2838)) 
		AND ControlType = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID Desc, VersionID Desc 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

   SELECT PageID,VersionState,AuthorID
     FROM Data_LinkList_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	

	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 

	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=7 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action

			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
		

	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	

	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 

	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=2838 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action

			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
		

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

		
		SELECT *
		  FROM Param_TextBlock
		 WHERE (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 ORDER BY ControlID, PageID Desc, VersionID Desc 

			
			SELECT *
			  FROM Data_TextBlock
			 WHERE (pageID IN (1,2,7,2838)) 
			 	AND versionState = 2
		 ORDER BY ControlID, PageID Desc, VersionID Desc 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

   SELECT PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

		SELECT *
		  FROM Param_WDDX
		 WHERE PageID=0
			AND ControlID=0
			AND ItemID=? 

	SELECT *
	  FROM Data_Schedule_Items
	 WHERE ControlID=1824
		AND ((PageID=2) AND (VersionState=2))
		AND (VersionState = 2) 
		AND ((itemEndDate >= ?)
			OR (itemEndDate is NULL) OR (itemEndDate = ''))
	
	ORDER BY PageID Desc, ItemPos Asc, VersionID DESC

    SELECT Count(x.uniqueid) AS Total
      FROM (Select DISTINCT uniqueid
			FROM Data_Schedule_Items
			WHERE PageID=?
						AND ControlID = ?
						AND VersionState >= ?
			) x

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

   SELECT PageID,VersionState,AuthorID
     FROM Data_LinkList_Items
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

   SELECT PageID,VersionState,AuthorID
     FROM Param_WDDX
    WHERE ControlID=?
		AND (PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Data_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY pageID Desc, versionID Desc 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (2838,7,2,1)  AND (VersionState = 2)) AND ((PageID=2838 OR (PageID IN (7,2,1) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 

				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ?