Merge branch 'feat/watch-page'

1 files changed, 6 insertions, 1 deletions

diff --git a/backend/query.sql b/backend/query.sql
index 13bbbe6..bcbee12 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;
 
@@ -83,6 +83,11 @@ SELECT * FROM testcases
 WHERE testcases.problem_id = (SELECT problem_id FROM games WHERE game_id = $1)
 ORDER BY testcases.testcase_id;
 
+-- name: ListTestcaseIDsByGameID :many
+SELECT testcases.testcase_id FROM testcases
+WHERE testcases.problem_id = (SELECT problem_id FROM games WHERE game_id = $1)
+ORDER BY testcases.testcase_id;
+
 -- name: CreateSubmissionResult :exec
 INSERT INTO submission_results (submission_id, status, stdout, stderr)
 VALUES ($1, $2, $3, $4);