Handle inactive players or servers in materialized views.

[xonotic/xonstatdb.git] / scripts / refresh_active_servers_mv.sql

diff --git a/scripts/refresh_active_servers_mv.sql b/scripts/refresh_active_servers_mv.sql
index 05bdf7ba6d96e7a400d9396d1317b8366ac81960..10c8847004a61c22f5a43d2fbc05f589ac2cb638 100644 (file)
--- a/scripts/refresh_active_servers_mv.sql
+++ b/scripts/refresh_active_servers_mv.sql
@@ -10,6 +10,7 @@ begin
     from servers s join games g on g.server_id = s.server_id
     join player_game_stats pgs on g.game_id = pgs.game_id
     where pgs.player_id > 1
+    and s.active_ind = true
     and g.create_dt > cutoff
     and pgs.create_dt > cutoff
     group by s.server_id, s.name