Skip to main content

A to Z of Council Services

SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @NodeAliasPath nvarchar(max) = N'/Home';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

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-GB' THEN 2 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 ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (2)
@NodeAliasPath ("/Home")
@DocumentCulture ("en-GB")
3.2 kB
 
Table (1 [65], 8.5 kB)
 
SimpleHandler`2.StartEvent 0.000
 
2
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WorkflowStep';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WorkflowStep")
164 B
 
Table (1 [2], 4.2 kB)
 
SimpleHandler`2.StartEvent 0.000
 
3
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WorkflowStep';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WorkflowStep")
137 B
 
Table (1 [54], 12.8 kB)
 
SimpleHandler`2.StartEvent 0.000
 
4

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_WorkflowStep');
Table (1 [1], 6 B)
 
SimpleHandler`2.StartEvent 0.000
 
5
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 172
SimpleHandler`2.StartEvent 0.016
 
6
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 172
SimpleHandler`2.StartEvent 0.000
 
7
(cms.workflowstep.generalselect)
DECLARE @StepID int = 255;

SELECT TOP 1 *
FROM CMS_WorkflowStep
WHERE [StepID] = @StepID
@StepID (255)
97 B
 
Table (1 [23], 469 B)
 
SimpleHandler`2.StartEvent 0.000
 
8
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25794;

SELECT TOP 1 *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25794)
123 B
 
Table (1 [31], 38 kB)
 
SimpleHandler`2.StartEvent 0.016
 
9
(cms.document.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

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
@NodeSiteID (2)
@DocumentCulture ("en-GB")
360 B
 
Table (1 [160], 5 kB)
 
SimpleHandler`2.StartEvent 0.000
 
10
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 9
PageContext.CurrentPage_InitComplete 0.000
 
11
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1678;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1678)
102 B
 
Table (1 [19], 2.3 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
12
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'CMSUniView';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("CMSUniView")
133 B
 
Table (1 [19], 32 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
13
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'HeadHTML';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("HeadHTML")
129 B
 
Table (1 [19], 726 B)
 
0.000
 
14
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'Link';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("Link")
121 B
 
Table (1 [19], 7.1 kB)
 
0.016
 
15
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'unigridpager.previouspage';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("unigridpager.previouspage")
@CultureCode ("en-GB")
312 B
 
CMSUniView.CreateChildControls 0.000
 
16
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'unigridpager.nextpage';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("unigridpager.nextpage")
@CultureCode ("en-GB")
304 B
 
0.016
 
17
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-Pages_en-GB'
PageContext.CurrentPage_InitComplete 0.000
 
18
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-CurrentPage_en-GB'
0.000
 
19
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-PageSeparator_en-GB'
0.000
 
20
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-FirstPage_en-GB'
0.000
 
21
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-LastPage_en-GB'
0.000
 
22
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-PreviousPage_en-GB'
0.000
 
23
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-NextPage_en-GB'
0.000
 
24
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-PreviousGroup_en-GB'
0.000
 
25
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-NextGroup_en-GB'
0.000
 
26
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-PagerLayout_en-GB'
0.000
 
27
(cms.menuitem.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 9) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-GB")
393 B
 
Table (1 [169], 8.9 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
28
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'sz.card';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("sz.card")
119 B
 
Table (1 [54], 5.4 kB)
 
BasicRepeater.OnLoad 0.016
 
29
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'sz.card';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("sz.card")
146 B
 
Table (1 [2], 2.2 kB)
 
BasicRepeater.OnLoad 0.000
 
30

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('SZ_Card');
Table (1 [1], 6 B)
 
BasicRepeater.OnLoad 0.031
 
31
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 5508
BasicRepeater.OnLoad 0.000
 
32
(sz.card.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '2/23/2020 1:43:05 PM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Home/Home-Feature-Cards/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN SZ_Card AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[CardID] AND V.ClassName = N'SZ.Card' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder ASC
@NodeSiteID (2)
@Now (23/02/2020 13:43:05)
@NodeAliasPath ("/Home/Home-Feature-Cards/%")
@DocumentCulture ("en-GB")
813 B
 
Table (12 [166], 11.7 kB)
 
BasicRepeater.OnLoad 0.016
 
33
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '2/23/2020 1:43:05 PM';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ShowOnHomePage = 1) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel ASC, NodeOrder ASC, NodeName ASC
@NodeSiteID (2)
@Now (23/02/2020 13:43:05)
@DocumentCulture ("en-GB")
748 B
 
BasicUniView.OnLoad 0.016
 
34
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5483 AND [TransformationName] = N'SzFeatureCard_en-GB'
BasicUniView.OnLoad 0.016
 
35
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'sz.news';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("sz.news")
146 B
 
Table (1 [2], 1.8 kB)
 
BasicRepeater.OnLoad 0.000
 
36

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('SZ_News');
Table (1 [1], 6 B)
 
BasicRepeater.OnLoad 0.031
 
37
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 5507
BasicRepeater.OnLoad 0.016
 
38
(sz.news.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '2/23/2020 1:43:05 PM';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT TOP 3 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN SZ_News AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[NewsID] AND V.ClassName = N'SZ.News' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY NewsReleaseDate desc
@NodeSiteID (2)
@Now (23/02/2020 13:43:05)
@DocumentCulture ("en-GB")
689 B
 
Table (3 [166], 21 kB)
 
BasicRepeater.OnLoad 0.016
 
39
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5507 AND [TransformationName] = N'LatestListing_en-GB'
BasicRepeater.OnLoad 0.000
 
40
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'sz.event';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("sz.event")
148 B
 
Table (1 [2], 3.7 kB)
 
BasicRepeater.OnLoad 0.000
 
41

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('SZ_Event');
Table (1 [1], 7 B)
 
BasicRepeater.OnLoad 0.016
 
42
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 5509
BasicRepeater.OnLoad 0.000
 
43
(sz.event.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '2/23/2020 1:43:06 PM';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT TOP 3 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN SZ_Event AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventID] AND V.ClassName = N'SZ.Event' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY EventDate
@NodeSiteID (2)
@Now (23/02/2020 13:43:06)
@DocumentCulture ("en-GB")
681 B
 
Table (3 [173], 6.2 kB)
 
BasicRepeater.OnLoad 0.016
 
44
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5509 AND [TransformationName] = N'Latest_en-GB'
BasicRepeater.OnLoad 0.000
 
  44 queries, 12.4 kB write, 173 kB read   0.281