DECLARE @SitePresentationURL nvarchar(max) = N'%www.arabiagis.com%';
DECLARE @SiteStatus nvarchar(max) = N'RUNNING';

SELECT *
FROM CMS_Site
WHERE [SitePresentationURL] LIKE @SitePresentationURL AND [SiteStatus] = @SiteStatus
ORDER BY SitePresentationURL

DECLARE @SiteDomainName nvarchar(max) = N'www.arabiagis.com/';
DECLARE @SiteDomainAliasName nvarchar(max) = N'www.arabiagis.com/';
DECLARE @SiteStatus nvarchar(max) = N'RUNNING';

SELECT *
FROM CMS_Site
WHERE ([SiteDomainName] = @SiteDomainName OR [SiteID] IN (
SELECT [SiteID]
FROM CMS_SiteDomainAlias
WHERE [SiteDomainAliasName] = @SiteDomainAliasName
)) AND [SiteStatus] = @SiteStatus

DECLARE @SiteDomainName nvarchar(max) = N'www.arabiagis.com';
DECLARE @SiteDomainAliasName nvarchar(max) = N'www.arabiagis.com';
DECLARE @SiteStatus nvarchar(max) = N'RUNNING';

SELECT *
FROM CMS_Site
WHERE ([SiteDomainName] = @SiteDomainName OR [SiteID] IN (
SELECT [SiteID]
FROM CMS_SiteDomainAlias
WHERE [SiteDomainAliasName] = @SiteDomainAliasName
)) AND [SiteStatus] = @SiteStatus

DECLARE @SitePresentationURL nvarchar(max) = N'%arabiagis.com%';
DECLARE @SiteStatus nvarchar(max) = N'RUNNING';

SELECT *
FROM CMS_Site
WHERE [SitePresentationURL] LIKE @SitePresentationURL AND [SiteStatus] = @SiteStatus
ORDER BY SitePresentationURL

DECLARE @SiteDomainName nvarchar(max) = N'arabiagis.com/';
DECLARE @SiteDomainAliasName nvarchar(max) = N'arabiagis.com/';
DECLARE @SiteStatus nvarchar(max) = N'RUNNING';

SELECT *
FROM CMS_Site
WHERE ([SiteDomainName] = @SiteDomainName OR [SiteID] IN (
SELECT [SiteID]
FROM CMS_SiteDomainAlias
WHERE [SiteDomainAliasName] = @SiteDomainAliasName
)) AND [SiteStatus] = @SiteStatus

DECLARE @SiteDomainName nvarchar(max) = N'arabiagis.com';
DECLARE @SiteDomainAliasName nvarchar(max) = N'arabiagis.com';
DECLARE @SiteStatus nvarchar(max) = N'RUNNING';

SELECT *
FROM CMS_Site
WHERE ([SiteDomainName] = @SiteDomainName OR [SiteID] IN (
SELECT [SiteID]
FROM CMS_SiteDomainAlias
WHERE [SiteDomainAliasName] = @SiteDomainAliasName
)) AND [SiteStatus] = @SiteStatus

DECLARE @SiteID int = 2;

SELECT *
FROM CMS_SiteDomainAlias
WHERE [SiteID] = @SiteID

DECLARE @NodeSiteID int = 2;
DECLARE @DocumentUrlPath nvarchar(max) = N'/Industries';
DECLARE @NodeAliasPath nvarchar(max) = N'/Industries';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/Industries' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)))
) AS SubData
ORDER BY CMS_P DESC

DECLARE @PageTemplateID int = 6;

SELECT TOP 1 *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID

DECLARE @NodeSiteID int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] = N'/' AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC

DECLARE @ClassName nvarchar(max) = N'OM.Contact';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName

DECLARE @ClassName nvarchar(max) = N'OM.Contact';

SELECT (COUNT(*)) AS [Count]
FROM (
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
) AS SubData

DECLARE @ClassName nvarchar(max) = N'OM.Contact';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('OM_Contact');

SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'insert' AND ClassID = 2841

SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalinsert' AND ClassID = 2841

DECLARE @ContactFirstName nvarchar = NULL;
DECLARE @ContactMiddleName nvarchar = NULL;
DECLARE @ContactLastName nvarchar(max) = N'Anonymous - 2024-04-24 16:34:15.400';
DECLARE @ContactJobTitle nvarchar = NULL;
DECLARE @ContactAddress1 nvarchar = NULL;
DECLARE @ContactCity nvarchar = NULL;
DECLARE @ContactZIP nvarchar = NULL;
DECLARE @ContactStateID nvarchar = NULL;
DECLARE @ContactCountryID nvarchar = NULL;
DECLARE @ContactMobilePhone nvarchar = NULL;
DECLARE @ContactBusinessPhone nvarchar = NULL;
DECLARE @ContactEmail nvarchar = NULL;
DECLARE @ContactBirthday nvarchar = NULL;
DECLARE @ContactGender nvarchar = NULL;
DECLARE @ContactStatusID nvarchar = NULL;
DECLARE @ContactNotes nvarchar = NULL;
DECLARE @ContactOwnerUserID nvarchar = NULL;
DECLARE @ContactMonitored bit = 1;
DECLARE @ContactGUID uniqueidentifier = '4271373d-b18d-44b7-a53d-2a581264872a';
DECLARE @ContactLastModified datetime2 = '4/24/2024 4:34:15 PM';
DECLARE @ContactCreated datetime2 = '4/24/2024 4:34:15 PM';
DECLARE @ContactBounces nvarchar = NULL;
DECLARE @ContactCampaign nvarchar = NULL;
DECLARE @ContactSalesForceLeadID nvarchar = NULL;
DECLARE @ContactSalesForceLeadReplicationDisabled nvarchar = NULL;
DECLARE @ContactSalesForceLeadReplicationDateTime nvarchar = NULL;
DECLARE @ContactSalesForceLeadReplicationSuspensionDateTime nvarchar = NULL;
DECLARE @ContactCompanyName nvarchar = NULL;
DECLARE @ContactSalesForceLeadReplicationRequired nvarchar = NULL;
DECLARE @ContactPersonaID nvarchar = NULL;

INSERT INTO OM_Contact ([ContactFirstName], [ContactMiddleName], [ContactLastName], [ContactJobTitle], [ContactAddress1], [ContactCity], [ContactZIP], [ContactStateID], [ContactCountryID], [ContactMobilePhone], [ContactBusinessPhone], [ContactEmail], [ContactBirthday], [ContactGender], [ContactStatusID], [ContactNotes], [ContactOwnerUserID], [ContactMonitored], [ContactGUID], [ContactLastModified], [ContactCreated], [ContactBounces], [ContactCampaign], [ContactSalesForceLeadID], [ContactSalesForceLeadReplicationDisabled], [ContactSalesForceLeadReplicationDateTime], [ContactSalesForceLeadReplicationSuspensionDateTime], [ContactCompanyName], [ContactSalesForceLeadReplicationRequired], [ContactPersonaID])
VALUES (@ContactFirstName, @ContactMiddleName, @ContactLastName, @ContactJobTitle, @ContactAddress1, @ContactCity, @ContactZIP, @ContactStateID, @ContactCountryID, @ContactMobilePhone, @ContactBusinessPhone, @ContactEmail, @ContactBirthday, @ContactGender, @ContactStatusID, @ContactNotes, @ContactOwnerUserID, @ContactMonitored, @ContactGUID, @ContactLastModified, @ContactCreated, @ContactBounces, @ContactCampaign, @ContactSalesForceLeadID, @ContactSalesForceLeadReplicationDisabled, @ContactSalesForceLeadReplicationDateTime, @ContactSalesForceLeadReplicationSuspensionDateTime, @ContactCompanyName, @ContactSalesForceLeadReplicationRequired, @ContactPersonaID);

SELECT SCOPE_IDENTITY() AS [ID]

DECLARE @ClassName nvarchar(max) = N'CMS.WebFarmTask';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName

DECLARE @ClassName nvarchar(max) = N'CMS.WebFarmTask';

SELECT (COUNT(*)) AS [Count]
FROM (
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
) AS SubData

DECLARE @ClassName nvarchar(max) = N'CMS.WebFarmTask';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_WebFarmTask');

DECLARE @ClassName nvarchar(max) = N'OM.ActivityType';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName

DECLARE @ClassName nvarchar(max) = N'OM.ActivityType';

SELECT (COUNT(*)) AS [Count]
FROM (
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
) AS SubData

DECLARE @ClassName nvarchar(max) = N'OM.ActivityType';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName

SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 2857

SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 2857

SELECT *
FROM OM_ActivityType

DECLARE @StringKey nvarchar(max) = N'om.acttitle.landingpage';
DECLARE @CultureCode nvarchar(max) = N'en-us';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode

SELECT [SearchEngineID], [SearchEngineDomainRule]
FROM CMS_SearchEngine

DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 525;

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID)
) AS SubData
ORDER BY CMS_P DESC

DECLARE @PageTemplateID int = 85;

SELECT TOP 1 *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID

DECLARE @ClassName nvarchar(max) = N'cms.personalization';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName

DECLARE @ClassName nvarchar(max) = N'cms.personalization';

SELECT (COUNT(*)) AS [Count]
FROM (
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
) AS SubData

DECLARE @ClassName nvarchar(max) = N'cms.personalization';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName

SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 1841

SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 525

DECLARE @StringKey nvarchar(max) = N'';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode

DECLARE @StringKey nvarchar(max) = N'QueryLog.QueryText';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode

DECLARE @StringKey nvarchar(max) = N'General.Context';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode

DECLARE @StringKey nvarchar(max) = N'QueryLog.QueryDuration';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode

DECLARE @StringKey nvarchar(max) = N'QueryLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode