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
'',
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
depth = 0
AND parent_author = ''
AND ISJSON(json_metadata) > 0
AND author IN('USERNAME')
ORDER BY
created asc
@carlgnash Post Catalog - PART 1:
July - September, 2017:
7/12/2017 6:16 PM Observations of a neophyte cryptocurrency investor
/@carlgnash/observations-of-a-neophyte-cryptocurrency-investor
#cryptocurrency
7/12/2017 7:04 PM Daddy don't have no boobs (3 part harmony)
/@carlgnash/daddy-don-t-have-no-boobs-3-part-harmony
#steemit

7/12/2017 10:14 PM Crossbow of Illumination - Minor Magic Item
/@carlgnash/crossbow-of-illumination-minor-magic-item
#dungeonsanddragons

7/13/2017 6:19 AM Dimorphodon
/@carlgnash/dimorphodon
#art

7/13/2017 6:56 PM Pouch of Translocation - Minor Magic Item
/@carlgnash/pouch-of-translocation-minor-magic-item
#rpg

7/16/2017 5:14 PM Got (raw) milk?
/@carlgnash/got-raw-milk
#food

7/17/2017 6:27 AM Experimental Ape - art by moi
/@carlgnash/experimental-ape-art-by-moi
#art

7/17/2017 5:27 PM A man must have his cheese - song seed (alternate tuning DADEAD)
/@carlgnash/a-man-must-have-his-cheese-song-seed-alternate-tuning-dadead
#music

7/18/2017 6:13 AM White Boy Recycluh
/@carlgnash/white-boy-recycluh
#yunk

7/18/2017 4:51 PM Muscle Cuirass - Minor Magic Item
/@carlgnash/muscle-cuirass-minor-magic-item
#rpg

7/19/2017 12:36 AM Cinnabar Caterpillar on Tansy Ragwort (ColorChallenge Tuesday Orange)
/@carlgnash/cinnabar-caterpillar-on-tansy-ragwort-colorchallenge-tuesday-orange
#colorchallenge

7/19/2017 6:02 AM Pic from last Saturday's D&D game
/@carlgnash/pic-from-last-saturday-s-d-and-d-game
#devil

7/20/2017 5:43 AM And now for something completely different... good news on the climate front?
/@carlgnash/and-now-for-something-completely-different-good-news-on-the-climate-front
#science

7/20/2017 6:52 AM Blackberry ICO - exclusive early access opportunity
/@carlgnash/blackberry-ico-exclusive-early-access-opportunity
#ico

7/20/2017 7:34 AM Ladybug x Strawberry Cough (sativa)
/@carlgnash/ladybug-x-strawberry-cough-sativa
#photography

7/20/2017 5:06 PM Oregon Fir Sawyer (Longhorn Beetle family)
/@carlgnash/oregon-fir-sawyer-longhorn-beetle-family
#photography

7/20/2017 7:56 PM Introducing myself and Gnash Comment Challenge!
/@carlgnash/introducing-myself-and-gnash-comment-challenge
#introduceyourself

7/21/2017 3:16 PM Ladybug x Blue Widow (indica dominant)
/@carlgnash/ladybug-x-blue-widow-indica-dominant
#photography

7/21/2017 4:44 PM Raw Milk Friday
/@carlgnash/raw-milk-friday
#food

7/22/2017 5:45 AM ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn
/@carlgnash/ph-nglui-mglw-nafh-cthulhu-r-lyeh-wgah-nagl-fhtagn
#art

7/23/2017 6:39 AM Oh Cookies by Leo
/@carlgnash/oh-cookies-by-leo
#music

7/23/2017 6:07 PM The importance of swimming naked in mountain streams
/@carlgnash/the-importance-of-swimming-naked-in-mountain-streams
#health

7/24/2017 6:35 AM Trouble Shoot - original song
/@carlgnash/trouble-shoot-original-song
#music

7/24/2017 6:07 PM Beauty in the Fly of the Beholder
/@carlgnash/beauty-in-the-fly-of-the-beholder
#photography

7/25/2017 6:07 AM Campfire Breakfast Hack
/@carlgnash/campfire-breakfast-hack
#food

7/25/2017 5:52 PM First Witness Vote
/@carlgnash/first-witness-vote
#witness

7/26/2017 3:02 AM Trident of Tapping - minor magic item
/@carlgnash/trident-of-tapping-minor-magic-item
#rpg

7/26/2017 6:41 AM Yeti catches a frisbee
/@carlgnash/yeti-catches-a-frisbee
#photography

7/26/2017 7:05 AM At first I felt violated...
/@carlgnash/at-first-i-felt-violated
#minnowsupport

7/26/2017 6:57 PM Disc Golf - Way of Life
/@carlgnash/disc-golf-way-of-life
#sports

7/27/2017 12:19 AM Hold Me Daddy - original song
/@carlgnash/hold-me-daddy-original-song
#music

7/27/2017 6:28 AM Zombie Shepherd
/@carlgnash/zombie-shepherd
#art

7/27/2017 4:39 PM Color Challenge - Thursday Green
/@carlgnash/color-challenge-thursday-green
#photography

7/28/2017 3:58 AM Trippy Thursday - Shoggoth in the Fungus Forest (original art)
/@carlgnash/trippy-thursday-shoggoth-in-the-fungus-forest-original-art
#art

7/28/2017 6:38 PM Real Milk Friday
/@carlgnash/real-milk-friday
#food

7/29/2017 5:17 PM Dangers of Marijuana - PSA
/@carlgnash/dangers-of-marijuana-psa
#marijuana

7/31/2017 11:31 PM An Excavator Does Not Cry - original song
/@carlgnash/an-excavator-does-not-cry-original-song
#music

8/1/2017 10:25 PM Away - original song
/@carlgnash/away-original-song
#music

8/3/2017 1:53 AM Dog on a Bridge
/@carlgnash/dog-on-a-bridge
#photography

8/3/2017 3:15 PM Okanagana Cicada
/@carlgnash/okanagana-cicada
#photography

8/4/2017 3:51 AM Tractor - Original Song
/@carlgnash/tractor-original-song
#music

8/4/2017 9:43 PM Amulet of Disappearance - minor magic item
/@carlgnash/amulet-of-disappearance-minor-magic-item
#rpg

8/5/2017 6:56 AM Cucumber by Macka B
/@carlgnash/cucumber-by-macka-b
#music

8/5/2017 4:07 PM Minihippocrocs - original song
/@carlgnash/minihippocrocs-original-song
#music

8/5/2017 8:26 PM NEM fee fork coming up in ~2 weeks
/@carlgnash/nem-fee-fork-coming-up-in-2-weeks
#cryptocurrency

8/6/2017 7:24 PM I got you - original song
/@carlgnash/i-got-you-original-song
#music

8/7/2017 3:38 PM Set It Down - original song
/@carlgnash/set-it-down-original-song
#music

8/7/2017 6:09 PM Support my friend's Flugtag team!
/@carlgnash/support-my-friend-s-flugtag-team
#funny

8/7/2017 8:38 PM NEM into the top 5 cryptocurrencies
/@carlgnash/nem-into-the-top-5-cryptocurrencies
#cryptocurrency

8/8/2017 3:47 PM White Water Wyrm - original art
/@carlgnash/white-water-wyrm-original-art
#art

8/8/2017 7:15 PM To Ripple or not to Ripple
/@carlgnash/to-ripple-or-not-to-ripple
#cryptocurrency

8/8/2017 11:11 PM Old Maps are Beautiful
/@carlgnash/old-maps-are-beautiful
#art

8/9/2017 5:50 PM Ring of the Restless Dead - original art and poem
/@carlgnash/ring-of-the-restless-dead-original-art-and-poem
#art

8/10/2017 2:19 PM I Love You
/@carlgnash/i-love-you
#love

8/11/2017 5:40 PM Little One - original (improv) song
/@carlgnash/little-one-original-improv-song
#music

8/11/2017 6:47 PM Things that are more enjoyable than talking to Comcast tech support part 1
/@carlgnash/things-that-are-more-enjoyable-than-talking-to-comcast-tech-support-part-1
#funny

8/12/2017 7:50 PM Things that are more enjoyable than talking to Comcast tech support part 2
/@carlgnash/things-that-are-more-enjoyable-than-talking-to-comcast-tech-support-part-2
#life

8/13/2017 8:12 PM Iota withdraw my funds from Bitfinex (IOTA wallet instructions)
/@carlgnash/iota-withdraw-my-funds-from-bitfinex-iota-wallet-instructions
#cryptocurrency

8/14/2017 7:43 PM Potion of Healing - original art
/@carlgnash/potion-of-healing-original-art
#art

8/15/2017 4:47 PM How I made my cover image look good on all devices (tutorial)
/@carlgnash/how-i-made-my-cover-image-look-good-on-all-devices-tutorial
#steemit

8/16/2017 2:39 PM Goblin (original art)
/@carlgnash/goblin-original-art
#art

8/16/2017 3:48 PM Machine Learning to Combat Human (Sex) Trafficking
/@carlgnash/machine-learning-to-combat-human-trafficking
#news

8/17/2017 7:21 AM IGNORE ME PLEASE
/@carlgnash/ej2ie4xy
#dtube
8/17/2017 8:02 AM Steemit Open Mic Week 46 - "Balloon Song" - Original (improv) Song
/@carlgnash/steemit-open-mic-week-46-balloon-song-original-improv-song
#openmic

8/18/2017 6:23 PM Goodbye Forever Steemit (and shoutout post)
/@carlgnash/see-you-after-the-apocalypse-and-shout-out-post
#steemit

8/23/2017 2:52 PM Steemit Open Mic Week 47 - "Open String Improv" - Original (improv) Song
/@carlgnash/steemit-open-mic-week-47-open-string-improv-original-improv-song
#openmic

8/23/2017 6:17 PM Early Flowers on the Girls
/@carlgnash/early-flowers-on-the-girls
#marijuana

8/23/2017 11:41 PM Deep Dreaming About Global Warming
/@carlgnash/deep-dreaming-about-global-warming
#science

8/24/2017 6:14 PM Queen of the Blue Widow (Argiope aurantia - Black and Yellow Garden Spider)
/@carlgnash/queen-of-the-blue-widow-argiope-aurantia-black-and-yellow-garden-spider
#photography

8/25/2017 1:45 AM We Survived the Great Solar Eclipse Camping Trip of 2017 (eclipse video at end of post)
/@carlgnash/we-survived-the-great-solar-eclipse-camping-trip-of-2017-eclipse-video-at-end-of-post
#life

8/26/2017 9:54 AM Dreaming of the Dreamer (Art Explosion Contest Week 6 - Surrealism)
/@carlgnash/dreaming-of-the-dreamer-art-explosion-contest-week-6-surrealism
#artexplosion

8/27/2017 5:52 PM Open Source Whales
/@carlgnash/open-source-whales
#photography

8/28/2017 8:39 AM Steemit Open Mic Week 48 - An Original Song Fragment in DADEAD tuning (guitar)
/@carlgnash/steemit-open-mic-week-48-an-original-song-fragment-in-dadead-tuning-guitar
#openmic

8/29/2017 7:41 PM My Upvote and Resteem Service
/@carlgnash/my-upvote-and-resteem-service
#steemit

8/29/2017 10:27 PM Alien Invader - Bull Thistle in Eastern Oregon
/@carlgnash/alien-invader-bull-thistle-in-eastern-oregon
#photography

8/29/2017 11:34 PM Sound Advice - Original Song (DGDFGD Tuning)
/@carlgnash/sound-advice-original-song-dgdfgd-tuning
#music

8/30/2017 9:06 AM Polyhedral Cathedral
/@carlgnash/polyhedral-cathedral
#art

8/30/2017 8:32 PM Where is the original content?
/@carlgnash/where-is-the-original-content
#steemit

8/31/2017 10:27 PM Deep Style - Deep Dream Generator Tutorial (and OUTING MY WIFE ON STEEMIT post)
/@carlgnash/deep-style-deep-dream-generator-tutorial-and-outing-my-wife-on-steemit-post
#art

9/1/2017 3:01 PM Hi Steemit I was fired this morning!
/@carlgnash/hi-steemit-i-was-fired-this-morning
#life

9/2/2017 6:08 PM Original Steemit Logos - free for you to use with attribution
/@carlgnash/original-steemit-logos-free-for-you-to-use-with-attribution
#steemit

9/3/2017 9:05 AM Full Steem Ahead (work in progress)
/@carlgnash/full-steem-ahead-work-in-progress
#steemit

9/4/2017 12:56 AM Steemit Open Mic Week 49 - "The Mountain Wind" original song
/@carlgnash/steemit-open-mic-week-49-the-mountain-wind-original-song
#openmic

9/5/2017 7:31 AM Family Portrait in the Nutria Field
/@carlgnash/family-portrait-in-the-nutria-field
#life

9/6/2017 7:58 AM The Kama Sutra and ancient Indian manuscripts - example of my historical research
/@carlgnash/the-kama-sutra-and-ancient-indian-manuscripts-example-of-my-historical-research
#history

9/7/2017 9:32 AM Black Hole Sunflower - Steem-Art: Photo Editing Contest #1 submission
/@carlgnash/black-hole-sunflower-steem-art-photo-editing-contest-1-submission
#art

9/8/2017 2:10 AM All Hail the Artsy Overlord (original @artsygoddess themed art)
/@carlgnash/all-hail-the-artsy-overlord-artsygoddess-themed-art
#art

9/8/2017 9:15 AM Help me identify this creature?
/@carlgnash/help-me-identify-this-creature
#art

9/13/2017 10:06 PM Steemit Open Mic Week 50 - "Becoming" - Original a cappella song
/@carlgnash/steemit-open-mic-week-50-becoming-original-a-cappella-song
#openmic

9/14/2017 8:49 AM Fingerpicking improv over @stickchumpion's drum beat
/@carlgnash/fingerpicking-improv-over-stickchumpion-s-drum-beat
#music

9/15/2017 8:26 PM Searching - original acoustic guitar song with delay
/@carlgnash/searching
#dsound
https://scrappy.i.ipfs.io/ipfs/QmcHfgNhhzQuzNffQtZVjWay1fAFGD4M6sxwViwfQmuUa5
9/16/2017 7:19 AM Sacrifice - original song (vocal and mountain dulcimer)
/@carlgnash/sacrifice-original-song-vocal-and-mountain-dulcimer
#dsound
https://ipfs.io/ipfs/QmRxN7SMzKYA4fJCWDs73RaJiF7McX2uon4rq8D663EXfN
9/16/2017 6:56 PM Smokin' - original song
/@carlgnash/smokin-original-song
#dsound
https://chappy.i.ipfs.io/ipfs/QmZjgVq8JyXzzS4DFasv5PavnEAbfeKuiHb8zpL2wmUaTu
9/17/2017 8:44 AM A post about an opal and a dream (Steem-Art: Photo Editing Contest #2 Entry)
/@carlgnash/a-post-about-an-opal-and-a-dream-steem-art-photo-editing-contest-2-entry
#art

9/17/2017 7:21 PM That's how it goes - Original Song
/@carlgnash/thats-how-it-goes-original-song
#dsound
https://scrappy.i.ipfs.io/ipfs/QmV8fU1KMvyaKy5W2zbkLy6Bw6knyWdYU3BDAR7skqrDBf
9/18/2017 6:15 PM Alien Warlord Invades Steemit! (sextuple collaboration with @juliakponsford, @vachemorte, @buckydurddle, @stickchumpion and @carlgnash)
/@carlgnash/alien-warlord-invades-steemit-sextuple-collaboration-with-juliakponsford-vachemorte-buckydurddle-stickchumpion-and-carlgnash
#music

9/21/2017 1:17 AM Covering the ladies
/@carlgnash/covering-the-ladies
#marijuana

9/21/2017 8:17 AM Open Mic Week 51 - "You are not alone" - original song (raw and unrehearsed)
/@carlgnash/open-mic-week-51-you-are-not-alone-original-song-raw-and-unrehearsed
#openmic

9/22/2017 10:51 AM Burning my love to ashes - STEEMIT COLLABORATION ORIGINAL SONG - lyrics by @chapterclosed - music by @carlgnash
/@carlgnash/burning-my-love-to-ashes-steemit-collaboration-original-song-lyrics-by-chapterclosed-music-by-carlgnash
#music

9/24/2017 1:30 AM Support me in the "Six of the Best" MAP27 Minnow Contest!
/@carlgnash/support-me-in-the-six-of-the-best-map27-minnow-contest
#minnowsupport

9/24/2017 8:40 PM An open letter to Steemit user @sneak - Steemit community please help right this wrong!
/@carlgnash/an-open-letter-to-steemit-user-sneak-steemit-community-please-help-right-this-wrong
#flag

9/25/2017 7:36 AM Steemit Portrait Photography Contest Week 15 - "Mother's Day Portrait"
/@carlgnash/steemit-portrait-photography-contest-week-15-mother-s-day-portrait
#portraitcontest

9/26/2017 6:07 PM Beautiful Monster - Art Explosion Week 9 contest submission
/@carlgnash/beautiful-monster-art-explosion-week-9-contest-submission
#artexplosion

9/27/2017 10:54 PM Mount Pisgah Rocks! (with video of an Oregon Alligator Lizard crawling up my leg!)
/@carlgnash/mount-pisgah-rocks-with-video-of-an-oregon-alligator-lizard-crawling-up-my-leg
#life

9/29/2017 6:16 PM Dumpster Burning - original song
/@carlgnash/dumpster-burning-original-song
#dsound
https://gateway.ipfsstore.it:8443/ipfs/QmWQ6oU18jD8vp8GVGoxzRVrnMNDfK3ZywUNs7KXDudF8L