After a couple of hours of faffing around I have defeated SQL and have your top 10 curation rewards for April to present....
source
Before today, I wasn't actually aware where my largest curation rewards were coming from. I expected that my vote weight would be higher than average, and wondered if OCDB might be influencing them somewhat, but I wasn't sure where from, what vote time was working, or how much the top earners gave me.
So I thought I'd have a look, and see if there was something I could offer you :)
The columns are as follows:
- Author
- Link to the post/comment
- Number of hours, minutes, seconds the vote was cast following the creation of the post/comment
- Vote weight
- Reward in Vests
- Reward in SP (estimated)
The reward in SP is estimated because we are going back a month, and since the amount of STEEM per MVESTS is constantly moving (upwards), this number will be slightly inaccurate.
Also, as I am checking the curation payouts for April, the content could have been created during the last 7 days of March.
Here's mine for April 2019:
| Author | Link | Vote TD | weight | Vests | SP est |
|---|---|---|---|---|---|
| surfermarly | content | 00:08:30 | 10000 | 3071.56 | 1.540 |
| v4vapid | content | 00:11:15 | 10000 | 2952.32 | 1.480 |
| anomadsoul | content | 00:10:24 | 10000 | 2191.24 | 1.098 |
| v4vapid | content | 00:11:12 | 10000 | 1963.46 | 0.984 |
| v4vapid | content | 00:11:18 | 10000 | 1806.44 | 0.905 |
| anomadsoul | content | 00:10:33 | 10000 | 1602.44 | 0.803 |
| v4vapid | content | 00:11:18 | 10000 | 1516.32 | 0.760 |
| anomadsoul | content | 00:10:33 | 10000 | 1501.33 | 0.752 |
| anomadsoul | content | 00:10:45 | 10000 | 1432.56 | 0.718 |
| anomadsoul | content | 00:10:33 | 10000 | 1366.6 | 0.685 |
So basically, the 100% votes won the day - not a big surprise, but it would have been nice to see a lower vote weight in there too.
The authors are likely known to most of you, and well, they've all been good to me in the past so there we are :)
Two are contests which were backed by a blocktrades vote - that helped, but the top earning one I am very happy to see up there because I sat in the audience watching promoting Steem at a recent blockchain conference in sunny Palma, Mallorca. Fitting that it tops the list I think :)
Looking at the rewards in approximate Steem Power, the top two are more than 3 times the size of my full vote back then which was around 35 - 40 cents. Nice!
The query itself is rather slow at around 5 mins for 1 execution. It's almost certainly my code but I am joining 3 tables together to find the information I want to present.
Anyone interested in a report?
Cheers
Asher