From 78ea91bc73b365ff56f99cb35d3fb05d83f494fb Mon Sep 17 00:00:00 2001
From: poltawski <poltawski>
Date: Sat, 26 Jan 2008 17:35:58 +0000
Subject: [PATCH] MDL-13180 - prevent return of duplicate rows

---
 mod/forum/lib.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/mod/forum/lib.php b/mod/forum/lib.php
index 41ef985bbd..3047b6592f 100644
--- a/mod/forum/lib.php
+++ b/mod/forum/lib.php
@@ -4543,7 +4543,8 @@ function forum_remove_user_tracking($userid, $context) {
                                               FROM {$CFG->prefix}course c,
                                                    {$CFG->prefix}forum_read fr,
                                                    {$CFG->prefix}forum f
-                                             WHERE c.id = f.course AND f.id = fr.forumid AND fr.userid = $userid")) {
+                                                   WHERE c.id = f.course AND f.id = fr.forumid AND fr.userid = $userid
+                                                   GROUP BY c.id")) {
 
                 $allcourses = $allcourses + $courses;
             }
-- 
2.39.5