[SteemRank] Added more data about authors

Words
107
Reading
1 min
9y
Listen to this post
~1 min

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

image.png

Also, miniature-tiger@miniature-tiger did give me the advice about depth=0 and now parent_author='' replaced by depth=0. Thanks miniature-tiger@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

image



Posted on Utopian.io - Rewarding Open Source Contributors

[SteemRank] Added more data about authors | Ecency