Easy peasy way to list your recent posts with SteemSQL | 用SteemSQL简简单单列出你最近的帖 (by @ace108)
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.
🎶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.
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.
Here is the final SQL I came out with.
I'm just extract recent 4 posts in this case and select the result and copy to clipboard.
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.
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.
有几个人（至少我记得@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
请看我其他帖: @ace108
进来学习：）
你该是师傅啦。
upvote for me please? https://steemit.com/news/@bible.com/6h36cq
码农在steemit上还是用处非常大的
ꉂ ೭(˵¯̴͒ꇴ¯̴͒˵)౨”哇哈哈～
是的。多点想象就多点用途。
你好吗？什么？你还没参加 齐白石杯绘画大赛 吗？地球人都知道，对绘画感兴趣的朋友快快行动起来哟！奖金丰厚😊倘若你不喜欢我的留言，请回复“取消”。
Can this be done on macs too?
As long as you have a SQL client to access steemsql, should be able to.
I used SQLdeveloper from Oracle which I think runs on Mac too.