Updating my STEEMSQL query for this summer 😎 | 为知夏日改进 STEEMSQL 查询😎 (by @ace108)|
![HEADER-Swimming with SteemSQL](https://steemitimages.com/640x0/https://i.supload.com/HyYwpwwU-.jpg)
Sometime ago, I used steemsql to figure out all my posts ever and shared the details in this previous posts:
![FIRST305](https://steemitimages.com/128x72/https://i.supload.com/HyYwpwwU-.jpg)
🎶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 … | 改进。。。第一把
这回改进让你将一位用户全部的帖子的标签,标题,网址,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.
您可以将所需结果相当容易的列复制到其他文件中进行的编辑。在第一部分中,您可以看到标签在不同的列中。
![SSS180](https://steemitimages.com/640x0/https://i.supload.com/H1xfOU57pZ.png)
Next is the post title and a link to the post.
接下来是帖的标题和一个链接。
![SSS190](https://steemitimages.com/640x0/https://i.supload.com/B1ZfdUqXp-.png)
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.
最后,这两列是Markdown和HTML。 您可以轻易地将HTML列复制到表格中,或将Markdown复制到您的帖或留言中。
![SSS200](https://steemitimages.com/640x0/https://i.supload.com/rkMfdLqmab.png)
If you paste Markdown a comment, this is what you should see.
如果您在留言中贴上Markdown的评论,这是你应该看到的。
![SSS190](https://steemitimages.com/640x0/https://i.supload.com/HJxiHO-Vp-.png)
Is this cool or not? It’s all in one.
够酷吧?全都出来了。
Now, you can DIY and extract a list of all your posts.
现在,您可以动手提取所有帖子的资料。
![SEPARATOR-Dolphins In on Blue](https://steemitimages.com/640x0/https://i.supload.com/HyM8onW8-.png)
![ACE108-SignaturePhoto167f6.png](https://steemitimages.com/640x0/http://www.steemimg.com/images/2016/10/26/ACE108-SignaturePhoto167f6.png)
![Recent Post](https://steemitimages.com/640x0/https://i.supload.com/HJ9BkDPCl.png)
![SEPARATOR-Dolphins In on Blue](https://steemitimages.com/640x0/https://i.supload.com/HyM8onW8-.png)
请看我其他帖: @ace108
![Separator-ACE-800](https://steemitimages.com/0x0/http://i.imgur.com/01Ujwxa.gif)
Hey that looks pretty cool!
a quick way to get your post out😎
looks great!
thank you.
去年夏天還沒進來 XD
一个夏原来也做了很多事情 😎
充實! :D
Congratulations @ace108! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOP
thanks.
Thats great, thanks![
you're welcome. Thanks for checking out
多谢分享
不客气
That's looks great : )
It's great getting a list of your posts .