Cours qui n'existent plus mais referencés dans table des logs

SELECT DISTINCT courseid
FROM mdl_logstore_standard_log
WHERE courseid NOT IN (SELECT DISTINCT id FROM mdl_course);

Effacage des cours qui n'existent plus mais referencés dans table des logs

DELETE FROM mdl_logstore_standard_log
WHERE courseid NOT IN (SELECT DISTINCT id FROM mdl_course)
  AND courseid != 0;