diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-03-20 20:44:49 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-03-20 20:44:49 +0900 |
| commit | 23315cc2e0c98510ffca5adf06a2152945e51756 (patch) | |
| tree | b5a743ff2adbcd5ccafeb06107b186218d201e18 /backend/query.sql | |
| parent | 4a2438201d0e365a873632a1ffcf913661eacbec (diff) | |
| download | phperkaigi-2025-albatross-23315cc2e0c98510ffca5adf06a2152945e51756.tar.gz phperkaigi-2025-albatross-23315cc2e0c98510ffca5adf06a2152945e51756.tar.zst phperkaigi-2025-albatross-23315cc2e0c98510ffca5adf06a2152945e51756.zip | |
fix(backend): fix online qualifying ranking
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 1 |
1 files changed, 1 insertions, 0 deletions
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, |