From 1a08d06be929900fb8d8b61a1ac0611005c277e8 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Thu, 20 Mar 2025 19:41:38 +0900 Subject: feat: show submission date on ranking --- backend/query.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'backend/query.sql') 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 -- cgit v1.2.3-70-g09d2