#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.

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](https://steemit.com/steemitabuse/@cheetah/cheetah-bot-explained)."
@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](https://steemit.com/steemitabuse/@cheetah/cheetah-bot-explained)."
@muxxybot	@shahaalam19	"`Spam detected...*....` 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.

📷🏁 Stormtrooper again on Monday for #MonochromeMonday | 又见突击兵-单色星期一

🌞#BeautifulSunday Releasing more funky separators - Dogs/Bear- 美丽星期天 发布有趣分隔符-狗/熊

🌞#BeautifulSunday Releasing a funky separator - Dophins - 美丽星期天 发布有趣分隔符-海豚

🌞#BeautifulSunday - Powered up Winners for the week with help of steemsql | 美丽星期天 - 这周赢家找了steemsql帮手

📷🌞Chosen sun from #SunThursday - 1 steem given out - 选择的太阳。。。献阳光星期四 - 送出1steem

📸 bwphotocontest Entry 2 - Kwan Im Thong Hood Cho temple | 黑白照片比赛作品2 -观音堂佛祖庙

#TIL Result of guess and win price of dinner with help of steemsql.com | 通过steemsql.com的帮助，找出猜测晚餐话费的结果

Steemitphotochallenge 📷 # 45 - Entry 3 Yellow Bell | 作品3 黄钟花 (）

---

Please see my other posts: @ace108

请看我其他帖: @ace108

---

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