User Tools

Site Tools


moodle-requete-fusion

This is an old revision of the document!


Cours sans enseignants

SELECT c.id,c.shortname,c.fullname,FROM_UNIXTIME(c.timecreated),FROM_UNIXTIME(c.timemodified) FROM mdl_course AS c 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 = c.id) = 0 ORDER BY c.timemodified ASC;
moodle-requete-fusion.1707831580.txt.gz · Last modified: 2024/02/13 13:39 by 195.221.243.132 · Currently locked by: 216.73.217.114