From 458e6945e095797b8e5dcb41478669fe108f373f Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Thu, 4 Jan 2018 16:47:01 +0100
Subject: hotfix for builds only considering casual/ranked

---
 crunch_global.sql | 1 +
 1 file changed, 1 insertion(+)

diff --git a/crunch_global.sql b/crunch_global.sql
index 173b6d9..f2713dc 100644
--- a/crunch_global.sql
+++ b/crunch_global.sql
@@ -46,6 +46,7 @@ join skill_tier st on ((p.skill_tier between st.start and st.end and s.show_in_w
 join build b on ((  -- only per patch global
     s.show_in_web = true and
     gm.name = 'all' and
+    p.game_mode_id in (select id from game_mode where name in ('casual', 'ranked')) and  -- only casual / ranked
     reg.name = 'all' and
 
     (
-- 
cgit v1.3.1