I Will Share Some of the Things that I Learned ...

---

For Reference: Evolved08gsr's SteemSQL Analysis - Post #001 - Working to Identify and Eradicate Spam Accounts
Note: The results listed below are limited to Comments Posted Since June 1, 2017.

---

Lesson #1:

• There are SO MANY BOTS on Steemit!

The results from my queries have uncovered countless bots. Some of the bots are "harmless", mostly welcoming people to Steemit.

Let's take a quick look at this one..

This account has some recent, seemingly-human comments, followed by a plethora of: "I am a bot..." comments .. and this freaking bot has a higher reputation than me! (I'm at 48 at the time of this post):

Oh, and here's another fun one.. a bot trying to scam people and effectively diminish the Rewards Pool:

If you look closely, this bot even managed to get a reputation of 44!! It also started getting flagged, but only after it gained a sizable reputation. This bot is also cashing out (powering down)..

Potential Solution For #1:

• Prevent bots from taking over Steemit by removing them from the Rewards Pool.

If you set up a bot, I would offer that you are not allowed to contribute to, or be rewarded from, the Rewards Pool.
Said in another way: The Bot can't upvote or be upvoted! And here is why:

1. Bots are not people.
2. Bots are not "adding value" by being in the community.
3. No, Even if you're "supporting minnows" with the bot, You're not contributing to the community.
4. By "supporting minnows" with the bot, You're now Creating A New Problem which shouldn't exist. New Users believe that it's easy to get upvotes just from posting in the [introduceyourself] section.
5. If you built the bot to "Help the Community", then you should have no problem with not taking any rewards for it.
6. If you built the bot to "Make Money", then you don't understand the idea behind Steemit and you can, respectfully, leave the community and please take your bot with you.

---

Lesson #2:

• I don't have nearly enough time to spend working through this process alone.

I really want to see this project through, but considering every time that I run my analysis I need to then Manually comb through each of the results to review the Potential Spam Account list, I just can't dedicate enough of my time here. If anyone wants to talk through the process that I have taken already and build from my query, I am happy to share the SQL code and let you take over.

With that said, I would continue to offer my assistance from the strategic side (how to get fewer false positives and/or false negatives).

Potential Solution For #2:

• If you want to take over where I left off in my code, Please post a comment below and I'll share it with you. The reason I'm not simply posting the logic here is because I don't want those who create the bots to easily identify the logic I'm using in my query and create work-arounds in their bots so they're not caught by the query.

Sounds a bit paranoid, I know .. but that's just my nature. Trust, but verify!

---

Lesson #3:

• Feel free to review these results from my latest query. I filtered this list on results with fewer than 10 unique repeated comments.

Potential Solution For #3:

• The potential solution is in your hands ...
  
  
  
  You can copy/paste from the list below:

TXC_author	Unique Number of Repeated Comments	Total Repeated Comments Posted	Total Posts and Comments	Number of Days with Repeated Comments	Number of Days Since Account Created
zcgolf16	3	299	496	1	77
toscani40	1	249	646	1	48
readallaboutit	2	197	2968	1	78
maxcim7	1	130	133	1	22
tha199	2	129	181	1	18
hicpress	1	126	226	1	35
dobroman	2	117	119	1	15
amarie	3	111	1373	1	49
isacoin	2	110	1434	1	50
steem-global	3	108	181	1	317
tarunmewara	3	106	387	1	50
martinio6	1	106	428	1	41
brazilfootball	1	102	271	1	37
oddi18	4	100	505	1	37
llange	1	97	172	1	78
poetrytrail	1	97	229	1	32
tzar	1	97	137	1	40
ehuston	6	95	1212	1	17
playhard	5	93	177	1	273
inviter	2	87	1396	1	46
crystalpark	1	85	123	1	49
steemitkorea	2	81	240	1	154
punitchoudhary	2	81	702	1	48
sircork	2	78	3596	1	49
andren	1	77	548	1	11
ritikch	2	77	138	1	20
vingary	1	77	83	1	18
nmotwani21	3	75	213	1	20
benniebanana	1	74	542	1	56
catslover	2	74	133	1	12
ethical-ai	1	73	136	1	355
trevis	2	71	253	1	131
ridi20	1	71	981	1	57
krisii	1	68	449	1	56
mianfahad	2	67	110	1	23
whalegonewild	2	66	101	1	32

---

Lesson #4:

• There are so many other interesting analyses that I want to do, specifically related to the distribution of the Rewards Pool since HF 0.19.0 was rolled out.

I'm not sure if others have noticed, but I see that the overall rewards pool seems to have dropped significantly, outside of the whale realm. (Maybe even for whales too?).

Potential Solution For #4:

• Stay Tuned for Post #003!

---

_____________________________________________________

Thanks for reading, I hope you have a great day! _____________________________________________________

Follow My Daddy Daycare Adventure Here:

• The Start of a New Journey - Daddy Daycare Week!
• Evolved08gsr's Daddy Daycare Week - Day 1 (Last Night, This Morning)
• Evolved08gsr's Daddy Daycare Week - Day 1 (End of the Day)
• Evolved08gsr's Daddy Daycare Week - Day 2 (Morning Update)
  
  

If you want to read more, please take a look at some of my other posts:

• All of my Posts!
• Evolved08gsr's SteemSQL Analysis - Post #001 - Working to Identify and Eradicate Spam Accounts
• Evolved08gsr's Steemit Navigation Tips
• Evolved08gsr's Travel in NYC - Rooftop Views
• Steemit Goal(s) for this week and beyond!
• Evolved08gsr's Dabbling into Cryptocurrencies
• Evolved08gsr's Travel - Roaming Photos in NYC
• Evolved08gsr's Weekend Photography
• The True Minnow Challenge