From 534df5bd1a36bc7ba5ed76828e37ab6a1240f3c7 Mon Sep 17 00:00:00 2001 From: nsfisis 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.2.3-70-g09d2