Part I - Finds community roles in #aceh category on steemit media

I. Scope of Analysis

• Date of analysis: Saturday 10.02.2018
• Duration of data analyzed: from 18.09.2016 to 07.11.2016

II. Tool

• Microsoft Excel gets data from SteemSQL;
  

IV. SQL query to get data below from the database:

select * FROM Comments (NOLOCK) where created> = ('2016-09-18T00: 00: 00.000Z') and created <('2016-11-07T00: 00: 00.000Z' ) and depth = 0 and json_metadata like '% "aceh"%'

As for this analysis to find the first party contributing to the #aceh category on steemit, I looked for how many of them and how many articles they loaded so that in the main category they linked #aceh.

After searching the steemit database, I found the first 16 people using #aceh , and the following analyst data complete with their link post:

---

Author	Post Link	Date
@lukmanreyes	post	9/18/16 14:25
@ardyach	post	10/20/16 16:37
@keuudeip	post	10/20/16 16:44
@mapesa	post	10/21/16 5:18
@vannour	post	10/22/16 5:38
@steemcultures	post	10/22/16 17:31
@zaki.akhyar	post	10/23/16 15:30
@steemvest17	post	10/23/16 19:09
@curiesea	post	10/27/16 11:16
@safar01	post	10/27/16 20:50
@steemwart	post	10/31/16 14:03
@muhtadiaremi	post	10/31/16 21:30
@yonmusa	post	11/3/16 21:21
@alexsteem	post	11/7/16 8:33
@cih	post	11/7/16 8:33

---

The above table data shows a number of users who first use hastaq #aceh on their posts. The most contribute to #aceh from 9/18/16 - 11/7/16 is as follows:

| Hive account@keuudeip | Hive account@vannour | Hive account@anasz | Hive account@mapesa | Hive account@steemvest17 | Hive account@curiesea | Hive account@safar01 | Hive account@steemcultures |

And recorded on the database, that Hive account@lukmanreyes has been disabled. So that in the whole databases will appear as in the following Row Table, there we can find the amount of their contribution I have mentioned his name over in the time bracket from 9/18/16 - 11/7/16:

The hastag categories used do not all put #aceh on the main hastag, only some of them use it at first:

75% Using #aceh category in main part is | Hive account@mapesa | Hive account@vannour | time bracket from 9/18/16 - 11/7/16.

From my analysis of the use of #aceh categories on Steemit, it was first performed by those I have mentioned above and in accordance with the data on the steemitsql.com server. As for them use in a post or article that original/official discuss about aceh, be it culture, natural portrait, history and so on. I also found some performance done by Hive account@vannour in an effort to grow a #aceh rating . He has really created a quality and official content with members of the time.

But they as the main people in forming #aceh , in those days have actually done an evaluation of the post or any contents that go to #aceh , so often they teach to those who are wrong in the use of categories.

---

Posted on Utopian.io - Rewarding Open Source Contributors

---