Open burberius opened 6 years ago
select site_name, count(id) as count,avg(loot_value) as loot_value,avg(timestampdiff(SECOND, start, end)) as duration,sum(escalation)/count(id)100 as escalations,sum(faction)/count(id)100 as factions from outcome where account_id = :account group by site_id order by count desc;