Differences

This shows you the differences between two versions of the page.

--- moodle-requete-fusion [2024/02/13 13:56] – 195.221.243.132
+++ moodle-requete-fusion [2024/02/13 15:02] (current) – 195.221.243.132
@@ Line 14: / Line 14: @@
 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';
+</code>
+Cours sans participants
+<code>
+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;
+</code>
+<code>
+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 '|'