You are viewing a single comment's thread from:
RE: Introducing Philippines Steemit Stats BETA - A Database of Users from the Philippines
I connect to steemitdb for bisteemit pero inaaral ko pa powerbi haha. which table/s did you select from?
I connect to steemitdb for bisteemit pero inaaral ko pa powerbi haha. which table/s did you select from?
Selected from Accounts table, "SELECT * FROM ACCOUNTS WHERE NAME = 'yournamehere'" yan po ginawa kong basic query muna para makita ko yung laman. Tapos parse ng json_metadata para ma query ko yung Philippines hehe.
What if ijoin sya sa mga ngtatag ng philippines and pilipinas ?
Yan din gawa ko dati pero in (name1, name2).i stopped nung nasa 200 yung list. Nagawa mo na nasa external txt file ang list?
Hindi ko pa nagagawa yung external txt file, yun nga din naisip ko yung gumagamit ng tags, Subukan ko iquery yun hehe.
meep