From 1a08d06be929900fb8d8b61a1ac0611005c277e8 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
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.3.1

