Sometime ago, I used steemsql to figure out all my posts ever and shared the details in this previous posts:

#TIL I know what you did last summer😎 | 我知道你去年夏天做了什么😎

🎶Meanwhile, some music for you to enjoy as you read. This piece is part of Vivaldi’s The Four Seasons, particular the first of the 4 violin concertos, called Autumn.
🎶让大家继续读的时候，欣赏一点音乐。这件作品是维瓦尔第的“四季”的一部分 - 4小提琴协奏曲中的第一首，名为“秋天”。
Source | 来源: https://musopen.org/

Updating … | 改进。。。第一把

This new query will extract the tags, title, posts from one author and also Markdown formatted list and you can export the result out all in one file instead of two.

这回改进让你将一位用户全部的帖子的标签，标题，网址，Markdown格式化一次过一起提出。


SELECT 
    created,
    Category,
   JSON_VALUE(json_metadata,'$.tags[0]') tag1,   
   JSON_VALUE(json_metadata,'$.tags[1]') tag2, 
   JSON_VALUE(json_metadata,'$.tags[2]') tag3,
   JSON_VALUE(json_metadata,'$.tags[3]') tag4,
   JSON_VALUE(json_metadata,'$.tags[4]') tag5,
    root_title,
    'https://steemit.com' + url post_link,
    '* ['+ title + '](https://steemit.com' + permlink + ')' MD_post_link,
    '' + 
    '' +
    root_title + '' +
    '' html_link
FROM
    Comments cm WITH (NOLOCK)
WHERE
    (
        author = 'ace108' ------ A U T H O R
    ) AND
     (
        depth = 0
    ) AND 
    created >= DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0)   ---- FOR THIS YEAR ONLY
ORDER BY created DESC

You can copy a column of the result you want to a text file and edit quite easily. In the first part, you can see the tags are in different columns.

您可以将所需结果相当容易的列复制到其他文件中进行的编辑。在第一部分中，您可以看到标签在不同的列中。

IMAGE LINK|图片链接: https://supload.com/H1xfOU57pZ

Next is the post title and a link to the post.

接下来是帖的标题和一个链接。

IMAGE LINK|图片链接: https://supload.com/B1ZfdUqXp-

Lastly, these 2 columns are in Markdown and HTML. You can easily copy out the HTML one into a table or copy the Markdown one into your post or comment.