I've just generated a list of all my posts since my day 1 on Steem up until now. The SQL query is too long for a Snap, so it's in comments.
If you wanted to do so either.
You are viewing a single comment's thread from:
I've just generated a list of all my posts since my day 1 on Steem up until now. The SQL query is too long for a Snap, so it's in comments.
If you wanted to do so either.
There's a website where you can get all your posts without running an SQL query yourself, which most people can't do (talking about myself)
I haven't heard about it I guess.
you can enter your username in user drill down to get your post list
https://eroche.shinyapps.io/hiveanalytics/
Thanks a lot!
SELECT p.author, p.title, p.permlink, CONCAT('https://peakd.com/@', p.author, '/', p.permlink) AS url, p.created AS publish_date, REPLACE(REPLACE(REPLACE( JSON_QUERY(p.json_metadata, '$.tags'), '[', ''), ']', ''), '"', '') AS tags FROM Comments p WHERE p.author = 'YOUR USERNAME' AND p.parent_author = '' ORDER BY p.created DESC;