diff options
| author | André Noack <noack@data-quest.de> | 2023-12-13 14:39:18 +0000 |
|---|---|---|
| committer | André Noack <noack@data-quest.de> | 2023-12-13 14:39:18 +0000 |
| commit | 80ecf133e64f537571760147f4b744d3efcf77d2 (patch) | |
| tree | ee6ac23e34d4312ba97f9dcdee67faa56761f6dc /lib/classes | |
| parent | bba69ab3e72036338923c4a1770a021a801e94af (diff) | |
Resolve "Ankündigungen: SQL Fehler beim Suchen nach Bereichen"
Closes #3567
Merge request studip/studip!2449
Diffstat (limited to 'lib/classes')
| -rw-r--r-- | lib/classes/searchtypes/NewsRangesSearch.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/classes/searchtypes/NewsRangesSearch.php b/lib/classes/searchtypes/NewsRangesSearch.php index fc2fcbc..849b5c5 100644 --- a/lib/classes/searchtypes/NewsRangesSearch.php +++ b/lib/classes/searchtypes/NewsRangesSearch.php @@ -68,7 +68,7 @@ class NewsRangesSearch extends SearchType SELECT CONCAT(s.`Seminar_id`, '__seminar') AS `range_id`, TRIM(CONCAT({$number_sql} s.`name`, {$semester_sql})) AS `name` FROM `seminare` AS s - JOIN `seminar_user` USING (`Seminar_id`) AS su + JOIN `seminar_user` AS su USING (`Seminar_id`) LEFT JOIN `semester_courses` AS sc ON s.`Seminar_id` = sc.`course_id` LEFT JOIN `semester_data` USING (`semester_id`) WHERE s.`name` LIKE :input |