StudipSemSearchHelper will no longer return duplicated course ids, fixes #5104

Closes #5104

Merge request studip/studip!3817

1 files changed, 6 insertions, 6 deletions

diff --git a/lib/classes/StudipSemSearchHelper.php b/lib/classes/StudipSemSearchHelper.php
index 57b699b..172c845 100644
--- a/lib/classes/StudipSemSearchHelper.php
+++ b/lib/classes/StudipSemSearchHelper.php
@@ -175,13 +175,13 @@ class StudipSemSearchHelper {
             $sql_params['lecturer_name'] = $this->params['lecturer'];
         }
 
-        $stmt = $db->prepare(
-            sprintf(
-                'SELECT `seminar_id` FROM `seminare` %s WHERE %s',
-                implode(' ', $join_sql),
-                implode(' AND ', $where_sql)
-            )
+        $query = sprintf(
+            'SELECT DISTINCT `seminar_id` FROM `seminare` %s WHERE %s',
+            implode(' ', $join_sql),
+            implode(' AND ', $where_sql)
         );
+
+        $stmt = $db->prepare($query);
         $stmt->execute($sql_params);
         return $stmt->fetchAll();
     }