CONTENTSTART
EXCLUDESTART EXCLUDEEND

NWTC Newsroom

Bowl with Packers to raise funds for NWTC Promise
Bowl with Packers to raise funds for NWTC Promise
Relevance:
The Green Bay Packers will raise funds for NWTC students in need with a bowling event this June. The public is invited to bowl with current and former Packers players and coaches at the Packers Give Back Celebrity Bowling Event on June 7. The announcement from the Packe...
Monday March 13, 2017
View Details
NWTC Corporate Training announces new resource for small business
NWTC Corporate Training announces new resource for small business
Relevance:
Small business owners who are interested in getting expert help to grow can now contact Michelle Madl-Soehren, newest member of NWTC’s Small Business Initiative team. Michelle is NWTC's new Small Business Development Consultant and says she is passionate about "cultivating rel...
Wednesday March 8, 2017
View Details
National news: NWTC selected to join The Frontier Set
National news: NWTC selected to join The Frontier Set
Relevance:
Northeast Wisconsin Technical College is pleased to announce that the college has been selected to join the Frontier Set, a small diverse group of high-performing, high-potential postsecondary institutions and systems identified by the Bill & Melinda Gates Foundation and inter...
Thursday March 2, 2017
View Details
NWTC student projects showcased at State Capitol
NWTC student projects showcased at State Capitol
Relevance:
Northeast Wisconsin Technical College sent four students to the State Capitol in Madison on Feb. 21 as part of a statewide showcase of Service-Learning. The Wisconsin Technical College System (WTCS) held the Student Showcase event today at the State Capitol to highlight s...
Tuesday February 21, 2017
View Details
Food for Thought series explores addiction, race, poetry
Food for Thought series explores addiction, race, poetry
Relevance:
Rise Together - Drug Addiction:  Awareness  • Recovery  • Prevention Wednesday, March 8  |   11:30am - 12:30pm   |   SC132   Hear compelling stories first-hand from Rise Together. They will share their personal battles with addiction and their journey to recovery. Wha...
Thursday February 16, 2017
View Details
NWTC announces newly-accredited College of Business
NWTC announces newly-accredited College of Business
Relevance:
NWTC this week announced the accreditation of all of its business programs, establishing Northeast Wisconsin's first accredited two-year College of Business. NWTC College of Business Dean Randy Smith said the accreditation is a sign of quality and a tool for students intereste...
Tuesday February 7, 2017
View Details
Top 5: Being on Campus During Break
Top 5: Being on Campus During Break
Relevance:
NWTC students might be on break right now, but there are still plenty of cool things about being on campus during the holiday break. Here is a list of our top 5:   1. No line at the Campus Buzz. 2. Stop in Student Support Services and talk about your holiday expenses ...
Tuesday December 27, 2016
View Details
December Graduation photo gallery
December Graduation photo gallery
Relevance:
Congratulations to the newest Northeast Wisconsin Technical College graduates! Enjoy the photo gallery from December graduation at the KI Convention Center. Congratulate the newest graduates of Northeast Wisconsin Technical College! - See more at: https://wwwstg.nwtc.edu/abou...
Thursday December 22, 2016
View Details
Yes, 1,000 students will graduate from NWTC tonight as planned!
Yes, 1,000 students will graduate from NWTC tonight as planned!
Relevance:
UPDATE: Mid-Year Graduation WILL be held tonight, 6 p.m. Dec. 16, 2016 as planned About 1,000 students will graduate from Northeast Wisconsin Technical College this month. SEE IT LIVE! Watch  NWTC's 2016 December  Graduation live video stream NWTC's main December 201...
Friday December 16, 2016
View Details
Names of 1,000 December 2016 Graduates of NWTC
Names of 1,000 December 2016 Graduates of NWTC
Relevance:
Congratulate the newest graduates of Northeast Wisconsin Technical College! Below are the students who have completed their graduation requirements since July 1,2016 AND have given us permission to release their names. Key:  One asterisk (*) Graduate with honors Two ast...
Thursday December 8, 2016
View Details
|<  <   1 2 3 4 5 6 7 8 9 10 11    >  >|
1 of 11
You can use the URLs below to subscribe to our general News RSS or a filtered News RSS based on the search you just ran. Your RSS provider will use the URL to automatically check our website periodically and update your feed with new news releases meeting this search criteria. You can also subscribe using a desktop RSS applications or your browser.
 
General Subscription URL:
Filtered Subscription URL:
Note: Updates to your RSS feed can take up to 24 hours, depending on your RSS Feed settings.

EXCLUDESTART

Search 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/006E/1124420613.cache Local SimpleHandler`2.StartEvent
2 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local DbPathProvider.GetFileHash
3 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
4 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local
5 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
6 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local
7 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
8 GETFILES
~/App_Data/CMSModules/SmartSearch/News/ Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
9 GETFILES
~/App_Data/CMSModules/SmartSearch/News/
16
Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
10 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/News/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
11 READ
20 B (1)
 
~/App_Data/CMSModules/SmartSearch/News/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
12 CLOSE
~/App_Data/CMSModules/SmartSearch/News/segments.gen Local FileStream.CloseInnerStream
13 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/News/segments_1h Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
14 READ
198 B (1)
 
~/App_Data/CMSModules/SmartSearch/News/segments_1h Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
15 CLOSE
~/App_Data/CMSModules/SmartSearch/News/segments_1h Local FileStream.CloseInnerStream
16 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local cmsvirtualfiles_transformations__vg_f746e375_b393_4f78_90b5_48365dbdb928_nwtc_news_newssmartsearchresults_ascx.__DataBind__control2
17 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
18 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
19 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
20 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
21 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
22 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
23 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
24 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
25 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
26 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
27 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
28 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
29 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
30 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
31 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
32 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
33 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
34 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
35 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
36 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
37 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
38 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|en-us|/about-nwtc/news|true
template|24114
nodeid|29
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/about-nwtc/news|en-us||true|true
template|24114
nodeid|29
SimpleHandler`2.StartEvent
3 ADD currentdocument|nwtc|/about-nwtc/news|en-us
nodes|nwtc|cms.menuitem|all
node|nwtc|/about-nwtc/news
SimpleHandler`2.StartEvent
4 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
5 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
6 GET pageinfo|nwtc|/about-nwtc|en-us||false PageContext.CurrentPage_InitComplete
7 GET pageinfo|nwtc|/|en-us||false
8 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
9 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
10 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|29
partial
template|24098
11 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
12 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
13 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news|/|googletranslator
CMSWebPartZone.CachedWebPart_Init
14 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
15 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news|/|mobilemenubutton
16 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
17 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news|/|newmobilemenu
18 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news|/|mobilemenu
19 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
20 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|29
partial
template|24098
21 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|29
partial
template|24098
22 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|29
partial
template|24098
23 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
24 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
25 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|29
partial
template|24098
26 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|29
partial
template|24098
27 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
28 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
29 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
30 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
PageContext.CurrentPage_InitComplete
31 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|29
partial
template|24098
32 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
33 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news|/|googletranslator
34 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
35 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news|/|mobilemenubutton
36 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
37 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news|/|newmobilemenu
38 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/news|/|mobilemenu
39 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
40 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|29
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
41 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|29
partial
template|24098
42 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|29
partial
template|24098
43 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
PageContext.CurrentPage_InitComplete
44 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
45 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|29
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
46 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|29
partial
template|24098
47 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
PageContext.CurrentPage_InitComplete
48 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
49 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
50 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|29
partial
template|24098
51 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|29
partial
template|24098
52 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|29
partial
template|24098
53 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|29
partial
template|24098
54 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|29
partial
template|24098
55 GET onlinemarketingcpvariantsbytemplateid|24114 PageContext.CurrentPage_InitComplete
56 GET onlinemarketingcpvariantsbytemplateid|24114
57 GET onlinemarketingcpvariantsbytemplateid|24114
58 GET onlinemarketingcpvariantsbytemplateid|24114
59 GET onlinemarketingcpvariantsbytemplateid|24114
60 GET onlinemarketingcpvariantsbytemplateid|24114
61 GET onlinemarketingcpvariantsbytemplateid|24114
62 GET onlinemarketingcpvariantsbytemplateid|24114
63 GET onlinemarketingcpvariantsbytemplateid|24114
64 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24114
CMSWebPartZone.CachedWebPart_Init
65 ADD Partial cache (NewLeftMenu)
webpartinstance|789a120d-2ad5-4b08-98e6-572d8515f86b
partial
template|24114
66 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24114
67 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|29
partial
template|24114
68 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|29
partial
template|24114
69 ADD Partial cache (NewsSubscribe)
webpartinstance|629e8e1d-0c40-48aa-9010-e830bccf4bfd
partial
template|24114
70 ADD Partial cache (ShareThisContent)
webpartinstance|c657375f-bb0a-410b-846c-248b513d9eed
partial
template|24114
71 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
72 ADD Partial cache (FilterButton)
webpartinstance|2a52e2d0-c42a-4743-b50c-3a5483d68d62
partial
template|24114
CMSWebPartZone.CachedWebPart_Init
73 ADD Partial cache (NewsListing)
webpartinstance|2eeb8fcb-0daa-43c9-a31a-c0b771e8007b
partial
template|24114
74 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|2eeb8fcb-0daa-43c9-a31a-c0b771e8007b
nwtc.transformationsqueries|all
CMSWebPartZone.CachedWebPart_Init
75 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24114
PageContext.CurrentPage_InitComplete
76 ADD Partial cache (NewLeftMenu)
webpartinstance|789a120d-2ad5-4b08-98e6-572d8515f86b
partial
template|24114
77 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24114
78 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|29
partial
template|24114
79 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|29
partial
template|24114
80 ADD Partial cache (NewsSubscribe)
webpartinstance|629e8e1d-0c40-48aa-9010-e830bccf4bfd
partial
template|24114
81 ADD Partial cache (ShareThisContent)
webpartinstance|c657375f-bb0a-410b-846c-248b513d9eed
partial
template|24114
82 ADD Partial cache (NewsListing)
webpartinstance|2eeb8fcb-0daa-43c9-a31a-c0b771e8007b
partial
template|24114
83 ADD Partial cache (FilterButton)
webpartinstance|2a52e2d0-c42a-4743-b50c-3a5483d68d62
partial
template|24114
84 GET cmsdatasource||en-us|nwtc|/master-items/alerts/%|en-us|false|nwtc.alert||nodeorder|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|1||false|| BasicRepeater.OnLoad
85 GET pageinfo|nwtc|/master-items/mega-menus/admissions|en-us||false CMSAbstractWebPart.OnLoad
86 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
87 GET inlinewidgetcontrol|528|1572
88 GET pageinfo|nwtc|/master-items/mega-menus/programs|en-us||false CMSAbstractWebPart.OnLoad
89 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
90 GET inlinewidgetcontrol|528|1572
91 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
92 GET cmsdatasource||en-us|nwtc|/events/%|en-us|false|nwtc.event|((eventallday = 0 and datediff(minute,getdate(),eventdate)>=0) or (eventallday = 1 and datediff(day, getdate(), eventdate)>=0) or (eventenddate is not null and ((eventallday = 1 and datediff(day,eventenddate,getdate())<=0) or (eventallday = 0 and datediff(minute,eventenddate,getdate())<=0)))) and ( documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('academiccalendar_1','studentlife_1') )) ) and ( documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('greenbaycampus') )) ) |eventdate asc, nodelevel, nodeorder|-1|true|00000000-0000-0000-0000-000000000000||false|2||false|| BasicRepeater.OnLoad
93 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
94 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
95 GET cmsdatasource||en-us|nwtc|/resources/shared-page-content/satisfaction|en-us|false|custom.shareablecontent|||-1|true|00000000-0000-0000-0000-000000000000||false|0||false|| BasicRepeater.OnLoad
96 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
97 ADD breadcrumbs|nwtc|/about-nwtc/news|en-us|false|cms.menuitem||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/about-nwtc/news
node|nwtc|/about-nwtc
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
98 GET pageinfo|nwtc|/resources/shared-page-content/sharethis-main|en-us||false CMSAbstractWebPart.OnLoad
99 GET inlinewidgetcontrol|539|1575 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
100 GET inlinewidgetcontrol|539|1575
101 GET inlinewidgetcontrol|526|1571
102 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
103 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';
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 [DocumentUrlPath] = N'/about-nwtc/news' 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")
@NodeAliasPath ("/about-nwtc/news")
@DocumentCulture ("en-US")
3.5 kB
 
Table (1 [65], 23 kB)
 
SimpleHandler`2.StartEvent 0.022
 
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', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
379 B
 
Table (2 [157], 19.5 kB)
 
SimpleHandler`2.StartEvent 0.010
 
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.003
 
4
(cms.menuitem.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 29) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
394 B
 
Table (1 [166], 24 kB)
 
SimpleHandler`2.StartEvent 0.042
 
5
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 4608;
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 (4608)
@PermissionName ("read")
@SiteID (1)
359 B
 
Table (2 [10], 193 B)
 
SimpleHandler`2.StartEvent 0.002
 
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.002
 
7
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 1;
DECLARE @Date datetime2 = '1/16/2018 1:49:18 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/16/2018 1:49:18 AM)
1.3 kB
 
SimpleHandler`2.StartEvent 0.005
 
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.003
 
9
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.028
 
10
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.025
 
11
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 29
PageContext.CurrentPage_InitComplete 0.006
 
12
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

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

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

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
Table (1172 [19], 341 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.103
 
13
(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.150
 
14
(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.018
 
15
(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.017
 
16
(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.003
 
17
(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.003
 
18
(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.003
 
19
(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.004
 
20
(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.003
 
21
(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.003
 
22
(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.003
 
23
(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.003
 
24
(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.003
 
25
(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.003
 
26
(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.003
 
27
(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.003
 
28
(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.004
 
29
(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.003
 
30
(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.003
 
31
(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.002
 
32
(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.002
 
33
(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.002
 
34
(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.003
 
35
(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.002
 
36
(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.002
 
37
(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.003
 
38
(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.003
 
39
(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.003
 
40
(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.025
 
41
(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.025
 
42
(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.004
 
43
(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.004
 
44
(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.005
 
45
(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.005
 
46
(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.004
 
47
(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.004
 
48
(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.005
 
49
(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.004
 
50
(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.004
 
51
(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.004
 
52
(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.002
 
53
(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.003
 
54
(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.003
 
55
(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.003
 
56
(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.004
 
57
(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.003
 
58
(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.004
 
59
(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.004
 
60
(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.004
 
61
(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.003
 
62
(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.003
 
63
(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.003
 
64
(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.003
 
65
(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.003
 
66
(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.015
 
67
(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.014
 
68
(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.003
 
69
(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.003
 
70
(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.002
 
71
(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.004
 
72
(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.003
 
73
(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.004
 
74
(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.002
 
75
(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.002
 
76
(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.003
 
77
(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.002
 
78
(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.002
 
79
(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.002
 
80
(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.002
 
81
(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.002
 
82
(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.002
 
83
(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.002
 
84
(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.001
 
85
(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.002
 
86
(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.001
 
87
(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.002
 
88
(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.003
 
89
(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.002
 
90
(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.003
 
91
(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.002
 
92
(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.008
 
93
(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.008
 
94
(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.002
 
95
(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.002
 
96
(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.003
 
97
(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.003
 
98
(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.003
 
99
(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.002
 
100
(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.002
 
101
(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.002
 
102
(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.002
 
103
(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.002
 
104
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 '/%')) AND (Published = 1)) AND (NodeAliasPath like '/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
Table (1172 [19], 341 kB)
 
PageContext.CurrentPage_InitComplete 0.077
 
105
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/16/2018 1:49:23 AM';
DECLARE @NodeLevel int = 2;
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', 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/16/2018 1:49:23 AM)
@NodeLevel (2)
@DocumentCulture ("en-US")
1.5 kB
 
Table (2 [36], 329 B)
 
CMSAbstractMenuProperties.OnLoad 0.024
 
106
(nwtc.transformationsqueries.typecategoriessmartsearchfilter)
Select Filter, CategoryName, CategoryDisplayName from
(SELECT '' as Filter, '' as CategoryName, 'Select Type' as CategoryDisplayName, -1 as CategoryLevel, -1 CategoryOrder
UNION ALL
SELECT 'Categories' as Filter, CategoryName, CategoryDisplayName, CategoryLevel, CategoryOrder from CMS_Category WHERE CategoryNamePath like '/NWTC News Types/%') as Temp ORDER BY CategoryLevel, CategoryOrder
Table (31 [3], 1.2 kB)
 
CMSWebParts_SmartSearch_SearchFilter.Page_Load 0.003
 
107
(nwtc.transformationsqueries.locationscategoriessmartsearchfilter)
Select Filter, CategoryName, CategoryDisplayName from
(SELECT '' as Filter, '' as CategoryName, 'Select Location' as CategoryDisplayName, -1 as CategoryLevel, -1 CategoryOrder
UNION ALL
SELECT 'Categories' as Filter, CategoryName, CategoryDisplayName, CategoryLevel, CategoryOrder from CMS_Category WHERE CategoryNamePath like '/NWTC News Event Locations/%') as Temp ORDER BY CategoryLevel, CategoryOrder
Table (4 [3], 142 B)
 
0.002
 
108
(cms.site.generalselect)
SELECT [SiteID], [SiteName], [SiteStatus]
FROM CMS_Site
WHERE [SiteID] IN (
SELECT [IndexSiteID]
FROM CMS_SearchIndexSite
WHERE [IndexId] = 2
)
Table (1 [3], 15 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
109
(nwtc.news.generalselect)
DECLARE @Now datetime2 = '1/16/2018 1:49:23 AM';

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 (([DocumentID] IN (5101, 5097, 5083, 5076, 5078, 5049, 5038, 5044, 5025, 5007, 4879, 4834, 4816, 4815, 4814, 4809, 4801, 4776, 4777, 4773) AND [NodeLinkedNodeID] IS NULL)) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
@Now (1/16/2018 1:49:23 AM)
667 B
 
Table (20 [172], 113 kB)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.049
 
110
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'b1c4407b-a6d3-48e1-bed7-a8bd8fc920b4';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (b1c4407b-a6d3-48e1-bed7-a8bd8fc920b4)
302 B
 
Table (1 [1], 4 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
111
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'abdd131c-8dd5-4a1f-a663-1d8ef0546944';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (abdd131c-8dd5-4a1f-a663-1d8ef0546944)
302 B
 
Table (1 [1], 4 B)
 
0.001
 
112
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '96b05987-62b7-40a0-9a28-004ee2fc5e68';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (96b05987-62b7-40a0-9a28-004ee2fc5e68)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
113
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'c5640501-ed47-43ea-b2df-4e29de139639';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (c5640501-ed47-43ea-b2df-4e29de139639)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
114
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '08ce509f-9722-4cd5-b857-396cb2958e5f';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (08ce509f-9722-4cd5-b857-396cb2958e5f)
302 B
 
Table (1 [1], 4 B)
 
0.001
 
115
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'f9a9816f-1fb8-41b3-895b-dc60ba888f5f';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (f9a9816f-1fb8-41b3-895b-dc60ba888f5f)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
116
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'cd4181cf-f0f2-46d5-bf20-0ad9a5abe3f9';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (cd4181cf-f0f2-46d5-bf20-0ad9a5abe3f9)
302 B
 
Table (1 [1], 4 B)
 
0.001
 
117
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'b9e5ba0c-d5b2-472d-8c4d-4f961363bbd4';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (b9e5ba0c-d5b2-472d-8c4d-4f961363bbd4)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
118
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '5386bb86-c934-4b87-a979-56a3a4da531b';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (5386bb86-c934-4b87-a979-56a3a4da531b)
302 B
 
Table (1 [1], 4 B)
 
0.001
 
119
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '9eea65ad-7499-4ba6-a2e2-3e7821ba4f3c';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (9eea65ad-7499-4ba6-a2e2-3e7821ba4f3c)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
120
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '7db6f575-2ac0-45f1-8a04-e1bd4ee7067c';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (7db6f575-2ac0-45f1-8a04-e1bd4ee7067c)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
121
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '9fbabcfb-8036-4ce0-a442-2551737d358a';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (9fbabcfb-8036-4ce0-a442-2551737d358a)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
122
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'a426625b-5275-4cc4-a662-d31c172c28cd';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (a426625b-5275-4cc4-a662-d31c172c28cd)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
123
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '8f2566f1-8658-4506-8fd3-7f914601124a';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (8f2566f1-8658-4506-8fd3-7f914601124a)
302 B
 
Table (1 [1], 4 B)
 
0.001
 
124
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '20514310-ce4c-44c4-a6be-69c8c8aeb459';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (20514310-ce4c-44c4-a6be-69c8c8aeb459)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
125
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'c32a40ba-854d-4299-b244-47344d2d74f7';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (c32a40ba-854d-4299-b244-47344d2d74f7)
302 B
 
Table (1 [1], 4 B)
 
0.001
 
126
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'bf40d0d5-36d2-48d0-8fe7-c624d4050274';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (bf40d0d5-36d2-48d0-8fe7-c624d4050274)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
127
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '9818c831-61f0-44bc-b277-a50bda3a9811';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (9818c831-61f0-44bc-b277-a50bda3a9811)
302 B
 
Table (1 [1], 4 B)
 
0.002
 
128
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '662543bc-2de6-478d-86f6-2b3501d7edf7';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (662543bc-2de6-478d-86f6-2b3501d7edf7)
302 B
 
Table (1 [1], 5 B)
 
0.002
 
129
(cms.user.generalselect)
DECLARE @UserName nvarchar(max) = N'krsprenger';

SELECT *
FROM CMS_User
WHERE [UserName] = @UserName
@UserName ("krsprenger")
115 B
 
Table (1 [28], 398 B)
 
CMSWebParts_General_javascript.OnPreRender 0.004
 
  129 queries, 102 kB write, 1.8 MB read   0.960