Back post catalog PART 2 October - December, 2017
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
Congratulations. THis is a great idea for a post. ... I might do one limited to my fave ones though. I'm coming up on 1000...might be a good time.
I could either pull the whole list and you whittle it down, or it is easy for me to filter by payout or some other metric (e.g. could pull your top 50 posts by payout, or all your posting in one tag, or for your photo stories all posting that contains X in the title, etc.). Just let me know! Wow... 1000 posts :)
No - sorry for the misunderstanding. 1000 followers. I have no idea how many posts. Even a top 20 by payout could be cool though. I'd love the help!
Top 20 posts by payout, from highest payout first. I already added the table tags in your case as this will be postable in one go, so just copy/paste the entire contents of this into your post:
https://drive.google.com/open?id=1s8oLkWPohDSSh_0GscnOUxM1F2NlaCuC
You're a star. Thank you so much.
This is a cool idea for a post! I didn't realize that you had so much music on the blockchain!
Yeah I have probably posted more music than any other single category of posting, but I am kind of all over the place :)
Sounds like fun, Music Man, giving our creative offspring one more chance
Would love to give it a try ✌🏼
Excellent I will run your query this evening :)
Much appreciated— might post it, tomorrow 🤓
https://drive.google.com/open?id=1AgcHZ0stwD9mkZEiRr79lxNh6_NFG2QQ
You have a ton of posts, posting all of them would probably take 4 posts (you probably caught this from my own posting, but there is a post size limit and this will be way over it). If you want I could also pull a Top 25 or a Top 50 (by payout or commenting for instance) list of your posting that you could publish in one go. Just let me know :)
For the attached, when you break it into sections just make sure you are starting each section with a "
<table>
tag in front of your selection and a</table>
tag after for it to display as a table in the post.Much love - Carl
Many thanks, dear Carl! A top 25 (payout, I guess) sounds like a great idea, if not too much trouble 👌🏼
Meantime, hope I can figure out formatting, once I can figure out how to open doc (I’m a dope!) I’m on iPhone & might need password and laptop at home 🤪
would absolutely love to take you up on your offer of creating a back post! please and thank you, most awesome monster maker.
Cool it will be my honor <3
Here ya go :) See my comment to Yahia above for notes and instructions. Love
https://drive.google.com/open?id=1OF-YG160F-ZojYXPX7e0SR4LpILdy1u9
I would take you up on that offer but I fear the post would explode as I post multiple times a day and have done so consistently since day one . But it really is a good idea for a post to get stuff seen one really would like people to read. Is there away to do a list like this with just specific posts ?
I could either pull the whole list and you whittle it down, or it is easy for me to filter by payout or some other metric (e.g. could pull your top 50 posts by payout, or all your posting in one specific tag, or posting that contains X in the title, etc.). Just let me know!
No dear, it is to much work as it would be those I subjectively love and would like seen a bit more- it would be a mess. But thank you :)
Uhm... hmm, I don't have enough posts yet but yeah maybe I'd like to have mine without the bot upvotes? Or if not even with the bot upvoted posts is fine. Thanks!
There isn't an easy way to exclude bot-upvoted posts. I could do a top 10 or top 25 or whatever posts by payout, or if your goal with excluding bot upvotes was to try to feature your posts with more organic engagement, I could run a Top WHATEVER # of posts by # of comments (so all your most-commented on posts). Any of that sound good? Or should I just run your whole back catalog?
Maybe just top 10 payout and top 10 comments? :)
Hello there... I just saw this while searching for my 2018 summary post... Do you still do this? 😅 I'd like to check which one of my posts this year got the top 10 payout and top 10 comments so far. :)
Hi unfortunately I am no longer paying for a SteemSQL subscription anymore so I can't run these kinds of charts. @abh12345 has a steemsql sub maybe if you sweet talk him? LOL (Asher if you are reading this and are up for it, the SQL query is in the parent post that @artgirl is responding to here).
Cheers
😅😅😅 Ok. Hopefully he can help. Pretty please??? 😅
Just thought I'd try. Thank you.
Oh well... I guess @abh12345 is busy... 😅 May I know who else I can ask to find out abt my posts? 😅