summaryrefslogtreecommitdiff
path: root/server.js
diff options
context:
space:
mode:
Diffstat (limited to 'server.js')
-rw-r--r--server.js6
1 files changed, 2 insertions, 4 deletions
diff --git a/server.js b/server.js
index 9cf75c2..b6d3175 100644
--- a/server.js
+++ b/server.js
@@ -2935,11 +2935,9 @@ const SQL_GAME_STATS = SQL(`
result,
count(1) as n
from
- game_view
+ rated_games_view
where
- is_opposed
- and ( status = ${STATUS_FINISHED} or status = ${STATUS_ARCHIVED} )
- and ( title_id not in ( select title_id from titles where is_symmetric ) )
+ ( title_id not in ( select title_id from titles where is_symmetric ) )
group by
title_id,
player_count,