From 054248f3b95fa24ace3c3e7b599858401f6dce5d Mon Sep 17 00:00:00 2001 From: Jan-Hendrik Willms Date: Tue, 1 Jul 2025 12:56:01 +0200 Subject: Apply 1 suggestion(s) to 1 file(s) --- lib/classes/globalsearch/GlobalSearchCourses.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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"; } -- cgit v1.0