[SteemRank] Top authors by pending payout

What authors have the best content? Who are they? How much they are getting? How many posts they are writing? SteemRank has answers to all questions!

Right now it has only a rating of authors which is sorted by their pending payout. But the project will be bigger — the main idea is an analysis of the best parts of Steemit.

It was developed with SteemSQL Wrapper API. In fact, it is only one static page with some jQuery code which sends requests to SteemSQL Wrapper and then renders results.

I will rewrite it to Vue when the project becomes big.

The SQL which I use in my requests:

SELECT TOP 50 author, SUM(pending_payout_value) as pending_payout, COUNT(*) as posts
FROM Comments
WHERE
    parent_author='' AND
    created BETWEEN GETDATE()-7 AND GETDATE()
GROUP BY author
ORDER BY SUM(pending_payout_value) DESC

TO-DO List:

• Statistics about average data (pending payout, upvotes, posts, etc)
• Redesign and detailed info about authors (followers, reputation, steem power, avatars, location, etc)
• Other ratings of authors (by upvotes, comments, and more)
• Historical data
• Data visualizations

My commit

---

Posted on Utopian.io - Rewarding Open Source Contributors

---