#TIL Another use case of STEEMSQL - see for yourself are there spam comments or not? (by @ace108)



Today, I was playing with steemsql.com and looking at some comments and there's been talk of spam happening. So, wondering if I could do #myexperiment to use steem.sql to look at 2nd level comment presumably from the author responding to the person who left a comment. Below is a table of comments in the last 24 hours which I extracted and believe it's the author responding to spam. I extracted the comments based on some criteria. This is by no means fool proofed or exhaustive but I thought I just draw it out for you to see can comment and decided for yourself. You can probably learn something about responding to spammy type of comment. I'm sure I did. You can click on the link in the RESPONSE column to see the original response in the post.



SEPARATOR-Dolphins In on Blue

Recent Post

RESPONDER RESPONDED TO RESPONSE
@ipkiss @mcnamara Stop spamming people with your random comments!
@ipkiss @doanthuy Stop spamming people with your random comments!
@thecryptofiend @fazulujjan Or maybe I flag you instead for spamming?
@olegw @diegobusel SPAM!
@thecryptofiend @muneshtharinda This is spam and if you do it again I will flag you.
@markangeltrueman @dihoa Spambot, go away
@jwolf @raviraj4you pleas don't spam with links
@markangeltrueman @tuyetthi Spambot go away.
@markangeltrueman @doanthuy Spambot, go away
@adm @jeicko19 "High quality translations are welcomed. But we do not welcome spamming #cn with Google translated content!"
@richguy @rahulsingh01 I will visit your blog but know that some people might consider this a spam and flag you.
@karenmckersie @dongbich nice pictures !!! ??? Stop spamming my posts !
@teamhumble @kovilvns spammer, muted.
@nzfxtrader @gwelton Good to have some tins of spam in storage... stuff lasts forever ;)
@kid4life @tuyetthi How can such a little girl be such a big spam in the ass? ...
@calamus056 @jacksonoskele Because the vast majority of people had no power before June 20th and didn't notice the problem. Now everyone know about it and people finally realize it's a problem. People are mainly against self-voting spam comments.
@troyvandeventer @rupaibabu Flagged for comment spam. Your comment adds no value to this post.
@troyvandeventer @kumaran444 Flagged for comment spam. Your comment adds no value to this post.
@troyvandeventer @krpawarssc Flagged for comment spam. Your comment adds no value to this post.
@tinashe @dinar Did you even read this blog or you are just spamming?
@fakj94 @tuyetthi But Im not in the photograph hahahahahaha Spam (?)
@kid4life @good-joinned "Ty Troll! -- Spam/copy/paste I do not care... Come again pls...

I WAS JUST TALKING ABOUT YOU...

Looks like you are the dumb one, right?:)"

@alexanarcho @juanpchica boring spam...
@dutch @vortac There is a lot of this Boid spam appearing lately... Very weird.
@rach @djnoel Hola @djnoel. Por favor deja de estar haciendo "SPAM"; has colocado este mismo comentario en centenares de publicaciones.
@chinadaily @coldhair 可惜里边有不少SPAMER
@tarazkp @jkly87 "That is an interesting method for the bots. Even a different coloured reputation flag might work. what of the humans that spam?

Edit: Not just spam, spam but spam useless nonsense."

@mrwanderlust @yash0108 stop spamming please...
@retiredinsamar @davidzack A spammer spamming another spammer! Unfollowed!
@steemcleaners @farhannaqvi7 "Spamming comments is frowned upon by the community.

Continued comment spamming may result in action from the cheetah bot."

@quinneaker @bassemm you will get flagged for spam posting links on others pages. We won't do it because we are benevolent but many will. Only trying to help u have a chance at success here.
@steemcleaners @aryan12o "Spamming comments is frowned upon by the community.

Continued comment spamming may result in action from the cheetah bot."

@muxxybot @shahaalam19 "`Spam detected...*....`

<img class="markdown-img-link" src="https://steemitimages.com/0x0/https://gmuxx.files.wordpress.com/2017/07/bot-detected-muxxy.png" "/>

@sgnsteems @palashjyotinath Hello @palashjyotinah. We do not participate in upvote for upvote. You are welcome to upvote if you like the content. Please do not *spam* by putting other links, unless people ask for it..and welcome to steemit!
@sgnsteems @shahaalam19 Hi @shashaalam19! Like I told another user: A suggestion: When leaving comments, do not leave your own links...people may flag you. That can be considered *spam*. Maybe you didn't know, so I wanted to let you know, and welcome to steemit!
@sgnsteems @kishore1988 Hello @kishore1988. A suggestion: When leaving comments, do not leave your own links...people may flag you. That can be considered *spam*. Maybe you didn't know, so I wanted to let you know, and welcome to steemit!
@barrydutton @iqbalmaulana Don't write spammy comments in posts with nothing to offer on the topic.
@barrydutton @ivylifestyle Don't write spammy comments in posts with nothing to offer on the topic.
@stevescoins @raviraj4you "spam spam spam spam spam spam spam spam

I'd suggest you change this comment to something more appropriate to the post you are commenting on"

@barrydutton @matuca Pls don't spam your post with nothing but a link. You will be flagged and your account damaged.
@joeyrocketfilms @crooklyncat Because ponzi. I think the referee program is amazing but it attracts the kind of people that spend 23/24 hours of the day spamming their link and it annoys people. I think that has a lot to do with it.
FIRST2
📷🏁 Stormtrooper again on Monday for #MonochromeMonday | 又见突击兵-单色星期一
FIRST3
🌞#BeautifulSunday Releasing more funky separators - Dogs/Bear- 美丽星期天 发布有趣分隔符-狗/熊
FIRST4
🌞#BeautifulSunday Releasing a funky separator - Dophins - 美丽星期天 发布有趣分隔符-海豚
FIRST5
🌞#BeautifulSunday - Powered up Winners for the week with help of steemsql | 美丽星期天 - 这周赢家找了steemsql帮手
FIRST6
📷🌞Chosen sun from #SunThursday - 1 steem given out - 选择的太阳。。。献阳光星期四 - 送出1steem
FIRST7
📸 bwphotocontest Entry 2 - Kwan Im Thong Hood Cho temple | 黑白照片比赛作品2 -观音堂佛祖庙
FIRST8
#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助,找出猜测晚餐话费的结果
FIRST9
Steemitphotochallenge 📷 # 45 - Entry 3 Yellow Bell | 作品3 黄钟花 ()

Please see my other posts: @ace108
请看我其他帖: @ace108

ACE108-SignatureV1Bc45c8.gif

FollowACE108-1cdc5f.gif

I See👀. I Shoot📷. I Steemit♨️.



H2
H3
H4
3 columns
2 columns
1 column
30 Comments