diff options
Diffstat (limited to 'lib/classes')
| -rw-r--r-- | lib/classes/globalsearch/GlobalSearchCourses.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/classes/globalsearch/GlobalSearchCourses.php b/lib/classes/globalsearch/GlobalSearchCourses.php index ce82199..210aa0d 100644 --- a/lib/classes/globalsearch/GlobalSearchCourses.php +++ b/lib/classes/globalsearch/GlobalSearchCourses.php @@ -123,7 +123,8 @@ class GlobalSearchCourses extends GlobalSearchModule implements GlobalSearchFull GROUP BY courses.Seminar_id"; if (Config::get()->IMPORTANT_SEMNUMBER) { - $sql .= " ORDER BY CASE WHEN courses.`VeranstaltungsNummer` THEN courses.`VeranstaltungsNummer` ELSE MAX(`semester_data`.`beginn`) END"; + $sql .= " ORDER BY courses.`VeranstaltungsNummer` = '', courses.`VeranstaltungsNummer`, MAX(`semester_data`.`beginn`) DESC"; + } else { $sql .= " ORDER BY MAX(`semester_data`.`beginn`) DESC"; } |