Equilibrium: Contest

79,989
Players (Attempted): 9,956
Players (Cleared): 4,167
Clears: 23,344
Time Played (days): 1,106
Redacted Activities by Bungie: 137,219,598
Kills: 5,662,179
Deaths

Reports

Equilibrium: Contest - World First First completions of Equilibrium Contest mode 4,167 rows Equilibrium: Contest - Weapon Meta Weapon usage sorted by kills 200 rows Equilibrium: Contest - By Class Stats for Equilibrium by class 3 rows Equilibrium: Contest - Clear Count Players ranked by number of contest clears 1,486 rows Equilibrium - World First Solo Flawless First 1000 solo flawless completions of Equilibrium 1,000 rows Equilibrium: Contest - Fastest Clears Top 500 fastest contest completions 500 rows Equilibrium: Contest - Duo First duo completions 3 rows

Time: 0.83s Scanned: 106,656 rows Read: 145.9 MB

SELECT
    countDistinct(membershipId) as unique_players,
    countDistinctIf(membershipId, completed = 1 and completionReason = 0) as unique_players_completed,
    countDistinctIf(pgcrId, completed = 1 and completionReason = 0) as clears,
    round(sum(timePlayedSeconds)/60/60/24) as time_played_days,
    1106 as redacted,
    sum(kills) as kills,
    sum(deaths) as deaths
FROM pgcr.ventries
WHERE referenceId = 1754635208  -- Equilibrium: Contest