From 3142e9fa5bbcb1b857a39c630d5c0d8a393b3e03 Mon Sep 17 00:00:00 2001 From: schneefux Date: Fri, 23 Jun 2017 22:31:57 +0200 Subject: fix filters, second attempt --- crunch_global.sql | 1 - 1 file changed, 1 deletion(-) 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