Moodle courses that have used inline PDF annotation feedback -thanks, mackensen

courses_with_annotation_feedback.sql

SELECT DISTINCT name as "Assignment Name", course as "Course ID", fullname as "course title", "Standard" as "Annotation"
FROM prefix_assignfeedback_editpdf_annot ant
INNER JOIN prefix_assign_grades grd ON ant.gradeid = grd.id
INNER JOIN prefix_assign assign ON grd.assignment = assign.id
INNER JOIN prefix_course c ON assign.course = c.id
UNION
SELECT DISTINCT name as "Assignment Name", course as "Course ID", fullname as "course title", "Comment" as "Annotation"
FROM prefix_assignfeedback_editpdf_cmnt cmnt
INNER JOIN prefix_assign_grades grd ON cmnt.gradeid = grd.id
INNER JOIN prefix_assign assign ON grd.assignment = assign.id
INNER JOIN prefix_course c ON assign.course = c.id