SteemSQL Tutorial – I have spent 800 SBD (7000+ USD) buying votes!

money-calculator-potato

I spent around 800 SBD (7000 USD) in buying votes. The following queries the table TxTransfers thanks to @arcange’s STEEMSQL.

1
2
3
4
5

select "from", "to", "memo", (amount)
from TxTransfers (NOLOCK)
where
    "from" = 'justyy' and
    memo like 'http%'   

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.

1
2
3
4
5
6
7

select "to", sum(amount)
from TxTransfers (NOLOCK)
where
    "from" = 'justyy' and
    memo like 'http%'
group by
    "to"

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!

txtransfers-buying-upvotes

Some data should have been excluded from the STEEMSQL resutls, 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?

You may also like: SteemSQL 教程 – 我花了800多 SBD (7000多美元)买赞

STEEM SQL Tutorial

• SteemSQL Tutorial: How to Get Random Posts on SteemIt?
• SteemSQL Tutorial: How to Get Authors Order By Potential Payout in Last 7 days?
• SteemSQL Tutorial: How to Get Historic Posts of Today on SteemIt?
• SteemSQL Tutorial: How to Calculate Monthly Income on STEEMIT?
• SteemSQL Tutorial: Can we Really Recover Deleted Comments/Posts on STEEMIT?
• SteemSQL Tutorial: What are the Outgoing Votes for Big Whales?
• SteemSQL Tutorial: Count Total Interests Sent
• SteemSQL Tutorial: Finding Inactive Steemians that You Follow
• SteemSQL Tutorial: How to Fix “JSON text is not properly formated. Unexpected character ‘.’ is found at position 0.”?
• SteemSQL Tutorial: How to Get the Most Payout Authors in History?
• SteemSQL Tutorial: Get Most Single Payout Authors
• SteemSQL Tutorial: How to Avoid SQL Injection?
• SteemSQL Tutorial: I have spent 800 SBD (7000+ USD) buying votes!
• SteemSQL Tutorial: How to Check If SteemSQL is Synchronized with Steem Blockchain?

–EOF (The Ultimate Computing & Technology Blog) —