diff options
Diffstat (limited to 'backend/query.sql')
| -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 c791c27..1c0a8fd 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -262,7 +262,8 @@ WHERE testcase_id = $1; -- name: GetSubmissionsByGameIDAndUserID :many SELECT * FROM submissions WHERE game_id = $1 AND user_id = $2 -ORDER BY created_at DESC; +ORDER BY created_at DESC +LIMIT 50; -- name: GetSubmissionsByGameID :many SELECT * |