Minion Lives Matter

- Based on Vainsocial users' data from the past 24 hours that by no means is representative to the whole player base of Vainglory. {{ sql_val("SELECT COUNT(*) FROM match WHERE created_at > NOW() - '1 day'::INTERVAL") }} matches are taken into account for this calculation. - -

- -

0 Minions died

since you opened this page

- -

{{ sql_val("SELECT COUNT((item_grants->>'1045_Item_FountainOfRenewal')::INT)-COUNT((item_uses->>'1045_Item_FountainOfRenewal')::INT) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }} Fountains

- -

did not help their team

{{ sql_val("SELECT (SUM(match.duration)/60*5) / SUM(roster.kraken_captures) FROM match JOIN roster ON roster.match_api_id=match.api_id WHERE match.created_at > NOW() - '1 day'::INTERVAL") }} Minions

are needed to unleash a Kraken

- - -

{{ sql_val("SELECT SUM(participant.crystal_mine_captures) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }} Crystal Sentries

- -

got slaugthered

{{ sql_val("SELECT SUM((participant.item_sells->>'1038_Item_Flare')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }} Flares

- -

got thrown into the trash

Every {{ sql_val("SELECT SUM(match.duration)/60 / (SUM((participant.item_uses->>'1052_Item_WeaponInfusion')::INT) + SUM((participant.item_uses->>'1053_Item_CrystalInfusion')::INT)) FROM participant JOIN roster ON participant.roster_api_id=roster.api_id JOIN match ON roster.match_api_id=match.api_id WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }} minutes

- -

A hero gets high on infusions

{{ sql_val("SELECT SUM((item_uses->>'1054_Item_ScoutTrap')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }} Scout Traps

- -

Scout Traps made the Halcyon Fold a dangerous place

{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE hero='SAW' AND created_at > NOW() - '1 day'::INTERVAL") }} Turrets

- -

were pushed by a SAW

{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }} Turrets

- -

need to be rebuilt by Minion Workers every day

{{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE NOT winner AND created_at > NOW() - '1 day'::INTERVAL") }} out of {{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }} Minions

- - -

died for nothing