Sort:  
  • Trending
    • [-]
     6 years ago 

    Thanks :)

    $0.03
    • Past Payouts $0.03
    • - Author $0.03
    • - Curators $0.01
    3 votes
    Reply
    [-]
     6 years ago 

    I have fixed the issue now. I am using

    SELECT (parent_author + '/' +  parent_permlink), COUNT((parent_author + '/' +  parent_permlink)) FROM [dbo].[Comments] 
where author = 'steemladder' 
 AND created >= DATEADD(day,-1, GETDATE())
 GROUP BY (parent_author + '/' +  parent_permlink);

    To track the number of comments on a post and I am getting only one comment. I will monitor it for couple more days.

    $0.03
    • Past Payouts $0.03
    • - Author $0.02
    • - Curators $0.01
    1 vote
    Reply

    Coin Marketplace

    STEEM 0.23
    TRX 0.24
    JST 0.038
    BTC 95361.20
    ETH 3282.78
    USDT 1.00
    SBD 3.29