Closed burberius closed 6 years ago
select DATE(start) as date, sum(loot_value + bounty_value + reward_value) as value from outcome where account_id = :account and DATE(start) > CURDATE() - INTERVAL 30 DAY group by DAY(start) order by DATE(start);