From 3142e9fa5bbcb1b857a39c630d5c0d8a393b3e03 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Fri, 23 Jun 2017 22:31:57 +0200
Subject: fix filters, second attempt

---
 crunch_global.sql | 1 -
 1 file changed, 1 deletion(-)

(limited to 'crunch_global.sql')

diff --git a/crunch_global.sql b/crunch_global.sql
index fe34356..b1486f7 100644
--- a/crunch_global.sql
+++ b/crunch_global.sql
@@ -40,7 +40,6 @@ JOIN `role` `player_role` ON `player_role`.`id` = `player`.`role_id` OR `player_
 JOIN `region` ON `region`.`name` = `player`.`shard_id` OR `region`.`name` = 'all'
 
 -- filters
-JOIN `global_point_filters` ON `player`.`match_api_id` = `global_point_filters`.`match_api_id`
 JOIN `filter` ON (`filter`.`name` = 'all' AND `filter`.`dimension_on` = 'global') OR `filter`.`id` IN (SELECT `global_point_filters`.`filter_id` FROM `global_point_filters` WHERE `global_point_filters`.`match_api_id` = `player`.`match_api_id`)
 
 -- being cheap
-- 
cgit v1.3.1

