diff options
| -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 |