SteemSQL Tutorial - I have spent 800 SBD (7000+ USD) buying votes! SteemSQL 教程 - 我花了800多 SBD (7000多美元)买赞。
I spent around 800 SBD (7000 USD) in buying votes. The following queries the table TxTransfers
thanks to @arcange's STEEMSQL
select "from", "to", "memo", (amount)
from TxTransfers (NOLOCK)
where
"from" = 'justyy' and
memo like 'http%'
This will list all the transfers with memo starting "http". If we group the results, we know exactly how much have been sent to per vote-buying ID.
select "to", sum(amount)
from TxTransfers (NOLOCK)
where
"from" = 'justyy' and
memo like 'http%'
group by
"to"
This is clear and I did spend a lot in this!
Some data should have been excluded from the SteemSQL results, for example, the SBD sent to @oflyhigh, @travelgirl, @wilkinshui and @yuxi were not for buying votes. The biggest service I use is @minnowbooster which I have spent 686.7 SBD, Gosh!
Why buy votes? My reasons are:
- Increase your Reputation faster
- Promote your posts
- SEO, the posts worth more than 10 USD have do-follow links
This might still be useful and reasonable to use these services. What do you think?
Image Credit: Pixabay.com
不查不知道,一查吓一跳,我前前后后花了大概800多 SBD买赞!按市价就是7000多美元!天啊撸。查询如下:
select "from", "to", "memo", (amount)
from TxTransfers (NOLOCK)
where
"from" = 'justyy' and
memo like 'http%'
这个语句显示了所有买赞的记录,我们再细分一下,按 "to" 来分组:
select "to", sum(amount)
from TxTransfers (NOLOCK)
where
"from" = 'justyy' and
memo like 'http%'
group by
"to"
这下更清楚了:
除去之前搞活动给 @oflyhigh , @travelgril, @wilkinshui 还有 @yuxi 的几笔小额奖励不算,真的花了7000多美元买赞!特别是之前很大一段时间都在给 @minnowbooster 买赞,一共花了 686.7 SBD。
为啥要买赞?我的原因有:
所以即使从帐面上看,买赞并不划算,但是考虑到以上三点,也不那么纠结了。
已同步到博文: https://justyy.com/archives/5772
AD 一波,最近SBD涨到10块钱了,SBD比SP值钱多了,所以你把钱存在YY银行是很划算的,YY银行吃的是草(借的SP),挤的是奶啊(值钱的SBD), 每日发 SBD利息,从不间断,提前祝YY股东们圣诞快乐,新年快乐,股东们都在2018里赚大钱,实现财务自由啊!
通过 SP 代理工具 成为 YY银行股东,好处多多。只要代理大于10 SP给 @justyy 即可自动成为YY股东。
SteemIt 教程、机器人、在线工具和API接口
SteemIt Tutorials, Robots, Tools and APIs
新人小白问题:高级了有什么好处?
等级高了大家都想和你做朋友,你挣钱挣得越会快。
多谢指教!
我是老人也問了同樣問題,哈哈。
😄
我也是抱着升级的心来用这类服务的
对的,升级更快。
你也买过?我也想快速升级
买买买。
很简单啊,用minnowbooster或是randowhale 等等。
very interesting post...
Thanks for sharing it...
upvoted and followed...!!!
Ahhh I saw my name thinking I don’t have enough sp to sell votes hahha! Yes it’s for a comp lol
yes. that was long time ago.
遊戲的一部分。
好奇查了一下你的:
![](https://steemitimages.com/DQmcBTmkZiLj4mXGxox7KKF79LNyKh11cMvsSKPohVHamxS/image.png)
是的,玩STEEM升级很好玩。
This post has received a 1.32 % upvote from @buildawhale thanks to: @justyy. Send at least 1 SBD to @buildawhale with a post link in the memo field for a portion of the next vote.
To support our daily curation initiative, please vote on my owner, @themarkymark, as a Steem Witness
存在即合理,哈哈。
这是你的:
![](https://steemitimages.com/640x0/https://steemitimages.com/DQma9VmWLRq2yCnagKzFSV2qZiFekciCJmdNghBBNYvfxyi/image.png)
我也刷了不少机器人,尤其是randowhale,哈哈。
(@ο@) 哇~ 竟然刚刚看见这个实用贴,目前还在学习中,还有YY银行的用法~~
多谢,这帖子很老了。