Since you're interested in unmarked assignments, it may make sense to use assign_submission as your base table, look for rows where the status = 'submitted', and do an outer join with assign_grades on assignment and userid. You'll of course have to filter further using the userid, context and role stuff.
General developer forum
Retrieve all unmarked assignments for a particular teacher
Denna diskussion är stängd och du kan inte längre göra inlägg i den.