User Tools

Site Tools


moodle-requete-fusion

This is an old revision of the document!


Cours sans enseignants

SELECT mdl_course.id FROM mdl_course WHERE (SELECT COUNT(mdl_role_assignments.id) 
FROM mdl_role_assignments INNER JOIN mdl_context ON mdl_role_assignments.contextid = mdl_context.id WHERE mdl_role_assignments.roleid = 3 AND mdl_context.contextlevel = 50 AND mdl_context.instanceid = mdl_course.id) = 0 AND mdl_course.id != 1
moodle-requete-fusion.1707831220.txt.gz · Last modified: 2024/02/13 13:33 by 195.221.243.132 · Currently locked by: 216.73.217.114