Hey TeamMalaysia users

I managed to extract data of everyone who uses the tag teammalaysia over the past 30 days and calculate how many votes they did over the past 30 days. There were indeed a few surprises.

Quick Stats on TeamMalaysia tag users over past 30 days

Total No. Authors : 744
Total No. of upvotes done by tag users : 215,200

Here are the results of the top 100 upvoters ! This is over the past 30 days how many votes was cast by individuals who had used the TeamMalaysia tags in the past 30 days.

voter	no. of votes
@howtostartablog	9355
@coloringiship	6696
@detlev	6115
@zord189	4616
@elizacheng	3839
@nelkeljdm	3744
@aaronleang	3511
@bitrocker2020	3393
@crypto3d	2920
@myach	2453
@arfa	2267
@teammalaysia	2148
@redpalestino	1866
@vaelriey	1801
@ackhoo	1589
@firepower	1578
@superoo7-dev	1529
@zouxx	1456
@stahlberg	1449
@afifa	1382
@djlethalskillz	1329
@tvb	1308
@halleyleow	1305
@jrvacation	1297
@fikards	1282
@recordpool	1264
@zublizainordin	1246
@awesomianist	1242
@gordon92	1215
@akhyasad	1194
@ryenneleow	1187
@maverickfoo	1148
@darniyuscivil	1146
@tngflx	1145
@branlee87	1137
@sjennon	1130
@kilathecla	1114
@cikxaijen	1092
@danielghufran	1079
@migueltoro	1068
@superoo7	1052
@bring	1048
@will12	1029
@zf90	1027
@khusairi	1024
@rijal8466	982
@winniex	974
@fundurian	881
@steemitguide	856
@nafazul	840
@edmundang	835
@fr3eze	807
@asrizal	800
@alvinauh	797
@littlenewthings	795
@danielwong	789
@wilhb81	783
@toniesteem	777
@inspiredgideon1	770
@amisteem	768
@davidke20	763
@danieldoughty	760
@ihsan19	725
@gtpjfoodbank	724
@debruyne844	721
@auleo	720
@abd.ghafarbahari	705
@choku	699
@calebleejl	661
@vamos-amigo	649
@srimulyani	640
@alexliow	639
@joeliew	630
@vandigital	613
@virgo27	611
@joannewong	607
@iipoh06	600
@juned0292	599
@thunderbirdcomic	595
@sireh	587
@perennial	586
@yumisee	578
@craftsofluv	574
@rafimaulana24	574
@rambai	572
@riezalzulfa	569
@akatsuki28121997	565
@r3aperz	564
@walkinharmony	561
@mutiarahmi	558
@annabellenoelle	557
@orenisme	541
@anthonywong	540
@asyrafahamed	537
@legendchew	536
@nurdinnakaturi	533
@aurah	527
@kymio	525
@aamsteem	521
@mystiquemolly	519

How I obtain the data ?

Thanks to @carlgnash who had helped with the SQL Query. You can run this as well if you would like to see all the stats. You would require to run separate queries to firstly obtain the userlist for the tag.

SELECT
 char(39) + author + char(39) + ', '
FROM
  Comments (NOLOCK)
WHERE
  ISJSON(json_metadata) > 0
AND 'teammalaysia' IN ( SELECT value FROM OPENJSON(json_metadata,'$.tags'))
AND datediff(day, created, GETDATE()) between 0 and 30
AND depth = 0

Once you have obtain the userlist you would need to do another query to obtain the voting count which is based on the userlist results from the above query

SELECT 
  voter, COUNT(permlink)
FROM TxVotes (NOLOCK)
WHERE
  datediff(day, timestamp, GETDATE()) between 0 and 30
AND    voter IN(USERNAMELIST)
GROUP BY
  voter
ORDER BY
  voter asc

That should be able for you to obtain the results as above. Just have to remember the longer the time gap eg. 60 days or 90 days , the longer your entire query will take.

So are you not utilising your upvotes ?

I do understand and respect that you would only vote on quality content which we all would love to do as well. I do suggest that you could follow credible curation trails. The once I follow is @curie , another would be @sndbox and of course if you would like to continuously support #teammalaysia then do follow @teammalaysia curation trail .

How do I follow a trail ?

One of the easiest way to follow a trail is to use http://steemauto.com
You could register yourself first and once you login . On the left menu click Curation Trails and then search for teammalaysia trail

Screen Shot 2018-03-09 at 1.39.33 AM.png

Once you have found it , just click follow and then set your parameters or you could leave it at default. To make sure you do not run out of voting power , you could set the voting % to around 20% . If you set it too low vote may not follow the trail as it would categorized as dust votes and will drop from the trail, unless you have more then 200 steem power then you can set it to below 10%

Screen Shot 2018-03-09 at 1.41.08 AM.png

Summary

If you are planning to go to the jungles for awhile and would like to continue voting , just the curation trail. At least you can obtain curation rewards even though you are away from technology.

Upvoting is a crucial segment of the Steem Blockchain as no one would be able to earn anything if upvotes are not being distributed around. By using steemauto and following a curation trail, you are placing your trust in that individual to cast your votes for you. So do research which curation trails that you are following.

Growing TeamMalaysia | The Upvote Heroes !