What are the UWI Games?

This is the major sporting event for the three (3) UWI campuses, which provides one of the few opportunities where students can get together as one university sharing in collective although competitive activity. Each campus is represented by over one hundred athletes clad in their respective campus colours (Mona-Red, Cave Hill-Yellow and St. Augustine-Blue) to compete. The Games are rotated biennially on each campus and feature sports including Basketball, Cricket, Football, Hockey, Netball, Swimming, Table Tennis, Tennis, Track & Field and Volleyball.
 

 

 
Brief History

In the mid 1960’s, the Student Intercampus Games began as a student-run event and were an annual fixture from 1968 until 1975 when the Games encountered financial difficulties. However, according to Jai Jebodhsingh, one of the individuals responsible for the continuation of the Games, it was less a question of “if” the Games would continue than “how”.
 
The University’s administration agreed to take responsibility for the Games and in 1979 a new structure was established – a biennial schedule, 65-member contingents and six core sporting disciplines plus two others (Football, Cricket, Hockey, Basketball, Volleyball, Netball, Track & Field and Table Tennis). Jai Jebodhsingh, Winford Green and Victor Cowan were the driving forces behind it all, until each retired from Cave Hill, Mona and St. Augustine respectively, in the early years of the new millennium. Interestingly, only Green carried the title “Director of Sports”. His counterparts headed Student Services at their respective campuses and became deeply involved in the Games because of their love of sports and their connection with the students.

The Games have grown over the years, and continue to grow. Contingents now comprise a total of 150 persons (135 athletes and 15 officials) and the UWI Open Campus is now included as a fourth participant, albeit on a limited basis.
 
Last Games

The most recent Games were held at the here at Cave Hill in 2017. There, the Cave Hill Blackbirds narrowly missed out on the title, placing second to Mona by two (2) points. 
 
The contingent secured the top spot in the following disciplines:
  • Hockey (Male & Female)
  • Netball
  • Basketball (Female)
  • Volleyball (Female)
  • Lawn Tennis
Next Games

The next UWI Games will be held at Mona in 2019!

Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute ApplicationModule.BeginRequest
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute ApplicationModule.AuthenticateRequest
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute ApplicationModule.AuthorizeRequest
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute ApplicationModule.PostAuthorizeRequest
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute ApplicationModule.PostResolveRequestCache
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData ApplicationModule.PostResolveRequestCache
7 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostResolveRequestCache
8 >> TypeInfo(cms.pagetemplate).Events.GetData ApplicationModule.PostResolveRequestCache
9 >> URLRewritingEvents.ProcessABTest.Execute ApplicationModule.PostResolveRequestCache
>>> ABHandlers.ProcessABTest
10 >> URLRewritingEvents.ProcessRewritingResult ApplicationModule.PostResolveRequestCache
11 RequestEvents.PostMapRequestHandler.Execute ApplicationModule.PostMapRequestHandler
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
12 ApplicationEvents.SessionStart.Execute CMSHttpApplication.Session_Start
> MembershipHandlers.SessionStart
13 >> SessionEvents.UpdateSession CMSHttpApplication.Session_Start
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
14 RequestEvents.AcquireRequestState.Execute ApplicationModule.AcquireRequestState
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
15 RequestEvents.PostAcquireRequestState.Execute ApplicationModule.PostAcquireRequestState
> MembershipHandlers.UpdateSession
16 >> SessionEvents.UpdateSession ApplicationModule.PostAcquireRequestState
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
17 >> DocumentEvents.GetData ApplicationModule.PostAcquireRequestState
18 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostAcquireRequestState
19 >>>> TypeInfo(cms.versionhistory).Events.GetData ApplicationModule.PostAcquireRequestState
20 >> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
21 >>> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
22 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
23 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
24 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
25 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
26 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
27 TypeInfo(cms.acl).Events.GetData CMSAbstractMenuProperties.OnLoad
28 DocumentEvents.GetData BasicDataList.OnLoad
29 TypeInfo(cms.document).Events.GetData BasicDataList.OnLoad
30 DocumentEvents.GetData CMSListMenu.OnLoad
31 TypeInfo(cms.document).Events.GetData CMSListMenu.OnLoad
   
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/SportTest/outputdata/0081/264829901.cache Local ApplicationModule.AuthorizeRequest
2 DIREXISTS
~/App_Themes/CaveHillSportNew Local ContentPage.OnPreInit
3 EXISTS
~/CMSControls/Sports/960_cave_footer.ascx Local DbPathProvider.GetFileHash
4 EXISTS
~/CMSControls/Sports/960_cave_header_new.ascx Local
5 EXISTS
~/CMSControls/Sports/960_cave_header_new.ascx.cs Local
6 EXISTS
~/CMSControls/Sports/cave_footer.ascx.cs Local
7 EXISTS
~/CMSWebParts/navigation/cmsbreadcrumbs.ascx Local
8 EXISTS
~/CMSWebParts/Navigation/cmsbreadcrumbs.ascx.cs Local
9 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
10 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
11 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
12 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Security checks called by this request / thread:
 UserOperationResultResource / Class / IDPermission / UI element / ValueSite / DomainContext
1 public FilterDataSetByPermissions DataSet: DataSet: Table (1 [37], 210 B) read SportTest CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False
CheckPrivilegeLevel False GlobalAdmin CMSAbstractMenuProperties.OnLoad
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|sporttest|/inter-campus-games|en-us|/inter-campus-games|true
template|414
nodeid|10122
pageinfo
ApplicationModule.PostResolveRequestCache
2 ADD pageinfobyurl|sporttest|https://www.cavehill.uwi.edu/sport/inter-campus-games.aspx|en-us||true|true
template|414
nodeid|10122
pageinfo
ApplicationModule.PostResolveRequestCache
3 GET cms.searchengine|cachedids|crawlers ApplicationModule.PostAcquireRequestState
4 GET pageinfo|sporttest|/|en-us||false PageContext.CurrentPage_InitComplete
5 GET siteresourcerolespermissions|75|cms.content CMSAbstractMenuProperties.OnLoad
6 ADD breadcrumbs|sporttest|/inter-campus-games|en-us|false|cms.menuitem;cms.office||true|
node|sporttest|/inter-campus-games|childnodes
CMSAbstractMenuProperties.OnLoad
7 GET cmsmenudatasource||en-us|sporttest|/%|en-us|false|cms.menuitem|||-1|true||false|false CMSListMenu.OnLoad
8 ADD cmsdatasource||en-us|sporttest|/inter-campus-games|en-us|false||||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|1||false||
webpartinstance|55b5c237-1114-41f5-b5c9-ffc83cc5b05c
node|sporttest|/inter-campus-games
BasicDataList.OnLoad
9 ADD cmsmenudatasource||en-us|sporttest|/inter-campus-games/%|en-us|false||||-1|true||false|false
webpartinstance|3cee7156-637b-4746-b047-a15633df4605
node|sporttest|/inter-campus-games|childnodes
CMSListMenu.OnLoad
10 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /inter-campus-games.aspx 0.000
0.203
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.203
0.172
 
3 > OnPreInit 0.375
0.016
 
4 > OnInit 0.391
0.125
 
5 > OnLoad 0.516
0.234
 
6 > OnPreRender 0.750
N/A
    0.750  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookieWvyNm10zcAKdCZmcJSs/P8iokr1i5bTljPDi5M6Y
3 ASP.NET_SessionId1p0ks1evkothtjihsdqy522f
4 Campaign 
5 Source 
6 CMSCurrentThemeCaveHillSportNew
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US4/23/2020 6:47:00 PM
2 CMSCsrfCookieWvyNm10zcAKdCZmcJSs/P8iokr1i5bTljPDi5M6Y 
3 ASP.NET_SessionId1p0ks1evkothtjihsdqy522f 
4 Campaign 4/23/2018 6:47:00 PM
5 Source 4/23/2018 6:47:00 PM
6 CMSCurrentThemeCaveHillSportNew4/24/2019 6:47:00 PM
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.91.121.255
5 UserLanguagesen-US;en;q=0.5
6 UserName 
7 SessionID1p0ks1evkothtjihsdqy522f
8 ServerNameARES2_sport
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 75;
DECLARE @DocumentUrlPath nvarchar(max) = N'/inter-campus-games';
DECLARE @NodeAliasPath nvarchar(max) = N'/inter-campus-games';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @Now datetime2 = '4/23/2019 6:47:00 PM';

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

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath = N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (1 [157], 925 B)
 
ApplicationModule.PostResolveRequestCache 0.031
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
3
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 414;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 11.8 kB)
 
ApplicationModule.PostResolveRequestCache 0.063
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
4
(cms.document.generalselect)
DECLARE @NodeSiteID int = 75;
DECLARE @NodeGUID uniqueidentifier = 'e9626c28-1bdc-4ce2-bb22-92021ef30dc7';
DECLARE @Now datetime2 = '4/23/2019 6:47:00 PM';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [NodeGUID] = @NodeGUID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
523 B
 
Table (1 [157], 5.4 kB)
 
ApplicationModule.PostAcquireRequestState 0.031
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 29230
Table (1 [23], 8.3 kB)
 
ApplicationModule.PostAcquireRequestState 0.078
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
6
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/Inter-Campus-Games';
DECLARE @ABVariantSiteID int = 75;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
ApplicationModule.PostAcquireRequestState 0.016
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
7
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 10197
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
8
(cms.document.generalselect)
DECLARE @NodeSiteID int = 75;
DECLARE @Now datetime2 = '4/23/2019 6:47:00 PM';
DECLARE @NodeLevel int = 1;
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], [DocumentID]
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'/Inter-Campus-Games', N'/'))) AND ([ClassName] IN (N'CMS.MenuItem', N'cms.office')) 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
1.5 kB
 
Table (1 [37], 210 B)
 
CMSAbstractMenuProperties.OnLoad 0.031
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
9
(cms.acl.generalselect)
DECLARE @ACLID int = 105;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
Table (1 [5], 52 B)
 
CMSAbstractMenuProperties.OnLoad 0.016
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
10
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 75;
DECLARE @Date datetime2 = '4/23/2019 6:47:00 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 (105)

1.3 kB
 
CMSAbstractMenuProperties.OnLoad 0.016
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
11
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 2214;
DECLARE @PermissionName nvarchar(max) = N'read';
DECLARE @SiteID int = 75;

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)
CMSAbstractMenuProperties.OnLoad 0.031
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
BasicDataList.OnLoad N/A
12
(cms.document.generalselect)
DECLARE @NodeSiteID int = 75;
DECLARE @Now datetime2 = '4/23/2019 6:47:00 PM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Inter-Campus-Games';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 1 *
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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
620 B
 
Table (1 [157], 5.4 kB)
 
BasicDataList.OnLoad 0.047
 
CloseConnection()
BasicDataList.OnLoad N/A
OpenConnection()
CMSListMenu.OnLoad N/A
13
(cms.document.generalselect)
DECLARE @NodeSiteID int = 75;
DECLARE @Now datetime2 = '4/23/2019 6:47:00 PM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Inter-Campus-Games/%';
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 (DocumentMenuItemHideInNavigation = 0)) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder, DocumentName
1.5 kB
 
Table (1 [36], 217 B)
 
CMSListMenu.OnLoad 0.047
 
CloseConnection()
CMSListMenu.OnLoad N/A
  13 queries, 10.3 kB write, 37 kB read   0.516
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% prefix %} Sport Cave Hill | The University of the West Indies at Cave Hill, Barbados ContentPage.OnLoad 0.000
 
> prefix Sport Cave Hill | The University of the West Indies at Cave Hill, Barbados 0.000
 
2 {% pagetitle_orelse_name %} UWI Games 0.016
 
> pagetitle_orelse_name UWI Games 0.000
 
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/sport/inter-campus-games.aspx" (30 B)
30 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 lt
cave_header1
DropDownList1
No
No
AutoPostBack = True
Width = 119px
0 B
 
4 lt
cave_header1
ImageButton1
No
ImageUrl = "http://www.cavehill.uwi.edu/CMSSiteFiles/images/go_button.png" (61 B)
61 B
 
5 lt
partPlaceholder
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
6 RightContent
cmsdatalist
lstElem
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
NestedControlsID = "" (0 B)
DataBindByDefault = True
TransformationName = "CMS.MenuItem.SportsNavLinksSectionTitle" (39 B)
RepeatLayout = Flow
ShowEditButton = False
_!ItemCount = 1
HideControlForZeroRows = True
RepeatColumns = 1
ShowDeleteButton = False
RepeatDirection = Vertical
DataSourceName = "" (0 B)
ZeroRowsText = "No data found" (13 B)
AlternatingTransformationName = "" (0 B)
DataKeys = System.Collections.ArrayList
EnablePaging = False
52 B
 
7 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes