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.

有几个人(至少我记得@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.

CODE


I'm just extract recent 4 posts in this case and select the result and copy to clipboard.

我就拉出我最近4帖在这里然后拷贝Copy.
Recent Post Copy
IMAGE LINK|图片链接: SJo4phBMX

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 发帖,右点击贴进去
Recent Post Paste
IMAGE LINK|图片链接: SJo4phBMX

Now, lets see how it looks it. Pretty cool, right?

来看看效果如何。够神吧?
Recent Post Look
IMAGE LINK|图片链接: SJo4phBMX

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

Recent Post

FIRST2
中日韩龙虎榜自 20180629 | CJK Top Pending Payout Post since 20180629
FIRST3
Top Level 1 commenters for 20180701, active hours and how their comments looks like
FIRST4
Monthly Author Challenge #7.01 Watch football in mall l 商场里看球赛
FIRST5
中日韩龙虎榜自 20180628 | CJK Top Pending Payout Post since 20180628
FIRST6
#DailyPetPhotography #BeautifulSunday A lazy cock | 懒雀
FIRST7
#BeautifulSunday #WalkWithMe After HSBC Rugby 7s Get on the way 4 | 橄榄球赛开赛后跟我走走4
FIRST8
Watching World Cup before watching World Cup | 看世界杯前看世界杯
FIRST9
Top Level 1 commenters for 20180630, active hours and how their comments looks like

SEPARATOR-Dolphins In on Blue

Please see my other posts: @ace108

请看我其他帖: @ace108

Separator-ACE-800

I See. I Shoot. I Steemit♨️.


H2
H3
H4
3 columns
2 columns
1 column
10 Comments