diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-03-21 09:52:26 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-03-21 09:52:26 +0900 |
| commit | e66bba3317c51b1c9d89bcef706d05b82c7148ec (patch) | |
| tree | 82645fa8eb1ea0a57d4bd1094138804c08f2c9f9 /backend | |
| parent | 80ee46c81dda5331f66aa401435447f22ff187cd (diff) | |
| download | phperkaigi-2025-albatross-e66bba3317c51b1c9d89bcef706d05b82c7148ec.tar.gz phperkaigi-2025-albatross-e66bba3317c51b1c9d89bcef706d05b82c7148ec.tar.zst phperkaigi-2025-albatross-e66bba3317c51b1c9d89bcef706d05b82c7148ec.zip | |
feat(backend): limit ranking entries
Diffstat (limited to 'backend')
| -rw-r--r-- | backend/query.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/backend/query.sql b/backend/query.sql index c052718..32f9273 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -130,7 +130,8 @@ FROM game_states JOIN users ON game_states.user_id = users.user_id JOIN submissions ON game_states.best_score_submission_id = submissions.submission_id WHERE game_states.game_id = $1 -ORDER BY submissions.code_size ASC, submissions.created_at ASC; +ORDER BY submissions.code_size ASC, submissions.created_at ASC +LIMIT 30; -- name: GetQualifyingRanking :many SELECT |