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 @surfermarly 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