SELECT *
				  FROM Param_Page
				 WHERE (PageID=98759 OR (PageID IN (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,3,7)) 
			)
	
			OR ((FormControlMap.ClassConstant = 1) AND ( (FormControlMap.ClassID IN (1,2,7)) ))
	
			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 = 98759
			ORDER BY SortOrder
		

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

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

				SELECT SitePages.Title
				  FROM SubSites,SitePages
				 WHERE SubSites.ID = 7
					AND SubSites.SecurityPageID = SitePages.ID
			

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

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

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

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

		
		SELECT *
		  FROM Param_TextBlock
		 WHERE (PageID=98759 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,98759)) 
			 	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=98759 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	

	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=98759 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=98759 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 TOP 3 SitePages.*, DocCategories.Category, data_fieldvalue.Fieldvalue
				FROM DocCategories As DocCategories, SitePages As SitePages,
					data_fieldvalue as data_fieldvalue, forminputcontrol as forminputcontrol
				WHERE (DocCategories.ID = SitePages.CategoryID) 
					AND (SitePages.ApprovalStatus=0 AND SitePages.AudienceID=0 
					AND sitePages.subSiteID <> 0 AND SitePages.PageSetID = 0) 
					AND (SitePages.PageType IN (0,5) AND Uploaded=0) 
					AND SitePages.PageType NOT IN (4,9) 
					AND ( ( SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where Data_FieldValue.fieldID = 6858 and Data_FieldValue.formID = 6855 
							and Data_FieldValue.VersionState >= 2 
						) and ( SitePages.SubSiteID in (7) and ((SitePages.CategoryID not in (8)) OR (SitePages.CategoryID = 0)) ) 
						or SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where 
						(Data_FieldValue.fieldID = 45868 or data_fieldvalue.fieldid = 51999)
						and Data_FieldValue.formID = 6855 
						and Data_FieldValue.VersionState >= 2 AND ((Data_FieldValue.fieldValue LIKE '%Education%') 
						)) 
						) ) 
					AND ((SitePages.IsPublic > 0) ) AND (SitePages.PublicReleaseDate <= '2008-07-04 11:39:46') AND (SitePages.ID <> 96544) AND 
					(SitePages.ExpDate >= '2008-07-04 11:39:46' OR SitePages.ExpDate IS NULL) 
					AND sitepages.id = data_fieldvalue.pageid
					AND data_fieldvalue.fieldid = forminputcontrol.id
					and forminputcontrol.fieldname = 'FIC_Date'
					and sitepages.filename not like '%es.cfm'
				ORDER BY fieldvalue desc 

			

								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 250737
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							

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

								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 240140
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							

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

								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 235132
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							

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

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

				SELECT TOP 3 SitePages.*, DocCategories.Category, data_fieldvalue.Fieldvalue
				FROM DocCategories As DocCategories, SitePages As SitePages,
					data_fieldvalue as data_fieldvalue, forminputcontrol as forminputcontrol
				WHERE (DocCategories.ID = SitePages.CategoryID) 
					AND (SitePages.ApprovalStatus=0 AND SitePages.AudienceID=0 
					AND sitePages.subSiteID <> 0 AND SitePages.PageSetID = 0) 
					AND (SitePages.PageType IN (0,5) AND Uploaded=0) 
					AND SitePages.PageType NOT IN (4,9) 
					AND ( ( SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where Data_FieldValue.fieldID = 6858 and Data_FieldValue.formID = 6855 
							and Data_FieldValue.VersionState >= 2 
						) and ( SitePages.SubSiteID in (7) and ((SitePages.CategoryID not in (8)) OR (SitePages.CategoryID = 0)) ) 
						or SitePages.ID in 
						(select pageID from Data_FieldValue As Data_FieldValue where 
						(Data_FieldValue.fieldID = 45868 or data_fieldvalue.fieldid = 51999)
						and Data_FieldValue.formID = 6855 
						and Data_FieldValue.VersionState >= 2 AND ((Data_FieldValue.fieldValue LIKE '%Education%') 
						)) 
						) ) 
					AND ((SitePages.IsPublic > 0) ) AND (SitePages.PublicReleaseDate <= '2008-07-04 11:39:46') AND (SitePages.ID <> 96544) AND 
					(SitePages.ExpDate >= '2008-07-04 11:39:46' OR SitePages.ExpDate IS NULL) 
					AND sitepages.id = data_fieldvalue.pageid
					AND data_fieldvalue.fieldid = forminputcontrol.id
					and forminputcontrol.fieldname = 'FIC_Date'
					and sitepages.filename not like '%es.cfm'
				ORDER BY fieldvalue desc 

			

								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 250737
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							

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

								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 240140
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							

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

								SELECT 	
												Data_FieldValue.pageid, 
												Data_fieldvalue.formid,
												Data_fieldvalue.fieldid,
												data_fieldvalue.fieldvalue,
												forminputcontrol.fieldname
												
								  FROM data_fieldvalue as data_fieldvalue,
									forminputcontrol as forminputcontrol
												
								 WHERE 
												data_fieldvalue.fieldid = forminputcontrol.id
												and data_fieldvalue.versionstate = 2
												AND Data_fieldvalue.formid in (6855,4500) 
												and data_fieldvalue.pageid = 235132
												and forminputcontrol.fieldname in ('FIC_Date','FIC_Author','FIC_PaperNum')
												order by pageid,formid,fieldid
							

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

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

	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=98759 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=98759 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 = ? 

				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 = ?