📊[IMPROVED] Top 22 Level 1 commenters for 20170809, active hours and how their comments looks like (by @ace108)
If you are seeing this, it means steemsql is back up to day. Yay.
Top 22 because there is a tie. I begin to see some comments where the end are the same. So, ADDED another table which explains the "..." added from the 2nd table now.
Note: Level 1 commenters are those who leave comment at the first level in reply to a post directly.
Here’s a look are the top level 1 commenters for 20170809. I’ve excluded known bots and curators from this but if anyone has any suggestions, they are most welcome. This serves to inform and you make you own decision whether they are the good, the bad or the ugly. I can only comment once every 20 seconds. Correction: I am only allowed to comment only once every 20 seconds. I type fast and sometimes get that annoying message quite a bit when responding and when I reply on my phone using voice typing, I get that even more. Anyway, 1,000 comments will need at least 333 minutes which is more than 5 and half hours. Hands up those of you who have spent more than 5 hours leaving comments at the first level.
Meanwhile, some music for you to enjoy as you read. This piece is part of Vivaldi’s The Four Seasons, particular the first of the 4 violin concertos, called Summer.
让大家继续读的时候，欣赏一点音乐。这件作品是维瓦尔第的“四季”的一部分 - 4小提琴协奏曲中的第一首，名为“夏天”。
Source | 来源: https://musopen.org/
Top 20 level 1 commenters and their active hours for 20170809
A look at some of their comments
First 28 characters...
| Commenter | First 28 characters | Count |
|---|---|---|
| @ahlawat | Sir, We are very grateful t... | 57 |
| @ahlawat | Sir, please vote for us. We ... | 19 |
| @bellyrub | This post has received a ... | 134 |
| @calibrae | http://listenonrepeat.com/?v... | 22 |
| @calibrae | https://www.youtube.com/watc... | 22 |
| @calibrae | the -16 who has been flagged... | 13 |
| @completelyanon | Great post, thanks for shari... | 143 |
| @danielzorila | Follow me back bro... | 53 |
| @danielzorila | Follow me back... | 38 |
| @danielzorila | Follow back😀... | 25 |
| @danielzorila | Follow back bro... | 14 |
| @djnoel | Nice post my friend i am @d... | 111 |
| @drotto | This post has received a ... | 553 |
| @fitzgibbon | [![baby WELCOME.gif](https:/... | 14 |
| @fitzgibbon | [![BTC.gif](https://steemiti... | 13 |
| @fitzgibbon | [![THANKS SWEETIE.gif](https... | 13 |
| @fitzgibbon | [![TRUMP2.gif](https://steem... | 11 |
| @fitzgibbon | [![PUTIN.gif](https://steemi... | 10 |
| @fitzgibbon | Do you remember when in 2015... | 10 |
| @fitzgibbon | Love your post, upvoted! It ... | 10 |
| @joeyarnoldvn | awesome... | 190 |
| @new-game-coin | Welcome to Steemit!... | 108 |
| @steemking777 | great work! keep it up!... | 11 |
| @voter | "
..." | 162 |
| @wayforhappiness | "Very good contest! 😊👍
htt..." | 59 |
| @wayforhappiness | Very interesting great greet... | 40 |
Last 28 characters...
| Commenter | Last 28 characters | Count |
|---|---|---|
| @ahlawat | ...so. And keep voting. @ahlawa | 57 |
| @ahlawat | ...way.And keep voting. @ahlawa | 13 |
| @bottymcbotface | ...ve upvoted and sent you a ti | 193 |
| @calibrae | "...wird alleine Mein!
Pestlienz" | 36 |
| @calibrae | ...Fa7YsTw#EISENFUNK_-_Pestilen | 23 |
| @completelyanon | ...a vote. I hope you enjoy it | 142 |
| @djnoel | ...etings and have a nice day : | 112 |
| @drotto | ...rotto thanks to: @banjo. | 501 |
| @drotto | ...tto thanks to: @binkley. | 16 |
| @fitzgibbon | ...s an upvote, from me for you | 14 |
| @fitzgibbon | ... it, but don't click the gif | 13 |
| @fitzgibbon | ...ht that's so bitter and cold | 13 |
| @fitzgibbon | ... but here's an upvote. Enjoy | 11 |
| @fitzgibbon | ...have front seats at the show | 11 |
| @fitzgibbon | ... Snowden | 10 |
| @fitzgibbon | ...ts content. I just upvote it | 10 |
| @khunpoom | ...please follow me at @khunpoo | 27 |
| @khunpoom | ...lease follow me at @khunpoo | 20 |
| @khunpoom | ...r account, please follow me | 19 |
| @khunpoom | ... account, please follow me | 14 |
| @khunpoom | ...account, please follow me .. | 13 |
| @steemking777 | ...d thanks again for following | 10 |
| @wayforhappiness | ...uture post lets work togethe | 38 |
| @wayforhappiness | ...n-s-level-of-decentralizatio | 31 |
| @wayforhappiness | ...Upvote%20Resteem%20follow.gi | 20 |
Source of data: steemsql.com
请看我其他帖: @ace108
good work on this report @ace108 appriciate ur this work to share all toper
Thank you and thanks for your comment.
Very good post. . @ace108
Thanks and thank you for your comment
i appreciate ur work and upvoted you
good work keep it up..
Thank you and thanks for your comment
good work - good analysis. What's the next step? Are these accounts (with mostly 'follow me' quotes) going to be identified as 'spammers'? I've seen other steemians suggesting this.
This information is provided for you do interpret and decided what you want to do.
Thanks for your comment.
OK, this will be a good resource for them to reference. (I'm outside the loop) I'm a mini-minnow, not picking a fight or creating controversy with anyone.
.
Thank you for compiling these commentators stats @ace108. Hopefully I will make it to that list someday :)
You're welcome. I hope you don't make into the list in the wrong way. Thanks for your comment.
I recognise some of those names..wonder if a spammer list would be made and if their names might crown that one ;)
I kind wonder for a month who top the list but I won't afraid the query would take a long time to run and so didn't bother to modify it kaypoh. :-)
haha how long does it take to run the analysis for a day?