JOIN {groups_members} gm ON gm.groupid = g.id
WHERE go.assignid = :assignmentid6
)
- ) AS merged
+ ) merged
GROUP BY merged.userid
) priority ON priority.userid = u.id
JOIN (
(SELECT 9999999 AS priority,
u.id AS userid,
-
a.allowsubmissionsfromdate,
a.duedate,
a.cutoffdate
UNION
(SELECT 0 AS priority,
uo.userid,
-
uo.allowsubmissionsfromdate,
uo.duedate,
uo.cutoffdate
UNION
(SELECT go.sortorder AS priority,
gm.userid,
-
go.allowsubmissionsfromdate,
go.duedate,
go.cutoffdate
WHERE go.assignid = :assignmentid9
)
- ) AS effective ON effective.priority = priority.priority AND effective.userid = priority.userid ';
+ ) effective ON effective.priority = priority.priority AND effective.userid = priority.userid ';
}
if (!empty($this->assignment->get_instance()->blindmarking)) {