https://www.opendota.com/explorer?sql=SELECT%0Anotable_players.account_id %2C%0Around(sum(round((0.3 * kills %2B (3 - 0.3 * deaths) %2B 0.003 * (last_hits %2B denies) %2B 0.002 * gold_per_min %2B towers_killed %2B roshans_killed %2B 3 * teamfight_participation %2B 0.5 * observers_placed %2B 0.5 * camps_stacked %2B 0.25 * rune_pickups %2B 4 * firstblood_claimed %2B 0.05 * stuns)%3A%3Anumeric%2C 1))%3A%3Anumeric%2Fcount(1)%2C 2) avg%2C%0Acount(distinct matches.match_id) count%2C%0Asum(case when (player_matches.player_slot < 128) %3D radiant_win then 1 else 0 end)%3A%3Afloat%2Fcount(1) winrate%2C%0A((sum(case when (player_matches.player_slot < 128) %3D radiant_win then 1 else 0 end)%3A%3Afloat%2Fcount(1)) %0A %2B 1.96 * 1.96 %2F (2 * count(1)) %0A - 1.96 * sqrt((((sum(case when (player_matches.player_slot < 128) %3D radiant_win then 1 else 0 end)%3A%3Afloat%2Fcount(1)) * (1 - (sum(case when (player_matches.player_slot < 128) %3D radiant_win then 1 else 0 end)%3A%3Afloat%2Fcount(1))) %2B 1.96 * 1.96 %2F (4 * count(1))) %2F count(1))))%0A %2F (1 %2B 1.96 * 1.96 %2F count(1)) wr_lower_bound%2C%0Asum(round((0.3 * kills %2B (3 - 0.3 * deaths) %2B 0.003 * (last_hits %2B denies) %2B 0.002 * gold_per_min %2B towers_killed %2B roshans_killed %2B 3 * teamfight_participation %2B 0.5 * observers_placed %2B 0.5 * camps_stacked %2B 0.25 * rune_pickups %2B 4 * firstblood_claimed %2B 0.05 * stuns)%3A%3Anumeric%2C 1)) sum%2C%0Amin(round((0.3 * kills %2B (3 - 0.3 * deaths) %2B 0.003 * (last_hits %2B denies) %2B 0.002 * gold_per_min %2B towers_killed %2B roshans_killed %2B 3 * teamfight_participation %2B 0.5 * observers_placed %2B 0.5 * camps_stacked %2B 0.25 * rune_pickups %2B 4 * firstblood_claimed %2B 0.05 * stuns)%3A%3Anumeric%2C 1)) min%2C%0Amax(round((0.3 * kills %2B (3 - 0.3 * deaths) %2B 0.003 * (last_hits %2B denies) %2B 0.002 * gold_per_min %2B towers_killed %2B roshans_killed %2B 3 * teamfight_participation %2B 0.5 * observers_placed %2B 0.5 * camps_stacked %2B 0.25 * rune_pickups %2B 4 * firstblood_claimed %2B 0.05 * stuns)%3A%3Anumeric%2C 1)) max%2C%0Around(stddev(round((0.3 * kills %2B (3 - 0.3 * deaths) %2B 0.003 * (last_hits %2B denies) %2B 0.002 * gold_per_min %2B towers_killed %2B roshans_killed %2B 3 * teamfight_participation %2B 0.5 * observers_placed %2B 0.5 * camps_stacked %2B 0.25 * rune_pickups %2B 4 * firstblood_claimed %2B 0.05 * stuns)%3A%3Anumeric%2C 1)%3A%3Anumeric)%2C 2) stddev%0AFROM matches%0AJOIN match_patch using(match_id)%0AJOIN leagues using(leagueid)%0AJOIN player_matches using(match_id)%0AJOIN heroes on heroes.id %3D player_matches.hero_id%0ALEFT JOIN notable_players ON notable_players.account_id %3D player_matches.account_id AND notable_players.locked_until %3D (SELECT MAX(locked_until) FROM notable_players)%0ALEFT JOIN teams using(team_id)%0AWHERE TRUE%0AAND round((0.3 * kills %2B (3 - 0.3 * deaths) %2B 0.003 * (last_hits %2B denies) %2B 0.002 * gold_per_min %2B towers_killed %2B roshans_killed %2B 3 * teamfight_participation %2B 0.5 * observers_placed %2B 0.5 * camps_stacked %2B 0.25 * rune_pickups %2B 4 * firstblood_claimed %2B 0.05 * stuns)%3A%3Anumeric%2C 1) IS NOT NULL%0AAND matches.leagueid %3D 5401%0AAND matches.start_time >%3D extract(epoch from timestamp '2017-08-03T14%3A00%3A00.000Z')%0AAND matches.start_time <%3D extract(epoch from timestamp '2017-08-05T22%3A00%3A00.000Z')%0AAND teams.team_id IN (5%2C 15%2C 39%2C 46%2C 2163%2C 350190%2C 1375614%2C 1838315%2C 1883502%2C 2108395%2C 2512249%2C 2581813%2C 2586976%2C 2640025%2C 2672298%2C 1333179%2C 3331948%2C 1846548)%0AGROUP BY notable_players.account_id%0AHAVING count(distinct matches.match_id) >%3D 1%0AORDER BY avg DESC%2Ccount DESC NULLS LAST%0ALIMIT 200&format=table