RE: RE: HiveSQL: Author Rewards & Curation Rewards
You are viewing a single comment's thread from:

RE: HiveSQL: Author Rewards & Curation Rewards

Words
33
Reading
1 min
Listen
Play
5y

You may have to combine TxVotes table with Comments table using JOIN. Here is an example.

    SELECT v.author, v.permlink, c.title, v.timestamp
    FROM Comments c
    JOIN TxVotes v
    ON c.permlink = v.permlink
    WHERE v.voter = 'geekgirl'
    AND v.author = c.author
    AND c.parent_author = ''
    AND v.timestamp BETWEEN '2022-02-01' AND '2022-03-01'
    ORDER BY v.timestamp ASC

If parent_author is empty or nothing, it would mean it is a post, otherwise it is a comment.

@geekgirl: You may have | Ecency