SteemSQL Tutorial - I have spent 800 SBD (7000+ USD) buying votes! SteemSQL 教程 - 我花了800多 SBD (7000多美元)买赞。

in #busy7 years ago (edited)

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!

image.png

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"

这下更清楚了:

image.png

除去之前搞活动给 @oflyhigh , @travelgril, @wilkinshui 还有 @yuxi 的几笔小额奖励不算,真的花了7000多美元买赞!特别是之前很大一段时间都在给 @minnowbooster 买赞,一共花了 686.7 SBD。

为啥要买赞?我的原因有:

  • 升级更快
  • 花钱推帖子
  • SEO,帖子超过10块钱左右,文中的链接就是 follow。

所以即使从帐面上看,买赞并不划算,但是考虑到以上三点,也不那么纠结了。

已同步到博文: 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

近期帖子

Sort:  

新人小白问题:高级了有什么好处?

等级高了大家都想和你做朋友,你挣钱挣得越会快。

多谢指教!

我是老人也問了同樣問題,哈哈。

我也是抱着升级的心来用这类服务的

对的,升级更快。

你也买过?我也想快速升级

买买买。

很简单啊,用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.

遊戲的一部分。

好奇查了一下你的:

是的,玩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

存在即合理,哈哈。

这是你的:

我也刷了不少机器人,尤其是randowhale,哈哈。

(@ο@) 哇~ 竟然刚刚看见这个实用贴,目前还在学习中,还有YY银行的用法~~

多谢,这帖子很老了。

Coin Marketplace

STEEM 0.15
TRX 0.12
JST 0.025
BTC 56208.10
ETH 2476.58
USDT 1.00
SBD 2.26