The DHS Program

    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    

		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=9415 OR (PageID IN (1501,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 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 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 = 1689 ORDER BY d1.id, d2.id 

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

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

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

			SELECT PublicReleaseDate
			  FROM SitePages
			 WHERE (PublicReleaseDate is NOT NULL AND PublicReleaseDate <> '')
				AND PublicReleaseDate > ?
			 ORDER BY PublicReleaseDate 

			SELECT PageID
			  FROM TemplateInheritance
			 WHERE (InheritedFromPageID = ?) 
				AND PageID IN (SELECT ID
									  FROM SitePages
									 WHERE PageType=?)

			

			SELECT SitePages.*,GeneralCategories.Category 
				,UploadedDocs.PublicFileName
		
			  FROM GeneralCategories,SitePages 
			LEFT OUTER JOIN UploadedDocs ON UploadedDocs.PageID = SitePages.ID AND UploadedDocs.VersionState = 2
		
			 WHERE
			
		SitePages.PublicReleaseDate <? AND GeneralCategories.ID = SitePages.CategoryID AND GeneralCategories.CategoryTypeID = 1 AND SitePages.AudienceID = ? AND SitePages.SubSiteID <> ? AND SitePages.PageSetID = ? AND SitePages.ApprovalStatus = ? AND 
		( (SitePages.PageType IN (?,?,?,?)) 
		)
		AND 
		( (SitePages.IsPublic IN (?,?,?,?,?,?,?,?)) 
		)
	AND 
			(
			SitePages.ID IN 
		(
			SELECT DISTINCT PageID
			  FROM TemplateInheritance
			 WHERE (InheritedFromPageID = ?) 
		)
	
			)
			
				ORDER BY SitePages.PublicReleaseDate desc,SitePages.title desc,SitePages.ID
			

		SELECT DISTINCT ContactID, FullName2 AS fullname
		  FROM UserFullNames
		 WHERE (ContactID IN (1000006,1000008,1000034,1000041,1000042))
		 
		 	UNION
		
		SELECT DISTINCT ID as ContactID, GroupName AS fullname
		  FROM idgroup
		 WHERE (ID IN (1000006,1000008,1000034,1000041,1000042)) 

		SELECT *
		  FROM Formats
	

			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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 AvailableControls
		 WHERE ID = ?
			AND (Name='custom')
	

		SELECT fic.ID, fic.FieldName AS Name, cft.ID AS TypeID, fic.Type, fic.params AS Label, fic.Shared AS isShared,
				 fic.Description, ficm.TabID, ficm.ItemPos AS Position, '0' AS Required
		  FROM FormInputControl fic
		  JOIN FormInputControlMap ficm ON ficm.FieldID = fic.ID
		  LEFT OUTER JOIN CustomFieldTypes cft ON cft.Type = fic.Type
		 WHERE ficm.FormID = ? 
	 ORDER BY ficm.ItemPos
	

		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 *
	  FROM Data_Ghost_Common
	 WHERE (PageID=9415 OR (PageID IN (1501,2,1) AND (VersionState = 2)))
	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 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 = 9410 ORDER BY d1.id, d2.id 

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

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

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

			SELECT PageID
			  FROM TemplateInheritance
			 WHERE (InheritedFromPageID = ?) 
				AND PageID IN (SELECT ID
									  FROM SitePages
									 WHERE PageType=?)

			

			SELECT SitePages.*,GeneralCategories.Category 
				,UploadedDocs.PublicFileName
		
			  FROM GeneralCategories,SitePages 
			LEFT OUTER JOIN UploadedDocs ON UploadedDocs.PageID = SitePages.ID AND UploadedDocs.VersionState = 2
		
			 WHERE
				
		(SitePages.ExpDate >= ?
			OR	(SitePages.ExpDate is NULL or SitePages.ExpDate = ''))
	AND GeneralCategories.ID = SitePages.CategoryID AND GeneralCategories.CategoryTypeID = 1 AND SitePages.AudienceID = ? AND SitePages.SubSiteID <> ? AND SitePages.PageSetID = ? AND SitePages.ApprovalStatus = ? AND 
		( (SitePages.PageType IN (?,?,?,?)) 
		)
		AND 
		( (SitePages.IsPublic IN (?,?,?,?,?,?,?,?)) 
		)
	AND 
			(
			SitePages.ID IN 
		(
			SELECT DISTINCT PageID
			  FROM TemplateInheritance
			 WHERE (InheritedFromPageID = ?) 
		)
	
			)
			
				ORDER BY SitePages.PublicReleaseDate desc,SitePages.title desc,SitePages.ID
			

		SELECT DISTINCT ContactID, FullName2 AS fullname
		  FROM UserFullNames
		 WHERE (ContactID IN (1000006,1000008,1000034,1000041,1000042))
		 
		 	UNION
		
		SELECT DISTINCT ID as ContactID, GroupName AS fullname
		  FROM idgroup
		 WHERE (ID IN (1000006,1000008,1000034,1000041,1000042)) 

		SELECT *
		  FROM Formats
	

			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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)
	

					UPDATE ElementInstance
						SET CacheFormat=?,
							 CacheValidUntil=?,
							 ContentValidUntil=?,
							 DataPageID=?,
							 DependentObjectID=?,
							 DynamicStatus=?,
							 HasChildren=?,
							 HasData=?,
							 HasDynamicContent=?,
							 IndexStatus=?,
							 IsDeviceDependent=?,
							 ParamPageID=?,
							 PrintStatus=?,
							 ShareStatus=?,
							 ConflictList=?
					 WHERE ServerID=?
						AND SubsiteID=?
						AND PageID=?
						AND ControlID=?
						AND CacheLevel=?
						AND IsWIP=? 

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-03 12:12:03
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\Who-We-Are\News-Room\archives.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/Who-We-Are/News-Room/archives.cfm?beginDate=%7Bts+%272004-01-01+00%3A00%3A00%27%7D
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\Who-We-Are\News-Room\archives.cfm
QUERY_STRING=beginDate=%7Bts+%272004-01-01+00%3A00%3A00%27%7D
REMOTE_ADDR=10.0.2.129
REMOTE_HOST=10.0.2.129
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Who-We-Are/News-Room/archives.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CSRFTOKEN=6FD57ABB5703259F3C7A424148C11971327B54C9

Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=27
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
cloudfrontkeypairid=K3LSHNFSZFMIUC
cloudfronturl=d1vyaiefsqy4pf
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (123)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_request_start_memory=1591736320
cs_runningdashboardcmdcode=0
csrftoken=6FD57ABB5703259F3C7A424148C11971327B54C9
ctrl_data=Struct (90)
customcfupfront=
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
data_ghost=Struct (0)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (2)
elementsrun=2
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-07-03 03:35:34
getghost=Query (0)
gvpageid=9415
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719977734827
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modeorderbyclause_page=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (5)
params_formfields=
params_urlfields=beginDate
previewmode=0
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-03 03:35:34.812
req_sequenceid=58941
req_startticks=1719977734812
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_1E5E4DE66B1C47C3D98FCADE08E5BA61.cfusion
sessionstring=1_1E5E4DE66B1C47C3D98FCADE08E5BA61.cfusion
sicupfront=
sicupfrontparam=
site=Struct (74)
siteid=1
standardrenderhandlers=
structdoctypes=Struct (158)
structowners=Struct (5)
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
subsiteid=18
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
thecontrolid=9408
timestamp={ts '2024-07-03 03:35:34'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
vcontrolid=9408
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)

Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
_csrf_token=6FD57ABB5703259F3C7A424148C11971327B54C9
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=9415
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1719977734827
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=1E5E4DE66B1C47C3D98FCADE08E5BA61.cfusion
sessionstring=1_1E5E4DE66B1C47C3D98FCADE08E5BA61.cfusion
urltoken=CFID=2280258&CFTOKEN=eb79b2284897b303-A29E1029-F75B-1162-763138D9F3E1EA1C&jsessionid=1E5E4DE66B1C47C3D98FCADE08E5BA61.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)

URL Parameters:
beginDate={ts '2004-01-01 00:00:00'}