CONTENTSTART
EXCLUDESTART EXCLUDEEND

President Rafn presents on Career Pathways: What Will Be

Casey M Fryda

Friday June 23, 2017
Dr. H. Jeffrey Rafn, NWTC President, is speaking with national higher ed leaders about how the College discovers where business growth and economic demands will happen next. He is presenting at a national Pathways Institute conference this week. See his slides below: 

 
EXCLUDESTART

Other News

EXCLUDESTART EXCLUDEEND EXCLUDEEND
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/00AA/m896918787.cache Local SimpleHandler`2.StartEvent
2 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local DbPathProvider.GetFileHash
3 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
4 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
5 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|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|en-us|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|true
template|24115
nodeid|5619
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|en-us||true|true
template|24115
nodeid|5619
SimpleHandler`2.StartEvent
3 ADD currentdocument|nwtc|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|en-us
nodes|nwtc|nwtc.news|all
node|nwtc|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w
SimpleHandler`2.StartEvent
4 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
5 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
6 ADD pageinfo|nwtc|/about-nwtc/news|en-us||false
template|24114
nodeid|29
PageContext.CurrentPage_InitComplete
7 ADD pageinfo|nwtc|/about-nwtc/news/2017|en-us||false
template|24114
nodeid|4818
PageContext.CurrentPage_InitComplete
8 ADD pageinfo|nwtc|/about-nwtc/news/2017/june|en-us||false
template|24114
nodeid|5488
PageContext.CurrentPage_InitComplete
9 GET pageinfo|nwtc|/about-nwtc|en-us||false PageContext.CurrentPage_InitComplete
10 GET pageinfo|nwtc|/|en-us||false
11 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
12 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
13 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|5482
partial
template|24098
14 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
15 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
16 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|/|googletranslator
CMSWebPartZone.CachedWebPart_Init
17 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
18 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|/|mobilemenubutton
19 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
20 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|/|newmobilemenu
21 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|/|mobilemenu
22 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
23 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|5482
partial
template|24098
24 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|5482
partial
template|24098
25 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|5482
partial
template|24098
26 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
27 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
28 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|5482
partial
template|24098
29 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|5482
partial
template|24098
30 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
31 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
32 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
33 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
PageContext.CurrentPage_InitComplete
34 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|5482
partial
template|24098
35 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
36 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|/|googletranslator
37 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
38 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|/|mobilemenubutton
39 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
40 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|/|newmobilemenu
41 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|/|mobilemenu
42 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
43 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|5482
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
44 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|5482
partial
template|24098
45 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|5482
partial
template|24098
46 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
PageContext.CurrentPage_InitComplete
47 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
48 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|5482
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
49 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|5482
partial
template|24098
50 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
PageContext.CurrentPage_InitComplete
51 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
52 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
53 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|5482
partial
template|24098
54 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|5482
partial
template|24098
55 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|5482
partial
template|24098
56 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|5482
partial
template|24098
57 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|5482
partial
template|24098
58 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24115
CMSWebPartZone.CachedWebPart_Init
59 ADD Partial cache (NewLeftMenu)
webpartinstance|ea152275-23ac-4918-a180-5edaa38a9060
partial
template|24115
60 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24115
61 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24115
62 ADD Partial cache (DateInfoRepeater)
webpartinstance|ec832534-60f9-49a7-968a-1a59b95d21d2
partial
template|24115
63 ADD cmsdatasource||en-us|nwtc|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|en-us|false|nwtc.news|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
webpartinstance|ec832534-60f9-49a7-968a-1a59b95d21d2
nodes|nwtc|nwtc.news|all
node|nwtc|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w
CMSWebPartZone.CachedWebPart_Init
64 ADD Partial cache (ContentRepeater)
webpartinstance|389cf0a8-74f0-40da-b334-b497f0da4c7c
partial
template|24115
CMSWebPartZone.CachedWebPart_Init
65 GET cmsdatasource||en-us|nwtc|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|en-us|false|nwtc.news|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| CMSWebPartZone.CachedWebPart_Init
66 ADD Partial cache (MainImage)
webpartinstance|5ad6cc06-5907-4975-93ed-b6dd251642d8
documentid|5482
partial
template|24115
CMSWebPartZone.CachedWebPart_Init
67 ADD Partial cache (MainContent)
webpartinstance|46ccf90e-e6d3-4124-88a0-6655c842ecb5
documentid|5482
partial
template|24115
68 ADD Partial cache (ShareThisContent)
webpartinstance|5b48a210-e0f3-47f7-979b-db22b2cc81ea
partial
template|24115
69 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
70 ADD Partial cache (RelatedNewsRepeater)
webpartinstance|cc9ebe2d-982e-44b1-8ab5-0f9db2981d93
partial
template|24115
CMSWebPartZone.CachedWebPart_Init
71 ADD cmsdatasource||en-us|nwtc|/%|en-us|false|nwtc.news|documentid <> 5482 and 1=1 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))) |newsdate desc, nodeorder|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|3||false||
webpartinstance|cc9ebe2d-982e-44b1-8ab5-0f9db2981d93
nodes|nwtc|nwtc.news|all
node|nwtc|/|childnodes
CMSWebPartZone.CachedWebPart_Init
72 ADD Partial cache (NewsListing)
webpartinstance|82ceaeee-06d0-44c5-87e5-4f8a88fdc143
partial
template|24115
CMSWebPartZone.CachedWebPart_Init
73 ADD querydatasource|nwtc.transformationsqueries.newsandfoldersjoined||nodealiaspath like '/about-nwtc/news/%' and
documentmenuitemhideinnavigation = 0 and
([documentcanbepublished] = 1 and ([documentpublishfrom] is null or [documentpublishfrom] <= getdate()) and ([documentpublishto] is null or [documentpublishto] >= getdate()))
|newsdate desc, nodelevel, nodeorder|0||
webpartinstance|82ceaeee-06d0-44c5-87e5-4f8a88fdc143
nwtc.transformationsqueries|all
CMSWebPartZone.CachedWebPart_Init
74 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24115
PageContext.CurrentPage_InitComplete
75 ADD Partial cache (NewLeftMenu)
webpartinstance|ea152275-23ac-4918-a180-5edaa38a9060
partial
template|24115
76 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24115
77 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24115
78 ADD Partial cache (RelatedNewsRepeater)
webpartinstance|cc9ebe2d-982e-44b1-8ab5-0f9db2981d93
partial
template|24115
79 ADD Partial cache (NewsListing)
webpartinstance|82ceaeee-06d0-44c5-87e5-4f8a88fdc143
partial
template|24115
80 ADD Partial cache (DateInfoRepeater)
webpartinstance|ec832534-60f9-49a7-968a-1a59b95d21d2
partial
template|24115
81 ADD Partial cache (ContentRepeater)
webpartinstance|389cf0a8-74f0-40da-b334-b497f0da4c7c
partial
template|24115
82 ADD Partial cache (MainImage)
webpartinstance|5ad6cc06-5907-4975-93ed-b6dd251642d8
documentid|5482
partial
template|24115
83 ADD Partial cache (MainContent)
webpartinstance|46ccf90e-e6d3-4124-88a0-6655c842ecb5
documentid|5482
partial
template|24115
84 ADD Partial cache (ShareThisContent)
webpartinstance|5b48a210-e0f3-47f7-979b-db22b2cc81ea
partial
template|24115
85 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
86 GET pageinfo|nwtc|/master-items/mega-menus/admissions|en-us||false CMSAbstractWebPart.OnLoad
87 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
88 GET inlinewidgetcontrol|528|1572
89 GET pageinfo|nwtc|/master-items/mega-menus/programs|en-us||false CMSAbstractWebPart.OnLoad
90 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
91 GET inlinewidgetcontrol|528|1572
92 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
93 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
94 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
95 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
96 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
97 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
98 ADD breadcrumbs|nwtc|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w|en-us|false|cms.menuitem||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w
node|nwtc|/about-nwtc/news/2017/june
node|nwtc|/about-nwtc/news/2017
node|nwtc|/about-nwtc/news
node|nwtc|/about-nwtc
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
99 GET pageinfo|nwtc|/resources/shared-page-content/sharethis-main|en-us||false CMSAbstractWebPart.OnLoad
100 GET inlinewidgetcontrol|526|1571 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
101 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
102 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'/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w';
DECLARE @NodeAliasPath nvarchar(max) = N'/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w';
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'/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w' 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 ("/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w")
@NodeAliasPath ("/about-nwtc/news/2017/june/president-rafn-presents-on-career-pathways-what-w")
@DocumentCulture ("en-US")
3.8 kB
 
Table (1 [65], 642 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'/About-NWTC/News/2017/June', N'/About-NWTC/News/2017', N'/About-NWTC/News', N'/About-NWTC', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
457 B
 
Table (5 [157], 44 kB)
 
SimpleHandler`2.StartEvent 0.016
 
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.news.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_News AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[NewsID] AND V.ClassName = N'NWTC.News' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 5619) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
382 B
 
Table (1 [172], 1.6 kB)
 
SimpleHandler`2.StartEvent 0.031
 
5
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 4631;
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 (4631)
@PermissionName ("read")
@SiteID (1)
359 B
 
Table (3 [10], 339 B)
 
SimpleHandler`2.StartEvent 0.000
 
6
(cms.acl.generalselect)
DECLARE @ACLID int = 14;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
@ACLID (14)
78 B
 
Table (1 [5], 54 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:08:31 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 (12,14)

@UserID (65)
@SiteID (1)
@Date (1/18/2018 12:08:31 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 = 5488;

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 (5488)
3.1 kB
 
Table (1 [65], 401 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
10
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/About-NWTC/News/2017';
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 [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (1)
@NodeAliasPath ("/About-NWTC/News/2017")
@DocumentCulture ("en-US")
3.3 kB
 
Table (1 [65], 386 B)
 
PageContext.CurrentPage_InitComplete 0.016
 
11
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/About-NWTC/News';
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 [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (1)
@NodeAliasPath ("/About-NWTC/News")
@DocumentCulture ("en-US")
3.3 kB
 
Table (1 [65], 23 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
12
(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'/About-NWTC', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
379 B
 
Table (2 [157], 19.5 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
13
(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'/About-NWTC/News', N'/About-NWTC', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
400 B
 
Table (3 [157], 43 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
14
(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'/About-NWTC/News/2017', N'/About-NWTC/News', N'/About-NWTC', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
426 B
 
Table (4 [157], 44 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
15
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
 
16
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.016
 
17
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 5482
PageContext.CurrentPage_InitComplete 0.016
 
18
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 '/About-NWTC/News/2017/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
CMSWebPartZone.CachedWebPart_Init 0.031
 
19
(nwtc.news.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:08:32 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/About-NWTC/News/2017/June/President-Rafn-presents-on-Career-Pathways-What-W';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_News AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[NewsID] AND V.ClassName = N'NWTC.News' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:08:32 AM)
@NodeAliasPath ("/About-NWTC/News/2017/June/President-Rafn-presents-on-Career-Pathways-What-W")
@DocumentCulture ("en-US")
891 B
 
Table (1 [172], 1.6 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.000
 
20
(cms.user.generalselect)
SELECT TOP 1 [FullName]
FROM CMS_User
WHERE (UserID = 758)
Table (1 [1], 13 B)
 
cmsvirtualfiles_transformations__vg_4713bc67_3d32_494b_a5fa_0a9edd75bd13_nwtc_news_newsdetailtime_ascx.__DataBind__control2 0.000
 
21
(nwtc.news.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:08:33 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 3 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_News AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[NewsID] AND V.ClassName = N'NWTC.News' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (DocumentID <> 5482 and 1=1 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 [DocumentCulture] = @DocumentCulture)
ORDER BY NewsDate desc, NodeOrder
@NodeSiteID (1)
@Now (1/18/2018 12:08:33 AM)
@DocumentCulture ("en-US")
925 B
 
Table (3 [172], 14.1 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.344
 
22
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = 'c50517ca-fe4e-4063-89fb-d8c91f820aac';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (c50517ca-fe4e-4063-89fb-d8c91f820aac)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 166 B)
 
cmsvirtualfiles_transformations__vg_cf34c393_0c77_44e7_a566_1b7f2f95dceb_nwtc_news_newswidget_ascx.__DataBind__control2 0.000
 
23
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = 'a68b9713-4b04-41da-9bcb-efd125061045';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (a68b9713-4b04-41da-9bcb-efd125061045)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 138 B)
 
0.000
 
24
(nwtc.transformationsqueries.newsandfoldersjoined)
SELECT * FROM (SELECT TreeTable.*
,NewsTable.[NewsID]
,NewsTable.[Title]
,NewsTable.[Content]
,NewsTable.[ShowOnHomepage]
,NewsTable.[Author]
,NewsTable.[TeaserImage]
,NewsTable.[UseCustomContent]
,NewsTable.[PostToTwitter]
,NewsTable.[PostToFacebook]
,NewsTable.[CategoryType]
,NewsTable.[CategoryLocation]
,NewsTable.[NewsDate]
,NewsMonthTable.[Month] as NewsMonth
,NewsMonthTable.[Year] as NewsMonthYear
,NewsYearTable.[Year] as NewsYear
FROM View_CMS_Tree_Joined as TreeTable
Left Join View_NWTC_News_Joined as NewsTable on TreeTable.DocumentID = NewsTable.DocumentID
Left Join View_NWTC_NewsMonthFolder_Joined as NewsMonthTable on TreeTable.DocumentID = NewsMonthTable.DocumentID
Left Join View_NWTC_NewsYearFolder_Joined as NewsYearTable on TreeTable.DocumentID = NewsYearTable.DocumentID
where TreeTable.ClassName in('NWTC.NewsMonthFolder', 'NWTC.News', 'NWTC.NewsYearFolder')) as JoinedTable WHERE NodeAliasPath like '/About-NWTC/News/%' and
DocumentMenuItemHideInNavigation = 0 and
([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= GETDATE()) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= GETDATE()))
order by NewsDate Desc, NodeLevel, NodeOrder
1.3 kB
 
Table (290 [124], 986 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.156
 
25
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/%';
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 ("/About-NWTC/News/2017/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
cmsvirtualfiles_transformations__vg_c9bd261e_b85f_48d9_81ca_39fca5eeb675_cms_folder_collapsiblemenuitemeventnewssubcount_ascx.__DataBind__control2 0.016
 
26
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/%';
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 ("/About-NWTC/News/2017/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.016
 
27
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/December/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.000
 
28
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/December/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.000
 
29
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/January/%")
@SiteID (1)
828 B
 
Table (1 [1], 4 B)
 
0.000
 
30
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/January/%")
@SiteID (1)
829 B
 
Table (1 [1], 4 B)
 
0.000
 
31
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/February/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.016
 
32
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/February/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.000
 
33
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/March/%")
@SiteID (1)
824 B
 
Table (1 [1], 4 B)
 
0.000
 
34
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/March/%")
@SiteID (1)
825 B
 
Table (1 [1], 4 B)
 
0.016
 
35
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/April/%")
@SiteID (1)
824 B
 
Table (1 [1], 4 B)
 
0.000
 
36
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/April/%")
@SiteID (1)
825 B
 
Table (1 [1], 4 B)
 
0.000
 
37
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/May/%")
@SiteID (1)
820 B
 
Table (1 [1], 4 B)
 
0.016
 
38
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/May/%")
@SiteID (1)
821 B
 
Table (1 [1], 4 B)
 
0.000
 
39
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/June/%")
@SiteID (1)
822 B
 
Table (1 [1], 4 B)
 
0.000
 
40
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/June/%")
@SiteID (1)
823 B
 
Table (1 [1], 4 B)
 
0.000
 
41
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/July/%")
@SiteID (1)
822 B
 
Table (1 [1], 4 B)
 
0.000
 
42
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/July/%")
@SiteID (1)
823 B
 
Table (1 [1], 4 B)
 
0.000
 
43
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/August/%")
@SiteID (1)
826 B
 
Table (1 [1], 4 B)
 
0.000
 
44
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/August/%")
@SiteID (1)
827 B
 
Table (1 [1], 4 B)
 
0.016
 
45
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/November/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.000
 
46
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/November/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.000
 
47
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/October/%")
@SiteID (1)
828 B
 
Table (1 [1], 4 B)
 
0.000
 
48
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/October/%")
@SiteID (1)
829 B
 
Table (1 [1], 4 B)
 
0.016
 
49
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/September/%")
@SiteID (1)
832 B
 
Table (1 [1], 4 B)
 
0.000
 
50
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2017/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 ("/About-NWTC/News/2017/September/%")
@SiteID (1)
833 B
 
Table (1 [1], 4 B)
 
0.000
 
51
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/%';
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 ("/About-NWTC/News/2016/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
0.031
 
52
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/%';
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 ("/About-NWTC/News/2016/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.016
 
53
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/January/%")
@SiteID (1)
828 B
 
Table (1 [1], 4 B)
 
0.000
 
54
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/January/%")
@SiteID (1)
829 B
 
Table (1 [1], 4 B)
 
0.000
 
55
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/February/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.016
 
56
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/February/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.000
 
57
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/March/%")
@SiteID (1)
824 B
 
Table (1 [1], 4 B)
 
0.000
 
58
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/March/%")
@SiteID (1)
825 B
 
Table (1 [1], 4 B)
 
0.000
 
59
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/April/%")
@SiteID (1)
824 B
 
Table (1 [1], 4 B)
 
0.016
 
60
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/April/%")
@SiteID (1)
825 B
 
Table (1 [1], 4 B)
 
0.000
 
61
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/May/%")
@SiteID (1)
820 B
 
Table (1 [1], 4 B)
 
0.016
 
62
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/May/%")
@SiteID (1)
821 B
 
Table (1 [1], 4 B)
 
0.000
 
63
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/June/%")
@SiteID (1)
822 B
 
Table (1 [1], 4 B)
 
0.000
 
64
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/June/%")
@SiteID (1)
823 B
 
Table (1 [1], 4 B)
 
0.000
 
65
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/July/%")
@SiteID (1)
822 B
 
Table (1 [1], 4 B)
 
0.000
 
66
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/July/%")
@SiteID (1)
823 B
 
Table (1 [1], 4 B)
 
0.000
 
67
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/August/%")
@SiteID (1)
826 B
 
Table (1 [1], 4 B)
 
0.000
 
68
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/August/%")
@SiteID (1)
827 B
 
Table (1 [1], 4 B)
 
0.016
 
69
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/September/%")
@SiteID (1)
832 B
 
Table (1 [1], 4 B)
 
0.000
 
70
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/September/%")
@SiteID (1)
833 B
 
Table (1 [1], 4 B)
 
0.000
 
71
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/October/%")
@SiteID (1)
828 B
 
Table (1 [1], 4 B)
 
0.000
 
72
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/October/%")
@SiteID (1)
829 B
 
Table (1 [1], 4 B)
 
0.000
 
73
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/November/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.016
 
74
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/November/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.000
 
75
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/December/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.000
 
76
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2016/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 ("/About-NWTC/News/2016/December/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.016
 
77
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/%';
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 ("/About-NWTC/News/2015/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
0.016
 
78
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/%';
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 ("/About-NWTC/News/2015/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.016
 
79
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/January/%")
@SiteID (1)
828 B
 
Table (1 [1], 4 B)
 
0.000
 
80
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/January/%")
@SiteID (1)
829 B
 
Table (1 [1], 4 B)
 
0.000
 
81
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/Febuary/%';
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 ("/About-NWTC/News/2015/Febuary/%")
@SiteID (1)
828 B
 
Table (1 [1], 4 B)
 
0.000
 
82
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/Febuary/%';
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 ("/About-NWTC/News/2015/Febuary/%")
@SiteID (1)
829 B
 
Table (1 [1], 4 B)
 
0.000
 
83
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/March/%")
@SiteID (1)
824 B
 
Table (1 [1], 4 B)
 
0.000
 
84
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/March/%")
@SiteID (1)
825 B
 
Table (1 [1], 4 B)
 
0.016
 
85
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/April/%")
@SiteID (1)
824 B
 
Table (1 [1], 4 B)
 
0.000
 
86
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/April/%")
@SiteID (1)
825 B
 
Table (1 [1], 4 B)
 
0.000
 
87
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/May/%")
@SiteID (1)
820 B
 
Table (1 [1], 4 B)
 
0.016
 
88
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/May/%")
@SiteID (1)
821 B
 
Table (1 [1], 4 B)
 
0.000
 
89
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/June/%")
@SiteID (1)
822 B
 
Table (1 [1], 4 B)
 
0.000
 
90
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/June/%")
@SiteID (1)
823 B
 
Table (1 [1], 4 B)
 
0.000
 
91
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/July/%")
@SiteID (1)
822 B
 
Table (1 [1], 4 B)
 
0.000
 
92
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/July/%")
@SiteID (1)
823 B
 
Table (1 [1], 4 B)
 
0.000
 
93
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/August/%")
@SiteID (1)
826 B
 
Table (1 [1], 4 B)
 
0.000
 
94
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/August/%")
@SiteID (1)
827 B
 
Table (1 [1], 4 B)
 
0.000
 
95
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/September/%")
@SiteID (1)
832 B
 
Table (1 [1], 4 B)
 
0.000
 
96
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/September/%")
@SiteID (1)
833 B
 
Table (1 [1], 4 B)
 
0.000
 
97
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/October/%")
@SiteID (1)
828 B
 
Table (1 [1], 4 B)
 
0.000
 
98
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/October/%")
@SiteID (1)
829 B
 
Table (1 [1], 4 B)
 
0.000
 
99
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/November/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.016
 
100
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/November/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.000
 
101
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/December/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.000
 
102
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2015/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 ("/About-NWTC/News/2015/December/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.016
 
103
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/%';
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 ("/About-NWTC/News/2014/%")
@SiteID (1)
812 B
 
Table (1 [1], 4 B)
 
0.016
 
104
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/%';
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 ("/About-NWTC/News/2014/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.016
 
105
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/August/%")
@SiteID (1)
826 B
 
Table (1 [1], 4 B)
 
0.000
 
106
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/August/%")
@SiteID (1)
827 B
 
Table (1 [1], 4 B)
 
0.000
 
107
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/September/%")
@SiteID (1)
832 B
 
Table (1 [1], 4 B)
 
0.016
 
108
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/September/%")
@SiteID (1)
833 B
 
Table (1 [1], 4 B)
 
0.000
 
109
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/October/%")
@SiteID (1)
828 B
 
Table (1 [1], 4 B)
 
0.000
 
110
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/October/%")
@SiteID (1)
829 B
 
Table (1 [1], 4 B)
 
0.016
 
111
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/November/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.000
 
112
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/November/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.000
 
113
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/December/%")
@SiteID (1)
830 B
 
Table (1 [1], 4 B)
 
0.000
 
114
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/About-NWTC/News/2014/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 ("/About-NWTC/News/2014/December/%")
@SiteID (1)
831 B
 
Table (1 [1], 4 B)
 
0.016
 
115
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 '/About-NWTC/News/2017/%')) AND (Published = 1)) AND (NodeAliasPath like '/About-NWTC/News/2017/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.9 kB
 
PageContext.CurrentPage_InitComplete 0.016
 
116
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:08:34 AM';
DECLARE @NodeLevel int = 5;
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'/About-NWTC/News/2017/June/President-Rafn-presents-on-Career-Pathways-What-W', N'/About-NWTC/News/2017/June', N'/About-NWTC/News/2017', N'/About-NWTC/News', N'/About-NWTC', 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:08:34 AM)
@NodeLevel (5)
@DocumentCulture ("en-US")
1.6 kB
 
Table (2 [36], 329 B)
 
CMSAbstractMenuProperties.OnLoad 0.016
 
  116 queries, 109 kB write, 1.2 MB read   1.188