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