I've just open sourced the queries now: https://github.com/Demotruk/hivesql-queries

I added a note about eSteem/Ecency in the post. I've kept them split because there does seem to be a meaningful difference in the numbers, even if it's that's driven by the difference in era (pre- versus post-fork).