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

	SELECT Data_FieldValue.FieldValue,FormInputControl.FieldName,FormInputControl.type,FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE Data_FieldValue.PageID = ?
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
		AND (
				((FormControlMap.ClassConstant = 4)
			
				AND (FormControlMap.ClassID IN (1,4,42)) 
			)
	
			OR ((FormControlMap.ClassConstant = 1) AND ( (FormControlMap.ClassID IN (1,2,7,15136)) ))
	
			OR ((FormControlMap.ClassConstant = 2) AND (FormControlMap.ClassID = ?))
	
			 )
 ORDER BY FormControl.ID, FormInputControl.ID

			select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
			tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
			WHERE SitePagesID = 234194
			ORDER BY SortOrder
		

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

		SELECT *
		FROM Param_WDDX
		WHERE (PageID=234194 OR (PageID IN (15136,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=234194 OR (PageID IN (15136,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_Menu_Items
		 WHERE (PageID=234194 OR (PageID IN (15136,7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
	

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

			SELECT DISTINCT ControlID
			  FROM ItemSecurity
			 WHERE ((PageID = ? AND ApplyTo=0)
						OR ( (PageID IN (1,2,7,15136,234194)) 
							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 (15136,7,2,1) 

		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (15136,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 (15136,7,2,1)))
				)
				AND ControlID<>0
		 GROUP BY ControlID
		

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

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

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

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

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

	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=234194 OR (PageID IN (15136,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=234194 OR (PageID IN (15136,7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
		

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

		
		SELECT *
		  FROM Param_TextBlock
		 WHERE (PageID=234194 OR (PageID IN (15136,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,15136,234194)) 
			 	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 = ? 

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

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

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

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

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

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

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

			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=234194 OR (PageID IN (15136,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 dcr.*
			  FROM Data_Custom_Render dcr, CustomElementModules cem
			 WHERE (dcr.PageID IN (1,2,7,15136,234194)) 
				AND dcr.VersionState=?
				AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
		 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
		

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 d4.ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1, formInputControl d2, formInputControlMap d3,
		  formControlMap d4, FormControlTabs d5
		 WHERE d3.fieldID = d2.ID
			AND d1.ID = d3.formID
		
			AND d1.ID = d4.formID
		
			AND d5.ID = d3.TabID
				and d4.classConstant in ( 7 ) and d4.classID = 15205 order by d1.id, d2.id 

			SELECT ID, Name, InheritedTemplateList, PageType
			  FROM SitePages
			 WHERE ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (234194,15136,7,2,1)  AND (VersionState = 2)) AND ((((PageID=234194) AND (VersionState >= 2)) OR (PageID IN (15136,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_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ?
		AND (PageID IN (234194,15136,7,2,1)  AND (VersionState = 2)) AND ((PageID=234194 OR (PageID IN (15136,7,2,1) AND (VersionState = 2))))
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

	SELECT ID, ParentID
	  FROM SubSites
	 WHERE ParentID = ?
		AND SiteState = 1

		SELECT expDate
		  FROM SitePages
		 WHERE expDate IS NOT NULL
			AND expDate > ?
	 ORDER BY expDate
	

		SELECT PublicReleaseDate
		  FROM SitePages
		 WHERE PublicReleaseDate IS NOT NULL
			AND PublicReleaseDate > ?
	 ORDER BY PublicReleaseDate
	

		    SELECT
		SitePages.*, DocCategories.Category  FROM DocCategories,SitePages
 WHERE (DocCategories.ID = SitePages.CategoryID)  AND  AudienceID = 0
	AND (( (SitePages.ApprovalStatus=0 AND SitePages.AudienceID=0 AND sitePages.subSiteID <> 0 AND SitePages.PageSetID = 0)
			AND (SitePages.PageType IN (0) AND Uploaded=0) AND SitePages.PageType NOT IN (4,9)  AND (  SitePages.ID in (select pageID from Data_FieldValue where Data_FieldValue.fieldID = 15166 AND Data_FieldValue.formID = 15164 AND Data_FieldValue.VersionState >= 2 AND Data_FieldValue.fieldValue > '2008-07-04 23:59:59')  )  AND (SitePages.IsPublic IN (1,3,5,7,9,11,13,15)) ))  AND (SitePages.ExpDate >= '2008-07-04 00:00:00' OR SitePages.ExpDate IS NULL) AND (SitePages.PublicReleaseDate < '2008-07-04 23:06:24') 
	 ORDER BY SitePages.Title asc 

		SELECT DISTINCT LastName, FirstName, ContactID
		  FROM Contacts
		 WHERE (ContactID  IN (1000015 )) 

		SELECT *
		  FROM Formats
	

	SELECT Data_FieldValue.FieldValue,FormInputControl.FieldName,FormInputControl.type,FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE Data_FieldValue.PageID = ?
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
		AND (
				((FormControlMap.ClassConstant = 4)
			
				AND (FormControlMap.ClassID IN (1,4,42)) 
			)
	
			OR ((FormControlMap.ClassConstant = 1) AND ( (FormControlMap.ClassID IN (1,2,7,15136)) ))
	
			OR ((FormControlMap.ClassConstant = 2) AND (FormControlMap.ClassID = ?))
	
			 )
 ORDER BY FormControl.ID, FormInputControl.ID

	SELECT Data_FieldValue.FieldValue,FormInputControl.FieldName,FormInputControl.type,FormControl.Fo