The DHS Program

	    Variable AUTHORLIST is undefined.
	    

		SELECT *
		  FROM SitePages
		 WHERE ID=?
			AND AudienceID=0
	

	SELECT *
	  FROM SitePages
	 WHERE ID=? 

		SELECT StaleCacheMaxKeepTime,DynamicContentCacheKeepTime
		  FROM SitePages
		 WHERE (ID IN (?,?,?,?)) 
	 ORDER BY ID
	

		SELECT DISTINCT SitePages.SubSiteID
		  FROM SitePages, Subsites
		 WHERE SitePages.SubSiteID = Subsites.ID
		
			AND Subsites.ID = ? 

			SELECT PageType
			  FROM SitePages
			 WHERE ID = ? 

					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,3,11,14,15))
	

		SELECT OriginalString AS Word 
				, KeywordType As KeywordTypeID
				
		  FROM ObjectKeywords
		 WHERE ObjectID = ? 
			AND KeywordType = ? 
	 ORDER BY Position, OriginalString
	

			SELECT GeneralCategories.Category, RenderOptions.PageID
			  FROM RenderOptions, GeneralCategories
			 WHERE GeneralCategories.ID = RenderOptions.CategoryID
				AND GeneralCategories.CategoryTypeID = ?
				AND (RenderOptions.PageID IN (?,?,?,?,?)) 
		 ORDER BY RenderOptions.PageID Desc
		

	SELECT PageType, SubSiteID, CategoryID, InheritedTemplateList, DocType, Uploaded
	  FROM SitePages
	 WHERE ID = ? 

	SELECT Data_FieldValue.PageID, Data_FieldValue.FieldValue, FormInputControl.FieldName, FormInputControl.type, FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid, FormInputControl.params AS fieldParams
						  
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE (Data_FieldValue.PageID IN (?,?,?,?,?))  
		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 (?,?)) 
				)
				
				
					OR (
								 (FormControlMap.ClassConstant = 1)
							AND ( (FormControlMap.ClassID IN (?,?,?,?)) )
						)
				
				
					OR (
								 (FormControlMap.ClassConstant = 2)
							AND (FormControlMap.ClassID = ?)
						)
				
				

				
			 )
	
 ORDER BY PageID DESC, FormControl.ID, FormInputControl.ID

	SELECT *
	  FROM Data_ClassNames
	 WHERE (PageID IN (?,?,?,?,?)) 
		AND VersionState = ?
		AND OutputTypeID = 0
 ORDER BY PageID DESC, ControlID DESC

		SELECT *
		  FROM Data_StyleSheetGroups
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos ASC
	

		SELECT *
		  FROM Data_StyleSheets
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND ControlID = ?
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos
	

		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState >= ?
			AND ModuleID <> 0
	

	SELECT DISTINCT ControlID
	  FROM ItemSecurity
	 WHERE PageID = ?
		AND ApplyTo = 0 

		SELECT SubsiteID,Filename,PageType
		  FROM SitePages
		 WHERE ID = ? 

		SELECT dcr.*
		  FROM Data_Custom_Render dcr, CustomElementModules cem
		 WHERE (dcr.PageID IN (?,?,?,?,?)) 
			AND dcr.VersionState=?
			AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
	 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
	

			SELECT *
			  FROM Param_Page
			 WHERE (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		

					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	

		SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename,
				 XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat,
				 XMLPublications.description,
				 CASE
					 	WHEN XMLPublicationFormat.IsSyndication = 0 THEN 0
						ELSE 1
				 END AS IsSyndicationFeed
		  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
		 WHERE Data_SeeAlso.PageID = ?
		 	AND Data_SeeAlso.Action = ?
		 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
		 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND XMLPublications.PageID = SitePages.ID
		 	AND SitePages.SubSiteID = SubSites.ID
	

SELECT Pub_Catalog.Pub_ID, Pub_Catalog.Pub_Type_ID, Pub_Stts.Stts_Lbl,Pub_Catalog.Pub_Code, 
  Pub_Catalog.Pub_Code_Num, Pub_Catalog.Ctry_List, Pub_Catalog.Print_Date, Pub_Catalog.Lang_List, 
  Pub_Catalog.Title, Pub_Catalog.Out_of_Print, Pub_Catalog.Copies, Pub_Type.Pub_Type_Name, Survey.Survey_Yr_Display, 
  Pub_Catalog.abstract, Pub_Catalog.authors, Pub_Catalog.notes, Pub_Catalog.Addln_notes, Pub_Catalog.title_secondary, 
  Pub_Catalog.title_sentencecaps, pub_url, publisher, publisher_city, pub_type_cite, citation, abstract_updated, citation_checked,
  Author_Fname_1, Author_Fname_2, Author_Fname_3, Author_Fname_4, Author_Fname_5,
  Author_Lname_1, Author_Lname_2, Author_Lname_3, Author_Lname_4, Author_Lname_5,
  Author_Fname_6, Author_Fname_7, Author_Fname_8, Author_Fname_9, Author_Fname_10,
  Author_Lname_6, Author_Lname_7, Author_Lname_8, Author_Lname_9, Author_Lname_10,
  Author_Type_1, Author_Type_2, Author_Type_3, Author_Type_4, Author_Type_5,
  Author_Type_6, Author_Type_7, Author_Type_8, Author_Type_9, Author_Type_10, 
  (SELECT ctry_name FROM Ctry, survey WHERE ctry.ctry_id = survey.ctry_id and survey.survey_id=Pub_Catalog.survey_id ) AS ctry_name, 
  (SELECT Count(*) FROM Pub_PDF WHERE Pub_PDF.Pub_ID = Pub_Catalog.Pub_ID) AS NoPDF 
FROM Pub_Catalog 
  INNER JOIN Pub_Type 
    ON Pub_Type.Pub_Type_ID = Pub_Catalog.Pub_Type_ID
     INNER JOIN Pub_Stts
    ON Pub_Stts.Stts_ID = Pub_Catalog.Stts_ID
  LEFT OUTER JOIN Survey 
    ON Survey.Survey_ID = Pub_Catalog.Survey_ID 
WHERE Pub_Code = 'ab11'

SELECT Ctry_Name, Survey_Type_Lbl, Pub_Catalog.Pub_ID, Pub_Catalog.Pub_Type_ID, Pub_Stts.Stts_Lbl,Pub_Catalog.Pub_Code, 
  Pub_Catalog.Pub_Code_Num, Pub_Catalog.Print_Date, Pub_Catalog.Title, Pub_Type.Pub_Type_Name, Pub_Catalog.Lang_List, 
  Survey.Survey_Yr_Display, Pub_Catalog.title_secondary, Pub_Catalog.title_sentencecaps, pub_url
FROM Pub_Catalog 
  INNER JOIN Pub_Type 
    ON Pub_Type.Pub_Type_ID = Pub_Catalog.Pub_Type_ID
  INNER JOIN Pub_Stts
    ON Pub_Stts.Stts_ID = Pub_Catalog.Stts_ID
  LEFT OUTER JOIN Survey 
    ON Survey.Survey_ID = Pub_Catalog.Survey_ID 
  LEFT OUTER JOIN Ctry
     ON Ctry.Ctry_ID = Survey.Ctry_ID
  LEFT OUTER JOIN Survey_SubType
     ON Survey_SubType.Survey_SubType_ID = Survey.Survey_Type_ID
  LEFT OUTER JOIN Survey_Type
     ON Survey_Type.Survey_Type_ID = Survey_SubType.Survey_Type_MainID	
WHERE Pub_Code = 'ab11'

		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

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

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

	SELECT *
	  FROM Data_Menu_Items
	 WHERE (PageID=126278 OR (PageID IN (11242,1652,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=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 19150 ORDER BY d1.id, d2.id 

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

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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_LinkList_Items
	 WHERE (PageID=126278 OR (PageID IN (11242,1652,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=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
	

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 13691 ORDER BY d1.id, d2.id 

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

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

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND PageID=126278
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND ((PageID=1652) AND (VersionState=2))
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	AND (
		 
			 (ItemID = ?
			 AND VersionID = ?)
		 
		 )

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 1639 ORDER BY d1.id, d2.id 

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

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND ((PageID=11242) AND (VersionState=2))
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	AND (
		 
			 (ItemID = ?
			 AND VersionID = ?)
		 
			 OR
			 
			 (ItemID = ?
			 AND VersionID = ?)
		 
		 )

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 62104 ORDER BY d1.id, d2.id 

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

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 DisplayTemplateID, ModuleID
	  FROM Data_Custom_Render
	 WHERE ControlID = ?
		AND (PageID IN (?,?,?,?,?)) 
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID DESC

	SELECT *
	  FROM ElementDefaults
	 WHERE ElementTypeID = ? 

		SELECT params
		  FROM FormControl
		 WHERE ID = ? 

		SELECT *
		  FROM CustomElementModules
		 WHERE ID = ?
			AND (IncludeStyle + IncludeParams + IncludeLayout + IncludeMetadata) > 0 
			AND DisplayTemplateID = 0
	

	SELECT *
	  FROM Data_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

			SELECT DataBlock, PageID, ControlID
			  FROM ElementDataCache
			 WHERE (PageID = ?) 
				AND ControlID = 0
			
				AND FormID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

		SELECT DisplayTemplateID, ModuleID
		  FROM Data_Custom_Render
		 WHERE ControlID = ?
			AND (PageID IN (?,?,?,?,?)) 
			AND (VersionState = 2)
	 ORDER BY PageID DESC, VersionID DESC
	

		SELECT rmm.FormControlID, rmm.Data_TextBlockID, rmm.TransactionDate, rmm.PreviewImageID, rmm.ItemState, rmm.Description,
			CASE WHEN ed.DisplayTemplateID = rmm.Data_TextBlockID THEN 1 ELSE 0 END AS IsDefault
		  FROM RenderMaskMap rmm
		  LEFT OUTER JOIN ElementDefaults ed ON ed.DisplayTemplateID = rmm.Data_TextBlockID AND ed.HandlerID = 0
		 WHERE rmm.FormControlID = ? 
			AND rmm.Data_TextBlockID = ed.DisplayTemplateID
		

	SELECT InputType, FieldName, FormID, InputID, custFldType_ID, custFldType_DataType
	  FROM attributes.formDefQuery
	 WHERE InputType IN (?,?,?,?,?,?,?,?,?,?)
		 OR custFldType_ID > 0

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

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

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

				SELECT Ctry_ID
				 FROM    Ctry
				 WHERE   Ctry_Name = ? 

		SELECT topic_id, pub_topic_name
		FROM qGetTopicList
		ORDER by pub_topic_name 
		

		SELECT PDF_File_Name
		FROM qGetPubsDetails   
		

    SELECT pub_id from pub_catalog where parent_pub_id = 2150 

    SELECT link_pub_ids 
	FROM pub_catalog 
	WHERE pub_id = 2150 
	  AND link_pub_ids is not NULL
    

SELECT Pub_Catalog.Pub_ID, Pub_Catalog.Pub_Type_ID, Pub_Stts.Stts_Lbl,Pub_Catalog.Pub_Code, 
  Pub_Catalog.Pub_Code_Num, Pub_Catalog.Ctry_List, Pub_Catalog.Print_Date, Pub_Catalog.Lang_List, 
  Pub_Catalog.Title, Pub_Catalog.Out_of_Print, Pub_Catalog.Copies, Pub_Type.Pub_Type_Name, Survey.Survey_Yr_Display, 
  Pub_Catalog.abstract as abstract_text, Pub_Catalog.authors, Pub_Catalog.notes, Pub_Catalog.Addln_notes, Pub_Catalog.title_secondary, 
  Pub_Catalog.title_sentencecaps, pub_url, publisher, publisher_city, pub_type_cite, citation, abstract_updated, citation_checked,
  Author_Fname_1, Author_Fname_2, Author_Fname_3, Author_Fname_4, Author_Fname_5,
  Author_Lname_1, Author_Lname_2, Author_Lname_3, Author_Lname_4, Author_Lname_5,
  Author_Fname_6, Author_Fname_7, Author_Fname_8, Author_Fname_9, Author_Fname_10,
  Author_Lname_6, Author_Lname_7, Author_Lname_8, Author_Lname_9, Author_Lname_10,
  Author_Type_1, Author_Type_2, Author_Type_3, Author_Type_4, Author_Type_5,
  Author_Type_6, Author_Type_7, Author_Type_8, Author_Type_9, Author_Type_10, 
  (SELECT ctry_name FROM Ctry, survey WHERE ctry.ctry_id = survey.ctry_id and survey.survey_id=Pub_Catalog.survey_id ) AS ctry_name, 
  (SELECT Count(*) FROM Pub_PDF WHERE Pub_PDF.Pub_ID = Pub_Catalog.Pub_ID) AS NoPDF 
FROM Pub_Catalog 
  INNER JOIN Pub_Type 
    ON Pub_Type.Pub_Type_ID = Pub_Catalog.Pub_Type_ID
     INNER JOIN Pub_Stts
    ON Pub_Stts.Stts_ID = Pub_Catalog.Stts_ID
  LEFT OUTER JOIN Survey 
    ON Survey.Survey_ID = Pub_Catalog.Survey_ID 
WHERE Pub_Code <> 'NA' 
  AND Pub_Catalog.Pub_ID = 2150
  AND Pub_Type.Pub_Type_ID IN (15,16,6,18,9,45,11,4,8,12,27,5,26,39,21,30,46)    

				    SELECT Ctry_ID FROM    Ctry WHERE   Ctry_Name = 'Burundi'
				 

				    SELECT Ctry_ID FROM    Ctry WHERE   Ctry_Name = 'Nepal'
				 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND ((PageID=1652) AND (VersionState=2))
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	AND (
		 
			 (ItemID = ?
			 AND VersionID = ?)
		 
			 OR
			 
			 (ItemID = ?
			 AND VersionID = ?)
		 
		 )

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 27367 ORDER BY d1.id, d2.id 

			SELECT Data_FieldValue.PageID, Data_FieldValue.FieldValue,FormInputControl.FieldName,FormControl.FormName,FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,Data_FieldValue.MemoValue
			  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue
			 WHERE Data_FieldValue.FieldID = FormInputControl.ID
				AND Data_FieldValue.FormID = FormControl.ID
				AND (Data_FieldValue.PageID IN (?,?,?,?,?)) 
				AND FormInputControl.ID = FormInputControlMap.FieldID
				AND FormControl.ID = FormInputControlMap.FormID
				AND (( (Data_FieldValue.FieldID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) 
				AND (Data_FieldValue.formID = ?) ))
				AND ControlID = ?
		 ORDER BY Data_FieldValue.PageID DESC, FormControl.ID, FormInputControl.ID
		

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

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 DisplayTemplateID, ModuleID
	  FROM Data_Custom_Render
	 WHERE ControlID = ?
		AND (PageID IN (?,?,?,?,?)) 
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID DESC

	SELECT *
	  FROM ElementDefaults
	 WHERE ElementTypeID = ? 

		SELECT params
		  FROM FormControl
		 WHERE ID = ? 

		SELECT *
		  FROM CustomElementModules
		 WHERE ID = ?
			AND (IncludeStyle + IncludeParams + IncludeLayout + IncludeMetadata) > 0 
			AND DisplayTemplateID = 0
	

	SELECT *
	  FROM Data_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 

			SELECT DataBlock, PageID, ControlID
			  FROM ElementDataCache
			 WHERE (PageID = ?) 
				AND ControlID = 0
			
				AND FormID = ? 

		SELECT ig.GalleryID, ig.OrigHeight, ig.OrigWidth, ig.FileName, ig.SubsiteID, ig.PageID, igs.SizeRestrictionType, ig.SubsiteID
		  FROM ImageGallery ig
		  JOIN Subsites s ON s.ID = ig.SubsiteID
		  JOIN SitePages sp ON sp.ID = ig.PageID
		  JOIN ImageGalleries igs ON ig.GalleryID = igs.ID
		 WHERE ig.PageID IN (?)
			AND ig.VersionState = ? 

			SELECT IsTransparent, SubsiteID, GalleryID, FileName
			  FROM ImageGallery
			 WHERE PageID = ?
				AND VersionState = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

		SELECT ID
		  FROM CustomElementModules
		 WHERE ID = ? 

		SELECT Name, HasFieldMappings, GenericFieldMappings, ModulePath
		  FROM CustomElementModules
		 WHERE ElementType = ?
			AND ID = ? 

		SELECT DisplayTemplateID, ModuleID
		  FROM Data_Custom_Render
		 WHERE ControlID = ?
			AND (PageID IN (?,?,?,?,?)) 
			AND (VersionState = 2)
	 ORDER BY PageID DESC, VersionID DESC
	

		SELECT rmm.FormControlID, rmm.Data_TextBlockID, rmm.TransactionDate, rmm.PreviewImageID, rmm.ItemState, rmm.Description,
			CASE WHEN ed.DisplayTemplateID = rmm.Data_TextBlockID THEN 1 ELSE 0 END AS IsDefault
		  FROM RenderMaskMap rmm
		  LEFT OUTER JOIN ElementDefaults ed ON ed.DisplayTemplateID = rmm.Data_TextBlockID AND ed.HandlerID = 0
		 WHERE rmm.FormControlID = ? 
			AND rmm.Data_TextBlockID = ed.DisplayTemplateID
		

	SELECT InputType, FieldName, FormID, InputID, custFldType_ID, custFldType_DataType
	  FROM attributes.formDefQuery
	 WHERE InputType IN (?,?,?,?,?,?,?,?,?,?)
		 OR custFldType_ID > 0

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

SELECT FormName FROM mdCheckQry where lower(FormName) = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

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

		SELECT *
		  FROM Param_TextBlock
		 WHERE ControlID=?
			AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 ORDER BY ControlID, PageID Desc, VersionID Desc 

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

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND PageID=126278
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND ((PageID=2) AND (VersionState=2))
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	AND (
		 
			 (ItemID = ?
			 AND VersionID = ?)
		 
		 )

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND ((PageID=2) AND (VersionState=2))
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	AND (
		 
			 (ItemID = ?
			 AND VersionID = ?)
		 
			 OR
			 
			 (ItemID = ?
			 AND VersionID = ?)
		 
		 )

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 19148 ORDER BY d1.id, d2.id 

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

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 19148 ORDER BY d1.id, d2.id 

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

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND ((PageID=2) AND (VersionState=2))
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	AND (
		 
			 (ItemID = ?
			 AND VersionID = ?)
		 
			 OR
			 
			 (ItemID = ?
			 AND VersionID = ?)
		 
		 )

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND ((PageID=2) AND (VersionState=2))
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	AND (
		 
			 (ItemID = ?
			 AND VersionID = ?)
		 
		 )

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 19148 ORDER BY d1.id, d2.id 

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

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 19148 ORDER BY d1.id, d2.id 

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

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID,VersionState,AuthorID
     FROM Data_Schedule_Items
    WHERE ControlID=?
		AND (PageID=126278 OR (PageID IN (11242,1652,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc

	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=126278 AND (VersionState = 2)) OR ((PageID IN (11242,1652,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 PageID, ControlID, VersionID, VersionState, Action AS ItemAction, OwnerID, AuthorID, DateAdded,
				DateApproved, DateLastCurrent, ItemID, ItemPos, ItemUserGroupList, ItemBeginDate, ItemEndDate, ItemPageCategories,
				ItemSubsites, ItemRenderOps, ItemLevelList, ItemBeginTime, ItemEndTime, ItemWeekDays, ItemBrowserTypes,
				ItemVarName, ItemVarValue, ItemVarOperator, UniqueID, ElementInstanceType, ShortDesc, RowNumber, ColumnNumber
	  FROM Data_Schedule_Items
	 WHERE ControlID=?
		AND ((PageID=2) AND (VersionState=2))
		AND (VersionState = 2) 
		AND (itemEndDate >= ?
			OR (itemEndDate is NULL or itemEndDate = ''))
	
		AND ElementInstanceType > 0
		AND UniqueID > 0
	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

	SELECT ItemID
	  FROM GetAllScheduleItems
	 WHERE (ItemAction = ?
	 		OR ItemAction = ?)
	 	AND ElementInstanceType = ? 

	SELECT ItemID, MAX(VersionID) AS MaxVersionID
	  FROM GetAllScheduleItems
	 GROUP BY ItemID

	SELECT *
	  FROM GetAllScheduleItems
	  WHERE 1=1

	AND (
		 
			 (ItemID = ?
			 AND VersionID = ?)
		 
		 )

	ORDER BY PageID Desc, RowNumber Asc, ColumnNumber Asc, ItemPos Asc, VersionID DESC

			SELECT ControlName
			  FROM ControlInstance
			 WHERE ParentControlID = ?
			 	AND ControlID = ?
				AND (PageID IN (?,?,?,?,?)) 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,14,15))
	

		SELECT gr.ID AS GridRowID, gr.Name, gr.Description, gr.isFactory, gr.isActive, gr.RowTag, gr.isDefault, 
				 gr.DateContentLastModified, gr.RowTag_AllowOverride, gr.RowClasses, gr.RowClasses_AllowOverride,
				 gr.ClassOptions, gr.InnerRowTag, gr.InnerRowTag_AllowOverride, gr.InnerRowClasses, 
				 gr.InnerRowClasses_AllowOverride, gr.InnerClassOptions,
		(SELECT COUNT(ID)
					  FROM GridLayout_Columns
					 WHERE GridRowID = gr.ID) AS ColumnCount
		  FROM GridLayout_Rows gr
		 WHERE ID = ? 

		SELECT gc.ID as ColumnID, gc.GridRowID, gr.Name as RowName, gc.isFactory, gc.ColumnNumber, gc.ColumnTag,
				   gc.ColumnTag_AllowOverride, gc.ColumnClasses, gc.ColumnClasses_AllowOverride, 
					gc.ClassOptions, gc.AllowedElementTypes, gc.DateContentLastModified AS DateLastModified
		  FROM GridLayout_Columns gc, Gridlayout_Rows gr
		 WHERE gc.GridRowID = gr.ID
		 
		   AND gc.GridRowID = ? 
		 	AND gc.ID = ? 
		 ORDER BY gc.ColumnNumber asc
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ?