diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-03-20 19:41:38 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-03-20 19:41:39 +0900 |
| commit | 1a08d06be929900fb8d8b61a1ac0611005c277e8 (patch) | |
| tree | b064bfb79cc0021a42c423a04359504369e1faa5 /backend/query.sql | |
| parent | 96081efcce7b7e1f4540cb74cb511a341f2cb4d3 (diff) | |
| download | phperkaigi-2025-albatross-1a08d06be929900fb8d8b61a1ac0611005c277e8.tar.gz phperkaigi-2025-albatross-1a08d06be929900fb8d8b61a1ac0611005c277e8.tar.zst phperkaigi-2025-albatross-1a08d06be929900fb8d8b61a1ac0611005c277e8.zip | |
feat: show submission date on ranking
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/backend/query.sql b/backend/query.sql index 61175ab..2a95a23 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -123,7 +123,10 @@ LEFT JOIN submissions ON game_states.best_score_submission_id = submissions.subm WHERE game_main_players.game_id = $1; -- name: GetRanking :many -SELECT * FROM game_states +SELECT + sqlc.embed(submissions), + sqlc.embed(users) +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 |