diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-10 14:06:28 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-10 19:55:45 +0900 |
| commit | 0b520dc2529d7df6263842480d4ba7eaf07f4dcd (patch) | |
| tree | 4a015b17210ba1d61ca98d2e18e339c817016f8c /backend/query.sql | |
| parent | a8f2594e8dcb741fb942092cbc53d64cf93132ef (diff) | |
| download | phperkaigi-2025-albatross-0b520dc2529d7df6263842480d4ba7eaf07f4dcd.tar.gz phperkaigi-2025-albatross-0b520dc2529d7df6263842480d4ba7eaf07f4dcd.tar.zst phperkaigi-2025-albatross-0b520dc2529d7df6263842480d4ba7eaf07f4dcd.zip | |
feat(backend): include `players` in `Game` object
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/backend/query.sql b/backend/query.sql index 13bbbe6..12b67b9 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -58,7 +58,7 @@ LIMIT 1; -- name: ListGamePlayers :many SELECT * FROM game_players -LEFT JOIN users ON game_players.user_id = users.user_id +JOIN users ON game_players.user_id = users.user_id WHERE game_players.game_id = $1 ORDER BY game_players.user_id; |