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
'',
created,
' ' + title + '' + 'https://steemit.com' + url + '
#' + category + '
' + '' as [Title_URL_Date],
'' + ISNULL((JSON_VALUE(json_metadata,'$.image[0]')),'')+ '' 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
@carlgnash Post Catalog - PART 3:
January - April 18th, 2018:
1/1/2018 1:52 AM "Big Brown Toad" - D-TUBE EXCLUSIVE - Original Music Steemit Collab w/@amberyooper - Gnash Song Challenge #3
/@carlgnash/t8q7ooqf
#dtube
https://gateway.ipfsstore.it:8443/ipfs/QmVtZs4Nw4n2YPtXLFL7mK7bL5SSx1e3C8utwYuuVJqHiu 1/2/2018 11:33 AM "Ode to my Crawdad" - D-TUBE EXCLUSIVE MUSIC VIDEO - Gnash Song Challenge #4 - Steemit Collab w/@dillemma
/@carlgnash/uhwe1ioy
#dtube
https://ipfs.io/ipfs/QmVx1AvJqAvYKyEtWaYVQtbQNHbaNpDVjfqJGna8ZEryDX 1/3/2018 9:34 AM D-Tube Exclusive Guitar Tutorial - "How to take a Fire Truck out of your guitar"
/@carlgnash/jo2pj642
#dtube
1/4/2018 10:22 AM Big Brother in your Pocket? - also musings on the future of VALUE and ADVERTISING on the Steem platform
/@carlgnash/apps-on-your-phone-listen-to-your-tv-while-running-in-the-background-to-target-ads-based-on-your-viewing-habits-also-musings-on
#news
1/4/2018 7:05 PM Bitcoin Fool Me Once #cryptomeme #originalmeme
/@carlgnash/bitcoin-fool-me-once-cryptomeme-originalmeme
#cryptomeme
1/6/2018 10:00 AM Gnash Family Band - D-TUBE EXCLUSIVE - World Premiere Music Video
/@carlgnash/u9w5i001
#dtube
1/7/2018 12:00 PM "Funk Your Feet" - D-TUBE EXCLUSIVE MUSIC VIDEO - Gnash Song Challenge #5 - Steemit Collab w/@limabeing
/@carlgnash/12fdogoa
#dtube
1/8/2018 9:24 PM "To Leave a Dying World" - D-TUBE EXCLUSIVE MUSIC VIDEO - Steem Collab w/@calluna | Gnash Song Challenge #6
/@carlgnash/onm3shdx
#dtube
1/10/2018 11:19 AM Original Image Dump
/@carlgnash/original-image-dump
#art
1/12/2018 9:41 AM Goddess Does Not Have Bad Hair Day - @torico Meme da Chit out of Mah Selfie Contest Entry
/@carlgnash/goddess-does-not-have-bad-hair-day-torico-meme-da-chit-out-of-mah-selfie-contest-entry
#art
1/14/2018 10:01 AM "Too Many Selfies" - D-TUBE EXCLUSIVE MUSIC VIDEO - Steem Collab w/@geekgirl | Gnash Song Challenge #7
/@carlgnash/4jbw1o0s
#dtube
1/17/2018 11:12 AM Gnash Boarding Pass - episode 1
/@carlgnash/gnash-boarding-pass
#curation
1/20/2018 4:26 AM "Chimichangas" - D TUBE EXCLUSIVE MUSIC VIDEO - Gnash Song Challenge #8
/@carlgnash/3od0nd5p
#dtube
1/22/2018 8:34 PM Steemit Open Mic Week 69 - ORIGINAL IMPROV SONG - Gnash Family Band "Roar!"
/@carlgnash/steemit-open-mic-week-69-original-improv-song-gnash-family-band-roar
#openmic
1/24/2018 8:48 PM Ursula K. Le Guin died
/@carlgnash/ursula-k-le-guin-died
#writing
1/26/2018 10:49 AM I support #womenspeakout #teamgirlpowa 100% OF THE SBD PAYOUT OF THIS POST DONATED TO @TEAMGIRLPOWA
/@carlgnash/i-support-womenspeakout-teamgirlpowa-100-of-the-sbd-payout-of-this-post-donated-to-teamgirlpowa
#womenspeakout
1/29/2018 11:57 AM "Hot Out Of The Oven" - 3 Part Harmony ORIGINAL MUSIC - Gnash Song Challenge #9
/@carlgnash/hot-out-of-the-oven-3-part-harmony-original-music-gnash-song-challenge-9
#music
1/31/2018 9:38 AM Paying it Forward like a Steward of Gondor
/@carlgnash/paying-it-forward-like-a-steward-of-gondor
#stewardsofgondor
2/4/2018 11:00 AM Two Haiku set to music
/@carlgnash/two-haiku-set-to-music
#music
2/4/2018 9:04 PM DOWNVOTED FOR NOISE VIOLATION (original Steemit meme)
/@carlgnash/downvoted-for-noise-violation-original-steemit-meme
#meme
2/5/2018 10:49 PM Growing up in love - Singing to the Baby Boy Volume I (16 original songs)
/@carlgnash/growing-up-in-love-singing-to-the-baby-boy-volume-i-16-original-songs
#music
2/7/2018 9:00 AM I'm going to be on the radio!
/@carlgnash/i-m-going-to-be-on-the-radio
#msp
2/11/2018 11:22 PM Full Steem
/@carlgnash/full-steem
#dsound
https://chappy.i.ipfs.io/ipfs/QmUdmgvKQXgEayxpRPw6n77EfKEE9bcDL91WsKNCzAZ6h6 2/18/2018 9:59 PM "The Future" - DTUBE EXCLUSIVE Original Music Video - Gnash Song Challenge #10
/@carlgnash/orsc63u4
#music
2/20/2018 1:13 PM An accidental post = bonus deep dream for you (@cyclops!)
/@carlgnash/curie-logo-design-contest-winners
#contest
2/22/2018 6:55 PM This Steward plans to keep on serving Gondor
/@carlgnash/this-steward-plans-to-keep-on-serving-gondor
#stewardsofgondor
3/1/2018 3:14 PM Steemit Open Mic Week 74 - "The Road Less Bacon" ORIGINAL STEEM COLLABORATION w/@DIEBITCH
/@carlgnash/steemit-open-mic-week-74-the-road-less-bacon-original-steem-collaboration-w-diebitch
#openmic
3/8/2018 9:08 PM "The Roots" - original music - DSound EXCLUSIVE
/@carlgnash/20180308t210755934z-the-roots-original-music-dsound-exclusive
#dsound
3/18/2018 9:49 PM Interviews Theme - Extended (DSound Exclusive Original Music)
/@carlgnash/20180318t214935678z-interviews-theme-extended-dsound-exclusive-original-music
#dsound
https://ipfs.io/ipfs/QmdWX7UuB4M4ta1BRtNM4wjuicC6UwwHxybhPqJZs2qEji 3/21/2018 10:16 AM Just a reminder - this is real :) STEEM wallet by @armadilloman
/@carlgnash/just-a-reminder-this-is-real-steem-wallet-by-armadilloman
#art
3/25/2018 10:02 AM Free Range Bass Cryptofunk
/@carlgnash/20180325t100242424z-free-range-bass-cryptofunk
#dsound
https://ipfs.io/ipfs/QmaKqNX69dcxZsizCz6tx2nJyucPUNks5Qd1nUensPGtUL 4/8/2018 11:32 PM My Curie Story
/@carlgnash/my-curie-story
#mycuriestory
4/13/2018 6:22 PM @transparencybot - three points
/@carlgnash/transparencybot-three-points
#steemit
4/14/2018 8:43 PM Dreaming of the Willamette - Deep Dream Generator gallery #3
/@carlgnash/dreaming-of-the-willamette-deep-dream-generator-gallery-3
#art
