Videos

Video contents produced by the Concordia project

No videosSELECT * from video WHERE video.id IN (select objectid FROM acl WHERE objecttype='video' AND granttype='default' AND accesslevel>='10') AND (video.state = 'active') AND ( id IN (SELECT targetid FROM objectrelation WHERE targettype='video' AND ownertype='videocategory' AND ownerid IN ('2')) )