Search Content Provider Programs

Check out our FREE and discounted programming: View Now
 

Tips for Searching:

  • In the Keyword box, be as specific as possible on the topic you are looking for and the audience. 
  • Separate keywords with a space.  Example: human body 7th grade or Impressionist Art adult learners
Content Provider:
Program Cost:
Search Premium Service discounted programs
 
Legend
rated exceptional by educators recommended by CILC members
Content Provider Pinnacle Award number of tickets indicates ticket value for the Carnival Package
Life Long Learner Seal of Alignment Life Long Learner Seal of Alignment Pending

 

Discover our Professional Learning Network!

Find the perfect collaborative project for your learners  
 
 
 
 
Connected North • Canada
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'/Interactive-Content/Search-Content-Provider-Programs') AND (DocumentUrlPath <> NodeAliasPath)))
UNION ALL
(SELECT TOP 2 * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (NodeAliasPath = N'/Interactive-Content/Search-Content-Provider-Programs') AND ([DocumentCulture] = N'en-US')))
Table (1 [67], 5.3 kB)
 
SimpleHandler`2.StartEvent 0.047
 
2
(cms.document.selectdocuments)
SELECT * FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Interactive-Content', N'/')) AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
198 B
 
Table (2 [172], 11.4 kB)
 
SimpleHandler`2.StartEvent 0.000
 
3
(cms.menuitem.selectdocuments)
SELECT * FROM View_CONTENT_MenuItem_Joined WHERE ([DocumentCulture] = N'en-US') AND (NodeID = 891)
Table (1 [176], 6.1 kB)
 
SimpleHandler`2.StartEvent 0.000
 
4
(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
 
5
(cms.user.isauthorizedpernode)
Proc_CMS_User_IsAuthorizedPerNode
@UserID (65)
@NodeID (891)
@PermissionName ("read")
@GenericRoles ("'_everyone_', '_notauthenticated_'")
@SiteID (1)
@Date (7/19/2018 12:33:16 PM)
91 B
 
SimpleHandler`2.StartEvent 0.000
 
6
(cms.acl.generalselect)
SELECT * FROM CMS_ACL WHERE [ACLID] = @ACLID
@ACLID (1)
48 B
 
Table (1 [6], 56 B)
 
SimpleHandler`2.StartEvent 0.000
 
7
(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:33:16 PM)
1.2 kB
 
Table (1 [4], 16 B)
 
SimpleHandler`2.StartEvent 0.000
 
8
(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'/Interactive-Content/Search-Content-Provider-Programs', N'/Interactive-Content', 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], 572 B)
 
CMSAbstractMenuProperties.OnLoad 0.000
 
9
(customtable.sampletable.contentproviderddl)
select '','',' -- All --' as ProviderName
UNION
Select '+_cpid' as CPID1, CPID,ProviderName from tblContentProviders
WHERE Deleted = 0 AND CPType = 1 ORDER BY ProviderName
Table (163 [3], 6.2 kB)
 
CMSWebParts_SmartSearch_SearchFilter.Page_Load 0.000
 
10
(media.file.generalselect)
SELECT * FROM Media_File WHERE ((FileLibraryID = 26) AND (FileLibraryID IN (SELECT LibraryID FROM Media_Library WHERE ((LibraryAccess < 1000000)) AND (LibraryGroupID IS NULL))))
Table (2 [18], 498 B)
 
CMSRepeaterWithEffect.OnLoad 0.000
 
  10 queries, 3.8 kB write, 30 kB read   0.047