Back post catalog PART 3 January - April 18th, 2018
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 a query for your username and share the results with you (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. 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
ISJSON(json_metadata) > 0
AND depth = 0
AND parent_author = ''
AND author IN('USERNAME')
ORDER BY
created asc
This post has been voted on from MSP3K courtesy of @Scuzzy from the Minnow Support Project ( @minnowsupport ).
Bots Information:
Join the P.A.L. Discord | Check out MSPSteem | Listen to MSP-Waves
Go, Carl, go!
I think I'm interested in this.
Here you go. You will probably have to split this up into two posts (there is a max post size limit). Just make sure you are starting each selection at a "
<table>tag before the selection and a</table>tag after for it to display properly as a table in your post. Cheers - Carlhttps://drive.google.com/open?id=1AqM9mBnBfnHgH6DyOTBUiO_TcenPSlP6
Thank you very much for the information, I hope to work on it soon.
I'd be interested Carl. Appreciate the offer.
Here ya go :) I think with this number you may be able to do it all in one post, but I am not sure - it will be close (there is a max post size). For it to display properly as a table, you will have to have a
<table>tag in front of the selection and a</table>tag after it. Cheers - Carlhttps://drive.google.com/open?id=1DmrabbQxxPNi3g4Ezipmz41hKNpYxXTD
Thanks Carl. Excuse the dumb question but this can only be displayed in a post on steemit?
Also, I wanted to ask if you still wanted me to let you know when I Post custom figurine articles or not. No biggie either way but wasn’t sure.
Oh sorry meant to reply to one of your earlier questions but I have been slammed :) To be entirely honest, when I asked you to notify me when you posted one of those it was before you had received a Curie, and the reason I asked you is I knew that posting would likely be approved for Curie and wanted to make sure I saw it and could submit it. @randomwanderings beat me to that first one and got you a Curie there already. I have been very impressed with your custom figurines and will try to visit your blog regularly, but you don't need to notify me every time you post one :)
RE the post list - I intentionally used HTML instead of Markdown to format the list so it will display properly on a regular website as well. But it will only display properly somewhere that can parse HTML - so for instance, on a wordpress website, in the post editor you would have to switch from visual editor to the HTML editor for it to work. On Facebook, I don't think this would work (I don't believe Facebook allows any kind of HTML or markdown table formatting). If you want it in a different format, e.g. just a list of URLs for instance in a single column, just let me know. Cheers - Carl
Ok, good to know about the custom figures. Thanks for giving me the heads up. I always thought you were the one who putin up for Curie. I have been going to write a Curie experience but maybe it is getting too old now.
Dude would love it if you wrote a #mycuriestory. Curie for most of its existence has been very non self-promotional. Never left a comment on upvote explaining what happened. But in a way we have done ourselves a disservice I think. #mycuriestory is a way for the community to remind itself, oh yeah, Curie has helped out a lot of us. If you are an engaged, consistent, quality poster, and you aren't receiving regular reward, Curie will find you eventually if you don't give up. ~100 curators looking on an average month. The more voices that speak up and say, hey, yeah, they gave me a big upvote too... the louder the message. I hope anyway :) But no pressure to post, either. Only if it feels right to you. Cheers - Carl
I did one a couple days ago, but doesn't seem to be a very popular one. Not sure I helped you out much.
https://steemit.com/mycuriestory/@bigskycustoms/my-curie-story-hope-given
I love this, @carlgnash. Thank you for making this offer to your followers. Yes please!
Hi @jayna, I will be happy to oblige :) Are you after all of your posts in chronological order (which will require multiple posts, as I did here - there is a max post size and you will not be able to fit the table with every post into one post)? Or would you prefer a Top 25 or Top X posts by payout, or only posts in a specific tag, or posts with X in the title, etc.?
Oh my gosh, I have choices? Okay, how about posts with the fiction tag? Thank you, @carlgnash!
Here ya go - all your posting with "fiction" as one of the five tags, chronological order ascending. I believe this will work in one post so I already enclosed it in
<table>and</table>tags, but if you have to cut this into two sections you will have to make sure both sections are enclosed in the above tags. Cheers - Carlhttps://drive.google.com/open?id=18kdhgw8HwrsLsftCwVyaSrtJzOYStrLb
Thanks so much, @carlgnash! What a wonderful treat. Wow!