CONTENTSTART
EXCLUDESTART EXCLUDEEND

Staff & Faculty Directory

|<  <   1 2 3 4 5 ...   >  >|
1 of 130
EXCLUDESTART
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/0081/m1774442327.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 GETFILES
~/App_Data/CMSModules/SmartSearch/StaffSearch/ Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
7 GETFILES
~/App_Data/CMSModules/SmartSearch/StaffSearch/
14
Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
8 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/StaffSearch/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
9 READ
20 B (1)
 
~/App_Data/CMSModules/SmartSearch/StaffSearch/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
10 CLOSE
~/App_Data/CMSModules/SmartSearch/StaffSearch/segments.gen Local FileStream.CloseInnerStream
11 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/StaffSearch/segments_2hj Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
12 READ
418 B (1)
 
~/App_Data/CMSModules/SmartSearch/StaffSearch/segments_2hj Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
13 CLOSE
~/App_Data/CMSModules/SmartSearch/StaffSearch/segments_2hj Local FileStream.CloseInnerStream
14 GETFILES
~/App_Data/CMSModules/SmartSearch/StaffSearchGreenBay/ Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
15 GETFILES
~/App_Data/CMSModules/SmartSearch/StaffSearchGreenBay/
24
Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
16 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/StaffSearchGreenBay/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
17 READ
20 B (1)
 
~/App_Data/CMSModules/SmartSearch/StaffSearchGreenBay/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
18 CLOSE
~/App_Data/CMSModules/SmartSearch/StaffSearchGreenBay/segments.gen Local FileStream.CloseInnerStream
19 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/StaffSearchGreenBay/segments_2cm Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
20 READ
1.6 kB (1)
 
~/App_Data/CMSModules/SmartSearch/StaffSearchGreenBay/segments_2cm Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
21 CLOSE
~/App_Data/CMSModules/SmartSearch/StaffSearchGreenBay/segments_2cm Local FileStream.CloseInnerStream
22 GETFILES
~/App_Data/CMSModules/SmartSearch/StaffSearchMarinette/ Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
23 GETFILES
~/App_Data/CMSModules/SmartSearch/StaffSearchMarinette/
14
Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
24 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/StaffSearchMarinette/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
25 READ
20 B (1)
 
~/App_Data/CMSModules/SmartSearch/StaffSearchMarinette/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
26 CLOSE
~/App_Data/CMSModules/SmartSearch/StaffSearchMarinette/segments.gen Local FileStream.CloseInnerStream
27 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/StaffSearchMarinette/segments_1v Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
28 READ
587 B (1)
 
~/App_Data/CMSModules/SmartSearch/StaffSearchMarinette/segments_1v Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
29 CLOSE
~/App_Data/CMSModules/SmartSearch/StaffSearchMarinette/segments_1v Local FileStream.CloseInnerStream
30 GETFILES
~/App_Data/CMSModules/SmartSearch/StaffSearchSturgeonBay/ Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
31 GETFILES
~/App_Data/CMSModules/SmartSearch/StaffSearchSturgeonBay/
15
Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
32 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/StaffSearchSturgeonBay/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
33 READ
20 B (1)
 
~/App_Data/CMSModules/SmartSearch/StaffSearchSturgeonBay/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
34 CLOSE
~/App_Data/CMSModules/SmartSearch/StaffSearchSturgeonBay/segments.gen Local FileStream.CloseInnerStream
35 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/StaffSearchSturgeonBay/segments_l Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
36 READ
1.2 kB (1)
 
~/App_Data/CMSModules/SmartSearch/StaffSearchSturgeonBay/segments_l Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
37 CLOSE
~/App_Data/CMSModules/SmartSearch/StaffSearchSturgeonBay/segments_l Local FileStream.CloseInnerStream
38 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local cmsvirtualfiles_transformations__vg_c36540e7_e3c0_43b0_abf5_d9cddf66ec52_nwtc_transformationsqueries_staffsearchresults_ascx.__DataBind__control2
39 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
40 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
41 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local
42 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
43 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
44 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local
45 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
46 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
47 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local
48 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
49 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
50 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local
51 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
52 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
53 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local
54 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
55 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
56 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local
57 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
58 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
59 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local
60 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
61 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
62 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local
63 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
64 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
65 EXISTS
~/App_Themes//Images/CMSModules/CMS_SmartSearch/no_image.gif Local
66 EXISTS
~/App_Themes/Default/Images/CMSModules/CMS_SmartSearch/no_image.gif Local
67 EXISTS
~/App_Themes/Default/Images/[Images.zip]/CMSModules/CMS_SmartSearch/no_image.gif Zip
68 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
69 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 pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/about-nwtc/staff-faculty-directory|en-us||true|true SimpleHandler`2.StartEvent
2 GET currentdocument|nwtc|/about-nwtc/staff-faculty-directory|en-us SimpleHandler`2.StartEvent
3 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
4 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
5 GET pageinfo|nwtc|/about-nwtc|en-us||false PageContext.CurrentPage_InitComplete
6 GET pageinfo|nwtc|/|en-us||false
7 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
8 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
9 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|172
partial
template|24098
10 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
11 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
12 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/staff-faculty-directory|/|googletranslator
CMSWebPartZone.CachedWebPart_Init
13 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
14 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/staff-faculty-directory|/|mobilemenubutton
15 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
16 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/staff-faculty-directory|/|newmobilemenu
17 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/staff-faculty-directory|/|mobilemenu
18 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
19 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|172
partial
template|24098
20 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|172
partial
template|24098
21 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|172
partial
template|24098
22 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
23 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
24 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|172
partial
template|24098
25 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|172
partial
template|24098
26 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
27 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
28 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
29 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
PageContext.CurrentPage_InitComplete
30 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|172
partial
template|24098
31 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
32 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/staff-faculty-directory|/|googletranslator
33 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
34 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/staff-faculty-directory|/|mobilemenubutton
35 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
36 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/staff-faculty-directory|/|newmobilemenu
37 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/staff-faculty-directory|/|mobilemenu
38 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
39 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|172
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
40 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|172
partial
template|24098
41 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|172
partial
template|24098
42 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
PageContext.CurrentPage_InitComplete
43 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
44 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|172
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
45 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|172
partial
template|24098
46 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
PageContext.CurrentPage_InitComplete
47 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
48 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
49 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|172
partial
template|24098
50 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|172
partial
template|24098
51 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|172
partial
template|24098
52 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|172
partial
template|24098
53 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|172
partial
template|24098
54 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24123
CMSWebPartZone.CachedWebPart_Init
55 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24123
56 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|172
partial
template|24123
57 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|172
partial
template|24123
58 ADD Partial cache (FilterButton)
webpartinstance|2a52e2d0-c42a-4743-b50c-3a5483d68d62
partial
template|24123
59 ADD Partial cache (CheckStaffIndexLocations)
webpartinstance|30c1e2dc-57de-4408-9563-dc830d534763
partial
template|24123
60 ADD Partial cache (AlphabetLinks)
webpartinstance|623725fc-409b-4b51-982a-bbbb80d9c760
partial
template|24123
61 ADD Partial cache (NewLeftMenu)
webpartinstance|7d4620cc-1215-4f19-bf9d-27de14f5ba9f
partial
template|24123
62 ADD Partial cache (LeftMenu)
webpartinstance|21216fba-960f-44f9-bcdf-751ea1ef13ea
partial
template|24123
63 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24123
PageContext.CurrentPage_InitComplete
64 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24123
65 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|172
partial
template|24123
66 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|172
partial
template|24123
67 ADD Partial cache (AlphabetLinks)
webpartinstance|623725fc-409b-4b51-982a-bbbb80d9c760
partial
template|24123
68 ADD Partial cache (NewLeftMenu)
webpartinstance|7d4620cc-1215-4f19-bf9d-27de14f5ba9f
partial
template|24123
69 ADD Partial cache (LeftMenu)
webpartinstance|21216fba-960f-44f9-bcdf-751ea1ef13ea
partial
template|24123
70 ADD Partial cache (FilterButton)
webpartinstance|2a52e2d0-c42a-4743-b50c-3a5483d68d62
partial
template|24123
71 ADD Partial cache (CheckStaffIndexLocations)
webpartinstance|30c1e2dc-57de-4408-9563-dc830d534763
partial
template|24123
72 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
73 GET pageinfo|nwtc|/master-items/mega-menus/admissions|en-us||false CMSAbstractWebPart.OnLoad
74 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
75 GET inlinewidgetcontrol|528|1572
76 GET pageinfo|nwtc|/master-items/mega-menus/programs|en-us||false CMSAbstractWebPart.OnLoad
77 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
78 GET inlinewidgetcontrol|528|1572
79 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
80 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
81 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
82 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
83 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
84 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
85 ADD breadcrumbs|nwtc|/about-nwtc/staff-faculty-directory|en-us|false|cms.menuitem||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/about-nwtc/staff-faculty-directory
node|nwtc|/about-nwtc
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
86 GET inlinewidgetcontrol|526|1571 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
87 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
88 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 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
 
2
(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
 
3
(cms.acl.generalselect)
DECLARE @ACLID int = 12;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
@ACLID (12)
78 B
 
Table (1 [5], 52 B)
 
SimpleHandler`2.StartEvent 0.002
 
4
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 1;
DECLARE @Date datetime2 = '1/16/2018 1:01:41 PM';

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)

@UserID (65)
@SiteID (1)
@Date (1/16/2018 1:01:41 PM)
1.3 kB
 
SimpleHandler`2.StartEvent 0.002
 
5 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.002
 
6
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.018
 
7
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.018
 
8
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

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

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

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/About-NWTC/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
Table (259 [19], 69 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.032
 
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' )
) CombinedTables
WHERE ((((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/About-NWTC/%')) AND (Published = 1)) AND (NodeAliasPath like '/About-NWTC/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
Table (259 [19], 69 kB)
 
PageContext.CurrentPage_InitComplete 0.038
 
10
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/16/2018 1:01:43 PM';
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/Staff-Faculty-Directory', 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:01:43 PM)
@NodeLevel (2)
@DocumentCulture ("en-US")
1.5 kB
 
Table (2 [36], 444 B)
 
CMSAbstractMenuProperties.OnLoad 0.007
 
11
(nwtc.transformationsqueries.userdeparmentfilter)
Select Filter, FilterVal, DisplayText from
(
Select '' as Filter, '' as FilterVal, '' as DisplayText, -1 as FilterOrder
UNION ALL
Select Distinct '+Department{0}' as Filter, concat('''', REPLACE(Department, ' ', '\ '),'''') as FilterVal, Department as DisplayText, 0 as FilterOrder from View_CMS_User
where Department is not null and Department <> ''
) as Joined
order by FilterOrder, FilterVal
Table (41 [3], 2.3 kB)
 
CMSWebParts_Custom_SmartSearch_AdvancedSearchFilter.Page_Load 0.032
 
12
(cms.site.generalselect)
SELECT [SiteID], [SiteName], [SiteStatus]
FROM CMS_Site
WHERE [SiteID] IN (
SELECT [IndexSiteID]
FROM CMS_SearchIndexSite
WHERE [IndexId] IN (7, 8, 9, 10)
)
Table (1 [3], 15 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
13
(cms.user.generalselect)
DECLARE @UserID int = 1089;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1089)
84 B
 
Table (1 [28], 340 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
14
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1089;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1089)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (32 [2], 803 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.011
 
15
(cms.user.generalselect)
DECLARE @UserID int = 972;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (972)
83 B
 
Table (1 [28], 158 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
16
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 972;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (972)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (14 [2], 339 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
17
(cms.user.generalselect)
DECLARE @UserID int = 272;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (272)
83 B
 
Table (1 [28], 170 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
18
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 272;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (272)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (10 [2], 212 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
19
(cms.user.generalselect)
DECLARE @UserID int = 1355;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1355)
84 B
 
Table (1 [28], 161 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
20
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1355;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1355)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (13 [2], 364 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
21
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1274;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1274)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (52 [2], 1.2 kB)
 
0.003
 
22
(cms.user.generalselect)
DECLARE @UserID int = 664;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (664)
83 B
 
Table (1 [28], 163 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
23
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 664;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (664)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 293 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
24
(cms.user.generalselect)
DECLARE @UserID int = 1979;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1979)
84 B
 
Table (1 [28], 338 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
25 This same query was called more than once within this request.
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1979;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1979)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (23 [2], 557 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
26 This same query was called more than once within this request.
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1979;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1979)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (23 [2], 557 B)
 
0.002
 
27
(cms.user.generalselect)
DECLARE @UserID int = 78;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (78)
82 B
 
Table (1 [28], 172 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
28
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 78;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (78)
@ValidTo (1/16/2018 1:01:43 PM)
763 B
 
Table (15 [2], 352 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
29
(cms.user.generalselect)
DECLARE @UserID int = 795;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (795)
83 B
 
Table (1 [28], 172 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
30
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 795;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (795)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (12 [2], 285 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
31
(cms.user.generalselect)
DECLARE @UserID int = 1054;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1054)
84 B
 
Table (1 [28], 166 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
32
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1054;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1054)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (12 [2], 259 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
33
(cms.user.generalselect)
DECLARE @UserID int = 1186;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1186)
84 B
 
Table (1 [28], 335 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
34
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1186;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1186)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (25 [2], 650 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.007
 
35
(cms.user.generalselect)
DECLARE @UserID int = 1124;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1124)
84 B
 
Table (1 [28], 178 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
36
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1124;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1124)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (11 [2], 238 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.006
 
37
(cms.user.generalselect)
DECLARE @UserID int = 6158;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (6158)
84 B
 
Table (1 [28], 326 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.003
 
38
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 6158;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (6158)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (24 [2], 595 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.004
 
39
(cms.user.generalselect)
DECLARE @UserID int = 428;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (428)
83 B
 
Table (1 [28], 172 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.003
 
40
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 428;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (428)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (10 [2], 218 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
41
(cms.user.generalselect)
DECLARE @UserID int = 670;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (670)
83 B
 
Table (1 [28], 157 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.003
 
42
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 670;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (670)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (9 [2], 204 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
43
(cms.user.generalselect)
DECLARE @UserID int = 323;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (323)
83 B
 
Table (1 [28], 175 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
44
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 323;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (323)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 297 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
45
(cms.user.generalselect)
DECLARE @UserID int = 206;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (206)
83 B
 
Table (1 [28], 200 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
46
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 206;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (206)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (12 [2], 260 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
47
(cms.user.generalselect)
DECLARE @UserID int = 2004;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (2004)
84 B
 
Table (1 [28], 164 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
48
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 2004;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (2004)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (11 [2], 234 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
49
(cms.user.generalselect)
DECLARE @UserID int = 1971;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1971)
84 B
 
Table (1 [28], 169 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
50
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1971;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1971)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (14 [2], 339 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
51
(cms.user.generalselect)
DECLARE @UserID int = 1064;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1064)
84 B
 
Table (1 [28], 172 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
52
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1064;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1064)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (12 [2], 297 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
53
(cms.user.generalselect)
DECLARE @UserID int = 500;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (500)
83 B
 
Table (1 [28], 285 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
54
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 500;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (500)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (53 [2], 1.4 kB)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
55
(cms.user.generalselect)
DECLARE @UserID int = 1869;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1869)
84 B
 
Table (1 [28], 169 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
56
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1869;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1869)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (8 [2], 180 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
57
(cms.user.generalselect)
DECLARE @UserID int = 1595;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1595)
84 B
 
Table (1 [28], 166 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
58
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1595;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1595)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (11 [2], 257 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
59
(cms.user.generalselect)
DECLARE @UserID int = 1488;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1488)
84 B
 
Table (1 [28], 166 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
60
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1488;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1488)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (11 [2], 269 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
61
(cms.user.generalselect)
DECLARE @UserID int = 2419;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (2419)
84 B
 
Table (1 [28], 158 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
62
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 2419;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (2419)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (10 [2], 215 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
63
(cms.user.generalselect)
DECLARE @UserID int = 6636;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (6636)
84 B
 
Table (1 [28], 466 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
64
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 6636;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (6636)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (36 [2], 819 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
65
(cms.user.generalselect)
DECLARE @UserID int = 2183;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (2183)
84 B
 
Table (1 [28], 170 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
66
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 2183;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (2183)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (12 [2], 260 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
67
(cms.user.generalselect)
DECLARE @UserID int = 912;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (912)
83 B
 
Table (1 [28], 169 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.003
 
68
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 912;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (912)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (10 [2], 213 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
69
(cms.user.generalselect)
DECLARE @UserID int = 4037;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (4037)
84 B
 
Table (1 [28], 179 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
70
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 4037;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (4037)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (12 [2], 292 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
71
(cms.user.generalselect)
DECLARE @UserID int = 897;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (897)
83 B
 
Table (1 [28], 169 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
72
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 897;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (897)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (14 [2], 339 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
73
(cms.user.generalselect)
DECLARE @UserID int = 960;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (960)
83 B
 
Table (1 [28], 175 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
74
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 960;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (960)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (11 [2], 241 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
75
(cms.user.generalselect)
DECLARE @UserID int = 957;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (957)
83 B
 
Table (1 [28], 164 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.001
 
76
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 957;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (957)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 293 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
77
(cms.user.generalselect)
DECLARE @UserID int = 1568;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1568)
84 B
 
Table (1 [28], 145 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
78
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1568;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1568)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (11 [2], 244 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
79
(cms.user.generalselect)
DECLARE @UserID int = 2342;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (2342)
84 B
 
Table (1 [28], 330 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.003
 
80
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 2342;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (2342)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (43 [2], 1 kB)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
81
(cms.user.generalselect)
DECLARE @UserID int = 983;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (983)
83 B
 
Table (1 [28], 181 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
82
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 983;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (983)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (8 [2], 162 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
83
(cms.user.generalselect)
DECLARE @UserID int = 752;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (752)
83 B
 
Table (1 [28], 172 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
84
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 752;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (752)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (10 [2], 222 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
85
(cms.user.generalselect)
DECLARE @UserID int = 411;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (411)
83 B
 
Table (1 [28], 169 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
86
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 411;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (411)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 293 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
87
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 83;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (83)
@ValidTo (1/16/2018 1:01:43 PM)
763 B
 
Table (14 [2], 333 B)
 
0.002
 
88
(cms.user.generalselect)
DECLARE @UserID int = 768;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (768)
83 B
 
Table (1 [28], 322 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
89
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 768;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (768)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (68 [2], 1.6 kB)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.003
 
90
(cms.user.generalselect)
DECLARE @UserID int = 933;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (933)
83 B
 
Table (1 [28], 169 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
91
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 933;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (933)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (12 [2], 284 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
92
(cms.user.generalselect)
DECLARE @UserID int = 189;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (189)
83 B
 
Table (1 [28], 172 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
93
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 189;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (189)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (11 [2], 254 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
94
(cms.user.generalselect)
DECLARE @UserID int = 792;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (792)
83 B
 
Table (1 [28], 172 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
95
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 792;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (792)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (14 [2], 312 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
96
(cms.user.generalselect)
DECLARE @UserID int = 446;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (446)
83 B
 
Table (1 [28], 160 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
97
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 446;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (446)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 293 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
98
(cms.user.generalselect)
DECLARE @UserID int = 1022;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1022)
84 B
 
Table (1 [28], 179 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
99
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1022;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1022)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (14 [2], 318 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
100
(cms.user.generalselect)
DECLARE @UserID int = 1868;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1868)
84 B
 
Table (1 [28], 166 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
101
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1868;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1868)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (13 [2], 297 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.013
 
102
(cms.user.generalselect)
DECLARE @UserID int = 435;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (435)
83 B
 
Table (1 [28], 166 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
103
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 435;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (435)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 313 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
104
(cms.user.generalselect)
DECLARE @UserID int = 117;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (117)
83 B
 
Table (1 [28], 166 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.009
 
105
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 117;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (117)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (14 [2], 342 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.003
 
106
(cms.user.generalselect)
DECLARE @UserID int = 1750;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1750)
84 B
 
Table (1 [28], 178 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
107
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1750;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1750)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (10 [2], 218 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
108
(cms.user.generalselect)
DECLARE @UserID int = 632;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (632)
83 B
 
Table (1 [28], 166 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
109
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 632;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (632)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 293 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
110
(cms.user.generalselect)
DECLARE @UserID int = 403;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (403)
83 B
 
Table (1 [28], 166 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
111
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 403;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (403)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 293 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
112
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 2296;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (2296)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (14 [2], 333 B)
 
0.002
 
113
(cms.user.generalselect)
DECLARE @UserID int = 140;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (140)
83 B
 
Table (1 [28], 178 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
114
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 140;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (140)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (14 [2], 339 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.004
 
115
(cms.user.generalselect)
DECLARE @UserID int = 2522;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (2522)
84 B
 
Table (1 [28], 161 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.003
 
116
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 2522;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (2522)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (14 [2], 339 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
117
(cms.user.generalselect)
DECLARE @UserID int = 407;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (407)
83 B
 
Table (1 [28], 169 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
118
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 407;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (407)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 293 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
119
(cms.user.generalselect)
DECLARE @UserID int = 806;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (806)
83 B
 
Table (1 [28], 184 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
120
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 806;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (806)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (12 [2], 318 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
121
(cms.user.generalselect)
DECLARE @UserID int = 2344;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (2344)
84 B
 
Table (1 [28], 179 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
122
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 2344;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (2344)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (13 [2], 313 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
123
(cms.user.generalselect)
DECLARE @UserID int = 1458;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1458)
84 B
 
Table (1 [28], 172 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
124
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1458;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1458)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (12 [2], 260 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
125
(cms.user.generalselect)
DECLARE @UserID int = 1871;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1871)
84 B
 
Table (1 [28], 175 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
126
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1871;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1871)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (11 [2], 247 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
127
(cms.user.generalselect)
DECLARE @UserID int = 1038;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (1038)
84 B
 
Table (1 [28], 169 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.003
 
128
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 1038;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (1038)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (15 [2], 350 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
129
(cms.user.generalselect)
DECLARE @UserID int = 2207;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (2207)
84 B
 
Table (1 [28], 176 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
130
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 2207;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (2207)
@ValidTo (1/16/2018 1:01:43 PM)
765 B
 
Table (14 [2], 339 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
131
(cms.user.generalselect)
DECLARE @UserID int = 424;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (424)
83 B
 
Table (1 [28], 172 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
132
(cms.user.selectmembershipuserroles)
DECLARE @UserID int = 424;
DECLARE @ValidTo datetime2 = '1/16/2018 1:01:43 PM';

SELECT [RoleName], [SiteID] FROM
(
SELECT CMS_Role.*, CMS_UserRole.ValidTo FROM CMS_Role
INNER JOIN CMS_UserRole ON CMS_UserRole.RoleID = CMS_Role.RoleID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, CMS_MembershipUser.ValidTo FROM CMS_Role
INNER JOIN CMS_MembershipRole ON CMS_MembershipRole.RoleID = CMS_Role.RoleID
INNER JOIN CMS_MembershipUser ON CMS_MembershipUser.MembershipID = CMS_MembershipRole.MembershipID WHERE UserID = @UserID
UNION ALL
SELECT CMS_Role.*, NULL FROM CMS_Role WHERE RoleName IN ('_everyone_','_authenticated_')
)
AS X WHERE ((SiteID IS NULL OR SiteID = 1)) AND ((ValidTo IS NULL OR ValidTo > @ValidTo))
@UserID (424)
@ValidTo (1/16/2018 1:01:43 PM)
764 B
 
Table (13 [2], 293 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.002
 
133
(cms.user.selectallview)
SELECT * FROM View_CMS_User WHERE UserID IN (1089,972,272,1355,1274,664,78,795,1054,1186)
Table (10 [90], 8 kB)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.004
 
134
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 878)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_c36540e7_e3c0_43b0_abf5_d9cddf66ec52_nwtc_transformationsqueries_staffsearchresults_ascx.__DataBind__control2 0.002
 
135
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 765)
Table (1 [16], 131 B)
 
0.002
 
136
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 175)
Table (1 [16], 131 B)
 
0.002
 
137
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 1073)
Table (1 [16], 131 B)
 
0.002
 
138
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 1006)
Table (1 [16], 131 B)
 
0.002
 
139
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 486)
Table (1 [16], 131 B)
 
0.002
 
140
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 29)
Table (1 [16], 131 B)
 
0.002
 
141
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 596)
Table (1 [16], 131 B)
 
0.002
 
142
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 845)
Table (1 [16], 131 B)
 
0.002
 
143
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 942)
Table (1 [16], 131 B)
 
0.002
 
  143 queries, 72 kB write, 210 kB read   0.463