3000 Followers! Plus Blog Archive through April 18th, 2018
Well I am officially less of a nobody here on Steem blockchain than I was when I started posting back on July 12th, 2017. I just hit 3000 followers this week and in celebration, and because of overwhelming demand from nobody, I am going to post my entire back catalog of posts to date (yes all 192 of them), from oldest to newest.
- Part 1: July - September 2017 is below
- Part 2: October - December, 2017
- Part 3: January - April 18th, 2018
- If you are reading this in the future, when April of 2018 is a dim memory, look at the top of the comments here for links to more recent post archives. I will add a comment here with a link to the more recent archive and vote it up to the top. Until Stinc or someone else makes a proper blogging front end for this blockchain, I suppose :)
I pulled this list using the SteemSQL database and the following query (the output is already formatted to be a table, the query output just needs to be inserted in between a <table>
and a </table>
tag in your post to display in a table as mine does).
As a special bonus offer just for my followers and commenters, if you are interested in posting your own back catalog, just let me know in the comments and I will run the same query for your username and share the results with you. You will likely have to post it in multiple parts as I have because of the post size / block size limitation.
Thanks for following! Much love - Carl
SQL Query Used:
SELECT
'<tr><td>',
created,
'</td><td><h4>' + title + '</h4>' + 'https://steemit.com' + url + '<br> #' + category + '<br>' + '</td>' as [Title_URL_Date],
'<td>' + ISNULL((JSON_VALUE(json_metadata,'$.image[0]')),'')+ '</td></tr>' as [Cover_Image]
FROM
Comments with (NOLOCK)
WHERE
depth = 0
AND parent_author = ''
AND ISJSON(json_metadata) > 0
AND author IN('USERNAME')
ORDER BY
created asc
https://steemit.com/blog/@carlgnash/5000th-post-plus-blog-archive-part-4-april-18th-september-17th-2018
Congrt @carlgnash, this is not a easy route at all, it shows you doing well..i will love to have my own catalog also. Thanks
Thanks dude! Here is your post back catalog :)
https://docs.google.com/document/d/1wgQKG5bKAm83dGoFFrHuC1xHUoNWf1l4O22Hy7K1s70/edit?usp=sharing
That is formatted to work as a table, just paste it (or sections of it) in between
<table>
and</table>
tags, making sure to begin and end your selections at a row break in the table (denoted with<tr>
for the beginning of a new row and</tr>
for the end of a row). Cheers - CarlCongrats!! Let us forever prosper!!
Congrats on the 3k Carl !!!!!!!! Nice milestone <3
Congratulations on the 3000!!! Well done, old chap! We must get together virtually for a beer and chat very soon. I would love to hear what you have been up to :)
Cheers,
Bucky
Congrats, 🎊🍾🎉 impressive catalogue 🤓 (I never thought of you as a nobody).
"... and because of overwhelming demand from nobody..." Lol! Good milestone. Congrats.