CONTENTSTART
EXCLUDESTART EXCLUDEEND

College Closed

November 22 - 25, 2018

All Campuses and RLCs

Closed for Thanksgiving break
CONTENTEND
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Data/Persistent/Cache/NWTC/outputdata/0082/m727857012.cache Local SimpleHandler`2.StartEvent
2 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local DbPathProvider.GetFileHash
3 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
4 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local
5 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
6 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local
7 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
8 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
9 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|nwtc|/events/2018/november/college-closed|en-us|/events/2018/november/college-closed|true
template|24113
nodeid|5363
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/events/2018/november/college-closed|en-us||true|true
template|24113
nodeid|5363
SimpleHandler`2.StartEvent
3 ADD currentdocument|nwtc|/events/2018/november/college-closed|en-us
nodes|nwtc|nwtc.event|all
node|nwtc|/events/2018/november/college-closed
SimpleHandler`2.StartEvent
4 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
5 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
6 GET pageinfo|nwtc|/events/2018|en-us||false PageContext.CurrentPage_InitComplete
7 GET pageinfo|nwtc|/events|en-us||false
8 ADD pageinfo|nwtc|/events/2018/november|en-us||false
template|24112
nodeid|3943
PageContext.CurrentPage_InitComplete
9 GET pageinfo|nwtc|/|en-us||false PageContext.CurrentPage_InitComplete
10 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
11 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
12 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|5229
partial
template|24098
13 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
14 GET cmsdatasource||en-us|nwtc|/master-items/mega-menus/%|en-us|false|nwtc.megamenu||nodeorder asc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| CMSWebPartZone.CachedWebPart_Init
15 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/|googletranslator
CMSWebPartZone.CachedWebPart_Init
16 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
17 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/|mobilemenubutton
18 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
19 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/|newmobilemenu
20 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/|mobilemenu
21 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
22 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|5229
partial
template|24098
23 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|5229
partial
template|24098
24 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|5229
partial
template|24098
25 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
26 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
27 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|5229
partial
template|24098
28 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|5229
partial
template|24098
29 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
30 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
31 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
32 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
PageContext.CurrentPage_InitComplete
33 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|5229
partial
template|24098
34 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
35 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/|googletranslator
36 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
37 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/|mobilemenubutton
38 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
39 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/|newmobilemenu
40 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/|mobilemenu
41 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
42 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|5229
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
43 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|5229
partial
template|24098
44 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|5229
partial
template|24098
45 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
PageContext.CurrentPage_InitComplete
46 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
47 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|5229
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
48 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|5229
partial
template|24098
49 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
PageContext.CurrentPage_InitComplete
50 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
51 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
52 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|5229
partial
template|24098
53 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|5229
partial
template|24098
54 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|5229
partial
template|24098
55 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|5229
partial
template|24098
56 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|5229
partial
template|24098
57 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24113
CMSWebPartZone.CachedWebPart_Init
58 ADD Partial cache (NewLeftMenu)
webpartinstance|ae02162b-9c08-4bab-8a2b-b69bbe528d47
partial
template|24113
59 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24113
60 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24113
61 ADD Partial cache (DateInfoRepeater)
webpartinstance|74968d15-9126-4cd6-a95d-aef65df87cdc
partial
template|24113
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/events/2018/november/college-closed|dateinforepeater
62 ADD cmsdatasource||en-us|nwtc|/events/2018/november/college-closed|en-us|false|nwtc.event|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
webpartinstance|74968d15-9126-4cd6-a95d-aef65df87cdc
nodes|nwtc|nwtc.event|all
node|nwtc|/events/2018/november/college-closed
CMSWebPartZone.CachedWebPart_Init
63 ADD Partial cache (ContentRepeater)
webpartinstance|06c34b97-e83b-48ae-98d6-0dec0accd52a
partial
template|24113
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/events/2018/november/college-closed|contentrepeater
CMSWebPartZone.CachedWebPart_Init
64 GET cmsdatasource||en-us|nwtc|/events/2018/november/college-closed|en-us|false|nwtc.event|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| CMSWebPartZone.CachedWebPart_Init
65 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|5229
partial
template|24113
CMSWebPartZone.CachedWebPart_Init
66 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|5229
partial
template|24113
67 ADD Partial cache (ShareThisContent)
webpartinstance|3979d84b-9e71-4830-87ed-a4bcfd4b9841
partial
template|24113
68 GET cmsdatasource||en-us|nwtc|/resources/shared-page-content/sharethis-main|en-us|false|custom.shareablecontent|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| CMSWebPartZone.CachedWebPart_Init
69 ADD Partial cache (RelatedEventsRepeater)
webpartinstance|b5ad0b5b-b5dc-4690-b91b-a63b7e4b36cc
partial
template|24113
CMSWebPartZone.CachedWebPart_Init
70 ADD cmsdatasource||en-us|nwtc|/events/%|en-us|false|nwtc.event|documentid <> 5229 and
(datediff(day,getdate(),eventdate)>=0 or (eventenddate is not null and datediff(day,eventenddate,getdate())<=0)) and
documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('65') or categoryid in (65))) and
documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('15','16','17') or categoryid in (15,16,17))) |eventdate asc, nodelevel, nodeorder|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|3||false||
webpartinstance|b5ad0b5b-b5dc-4690-b91b-a63b7e4b36cc
nodes|nwtc|nwtc.event|all
node|nwtc|/events|childnodes
CMSWebPartZone.CachedWebPart_Init
71 ADD Partial cache (EventListing)
webpartinstance|15fc9902-6cd0-4b8d-b9e6-fcfebef5f397
partial
template|24113
CMSWebPartZone.CachedWebPart_Init
72 GET querydatasource|nwtc.transformationsqueries.eventsandfolderjoin||nodealiaspath like '/events/%' and
documentmenuitemhideinnavigation = 0 and
([documentcanbepublished] = 1 and ([documentpublishfrom] is null or [documentpublishfrom] <= getdate()) and ([documentpublishto] is null or [documentpublishto] >= getdate()))
and
(eventdate is null or (datediff(day,getdate(),eventdate)>=0 or (eventenddate is not null and datediff(day,eventenddate,getdate())<=0))) and
(eventmonthyear is null or (eventmonthyear > year(getdate()) or (eventmonthyear = year(getdate()) and eventmonth >= month(getdate())))) and
(eventyear is null or eventyear >= year(getdate()))|nodelevel, eventdate, nodeorder|0||
CMSWebPartZone.CachedWebPart_Init
73 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24113
PageContext.CurrentPage_InitComplete
74 ADD Partial cache (NewLeftMenu)
webpartinstance|ae02162b-9c08-4bab-8a2b-b69bbe528d47
partial
template|24113
75 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24113
76 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24113
77 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|5229
partial
template|24113
78 ADD Partial cache (ShareThisContent)
webpartinstance|3979d84b-9e71-4830-87ed-a4bcfd4b9841
partial
template|24113
79 ADD Partial cache (RelatedEventsRepeater)
webpartinstance|b5ad0b5b-b5dc-4690-b91b-a63b7e4b36cc
partial
template|24113
80 ADD Partial cache (EventListing)
webpartinstance|15fc9902-6cd0-4b8d-b9e6-fcfebef5f397
partial
template|24113
81 ADD Partial cache (DateInfoRepeater)
webpartinstance|74968d15-9126-4cd6-a95d-aef65df87cdc
partial
template|24113
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/events/2018/november/college-closed|dateinforepeater
82 ADD Partial cache (ContentRepeater)
webpartinstance|06c34b97-e83b-48ae-98d6-0dec0accd52a
partial
template|24113
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/november/college-closed|/events/2018/november/college-closed|contentrepeater
83 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|5229
partial
template|24113
84 GET cmsdatasource||en-us|nwtc|/master-items/alerts/%|en-us|false|nwtc.alert||nodeorder|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|1||false|| BasicRepeater.OnLoad
85 GET pageinfo|nwtc|/master-items/mega-menus/admissions|en-us||false CMSAbstractWebPart.OnLoad
86 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
87 GET inlinewidgetcontrol|528|1572
88 GET pageinfo|nwtc|/master-items/mega-menus/programs|en-us||false CMSAbstractWebPart.OnLoad
89 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
90 GET inlinewidgetcontrol|528|1572
91 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
92 GET cmsdatasource||en-us|nwtc|/events/%|en-us|false|nwtc.event|((eventallday = 0 and datediff(minute,getdate(),eventdate)>=0) or (eventallday = 1 and datediff(day, getdate(), eventdate)>=0) or (eventenddate is not null and ((eventallday = 1 and datediff(day,eventenddate,getdate())<=0) or (eventallday = 0 and datediff(minute,eventenddate,getdate())<=0)))) and ( documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('academiccalendar_1','studentlife_1') )) ) and ( documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('greenbaycampus') )) ) |eventdate asc, nodelevel, nodeorder|-1|true|00000000-0000-0000-0000-000000000000||false|2||false|| BasicRepeater.OnLoad
93 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
94 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
95 GET cmsdatasource||en-us|nwtc|/resources/shared-page-content/satisfaction|en-us|false|custom.shareablecontent|||-1|true|00000000-0000-0000-0000-000000000000||false|0||false|| BasicRepeater.OnLoad
96 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
97 ADD breadcrumbs|nwtc|/events/2018/november/college-closed|en-us|false|cms.menuitem||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/events/2018/november/college-closed
node|nwtc|/events/2018/november
node|nwtc|/events/2018
node|nwtc|/events
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
98 GET pageinfo|nwtc|/resources/shared-page-content/sharethis-main|en-us||false CMSAbstractWebPart.OnLoad
99 GET inlinewidgetcontrol|526|1571 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
100 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
101 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
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 = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/events/2018/november/college-closed';
DECLARE @NodeAliasPath nvarchar(max) = N'/events/2018/november/college-closed';
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'/events/2018/november/college-closed' 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
@NodeSiteID (1)
@DocumentUrlPath ("/events/2018/november/college-closed")
@NodeAliasPath ("/events/2018/november/college-closed")
@DocumentCulture ("en-US")
3.6 kB
 
Table (1 [65], 433 B)
 
SimpleHandler`2.StartEvent 0.031
 
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
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] IN (N'/Events/2018/November', N'/Events/2018', N'/Events', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
418 B
 
Table (4 [157], 13.5 kB)
 
SimpleHandler`2.StartEvent 0.031
 
3 This same query was called more than once within this request.
(om.contact.generalselect)
DECLARE @VisitorToContactVisitorGUID uniqueidentifier = '00000000-0000-0000-0000-000000000000';

SELECT TOP 1 *
FROM OM_Contact
WHERE [ContactID] IN (
SELECT TOP 1 [VisitorToContactContactID]
FROM OM_VisitorToContact
WHERE [VisitorToContactVisitorGUID] = @VisitorToContactVisitorGUID
)
@VisitorToContactVisitorGUID (00000000-0000-0000-0000-000000000000)
333 B
 
SimpleHandler`2.StartEvent 0.000
 
4
(nwtc.event.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_NWTC_Event AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventID] AND V.ClassName = N'NWTC.Event' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 5363) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
393 B
 
Table (1 [174], 915 B)
 
SimpleHandler`2.StartEvent 0.016
 
5
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 4629;
DECLARE @PermissionName nvarchar(max) = N'read';
DECLARE @SiteID int = 1;

SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
@ClassID (4629)
@PermissionName ("read")
@SiteID (1)
359 B
 
Table (21 [10], 2.2 kB)
 
SimpleHandler`2.StartEvent 0.000
 
6
(cms.acl.generalselect)
DECLARE @ACLID int = 13;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
@ACLID (13)
78 B
 
Table (1 [5], 52 B)
 
SimpleHandler`2.StartEvent 0.016
 
7
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 1;
DECLARE @Date datetime2 = '1/18/2018 12:02:06 AM';

SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (13)

@UserID (65)
@SiteID (1)
@Date (1/18/2018 12:02:06 AM)
1.3 kB
 
SimpleHandler`2.StartEvent 0.000
 
8 This same query was called more than once within this request.
(om.contact.generalselect)
DECLARE @VisitorToContactVisitorGUID uniqueidentifier = '00000000-0000-0000-0000-000000000000';

SELECT TOP 1 *
FROM OM_Contact
WHERE [ContactID] IN (
SELECT TOP 1 [VisitorToContactContactID]
FROM OM_VisitorToContact
WHERE [VisitorToContactVisitorGUID] = @VisitorToContactVisitorGUID
)
@VisitorToContactVisitorGUID (00000000-0000-0000-0000-000000000000)
333 B
 
SimpleHandler`2.StartEvent 0.000
 
9
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 3943;

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
@DocumentCulture ("en-US")
@NodeID (3943)
3.1 kB
 
Table (1 [65], 396 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
10
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
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] IN (N'/Events/2018', N'/Events', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
392 B
 
Table (3 [157], 12.7 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
11
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_Blog ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_Blog.BlogID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.Blog' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE (((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
3.4 kB
 
Table (74 [19], 12.7 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.031
 
12
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_Blog ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_Blog.BlogID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.Blog' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((((((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
3.5 kB
 
Table (74 [19], 12.7 kB)
 
PageContext.CurrentPage_InitComplete 0.031
 
13
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 5229
PageContext.CurrentPage_InitComplete 0.000
 
14
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/Events/2018/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
CMSWebPartZone.CachedWebPart_Init 0.031
 
15
(nwtc.event.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:02:07 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Events/2018/November/College-Closed';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_NWTC_Event AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventID] AND V.ClassName = N'NWTC.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 [NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:02:07 AM)
@NodeAliasPath ("/Events/2018/November/College-Closed")
@DocumentCulture ("en-US")
822 B
 
Table (1 [174], 915 B)
 
CMSWebPartZone.CachedWebPart_Init 0.000
 
16
(cms.tree.generalselect)
DECLARE @NodeID int = 3943;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
@NodeID (3943)
84 B
 
Table (1 [34], 174 B)
 
CMSWebPartZone.CachedWebPart_Init 0.000
 
17
(.generalselect)
DECLARE @NodeID int = 3943;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @CMS_C int = 1;

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_EventMonthFolder AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventMonthFolderID] AND V.ClassName = N'NWTC.EventMonthFolder' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeID] = @NodeID
) AS SubData
WHERE [CMS_C] = @CMS_C
@NodeID (3943)
@DocumentCulture ("en-US")
@CMS_C (1)
641 B
 
Table (1 [161], 779 B)
 
CMSWebPartZone.CachedWebPart_Init 0.016
 
18
(cms.user.generalselect)
DECLARE @UserName nvarchar(max) = N'23307552';

SELECT *
FROM CMS_User
WHERE [UserName] = @UserName
@UserName ("23307552")
111 B
 
Table (1 [28], 309 B)
 
CMSWebPartZone.CachedWebPart_Init 0.000
 
19
(cms.tree.generalselect)
DECLARE @NodeID int = 3932;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
@NodeID (3932)
84 B
 
Table (1 [34], 157 B)
 
CMSWebPartZone.CachedWebPart_Init 0.000
 
20
(.generalselect)
DECLARE @NodeID int = 3932;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @CMS_C int = 1;

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_EventYearFolder AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventYearFolderID] AND V.ClassName = N'NWTC.EventYearFolder' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeID] = @NodeID
) AS SubData
WHERE [CMS_C] = @CMS_C
@NodeID (3932)
@DocumentCulture ("en-US")
@CMS_C (1)
638 B
 
Table (1 [160], 745 B)
 
CMSWebPartZone.CachedWebPart_Init 0.000
 
21
(cms.tree.generalselect)
DECLARE @NodeID int = 60;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
@NodeID (60)
82 B
 
Table (1 [34], 153 B)
 
CMSWebPartZone.CachedWebPart_Init 0.000
 
22
(.generalselect)
DECLARE @NodeID int = 60;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @CMS_C int = 1;

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C]
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] = @NodeID
) AS SubData
WHERE [CMS_C] = @CMS_C
@NodeID (60)
@DocumentCulture ("en-US")
@CMS_C (1)
617 B
 
Table (1 [167], 4.7 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.016
 
23
(nwtc.event.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:02:08 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Events/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 3 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_NWTC_Event AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventID] AND V.ClassName = N'NWTC.Event' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (DocumentID <> 5229 and
(DATEDIFF(day,GETDATE(),EventDate)>=0 or (EventEndDate is not null and DATEDIFF(day,EventEndDate,GETDATE())<=0)) and
DocumentID in (Select DocumentID from CMS_DocumentCategory WHERE CategoryID in (Select CategoryID from CMS_Category where CategoryName in('65') or CategoryId in (65))) and
DocumentID in (Select DocumentID from CMS_DocumentCategory WHERE CategoryID in (Select CategoryID from CMS_Category where CategoryName in('15','16','17') or CategoryId in (15,16,17))) ) 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 EventDate asc, NodeLevel, NodeOrder
@NodeSiteID (1)
@Now (1/18/2018 12:02:08 AM)
@NodeAliasPath ("/Events/%")
@DocumentCulture ("en-US")
1.3 kB
 
Table (3 [174], 2.7 kB)
 
CMSWebPartZone.CachedWebPart_Init 1.016
 
24
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/%")
@SiteID (1)
794 B
 
Table (1 [1], 4 B)
 
cmsvirtualfiles_transformations__vg_c9bd261e_b85f_48d9_81ca_39fca5eeb675_cms_folder_collapsiblemenuitemeventnewssubcount_ascx.__DataBind__control2 0.016
 
25
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/%")
@SiteID (1)
795 B
 
Table (1 [1], 4 B)
 
0.016
 
26
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/January/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/January/%")
@SiteID (1)
810 B
 
Table (1 [1], 4 B)
 
0.000
 
27
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/January/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/January/%")
@SiteID (1)
811 B
 
Table (1 [1], 4 B)
 
0.000
 
28
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/February/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/February/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
0.000
 
29
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/February/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/February/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.016
 
30
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/March/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/March/%")
@SiteID (1)
806 B
 
Table (1 [1], 4 B)
 
0.016
 
31
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/March/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/March/%")
@SiteID (1)
807 B
 
Table (1 [1], 4 B)
 
0.000
 
32
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/April/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/April/%")
@SiteID (1)
806 B
 
Table (1 [1], 4 B)
 
0.000
 
33
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/April/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/April/%")
@SiteID (1)
807 B
 
Table (1 [1], 4 B)
 
0.016
 
34
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/May/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/May/%")
@SiteID (1)
802 B
 
Table (1 [1], 4 B)
 
0.016
 
35
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/May/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/May/%")
@SiteID (1)
803 B
 
Table (1 [1], 4 B)
 
0.000
 
36
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/June/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/June/%")
@SiteID (1)
804 B
 
Table (1 [1], 4 B)
 
0.000
 
37
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/June/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/June/%")
@SiteID (1)
805 B
 
Table (1 [1], 4 B)
 
0.000
 
38
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/July/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/July/%")
@SiteID (1)
804 B
 
Table (1 [1], 4 B)
 
0.000
 
39
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/July/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/July/%")
@SiteID (1)
805 B
 
Table (1 [1], 4 B)
 
0.000
 
40
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/August/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/August/%")
@SiteID (1)
808 B
 
Table (1 [1], 4 B)
 
0.016
 
41
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/August/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/August/%")
@SiteID (1)
809 B
 
Table (1 [1], 4 B)
 
0.000
 
42
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/September/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/September/%")
@SiteID (1)
814 B
 
Table (1 [1], 4 B)
 
0.000
 
43
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/September/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/September/%")
@SiteID (1)
815 B
 
Table (1 [1], 4 B)
 
0.016
 
44
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/October/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/October/%")
@SiteID (1)
810 B
 
Table (1 [1], 4 B)
 
0.000
 
45
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/October/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/October/%")
@SiteID (1)
811 B
 
Table (1 [1], 4 B)
 
0.000
 
46
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/November/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/November/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
0.016
 
47
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/November/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/November/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.000
 
48
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/December/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/December/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
0.016
 
49
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/December/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2018/December/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.016
 
50
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/%")
@SiteID (1)
794 B
 
Table (1 [1], 4 B)
 
0.000
 
51
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/%")
@SiteID (1)
795 B
 
Table (1 [1], 4 B)
 
0.000
 
52
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/January/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/January/%")
@SiteID (1)
810 B
 
Table (1 [1], 4 B)
 
0.000
 
53
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/January/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/January/%")
@SiteID (1)
811 B
 
Table (1 [1], 4 B)
 
0.000
 
54
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/February/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/February/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
0.000
 
55
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/February/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/February/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.000
 
56
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/March/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/March/%")
@SiteID (1)
806 B
 
Table (1 [1], 4 B)
 
0.016
 
57
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/March/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/March/%")
@SiteID (1)
807 B
 
Table (1 [1], 4 B)
 
0.000
 
58
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/April/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/April/%")
@SiteID (1)
806 B
 
Table (1 [1], 4 B)
 
0.000
 
59
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/April/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/April/%")
@SiteID (1)
807 B
 
Table (1 [1], 4 B)
 
0.000
 
60
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/May/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/May/%")
@SiteID (1)
802 B
 
Table (1 [1], 4 B)
 
0.000
 
61
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/May/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/May/%")
@SiteID (1)
803 B
 
Table (1 [1], 4 B)
 
0.016
 
62
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/June/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/June/%")
@SiteID (1)
804 B
 
Table (1 [1], 4 B)
 
0.000
 
63
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/June/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/June/%")
@SiteID (1)
805 B
 
Table (1 [1], 4 B)
 
0.000
 
64
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/July/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/July/%")
@SiteID (1)
804 B
 
Table (1 [1], 4 B)
 
0.000
 
65
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/July/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/July/%")
@SiteID (1)
805 B
 
Table (1 [1], 4 B)
 
0.000
 
66
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/August/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/August/%")
@SiteID (1)
808 B
 
Table (1 [1], 4 B)
 
0.016
 
67
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/August/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/August/%")
@SiteID (1)
809 B
 
Table (1 [1], 4 B)
 
0.016
 
68
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/September/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/September/%")
@SiteID (1)
814 B
 
Table (1 [1], 4 B)
 
0.000
 
69
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/September/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/September/%")
@SiteID (1)
815 B
 
Table (1 [1], 4 B)
 
0.000
 
70
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/October/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/October/%")
@SiteID (1)
810 B
 
Table (1 [1], 4 B)
 
0.000
 
71
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/October/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/October/%")
@SiteID (1)
811 B
 
Table (1 [1], 4 B)
 
0.016
 
72
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/November/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/November/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
0.000
 
73
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/November/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/November/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.016
 
74
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/December/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in (SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/December/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
0.000
 
75
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2019/December/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/December/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.016
 
76
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/Events/2018/%')) AND (Published = 1)) AND (NodeAliasPath like '/Events/2018/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
PageContext.CurrentPage_InitComplete 0.016
 
77
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:02:10 AM';
DECLARE @NodeLevel int = 4;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings]
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] IN (N'/Events/2018/November/College-Closed', N'/Events/2018/November', N'/Events/2018', N'/Events', N'/'))) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeAliasPath DESC
@NodeSiteID (1)
@Now (1/18/2018 12:02:10 AM)
@NodeLevel (4)
@DocumentCulture ("en-US")
1.6 kB
 
Table (1 [36], 121 B)
 
CMSAbstractMenuProperties.OnLoad 0.031
 
  77 queries, 70 kB write, 66 kB read   1.578