天然金块 -拍于美国国家自然博物馆
刚才看 @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
全站收入的前五名分别是：
- $46,973.86 @xeroc/piston-web-first-open-source-steem-gui---searching-for-alpha-testers
- $31,543.06 @guerrint/the-first-steemit-makeup-turtorial-bringing-youtubers-to-steemit
- $27,037.14 @steemdrive/sa-s-city-of-durban-to-be-engulfed-by-steem-the-world-to-follow
- $25,602.00 @cass/steemit-chat-foss-alternative-to-slack-deployed-with-rocketchat
- $22,434.85 @jl777/steemit-is-crypto-s-first-mass-market-solution
修改一下代码，查询category是cn的收入前五名是
- $2,604.99 @teamsteem/this-post-is-going-to-become-the-best-paid-post-today
- $1,128.28 @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
- $1,014.86 @rea/my-adventure-on-the-island-of-crete-day-5
- $893.26 @abit/steem-v0-12-0
- $804.52 @rea/my-adventure-on-the-island-of-crete-day-7
再修改程序，查询九月份收入最高的cn贴($350.58)是@ygern的 @ygern/chinese-version-of-the-steem-whitepaper-steem
全站九月份收入最高的帖子($784.55)是 @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显示声望排名
游记系列
© Copyright 所有照片与文字皆为 @nationalpark原创。All photos taken by @nationalpark. All rights reserved.