From 23315cc2e0c98510ffca5adf06a2152945e51756 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Thu, 20 Mar 2025 20:44:49 +0900 Subject: fix(backend): fix online qualifying ranking --- backend/query.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'backend/query.sql') diff --git a/backend/query.sql b/backend/query.sql index 4707eff..c052718 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -135,6 +135,7 @@ ORDER BY submissions.code_size ASC, submissions.created_at ASC; -- name: GetQualifyingRanking :many SELECT u.username AS username, + u.label AS user_label, s1.code_size AS code_size_1, s2.code_size AS code_size_2, (s1.code_size + s2.code_size) AS total_code_size, -- cgit v1.2.3-70-g09d2