Don't count games that end early (resigned/timed out) in stats.

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,