DokuWiki

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;

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
 INTO OUTFILE '/tmp/cours-sans-enseignant-order-datemodif.csv' 
FIELDS ENCLOSED BY '' 
TERMINATED BY '|' 
ESCAPED BY '"' 
LINES TERMINATED BY '\r\n';