The Posts with Top Payout 史上收入最高的帖子 💰

天然金块 -拍于美国国家自然博物馆

刚才看 @fundurian的帖子里提到了一个收益三万多美元的帖子，于是想到可以用SteemSQL查询一下有史以来收入最高的帖子。

正好昨天看了 @justyy在讲有关收益的问题，我就测试了一下有关帖子收益total_payout_value, curator_payout_value, total_pending_payout_value, pending_payout_value，发现结果完全不靠谱。

我做了些有限的测试，发现

• total_pending_payout_value永远是零
• pending_payout_value和（total_payout_value, curator_payout_value）有时前者是0，有时后者是0，完全找不到规律
• 这几个量值即使不是0跟Steemit显示的收入也经常对不上号

如果把pending_payout_value，total_payout_value，curator_payout_value三个量全部加起来倒是基本和帖子的总收入差不多。反正也不是搞科学研究，差不多就行。就假设这个是帖子的总收入，就可以写代码了。

我用下面这段代码查询收入最高的帖子：

select Top 50
    created, author, (total_payout_value + curator_payout_value + pending_payout_value) as Value, 
    url
from 
    Comments 
where
    title <> ''
order by
    Value desc

全站收入的前五名分别是：

1. $46,973.86 https://steemit.com/piston/@xeroc/piston-web-first-open-source-steem-gui---searching-for-alpha-testers
2. $31,543.06 https://steemit.com/beauty/@guerrint/the-first-steemit-makeup-turtorial-bringing-youtubers-to-steemit
3. $27,037.14 https://steemit.com/money/@steemdrive/sa-s-city-of-durban-to-be-engulfed-by-steem-the-world-to-follow
4. $25,602.00 https://steemit.com/steemit/@cass/steemit-chat-foss-alternative-to-slack-deployed-with-rocketchat
5. $22,434.85 https://steemit.com/money/introduceyourself/@jl777/steemit-is-crypto-s-first-mass-market-solution

修改一下代码，查询category是cn的收入前五名是

1. $2,604.99 https://steemit.com/cn/@teamsteem/this-post-is-going-to-become-the-best-paid-post-today
2. $1,128.28 https://steemit.com/cn/@anwenbaumeister/a-clarification-on-my-translation-project-and-5-how-to-deal-with-bad-times-in-life-5-tips-to-make-you-feel-better-featuring
3. $1,014.86 https://steemit.com/cn/@rea/my-adventure-on-the-island-of-crete-day-5
4. $893.26 https://steemit.com/cn/@abit/steem-v0-12-0
5. $804.52 https://steemit.com/cn/@rea/my-adventure-on-the-island-of-crete-day-7

再修改程序，查询九月份收入最高的cn贴($350.58)是@ygern的 https://steemit.com/cn/@ygern/chinese-version-of-the-steem-whitepaper-steem

全站九月份收入最高的帖子($784.55)是 https://steemit.com/dtube/@heimindanger/dtube-0-3-this-update-contains-so-many-new-features-i-could-not-find-a-good-title-for-it

---

SteemSQL系列

• Use MacBook to Access SteemSQL and Find Delegator 用Mac搜索SteemSQL查询SP代理
• Show Rank of Reputation with SteemSQL 用SteemSQL显示声望排名

---

游记系列

• One Day in Lisbon 里斯本一日
• Journey of China in 2017 中国之旅
• Journey of New Zealand South Island 新西兰南岛之行

---

© Copyright 所有照片与文字皆为 @nationalpark原创。All photos taken by @nationalpark. All rights reserved.