From 534df5bd1a36bc7ba5ed76828e37ab6a1240f3c7 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Thu, 22 Aug 2024 19:14:32 +0900
Subject: .

---
 backend/query.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'backend/query.sql')

diff --git a/backend/query.sql b/backend/query.sql
index dc5f384..8a76753 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -46,8 +46,8 @@ ORDER BY games.game_id;
 -- name: ListGamesForPlayer :many
 SELECT * FROM games
 JOIN problems ON games.problem_id = problems.problem_id
-JOIN game_players ON games.game_id = game_players.game_id
-WHERE game_players.user_id = $1
+LEFT JOIN game_players ON games.game_id = game_players.game_id
+WHERE game_players.user_id = $1 OR games.game_id = 39
 ORDER BY games.game_id;
 
 -- name: UpdateGameState :exec
-- 
cgit v1.3.1

