Differences

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

--- moodle-requete-fusion [2024/02/13 13:33] – 195.221.243.132
+++ moodle-requete-fusion [2024/02/13 15:02] (current) – 195.221.243.132
@@ Line 1: / Line 1: @@
 Cours sans enseignants
 <code>
-SELECT mdl_course.id FROM mdl_course WHERE (SELECT COUNT(mdl_role_assignments.id)
+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 = mdl_course.id) = 0 AND mdl_course.id != 1
+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;
 </code>
+<code>
+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';
+</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 '|'
+ESCAPED BY '"'
+LINES TERMINATED BY '\r\n';
+</code>