Shouldn't the mined column add up to roughtly 2M? Or are there a ton of addresses beyond these 15 that were mining in this period?
not with the dataset quoted, because of the limit 15 there at the end, you are only seeing top 15.
Code:
mysql>
select dest_addr
, count(1)
, min(blocknum)
, max(blocknum)
, (select sum(val) from generation ig where ig.dest_addr = og.dest_addr and ig.blocknum < 4500) as mined
from generation og
where og.blocknum < 4500
group by dest_addr
order by mined desc
limit 15;
here's the full dataset without the limit: http://pastebin.com/7EcSdxK4
and the check, to make sure data is sane (and adds up to what you mentioned) ~1992655.0480
Code:
mysql> select sum(mined) from (
-> select dest_addr
-> , count(1)
-> , min(blocknum)
-> , max(blocknum)
-> , (select sum(val) from generation ig where ig.dest_addr = og.dest_addr and ig.blocknum < 4500) as mined
-> from generation og
-> where og.blocknum < 4500
-> group by dest_addr
-> order by mined desc
-> ) a;
+--------------------+
| sum(mined) |
+--------------------+
| 1992655.0480000000 |
+--------------------+
1 row in set (0.00 sec)