From cd9761b472954d4fb4b11c53ac4ffbee62f55cd2 Mon Sep 17 00:00:00 2001 From: Moritz Strohm Date: Thu, 26 Feb 2026 20:49:59 +0100 Subject: fixed institute sorting --- lib/models/Institute.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/lib/models/Institute.php b/lib/models/Institute.php index dbffab9..344270b 100644 --- a/lib/models/Institute.php +++ b/lib/models/Institute.php @@ -188,17 +188,17 @@ class Institute extends SimpleORMap implements Range /** * Retrieves all institutes, ordered by faculties and name: A faculty will always come before its institutes. - * Objects are ordered alphabetically afterwards. + * Objects are ordered alphabetically afterward. * * @returns Institute[] All institutes from the database. */ public static function findAll() { $query = "SELECT i0.* - FROM Institute AS i0 - LEFT JOIN Institute AS i1 - ON (i0.fakultaets_id = i1.Institut_id) - ORDER BY i0.Name, i0.Institut_id = i0.fakultaets_id DESC, i1.Name"; + FROM `Institute` AS i0 + LEFT JOIN `Institute` AS i1 + ON (i0.`fakultaets_id` = i1.`Institut_id`) + ORDER BY i1.`Name`, i0.`Institut_id` = i0.`fakultaets_id` DESC, i0.`Name` ASC"; return DBManager::get()->fetchAll( $query, callable: fn(array $row) => Institute::build($row, false) -- cgit v1.0