diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-11 20:53:17 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-11 20:53:17 +0900 |
| commit | fe8b14ccc77c829a2baa4034edb22daff9d5d8f8 (patch) | |
| tree | 37528798ede5a89b1a7be6c6ee2fec20395668a2 /backend/query.sql | |
| parent | e3502d9e649fe61bb0ba4046b2c23c0d78bc92e9 (diff) | |
| parent | 0c448f5d403a084389acb0b3d215f8728a599302 (diff) | |
| download | phperkaigi-2025-albatross-fe8b14ccc77c829a2baa4034edb22daff9d5d8f8.tar.gz phperkaigi-2025-albatross-fe8b14ccc77c829a2baa4034edb22daff9d5d8f8.tar.zst phperkaigi-2025-albatross-fe8b14ccc77c829a2baa4034edb22daff9d5d8f8.zip | |
Merge branch 'feat/send-problem-before-starting-game'
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/backend/query.sql b/backend/query.sql index bcbee12..408bf2d 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -30,12 +30,12 @@ SELECT EXISTS ( -- name: ListGames :many SELECT * FROM games -LEFT JOIN problems ON games.problem_id = problems.problem_id +JOIN problems ON games.problem_id = problems.problem_id ORDER BY games.game_id; -- name: ListGamesForPlayer :many SELECT * FROM games -LEFT JOIN problems ON games.problem_id = problems.problem_id +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 ORDER BY games.game_id; @@ -52,7 +52,7 @@ WHERE game_id = $1; -- name: GetGameByID :one SELECT * FROM games -LEFT JOIN problems ON games.problem_id = problems.problem_id +JOIN problems ON games.problem_id = problems.problem_id WHERE games.game_id = $1 LIMIT 1; |