diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-22 19:14:32 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-22 19:40:47 +0900 |
| commit | 534df5bd1a36bc7ba5ed76828e37ab6a1240f3c7 (patch) | |
| tree | d787850e0d0e0df53ca8b3363d9787bf26ecfb86 /backend/query.sql | |
| parent | dd541bfa7940959ab8a1d93d58a24cc277c51e48 (diff) | |
| download | phperkaigi-2025-albatross-534df5bd1a36bc7ba5ed76828e37ab6a1240f3c7.tar.gz phperkaigi-2025-albatross-534df5bd1a36bc7ba5ed76828e37ab6a1240f3c7.tar.zst phperkaigi-2025-albatross-534df5bd1a36bc7ba5ed76828e37ab6a1240f3c7.zip | |
.
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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 |