New Uganda Steemians - please follow, upvote and support them
promo-steem·@achimmertens·
0.000 HBDNew Uganda Steemians - please follow, upvote and support them
Hello, nine days ago I wrote the post [Bad News: New Steemians Are Left Alone](https://steemit.com/promo-steem/@achimmertens/bad-news-new-steemians-are-left-alone). I listed a set of people that are new on Steemit and I showed, that only about 20% of them are active now. I suggested to all promotors to tell the newbies to set their location country, so that I'm able to find them on the SteemSQL-database. So here are my new statistics and my please to care about the listet people below:     And here are the beginners in steemit from April and May 2018. Please click at them and upvote their posts: > select year(a.created) as year, month(a.created) as 'Month', a.name from Accounts a where a.json_metadata like '%uganda%' order by year(a.created), month(a.created) @kihurankuba @hazaharu @tysonvega @arinherbz @mastermind70 @keddi @sebitosi @babz-otim @daveberry @olivegift @evangelistjotham @mwamin7 @seacrets123 @artdooor @wesongaivan @julianbonita @elmanaa @getitright @hydrazine @kasha256 @leotek @kalmz @rukundodax @blessings100 @ogwang @sheevan10 If there are other newbies from Uganda you know about (then they have not set the location-field='Uganda'), please add them in the comments. Here one can see how busy they are: > select author, count (author) as 'count of posts' from comments where author in (Select name from accounts where json_metadata like '%uganda%' and (month(created)='4' or month(created)='5') and year(created)='2018' ) group by author order by author User | Number Of Comments (Posts or Replies) --------|------------- @arinherbz | 51 @artdooor |15 @blessings100 |1 @daveberry |35 @elmanaa |17 @evangelistjotham |58 @getitright |1 @hazaharu |188 @hydrazine |3 @julianbonita |8 @kalmz |8 @keddi |2 @kihurankuba |4 @leotek |4 @mastermind70 |2 @mwamin7 |56 @ogwang |1 @olivegift |3| @rukundodax |4 @seacrets123 |24 @sheevan10 |21 @tysonvega |41 @wesongaivan |12 Regards, Achim