Handle inactive players or servers in materialized views.

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

diff --git a/scripts/refresh_player_agg_stats_mv.sql b/scripts/refresh_player_agg_stats_mv.sql
index cf99aa518bafda700fe5506871f380115218b6cf..b75f0641e6cccc1ba3b5deb9372b3034478d34c6 100644 (file)
--- a/scripts/refresh_player_agg_stats_mv.sql
+++ b/scripts/refresh_player_agg_stats_mv.sql
@@ -76,6 +76,8 @@ begin
     join
        players p 
           on p.player_id = agg_stats.player_id            
+       where
+          p.active_ind = true
        group by
           p.player_id,
           p.nick,