New Uganda Steemians - please follow, upvote and support them

achimmertens (69)in #promo-steem • 7 years ago

Hello,

nine days ago I wrote the post 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

#steemit #uganda #africa #steem

7 years ago in #promo-steem by achimmertens (69)

$3.66

15 votes

Sort:

Trending

[-]

jaraumoses (69) 7 years ago

Thanks for this list,i know some of them and am going to contact the others in the list.

$0.07

2 votes

[-]

achimmertens (69) 7 years ago

Hi Jarau,
Thank you!

Regards, Achim

$0.00

[-]

arcange (78) 7 years ago

Please avoid using LIKE in queries when targeting the Comments table. This is resource killing for the server as the Comments table contains nearly 50 million rows.

json_metadata is FTS (Full Text Search ) enabled. You can use CONTAINS() predicate.

Replace json_metadata like '%uganda%' with CONTAINS(json_metadata, 'uganda') in your queries. It will execute MUCH faster and won't penalize other users!