diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-23 22:31:57 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-23 22:31:57 +0200 |
| commit | 3142e9fa5bbcb1b857a39c630d5c0d8a393b3e03 (patch) | |
| tree | 9b944dad06adae15a6fb1420c5fc856d7a8fde41 | |
| parent | b7420ecd6f47273989d315f3e13cf894d2aac7cf (diff) | |
| download | cruncher-3142e9fa5bbcb1b857a39c630d5c0d8a393b3e03.tar.gz cruncher-3142e9fa5bbcb1b857a39c630d5c0d8a393b3e03.zip | |
fix filters, second attempt
| -rw-r--r-- | crunch_global.sql | 1 |
1 files changed, 0 insertions, 1 deletions
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 |