DokuWiki

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';

Cours sans participants

SELECT c.id,c.fullname,c.shortname,FROM_UNIXTIME(timecreated),FROM_UNIXTIME(timemodified) 
FROM mdl_course AS c 
WHERE id NOT IN (SELECT mdl_context.instanceid FROM mdl_role_assignments,mdl_context WHERE mdl_context.id = mdl_role_assignments.contextid 
AND (mdl_role_assignments.roleid = 3 OR mdl_role_assignments.roleid = 4 OR mdl_role_assignments.roleid = 5) GROUP BY mdl_context.instanceid) ORDER BY timemodified ASC;

SELECT c.id,c.fullname,c.shortname,FROM_UNIXTIME(timecreated),FROM_UNIXTIME(timemodified) 
FROM mdl_course AS c 
WHERE id NOT IN (SELECT mdl_context.instanceid FROM mdl_role_assignments,mdl_context WHERE mdl_context.id = mdl_role_assignments.contextid 
AND (mdl_role_assignments.roleid = 3 OR mdl_role_assignments.roleid = 4 OR mdl_role_assignments.roleid = 5) GROUP BY mdl_context.instanceid) ORDER BY timemodified ASC
INTO OUTFILE '/tmp/cours-sans-participants-order-datemodif.csv' 
FIELDS ENCLOSED BY '' 
TERMINATED BY '|' 
ESCAPED BY '"' 
LINES TERMINATED BY '\r\n';