[SteemRank] Added more data about authors

I updated SteemRank and added the next info about each author:

• Number of upvotes (it calculates only from posts with pending payout)
• SBD balance
• Steem balance
• Date of the account creation

Also, @miniature-tiger did give me the advice about depth=0 and now parent_author='' replaced by depth=0. Thanks @miniature-tiger!

If you do not know what is SteemRank — right now it is a rating of authors which is sorted by their pending payout. But the main idea is an analysis of the best parts of Steemit. The project was developed with SteemSQL Wrapper API.

Now I use the next SQL:

SELECT TOP 50
    Comments.author,
    SUM(Comments.pending_payout_value) as pending_payout,
    COUNT(*) as posts,
    SUM(Comments.net_votes) as upvotes,
    Accounts.sbd_balance,
    Accounts.balance,
    Accounts.created
FROM
    Comments
    INNER JOIN Accounts ON Comments.author = Accounts.name
WHERE
    Comments.depth=0 AND
    Comments.created BETWEEN GETDATE()-7 AND GETDATE()
GROUP BY Comments.author, Accounts.sbd_balance, Accounts.balance, Accounts.created
ORDER BY SUM(Comments.pending_payout_value) DESC

My commit

---

Posted on Utopian.io - Rewarding Open Source Contributors

---