You are viewing a single comment's thread from:

RE: Looking at the numbers from Steepshot // January - May 2018

in #utopian-io • 7 years ago

It is not complex as you think.
First of all

depth > 0

filters post, leaving only comments

Then author not in (......) removes comments from the authors in the bracket

REFERENCE

https://www.w3schools.com/sql/sql_in.asp

https://steemit.com/utopian-io/@paulag/analysis-of-steemit-bidbot-business-steemit-business-intelligence

7 years ago in #utopian-io by
$0.00
    Reply 1
    Sort:  
  • Trending
    • [-]
     7 years ago 

    Hi @jingis07, thanks for your explanation. Now I understand: your query gets all comments done via steepshot, but does not include comments done via steemit, busy, etc,. Filtering out the bot authors on those comments probably makes no difference, since the bots don't post via steepshot anyway but use other/custom app settings in json_metadata. So the actual engagement level on steepshot posts is likely to be higher than the numbers you've shown.
    I think it could work to get all replies to a steepshot post by joining Comments as posts with Comments as replies on posts.permlink = replies.parent_permlink etc... In that case your author exclude list could be used to filter out the bot replies.

    $0.00
      Reply

      Coin Marketplace

      STEEM 0.13
      TRX 0.34
      JST 0.035
      BTC 111391.51
      ETH 4339.37
      SBD 0.84