Collaborations > Connect outside U.S. Collaborations  

Connect Outside U.S. Collaborations

Robotics and Coding Club
We are developing a robotics and applied coding program starting in the lower junior school and leading through to Year 9. The emphasis is on the practical applications of coding and robotics where students use coding to create. This can be applied to design, ...
Status:  Seeking Partners
Audience:  Education: Grade(s): 3, 4, 5, 6, 7, 8, 9

International High School Exchange Program
African School Culture is non-profit Organization helping to bring education under one umbrella by allowing students and teachers share curriculum programs. We have some High Schools around African Continent seeking for Exchange progr...
Status:  Seeking Partners
Audience:  Education: Grade(s): 8, 9, 10, 11, 12, K-12 Educator, Adult Learners

FOLLOW US
ADDRESS
Center for Interactive Learning and Collaboration
2075 Lookout Drive
North Mankato, MN 56003
SUPPORT MENU
© 2016 Center for Interactive Learning and Collaboration Privacy Policy
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(SELECT * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (DocumentUrlPath = N'/Collaborations/Outside-U-S-Collaborations') AND (DocumentUrlPath <> NodeAliasPath)))
UNION ALL
(SELECT TOP 2 * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (NodeAliasPath = N'/Collaborations/Outside-U-S-Collaborations') AND ([DocumentCulture] = N'en-US')))
SimpleHandler`2.StartEvent 0.047
 
2
(cms.tree.selectblankpageinfo)
SELECT * FROM View_PageInfo_Blank WHERE ((NodeSiteID = 1)) AND (NodeAliasPath = N'/Collaborations/Outside-U-S-Collaborations')
SimpleHandler`2.StartEvent 0.000
 
3
(cms.tree.selectbywildcardrule)
SELECT NodeAliasPath, DocumentCulture, DocumentURLPath, DocumentExtensions, DocumentCampaign FROM View_CMS_Tree_Joined WHERE @WildcardRule LIKE [DocumentWildcardRule] AND ((NodeSiteID = 1)) ORDER BY DocumentPriority DESC
@WildcardRule ("/Collaborations/Outside-U-S-Collaborations")
262 B
 
SimpleHandler`2.StartEvent 0.015
 
4
(cms.documentalias.selectbywildcardrule)
SELECT * FROM CMS_DocumentAlias INNER JOIN CMS_Tree ON CMS_DocumentAlias.AliasNodeID = CMS_Tree.NodeID WHERE (@UrlPath=AliasURLPath OR @WildcardRule LIKE CMS_DocumentAlias.AliasWildcardRule) AND CMS_Tree.NodeSiteID = @SiteID ORDER BY AliasPriority
@WildcardRule ("/Collaborations/Outside-U-S-Collaborations")
@SiteID (1)
@UrlPath ("/Collaborations/Outside-U-S-Collaborations")
335 B
 
Table (1 [45], 372 B)
 
SimpleHandler`2.StartEvent 0.000
 
5
(cms.tree.selectpageinfo)
SELECT * FROM View_PageInfo WHERE (NodeSiteID = 1) AND (NodeAliasPath = N'/Collaborations/Connect-outside-U-S-Collaborations') AND ([DocumentCulture] = N'en-US')
Table (1 [67], 1.5 kB)
 
SimpleHandler`2.StartEvent 0.016
 
6
(cms.pagetemplate.generalselect)
SELECT * FROM CMS_PageTemplate WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (24534)
75 B
 
Table (1 [34], 10.1 kB)
 
SimpleHandler`2.StartEvent 0.000
 
7
(cms.document.selectdocuments)
SELECT * FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Collaborations', N'/')) AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
193 B
 
Table (2 [172], 10.3 kB)
 
SimpleHandler`2.StartEvent 0.000
 
8
(cms.menuitem.selectdocuments)
SELECT * FROM View_CONTENT_MenuItem_Joined WHERE ([DocumentCulture] = N'en-US') AND (NodeID = 820)
Table (1 [176], 2 kB)
 
SimpleHandler`2.StartEvent 0.016
 
9
(cms.class.selectrequiredroles)
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 (4609)
@PermissionName ("read")
@SiteID (1)
251 B
 
Table (1 [10], 112 B)
 
SimpleHandler`2.StartEvent 0.000
 
10
(cms.user.isauthorizedpernode)
Proc_CMS_User_IsAuthorizedPerNode
@UserID (65)
@NodeID (820)
@PermissionName ("read")
@GenericRoles ("'_everyone_', '_notauthenticated_'")
@SiteID (1)
@Date (7/19/2018 12:15:05 PM)
91 B
 
SimpleHandler`2.StartEvent 0.016
 
11
(cms.acl.generalselect)
SELECT * FROM CMS_ACL WHERE [ACLID] = @ACLID
@ACLID (1)
48 B
 
Table (1 [6], 56 B)
 
SimpleHandler`2.StartEvent 0.000
 
12
(cms.aclitem.selectaclitemsbyaclidanduserid)
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 (1)

@UserID (65)
@SiteID (1)
@Date (7/19/2018 12:15:05 PM)
1.2 kB
 
Table (1 [4], 16 B)
 
SimpleHandler`2.StartEvent 0.000
 
13
(cms.tree.selectpageinfo)
SELECT * FROM View_PageInfo WHERE (NodeID = 817) AND ([DocumentCulture] = N'en-US')
Table (1 [67], 5 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
14
(cms.personalization.selectall)
SELECT TOP 1 * FROM CMS_Personalization WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 820
PageContext.CurrentPage_InitComplete 0.000
 
15
(cms.document.selectdocuments)
SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentMenuClassOver], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemImageOver], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemLeftImageOver], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuItemRightImageOver], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentMenuStyleOver], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [SiteName], [NodeACLID], [NodeSiteID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings] FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Collaborations/Connect-outside-U-S-Collaborations', N'/Collaborations', N'/')) AND ([Published] = @Published AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeAliasPath DESC
@NodeSiteID (1)
@Published (True)
@NodeLevel (2)
@DocumentCulture ("en-US")
1.3 kB
 
Table (3 [42], 642 B)
 
CMSAbstractMenuProperties.OnLoad 0.000
 
16
SELECT TOP 1 * FROM CMS_Query WHERE (QueryName = N'CollaborationsNonUS' AND ClassID = 4609)
Table (1 [12], 1.2 kB)
 
BasicRepeater.OnLoad 0.016
 
17
(cms.menuitem.collaborationsnonus)
SELECT
CollaborationID, Name, case when len(cast(Objective as VARCHAR(MAX))) >= 260 then left(cast(Objective as VARCHAR(MAX)),260) + '...' else Objective END as Objective,
StatusName,

CASE WHEN KenticoCILC.dbo.fnCreate_Audience_Export(TargetAudience, 'Education') IS NOT NULL THEN '<i>Education:</i> Grade(s): ' + KenticoCILC.dbo.fnCreate_Audience_Export(TargetAudience, 'Education') ELSE '' END +
CASE WHEN KenticoCILC.dbo.fnCreate_Audience_Export(TargetAudience, 'Business/Community') IS NOT NULL THEN ' <i>Business/Community:</i> ' + KenticoCILC.dbo.fnCreate_Audience_Export(TargetAudience, 'Business/Community') ELSE '' END +
CASE WHEN TargetAudienceEducationOther IS NOT NULL THEN ' <i>Other:</i> ' + TargetAudienceEducationOther ELSE '' END
as Audience

FROM
dbo.tblCollaborations c WITH (NOLOCK)
LEFT JOIN
KenticoCILC.dbo.tblCollaborations_Status cs WITH (NOLOCK)
on c.Status = cs.CollablorationsStatusID
WHERE
Deleted = 0 AND
CollaborationID <> HoldingID
AND (EndDate > GetDate() or (StartDate < '2015-12-01' and EndDate is null)) and status != 3
and Country <> 'United States'
ORDER BY
EndDate, StartDate, Name desc
1.1 kB
 
Table (2 [5], 758 B)
 
BasicRepeater.OnLoad 0.031
 
18
(cms.transformation.generalselect)
SELECT TOP 1 * FROM CMS_Transformation WHERE ([TransformationClassID] = 4609 AND [TransformationName] = N'ViewAllCollaboration_en-US')
BasicRepeater.OnLoad 0.000
 
  18 queries, 5.9 kB write, 32 kB read   0.156