diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-07 11:59:47 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-07 11:59:47 +0200 |
| commit | 110d03c8edaed51866a4c5131708b72295801cc6 (patch) | |
| tree | a001c22cbdd6b6bf56a1b01b6e42b0fc2026d813 | |
| parent | 6cd9a8543e1089cf8f9073326c4e4bc3e0b864c4 (diff) | |
| download | cruncher-110d03c8edaed51866a4c5131708b72295801cc6.tar.gz cruncher-110d03c8edaed51866a4c5131708b72295801cc6.zip | |
add heals
| -rw-r--r-- | crunch_phases.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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 |