You are viewing a single comment's thread from:

RE: Top 10 most popular posts by comment count in #category/tag - Give me your tags!

in #steemit7 years ago

Hi @abh12345. I wonder if you could help us with the SQL code for this one.

I'm trying to find out how many posts use our #newbieresteemday tag, weekly, monthly, or all time.

As you know @mellofello from our team likes BI and data. He is stubborn though so refuses to subscribe or 'pay' for steemSQL, even though I saved the SBD in the account for when he needs it.

So his bright idea is to query the data directly from the steem blockchain. Or some API layer of it with Privex SBSD (whatever that means). He has successfully done so (or thinks he has since he was able to query our acct's data).

Issue is, he's not sure what the search parameters would be used for 'tags'. I remembered this post of yours, and thought any guidance on tables/field names might be helpful to him.

Sort: