diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-23 19:38:31 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-23 19:38:31 +0200 |
| commit | 7f6bae2af6042cb71124acb40e97c6a0b7fde8dc (patch) | |
| tree | 7ef08a5fd0d0ebee07bec2e324811fb753e6cdd5 | |
| parent | 25e74303401b3036623fa62f5559eb51e5430265 (diff) | |
| download | cruncher-7f6bae2af6042cb71124acb40e97c6a0b7fde8dc.tar.gz cruncher-7f6bae2af6042cb71124acb40e97c6a0b7fde8dc.zip | |
set up filters
| -rw-r--r-- | crunch_global.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/crunch_global.sql b/crunch_global.sql index 257952d..4c2f00c 100644 --- a/crunch_global.sql +++ b/crunch_global.sql @@ -39,9 +39,11 @@ JOIN `hero` `player_hero` ON `player_hero`.`id` = `player`.`hero_id` OR `player_ JOIN `role` `player_role` ON `player_role`.`id` = `player`.`role_id` OR `player_role`.`name` = 'all' 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 `global_point_filters`.`filter_id` = `filter`.`id` + -- being cheap -JOIN `filter` ON `filter`.`name` = 'all' AND `filter`.`dimension_on` = 'global' - AND `series`.`show_in_web` = TRUE JOIN `game_mode` ON `game_mode`.`id` = `player`.`game_mode_id` OR `game_mode`.`name` = 'all' AND `series`.`show_in_web` = TRUE JOIN `skill_tier` ON `player`.`skill_tier` BETWEEN `skill_tier`.`start` AND `skill_tier`.`end` OR `skill_tier`.`name` = 'all' @@ -50,9 +52,8 @@ JOIN `skill_tier` ON `player`.`skill_tier` BETWEEN `skill_tier`.`start` AND `ski -- builds and counters do not cross -- builds JOIN `build` ON `build`.`name` = 'all' OR ( - -- do not cross daily series, filters, game mode, skill tier, region (builds excluded below) + -- do not cross daily series, game mode, skill tier, region (builds excluded below) `series`.`show_in_web` = TRUE AND - `filter`.`name` = 'all' AND `game_mode`.`name` = 'all' AND `skill_tier`.`name` = 'all' AND `region`.`name` = 'all' AND @@ -67,10 +68,9 @@ JOIN `build` ON `build`.`name` = 'all' OR ( -- counters JOIN `participant` `enemy` ON `enemy`.`match_api_id` = `player`.`match_api_id` AND `enemy`.`winner` <> `player`.`winner` - -- do not cross daily series, builds, filters, game mode, skill tier, region + -- do not cross daily series, builds, game mode, skill tier, region AND `series`.`show_in_web` = TRUE AND `build`.`name` = 'all' - AND `filter`.`name` = 'all' AND `game_mode`.`name` = 'all' AND `skill_tier`.`name` = 'all' AND `region`.`name` = 'all' |