Improve the performance of the SQL query when searching for unvisited involved bugs

1 files changed, 2 insertions, 2 deletions

diff --git a/buglist.cgi b/buglist.cgi
index 6e5e3d94c..ea6aa6ee5 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -878,10 +878,10 @@ if (@bugidlist) {
               $dbh->selectcol_arrayref('SELECT bugs.bug_id
                                           FROM bugs
                                      LEFT JOIN cc
-                                            ON cc.bug_id = bugs.bug_id
+                                            ON cc.bug_id = bugs.bug_id AND who = ?
                                          WHERE (reporter = ? OR assigned_to = ? OR qa_contact = ? OR who = ?)
                                            AND ' . $dbh->sql_in('bugs.bug_id', $new_bugs),
-                                         undef, ($user->id) x 4);
+                                         undef, ($user->id) x 5);
             %$involved_new_bugs = map { $_ => 1 } @$involved_new_bugs_list;
         }
     }