From 0ed167ceaf1d32678b2887e56e3527ea4c0e46f6 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Wed, 5 Jul 2017 17:08:08 +0200
Subject: builds: do not cross role, daily; cross everything else

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

(limited to 'crunch_global.sql')

diff --git a/crunch_global.sql b/crunch_global.sql
index 1205dfc..787725c 100644
--- a/crunch_global.sql
+++ b/crunch_global.sql
@@ -42,8 +42,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
-    st.name = 'all' and
-    reg.name = 'all' and
+    r.name = 'all' and
 
     (
         (b.item_1 is null or p_s.item_grants rlike concat(:build_regex_start, b.item_1, ';', b.item_1_count, :build_regex_end)) and
-- 
cgit v1.3.1

