MDL-37527 Assignment - Change query for print_overview so it uses an index (postgres)

[moodle.git] / mod / assign / lib.php

diff --git a/mod/assign/lib.php b/mod/assign/lib.php
index e2d7e01..81c9456 100644 (file)
--- a/mod/assign/lib.php
+++ b/mod/assign/lib.php
@@ -358,7 +358,7 @@ function assign_print_overview($courses, &$htmlarray) {
     $rs->close();
 
     // Get all user submissions, indexed by assignment id.
-    $dbparams = array_merge(array($USER->id, $USER->id), $assignmentidparams);
+    $dbparams = array($USER->id, $USER->id);
     $mysubmissions = $DB->get_records_sql('SELECT
                                                a.id AS assignment,
                                                a.nosubmissions AS nosubmissions,
@@ -372,8 +372,8 @@ function assign_print_overview($courses, &$htmlarray) {
                                                g.userid = ?
                                            LEFT JOIN {assign_submission} s ON
                                                s.assignment = a.id AND
-                                               s.userid = ? AND
-                                               a.id ' . $sqlassignmentids, $dbparams);
+                                               s.userid = ?
+                                           WHERE a.id ' . $sqlassignmentids, $dbparams);
 
     foreach ($assignments as $assignment) {
         // Do not show assignments that are not open.