CONTENTSTART
EXCLUDESTART EXCLUDEEND

February 2018 Events

You can use the URL below to subscribe to the search you just ran. Your calendar provider will use the URL to automatically check our website periodically and update your calendar with new events meeting this search criteria or new times for existing events. You can also subscribe using a desktop application such as Outlook.
 


 
  • To subscribe using your Google account, sign in to your account and click "Calendar" at the very top of the page. In the left column, find "Other Calendars" and click the down arrow to the right of it. In the drop down menu, click "Add by URL". Copy the Subscription URL above and paste it into the dialog. If you don't see the events, be sure the calendar is selected by expanding "Other Calendars" and verifying that the colored box is filled in next to the subscribed calendar.
  • To subscribe using your Outlook.com (Microsoft) account, sign in to your calendar and click "Import" at the very top of the page. In the left column click "Subscribe", then copy the Subscription URL above and paste it into the Calendar URL and click Subscribe.
Note: Updates to your calendar can take up to 24 hours, depending on your settings and calendar provider.
 
If you use a desktop calendar application that doesn't support subscriptions, you can download the results of this search to your computer and import them using the link below. Please note that an Import is a one-time download of the current events on our site; only Subscriptions allow your calendar to automatically sync with our website.
 
feb
01
BINGO for Prizes!
11:00 AM - 1:00 PM
Green Bay Campus Commons

Come and go as your schedule allows... stop down and play a couple rounds of BINGO anytime between 11am and 1pm in the commons!

View Details
feb
05
Pool Tournament - Win Cash Prizes!
11:00 AM - 12:00 PM
Green Bay Campus, SC118

All students welcome! You don't have to be an "expert" to play... just c'mon down and have some fun! CA$H Prizes! (amounts will depend on the number of players).Sign up opens Monday, 1/29/18 and closes 2/5/18 at ...

View Details
feb
05
Student Senate Meeting
2:30 PM - 3:30 PM
Green Bay Campus, SC130 Auditorium

A voice for NWTC Students!  Student Senate represents NWTC students, providing feedback, concerns, and suggestions to college administration. The senate meets the 1st and 3rd Mondays of...

View Details
feb
06
$cratch Off Cards!
Green Bay Campus, SC118

Stop in the Student Involvement office (SC118) today and pick up your Scratch Off card to win cash and other prizes! Starts at 9:00am  - Until Supplies Last - One Scratch off card per student- please have your student photo i.d. to...

View Details
feb
06
FREE Pathways to Entrepreneurship
5:00 PM - 7:00 PM
Advance Business & Manufacturing Center 2701 Larsen Road, Classroom Green Bay, WI

Join the Small Business Initiative at the Advance Business and Manufacturing Center on February 6th to discover the pathway to entrepreneurship! Whether you want to start a business or currently operate a part-time, home-based business, micro...

View Details
feb
07
Free Brunch & Live Music!
10:00 AM - 12:00 PM
Green Bay Campus Commons

Stop in the commons and enjoy free brunch and live music from 10:00am to Noon.- While supplies last - Please have your student photo i.d.

View Details
feb
07
Intro to QuickBooks Desktop for Small Business
3:00 PM - 4:30 PM
Advance Business & Manufacturing Center 2701 Larsen Road Green Bay, WI

This class will cover the basics of QuickBooks Desktop for entry level learners. Topics will include chart of accounts, setting up items, customers, vendors, entering and paying bills, invoicing customers, receiving payments, making deposits...

View Details
feb
08
Food for Thought: Culture of Consent (Title IX)
11:30 AM - 12:30 PM
Green Bay Campus Auditorium, SC130

Feed your body. Feed your mind.  Students receive a FREE lunch while attending!A keynote performance that blends storytelling and spoken-word poetry into a movement to end sexual violence. Culture of Consent is a keynote performance that...

View Details
feb
10
Snow Tubing
4:30 PM - 10:00 PM
Green Bay Campus, SC118

Join us for Snow Tubing at Nordic Mountain! $12 per person. Ticket includes: bus ride, snow tubing, tube rental, and hot dogs & s'mores over an open fire. Each student is allowed a plus one. Sign up in Student Involvement by February 2nd...

View Details
feb
12
NWTC Winterfest
11:00 AM - 1:00 PM
Green Bay Campus - Commons

ALL STUDENTS, FACULTY AND STAFF INVITED!  Monday, February 12 11am-1pm | NWTC Commons  Hot Chocolate BarWednesday, February 14 11am-1pm | NWTC Commons p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height...

View Details
Displaying results 1-10 (of 29)
 |<  < 1 2 3  >  >| 
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/0073/m500549429.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
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
7 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 GET pageinfo|nwtc|/events/2018|en-us||false SimpleHandler`2.StartEvent
2 GET pageinfo|nwtc|/events|en-us||false
3 ADD pageinfo|nwtc|/events/2018/february|en-us|/events/2018/february|true
template|24112
nodeid|3934
SimpleHandler`2.StartEvent
4 ADD pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/events/2018/february|en-us||true|true
template|24112
nodeid|3934
SimpleHandler`2.StartEvent
5 ADD currentdocument|nwtc|/events/2018/february|en-us
nodes|nwtc|nwtc.eventmonthfolder|all
node|nwtc|/events/2018/february
SimpleHandler`2.StartEvent
6 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
7 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
8 GET pageinfo|nwtc|/|en-us||false PageContext.CurrentPage_InitComplete
9 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
10 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
11 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|3805
partial
template|24098
12 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
13 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
14 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/february|/|googletranslator
CMSWebPartZone.CachedWebPart_Init
15 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
16 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/february|/|mobilemenubutton
17 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
18 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/february|/|newmobilemenu
19 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/february|/|mobilemenu
20 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
21 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|3805
partial
template|24098
22 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|3805
partial
template|24098
23 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|3805
partial
template|24098
24 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
25 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
26 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|3805
partial
template|24098
27 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|3805
partial
template|24098
28 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
29 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
30 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
31 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
PageContext.CurrentPage_InitComplete
32 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|3805
partial
template|24098
33 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
34 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/february|/|googletranslator
35 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
36 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/february|/|mobilemenubutton
37 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
38 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/february|/|newmobilemenu
39 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/events/2018/february|/|mobilemenu
40 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
41 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|3805
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
42 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|3805
partial
template|24098
43 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|3805
partial
template|24098
44 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
PageContext.CurrentPage_InitComplete
45 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
46 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|3805
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
47 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|3805
partial
template|24098
48 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
PageContext.CurrentPage_InitComplete
49 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
50 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
51 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|3805
partial
template|24098
52 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|3805
partial
template|24098
53 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|3805
partial
template|24098
54 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|3805
partial
template|24098
55 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|3805
partial
template|24098
56 ADD Partial cache (NewLeftMenu)
webpartinstance|8cf430a6-0036-44a7-9873-0579698be393
partial
template|24112
CMSWebPartZone.CachedWebPart_Init
57 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24112
58 ADD Partial cache (NewLeftMenu)
webpartinstance|8cf430a6-0036-44a7-9873-0579698be393
partial
template|24112
PageContext.CurrentPage_InitComplete
59 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24112
60 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
61 GET pageinfo|nwtc|/master-items/mega-menus/admissions|en-us||false CMSAbstractWebPart.OnLoad
62 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
63 GET inlinewidgetcontrol|528|1572
64 GET pageinfo|nwtc|/master-items/mega-menus/programs|en-us||false CMSAbstractWebPart.OnLoad
65 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
66 GET inlinewidgetcontrol|528|1572
67 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
68 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
69 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
70 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
71 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
72 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
73 ADD breadcrumbs|nwtc|/events/2018/february|en-us|false|cms.menuitem||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/events/2018/february
node|nwtc|/events/2018
node|nwtc|/events
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
74 GET querydatasource|nwtc.transformationsqueries.getcategories||categorynamepath like '/nwtc event types/%'|categorylevel, categoryorder|0|| BasicRepeater.OnLoad
75 GET querydatasource|nwtc.transformationsqueries.getcategories||categorynamepath like '/nwtc news event locations/%'|categorylevel, categoryorder|0||
76 ADD cmsdatasource||en-us|nwtc|/events/2018/february/%|en-us|false|nwtc.event|documentmenuitemhideinnavigation = 0 and
(datediff(day,getdate(),eventdate)>=0 or (eventenddate is not null and datediff(day,eventenddate,getdate())<=0)) and
( 1=1 ) and
( 1=1 ) |eventdate asc, nodelevel, nodeorder|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
webpartinstance|12351f82-e4d6-489c-8583-13495896912c
nodes|nwtc|nwtc.event|all
node|nwtc|/events/2018/february|childnodes
BasicRepeater.OnLoad
77 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|| BasicRepeater.OnLoad
78 GET pageinfo|nwtc|/resources/shared-page-content/sharethis-main|en-us||false CMSAbstractWebPart.OnLoad
79 GET querydatasource|nwtc.transformationsqueries.eventsandfolderjoin||nodealiaspath like '/events/%' and
documentmenuitemhideinnavigation = 0 and
([documentcanbepublished] = 1 and ([documentpublishfrom] is null or [documentpublishfrom] <= getdate()) and ([documentpublishto] is null or [documentpublishto] >= getdate()))
and
(eventdate is null or (datediff(day,getdate(),eventdate)>=0 or (eventenddate is not null and datediff(day,eventenddate,getdate())<=0))) and
(eventmonthyear is null or (eventmonthyear > year(getdate()) or (eventmonthyear = year(getdate()) and eventmonth >= month(getdate())))) and
(eventyear is null or eventyear >= year(getdate()))|nodelevel, eventdate, nodeorder|0||
BasicUniView.OnLoad
80 GET inlinewidgetcontrol|526|1571 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
81 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
82 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/events/2018/february';
DECLARE @NodeAliasPath nvarchar(max) = N'/events/2018/february';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] IN (N'/Events/2018', N'/Events', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
392 B
 
Table (3 [157], 12.7 kB)
 
SimpleHandler`2.StartEvent 0.016
 
3 This same query was called more than once within this request.
(om.contact.generalselect)
DECLARE @VisitorToContactVisitorGUID uniqueidentifier = '00000000-0000-0000-0000-000000000000';

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

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_EventMonthFolder AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventMonthFolderID] AND V.ClassName = N'NWTC.EventMonthFolder' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 3934) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
418 B
 
Table (1 [160], 777 B)
 
SimpleHandler`2.StartEvent 0.016
 
5
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 4671;
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 (4671)
@PermissionName ("read")
@SiteID (1)
359 B
 
Table (12 [10], 1.2 kB)
 
SimpleHandler`2.StartEvent 0.000
 
6
(cms.acl.generalselect)
DECLARE @ACLID int = 13;

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

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

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

SELECT TOP 1 *
FROM OM_Contact
WHERE [ContactID] IN (
SELECT TOP 1 [VisitorToContactContactID]
FROM OM_VisitorToContact
WHERE [VisitorToContactVisitorGUID] = @VisitorToContactVisitorGUID
)
@VisitorToContactVisitorGUID (00000000-0000-0000-0000-000000000000)
333 B
 
SimpleHandler`2.StartEvent 0.000
 
9
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.016
 
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.016
 
11
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 3805
PageContext.CurrentPage_InitComplete 0.000
 
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 '/Events/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
CMSWebPartZone.CachedWebPart_Init 0.031
 
13
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

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

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

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/Events/%')) AND (Published = 1)) AND (NodeAliasPath like '/Events/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
PageContext.CurrentPage_InitComplete 0.031
 
14
(cms.tree.generalselect)
DECLARE @NodeID int = 3932;

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

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

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

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeID] = @NodeID
) AS SubData
WHERE [CMS_C] = @CMS_C
@NodeID (60)
@DocumentCulture ("en-US")
@CMS_C (1)
617 B
 
Table (1 [167], 4.7 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
18
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:08:11 AM';
DECLARE @NodeLevel int = 3;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] IN (N'/Events/2018/February', N'/Events/2018', N'/Events', N'/'))) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeAliasPath DESC
@NodeSiteID (1)
@Now (1/18/2018 12:08:11 AM)
@NodeLevel (3)
@DocumentCulture ("en-US")
1.5 kB
 
Table (1 [36], 121 B)
 
CMSAbstractMenuProperties.OnLoad 0.031
 
19
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:08:11 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Events/2018/February/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @CMS_DUP int = 1;

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY DocumentNodeID, DocumentCulture ORDER BY CASE WHEN NodeLinkedNodeID IS NULL THEN 1 ELSE 2 END) AS [CMS_DUP], ROW_NUMBER() OVER (ORDER BY EventDate asc, NodeLevel, NodeOrder) AS [CMS_ORN]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_NWTC_Event AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventID] AND V.ClassName = N'NWTC.Event' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (DocumentMenuItemHideInNavigation = 0 and
(DATEDIFF(day,GETDATE(),EventDate)>=0 or (EventEndDate is not null and DATEDIFF(day,EventEndDate,GETDATE())<=0)) and
( 1=1 ) and
( 1=1 ) ) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
) AS SubData
WHERE [CMS_DUP] = @CMS_DUP
ORDER BY CMS_ORN
@NodeSiteID (1)
@Now (1/18/2018 12:08:11 AM)
@NodeAliasPath ("/Events/2018/February/%")
@DocumentCulture ("en-US")
@CMS_DUP (1)
1.3 kB
 
Table (29 [176], 78 kB)
 
BasicRepeater.OnLoad 0.094
 
20
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Events/2018/%';
DECLARE @SiteID int = 1;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and ((1=0 or Class.ClassName = 'CMS.MenuItem' or Class.ClassName = 'NWTC.Event' or Class.ClassName = 'NWTC.News' ) and NodeID not in ( SELECT NodeID FROM View_CONTENT_NWTC_Event_Joined WHERE (EventEndDate is null and CAST(EventDate as DATE) < CAST(GETDATE() as DATE)) or (EventEndDate is not null and CAST(EventEndDate as DATE) < CAST(GETDATE() as DATE)) )) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Events/2019/December/%")
@SiteID (1)
813 B
 
Table (1 [1], 4 B)
 
0.000
 
  71 queries, 65 kB write, 125 kB read   0.641