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, did give me the advice about
depth=0 and now parent_author='' replaced by depth=0. Thanks !
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
Posted on Utopian.io - Rewarding Open Source Contributors