Find out who's been the busiest, and the most popular #promo-steem author in the last 7 days.
I wanted to know who's been the most prolific author this week using the beautifully growing #promo-steem tag, so I thought I'd ask SteemSQL.
I thought it might be nice to also find out how many votes each of the top 100 posters got too, just for a giggle.
Note that this data is only taken from those who have posted to the #promo-steem category... that is, #promo-steem is the FIRST tag they use. Posts which are tagged #promo-steem but are in tag position 2 to 5 are NOT counted in this list, just in case you were wondering. Otherwise would probably have about 50,000 posts listed here!
Here are the results of the most prolific author of the week
Big kudos goes to
And now, the results of the most upvotes given to #promo-steem authors
For brevity, I have only listed the accounts who received a combined total of over 150 upvotes on their #promo-steem posts this week. You can see how many upvotes each of the top 100 authors got in the table above.
Massive shoutout to
who smashed it with just a fraction under 400 votes in the last week. A remarkable achievement.
some clever dicks might notice a slight discrepancy between the number of upvotes in the top table and the list below. This is because in the time it took to run 2 reports, a few additional upvotes were received, and I couldn't be bothered going back and re-jigging the data. If you don't like it, tough shit, they don't call me for nothing!
The techie bit
Here is the SQL Query I used to get this information. If you want to do similar things, get a subscription to SteemSQL:
Love, light and laughter.
Anarcotech x