Finally, I also know what I did last summer.

终于我也知道去年夏天我做了什么。

I have been keeping a summary list of my posts in a spreadsheet from the time I started blogging on steemit slightly more than a year ago. It’s hard work. Already 600 rows in the file. Recently, I have been using steemsql.com to generate some statistics and have also did some experiment to figure out all I have posted from last summer...

... and then @joythewanderer also started to wander into steemsql sea. Look at her post.

从一年多前开始这steemit博客的时候，我一直都记录下我发过的帖。也其实有点吃力。文件中已经有600行。最近，我在使用steemsql.com来看看些统计数据，并且实验了而成功找出从去年夏天发布的所有帖。。。
...然后早上也看到 @joythewanderer 也玩到steemsql天地。看她这帖：

My journey in Steemit (383 days, 250 posts, 700+ followers), from my "lottery place" to an open school. Thanks everyone! 也来写写我的Steemit心路历程，真心谢谢大家，顺便试试Steemsql

I saw her query is different from mine. So, I’m showing off mine here. 😎

我看到她写的SQL跟我不同。所以，我在这里炫耀下我的。😎

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 Summer.
让大家继续读的时候，欣赏一点音乐。这件作品是维瓦尔第的“四季”的一部分 - 4小提琴协奏曲中的第一首，名为“夏天”。
Source | 来源: https://musopen.org/

https://soundcloud.com/alan-chang-563971986/2213-vivaldi-four-concerti-grossi-op8-ii-l-estate-allegro-adagio-presto

First shot | 第一把

This query will extract the titles and posts from one author and you can export the result out.

这回帮你将一位用户全部的帖子的主题和网址提出。

SELECT
    created,
    category,
    'https://steemit.com' + url post_link,
    root_title
FROM
   Comments 
WHERE 
    (
        author = 'ace108' ------ A U T H O R
    ) AND
     (
        depth = 0
    )
ORDER BY created DESC

Second shot | 第二把

If you want the result to come out in Markdown formatted list, you can use this instead.

如果您希望在Markdown格式化列表中显示结果，您可以使用此选项。

SELECT 
    '* ['+ title + '](https://steemit.com' + permlink + ')' MD_post_link 
FROM
    comments
WHERE  
    (
        author = 'ace108' ------ A U T H O R
    ) AND
     (
        depth = 0
     )
ORDER BY created DESC

You can copy the results and just paste it into the Steemit Editor. For example, here I copy 4 rows.