From 110d03c8edaed51866a4c5131708b72295801cc6 Mon Sep 17 00:00:00 2001 From: schneefux Date: Sat, 7 Oct 2017 11:59:47 +0200 Subject: add heals --- crunch_phases.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/crunch_phases.sql b/crunch_phases.sql index fa0a95c..41a4665 100644 --- a/crunch_phases.sql +++ b/crunch_phases.sql @@ -63,6 +63,14 @@ select sum(ability_aa_damage_dealt), sum(ability_aacrit_damage_true), sum(ability_aacrit_damage_dealt), + sum(heal_heal_hero), + sum(heal_healed_hero), + sum(heal_heal_other), + sum(heal_healed_other), + sum(heal_rcvd_heal_hero), + sum(heal_rcvd_healed_hero), + sum(heal_rcvd_heal_other), + sum(heal_rcvd_healed_other), _ph_item_uses_insert from participant_phases ph join participant p on ph.participant_api_id = p.api_id -- cgit v1.3.1