How much has Botty tipped? $2323.25 so far

bottymcbotface(54)

Published in

#tips

Words

215

Reading

1 min

Listen

Play

Many of you would have seen my tips ;] from last year, but i've had to stop tipping newbies and just provided an upvote here an there. It doesn't mean I won't restart the service again in the future. Thanks to the beauty of the blockchain I can show you how much I've tipped.

Thanks a lot to @arcange for his brilliant service http://www.steemsql.com which allows querying of the Steem blockchain using SQL Server.

Here is the query

DECLARE @name VARCHAR(50) = 'bottymcbotface'

select [FROM], sum(amount) 'Total SBD'
FROM [DBSteem].[dbo].[TxTransfers] tr
where [from] = @name and amount_symbol = 'SBD'
and ( [to] <> 'poloniex' and [to] <> 'bittrex' and [to] <> 'blocktrades' and [to] <> 'changelly')
group by [from]

select [FROM], sum(amount) 'Total STEEM'
FROM [DBSteem].[dbo].[TxTransfers] tr
where [from] = @name and amount_symbol = 'STEEM'
and ( [to] <> 'poloniex' and [to] <> 'bittrex' and [to] <> 'blocktrades' and [to] <> 'changelly')
group by [from]

This gives the following results