Esborrar enviamens i notes de tasques i qüestionaris

DELETE
FROM mdl_assignment_submissions
WHERE assignment IN (
SELECT a.id
FROM mdl_assignment a, mdl_course c, mdl_course_categories cc
WHERE a.course = c.id AND c.category = cc.id and cc.name IN ('MCT', 'Socials', 'Comunicació')
);

DELETE
FROM mdl_quiz_grades
WHERE quiz IN (
SELECT q.id
FROM mdl_quiz q, mdl_course c, mdl_course_categories cc
WHERE q.course = c.id AND c.category = cc.id and cc.name IN ('MCT', 'Socials', 'Comunicació')
);

DELETE
FROM mdl_quiz_attempts
WHERE quiz IN (
SELECT q.id
FROM mdl_quiz q, mdl_course c, mdl_course_categories cc
WHERE q.course = c.id AND c.category = cc.id and cc.name IN ('MCT', 'Socials', 'Comunicació')
);