A couple of people (at least I remembered @abcallen and @efongym) have asked about my list of recent posts in my post. I wanted to reply but well.. one busy thing led to another. Now, I decided to share a simple way to do this if you have access too steemsql.com.
有几个人（至少我记得@abcallen和@efongym）在我的帖子中问过我的最近的帖子列表。 我想回复，但忙碌事情一宗由又一宗。 现在，我决定分享一个简单的方法来做到这一点。这方法要有到 steemsql.com 。
🎶Meanwhile, some music for you to enjoy as you read. This piece is part of Vivaldi’s The Four Seasons, particular the second of the 4 violin concertos, called Summer.
🎶让大家继续读的时候，欣赏一点音乐。这件作品是维瓦尔第的“四季”的一部分 - 4小提琴协奏曲中的第2首，名为“夏天”。
Source | 来源: https://musopen.org/
https://soundcloud.com/alan-chang-563971986/2213-vivaldi-four-concerti-grossi-op8-ii-l-estate-allegro-adagio-presto
Source: https://musopen.org/music/2213/antonio-vivaldi/the-four-seasons/
Violin Concerto in G minor, RV 315 'Summer' - Complete Concerto
Unless you are like me who keep a list of all your posts in a spreadsheet, trying to get a list of your posts will require some work. I have been using SteemSQL for various things and one of the thing I experimented with was to find a easy way to list my recent posts with the first image and include them in a new post.
除非你像我一样用微软Excel存你所有帖子的资料，要找出前帖可要一番功夫。 我在使用SteemSQL也找到一种简单的方法，列出我最近的帖子包括帖里的第一张图。
Here is the final SQL I came out with.
这是我最终的SQL.
I'm just extract recent 4 posts in this case and select the result and copy to clipboard.
我就拉出我最近4帖在这里然后拷贝Copy.
Then go to the steemit.com Post editor, right click at the place you want to insert list of the 4 recent posts and paste.
才去steemit.com 发帖，右点击贴进去
Now, lets see how it looks it. Pretty cool, right?
来看看效果如何。够神吧？
Note: Access to SteemSQL is currently provided at subscription fee of 10 SBD per month.
See this post from @arcange for more details:
SteemSQL is moving to a monthly subscription model
Please see my other posts: @ace108
请看我其他帖: @ace108
