For a day to start with, but I couldn't resist having a look around....

For those that aren't aware SteemSQL, and now HiveSQL, are a copy of the blockchain data, stored in a SQL Server database. Witness @arcange runs and manages the service, which is 4 SBB/HBD for 24 hours, or 40 SBD/HBD for a month.

Each database consists of over 60 views (a virtual table based on the result set of a SQL statement) which range from account information, content votes, witness data, rewards, transfers, and much more.

In my time I've come to know some of these views quite well, but there are also a bunch that i've not looked at all, such as TxSMTCreates and the other SMT data. Perhaps these will come into play soon ™.

Today, I'll just pull some basic stuff from tables I've used frequently (on the old chain), which may or may not be of interest to you.

The self-lovers...

select top 20 author, '', count(voter) 
from txvotes where author = voter 
and timestamp > getdate()-7
group by author
order by count(voter) desc

Top 20 voters of own content, past 7 days

A 100% vote is 10000, a 1% vote is 100. Probably some piss-taking there, but i'll leave that up to you to decide who.

Top 20 incoming pay-days...

select top 20 author, sum(pending_payout_value) from comments
where depth = 0 and created > getdate()-7
group by author
order by sum(pending_payout_value) desc

Top 20 authors by pending payouts, posts only.

Well done (4?) ladies and gentlemen. Many HIVE coming your way from week one :)

Top 20 communities by subscribers

select top 20 community, '|', count(subscriber)
from CommunitiesSubscribers
group by community 
order by count(subscriber) desc

This might well be detailed somewhere on PeakD, and if so, with friendlier names!

Top 20 accounts handing out upvotes

select top 20 voter,'|', count(distinct author) from txvotes
where timestamp > getdate()-7
and weight > 0
group by voter 
order by count(author) desc

And last one....

Top 20 accounts dishing out downvotes

select top 20 voter,'|', count(distinct author) from txvotes
where timestamp > getdate()-7
and weight < 0
group by voter 
order by count(distinct author) desc

I make that 3 with a plan, and 17 without :)

Just a note on the Engagement League. I'm still undecided if I'll have another week off, but I think it'll be back sooner rather than later.....

Does anyone want any data pulling specific to their account?

Cheers

Asher