3000 Followers! Plus Blog Archive through April 18th, 2018

in blog •  5 months ago

willamette abstract 3000 followers.jpg

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

@carlgnash Post Catalog - PART 1:
July - September, 2017:

7/12/2017 6:16 PM

Observations of a neophyte cryptocurrency investor

https://steemit.com/cryptocurrency/@carlgnash/observations-of-a-neophyte-cryptocurrency-investor
#cryptocurrency
7/12/2017 7:04 PM

Daddy don't have no boobs (3 part harmony)

https://steemit.com/steemit/@carlgnash/daddy-don-t-have-no-boobs-3-part-harmony
#steemit
7/12/2017 10:14 PM

Crossbow of Illumination - Minor Magic Item

https://steemit.com/dungeonsanddragons/@carlgnash/crossbow-of-illumination-minor-magic-item
#dungeonsanddragons
7/13/2017 6:19 AM

Dimorphodon

https://steemit.com/art/@carlgnash/dimorphodon
#art
7/13/2017 6:56 PM

Pouch of Translocation - Minor Magic Item

https://steemit.com/rpg/@carlgnash/pouch-of-translocation-minor-magic-item
#rpg
7/16/2017 5:14 PM

Got (raw) milk?

https://steemit.com/food/@carlgnash/got-raw-milk
#food
7/17/2017 6:27 AM

Experimental Ape - art by moi

https://steemit.com/art/@carlgnash/experimental-ape-art-by-moi
#art
7/17/2017 5:27 PM

A man must have his cheese - song seed (alternate tuning DADEAD)

https://steemit.com/music/@carlgnash/a-man-must-have-his-cheese-song-seed-alternate-tuning-dadead
#music
7/18/2017 6:13 AM

White Boy Recycluh

https://steemit.com/yunk/@carlgnash/white-boy-recycluh
#yunk
7/18/2017 4:51 PM

Muscle Cuirass - Minor Magic Item

https://steemit.com/rpg/@carlgnash/muscle-cuirass-minor-magic-item
#rpg
7/19/2017 12:36 AM

Cinnabar Caterpillar on Tansy Ragwort (ColorChallenge Tuesday Orange)

https://steemit.com/colorchallenge/@carlgnash/cinnabar-caterpillar-on-tansy-ragwort-colorchallenge-tuesday-orange
#colorchallenge
7/19/2017 6:02 AM

Pic from last Saturday's D&D game

https://steemit.com/devil/@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?

https://steemit.com/science/@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

https://steemit.com/ico/@carlgnash/blackberry-ico-exclusive-early-access-opportunity
#ico
7/20/2017 7:34 AM

Ladybug x Strawberry Cough (sativa)

https://steemit.com/photography/@carlgnash/ladybug-x-strawberry-cough-sativa
#photography
7/20/2017 5:06 PM

Oregon Fir Sawyer (Longhorn Beetle family)

https://steemit.com/photography/@carlgnash/oregon-fir-sawyer-longhorn-beetle-family
#photography
7/20/2017 7:56 PM

Introducing myself and Gnash Comment Challenge!

https://steemit.com/introduceyourself/@carlgnash/introducing-myself-and-gnash-comment-challenge
#introduceyourself
7/21/2017 3:16 PM

Ladybug x Blue Widow (indica dominant)

https://steemit.com/photography/@carlgnash/ladybug-x-blue-widow-indica-dominant
#photography
7/21/2017 4:44 PM

Raw Milk Friday

https://steemit.com/food/@carlgnash/raw-milk-friday
#food
7/22/2017 5:45 AM

ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn

https://steemit.com/art/@carlgnash/ph-nglui-mglw-nafh-cthulhu-r-lyeh-wgah-nagl-fhtagn
#art
7/23/2017 6:39 AM

Oh Cookies by Leo

https://steemit.com/music/@carlgnash/oh-cookies-by-leo
#music
7/23/2017 6:07 PM

The importance of swimming naked in mountain streams

https://steemit.com/health/@carlgnash/the-importance-of-swimming-naked-in-mountain-streams
#health
7/24/2017 6:35 AM

Trouble Shoot - original song

https://steemit.com/music/@carlgnash/trouble-shoot-original-song
#music
7/24/2017 6:07 PM

Beauty in the Fly of the Beholder

https://steemit.com/photography/@carlgnash/beauty-in-the-fly-of-the-beholder
#photography
7/25/2017 6:07 AM

Campfire Breakfast Hack

https://steemit.com/food/@carlgnash/campfire-breakfast-hack
#food
7/25/2017 5:52 PM

First Witness Vote

https://steemit.com/witness/@carlgnash/first-witness-vote
#witness
7/26/2017 3:02 AM

Trident of Tapping - minor magic item

https://steemit.com/rpg/@carlgnash/trident-of-tapping-minor-magic-item
#rpg
7/26/2017 6:41 AM

Yeti catches a frisbee

https://steemit.com/photography/@carlgnash/yeti-catches-a-frisbee
#photography
7/26/2017 7:05 AM

At first I felt violated...

https://steemit.com/minnowsupport/@carlgnash/at-first-i-felt-violated
#minnowsupport
7/26/2017 6:57 PM

Disc Golf - Way of Life

https://steemit.com/sports/@carlgnash/disc-golf-way-of-life
#sports
7/27/2017 12:19 AM

Hold Me Daddy - original song

https://steemit.com/music/@carlgnash/hold-me-daddy-original-song
#music
7/27/2017 6:28 AM

Zombie Shepherd

https://steemit.com/art/@carlgnash/zombie-shepherd
#art
7/27/2017 4:39 PM

Color Challenge - Thursday Green

https://steemit.com/photography/@carlgnash/color-challenge-thursday-green
#photography
7/28/2017 3:58 AM

Trippy Thursday - Shoggoth in the Fungus Forest (original art)

https://steemit.com/art/@carlgnash/trippy-thursday-shoggoth-in-the-fungus-forest-original-art
#art
7/28/2017 6:38 PM

Real Milk Friday

https://steemit.com/food/@carlgnash/real-milk-friday
#food
7/29/2017 5:17 PM

Dangers of Marijuana - PSA

https://steemit.com/marijuana/@carlgnash/dangers-of-marijuana-psa
#marijuana
7/31/2017 11:31 PM

An Excavator Does Not Cry - original song

https://steemit.com/music/@carlgnash/an-excavator-does-not-cry-original-song
#music
8/1/2017 10:25 PM

Away - original song

https://steemit.com/music/@carlgnash/away-original-song
#music
8/3/2017 1:53 AM

Dog on a Bridge

https://steemit.com/photography/@carlgnash/dog-on-a-bridge
#photography
8/3/2017 3:15 PM

Okanagana Cicada

https://steemit.com/photography/@carlgnash/okanagana-cicada
#photography
8/4/2017 3:51 AM

Tractor - Original Song

https://steemit.com/music/@carlgnash/tractor-original-song
#music
8/4/2017 9:43 PM

Amulet of Disappearance - minor magic item

https://steemit.com/rpg/@carlgnash/amulet-of-disappearance-minor-magic-item
#rpg
8/5/2017 6:56 AM

Cucumber by Macka B

https://steemit.com/music/@carlgnash/cucumber-by-macka-b
#music
8/5/2017 4:07 PM

Minihippocrocs - original song

https://steemit.com/music/@carlgnash/minihippocrocs-original-song
#music
8/5/2017 8:26 PM

NEM fee fork coming up in ~2 weeks

https://steemit.com/cryptocurrency/@carlgnash/nem-fee-fork-coming-up-in-2-weeks
#cryptocurrency
8/6/2017 7:24 PM

I got you - original song

https://steemit.com/music/@carlgnash/i-got-you-original-song
#music
8/7/2017 3:38 PM

Set It Down - original song

https://steemit.com/music/@carlgnash/set-it-down-original-song
#music
8/7/2017 6:09 PM

Support my friend's Flugtag team!

https://steemit.com/funny/@carlgnash/support-my-friend-s-flugtag-team
#funny
8/7/2017 8:38 PM

NEM into the top 5 cryptocurrencies

https://steemit.com/cryptocurrency/@carlgnash/nem-into-the-top-5-cryptocurrencies
#cryptocurrency
8/8/2017 3:47 PM

White Water Wyrm - original art

https://steemit.com/art/@carlgnash/white-water-wyrm-original-art
#art
8/8/2017 7:15 PM

To Ripple or not to Ripple

https://steemit.com/cryptocurrency/@carlgnash/to-ripple-or-not-to-ripple
#cryptocurrency
8/8/2017 11:11 PM

Old Maps are Beautiful

https://steemit.com/art/@carlgnash/old-maps-are-beautiful
#art
8/9/2017 5:50 PM

Ring of the Restless Dead - original art and poem

https://steemit.com/art/@carlgnash/ring-of-the-restless-dead-original-art-and-poem
#art
8/10/2017 2:19 PM

I Love You

https://steemit.com/love/@carlgnash/i-love-you
#love
8/11/2017 5:40 PM

Little One - original (improv) song

https://steemit.com/music/@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

https://steemit.com/funny/@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

https://steemit.com/life/@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)

https://steemit.com/cryptocurrency/@carlgnash/iota-withdraw-my-funds-from-bitfinex-iota-wallet-instructions
#cryptocurrency
8/14/2017 7:43 PM

Potion of Healing - original art

https://steemit.com/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)

https://steemit.com/steemit/@carlgnash/how-i-made-my-cover-image-look-good-on-all-devices-tutorial
#steemit
8/16/2017 2:39 PM

Goblin (original art)

https://steemit.com/art/@carlgnash/goblin-original-art
#art
8/16/2017 3:48 PM

Machine Learning to Combat Human (Sex) Trafficking

https://steemit.com/news/@carlgnash/machine-learning-to-combat-human-trafficking
#news
8/17/2017 7:21 AM

IGNORE ME PLEASE

https://steemit.com/dtube/@carlgnash/ej2ie4xy
#dtube
8/17/2017 8:02 AM

Steemit Open Mic Week 46 - "Balloon Song" - Original (improv) Song

https://steemit.com/openmic/@carlgnash/steemit-open-mic-week-46-balloon-song-original-improv-song
#openmic
8/18/2017 6:23 PM

Goodbye Forever Steemit (and shoutout post)

https://steemit.com/steemit/@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

https://steemit.com/openmic/@carlgnash/steemit-open-mic-week-47-open-string-improv-original-improv-song
#openmic
8/23/2017 6:17 PM

Early Flowers on the Girls

https://steemit.com/marijuana/@carlgnash/early-flowers-on-the-girls
#marijuana
8/23/2017 11:41 PM

Deep Dreaming About Global Warming

https://steemit.com/science/@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)

https://steemit.com/photography/@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)

https://steemit.com/life/@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)

https://steemit.com/artexplosion/@carlgnash/dreaming-of-the-dreamer-art-explosion-contest-week-6-surrealism
#artexplosion
8/27/2017 5:52 PM

Open Source Whales

https://steemit.com/photography/@carlgnash/open-source-whales
#photography
8/28/2017 8:39 AM

Steemit Open Mic Week 48 - An Original Song Fragment in DADEAD tuning (guitar)

https://steemit.com/openmic/@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

https://steemit.com/steemit/@carlgnash/my-upvote-and-resteem-service
#steemit
8/29/2017 10:27 PM

Alien Invader - Bull Thistle in Eastern Oregon

https://steemit.com/photography/@carlgnash/alien-invader-bull-thistle-in-eastern-oregon
#photography
8/29/2017 11:34 PM

Sound Advice - Original Song (DGDFGD Tuning)

https://steemit.com/music/@carlgnash/sound-advice-original-song-dgdfgd-tuning
#music
8/30/2017 9:06 AM

Polyhedral Cathedral

https://steemit.com/art/@carlgnash/polyhedral-cathedral
#art
8/30/2017 8:32 PM

Where is the original content?

https://steemit.com/steemit/@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)

https://steemit.com/art/@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!

https://steemit.com/life/@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

https://steemit.com/steemit/@carlgnash/original-steemit-logos-free-for-you-to-use-with-attribution
#steemit
9/3/2017 9:05 AM

Full Steem Ahead (work in progress)

https://steemit.com/steemit/@carlgnash/full-steem-ahead-work-in-progress
#steemit
9/4/2017 12:56 AM

Steemit Open Mic Week 49 - "The Mountain Wind" original song

https://steemit.com/openmic/@carlgnash/steemit-open-mic-week-49-the-mountain-wind-original-song
#openmic
9/5/2017 7:31 AM

Family Portrait in the Nutria Field

https://steemit.com/life/@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

https://steemit.com/history/@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

https://steemit.com/art/@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)

https://steemit.com/art/@carlgnash/all-hail-the-artsy-overlord-artsygoddess-themed-art
#art
9/8/2017 9:15 AM

Help me identify this creature?

https://steemit.com/art/@carlgnash/help-me-identify-this-creature
#art
9/13/2017 10:06 PM

Steemit Open Mic Week 50 - "Becoming" - Original a cappella song

https://steemit.com/openmic/@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

https://steemit.com/music/@carlgnash/fingerpicking-improv-over-stickchumpion-s-drum-beat
#music
9/15/2017 8:26 PM

Searching - original acoustic guitar song with delay

https://steemit.com/dsound/@carlgnash/searching
#dsound
9/16/2017 7:19 AM

Sacrifice - original song (vocal and mountain dulcimer)

https://steemit.com/dsound/@carlgnash/sacrifice-original-song-vocal-and-mountain-dulcimer
#dsound
9/16/2017 6:56 PM

Smokin' - original song

https://steemit.com/dsound/@carlgnash/smokin-original-song
#dsound
9/17/2017 8:44 AM

A post about an opal and a dream (Steem-Art: Photo Editing Contest #2 Entry)

https://steemit.com/art/@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

https://steemit.com/dsound/@carlgnash/thats-how-it-goes-original-song
#dsound
9/18/2017 6:15 PM

Alien Warlord Invades Steemit! (sextuple collaboration with @juliakponsford, @vachemorte, @buckydurddle, @stickchumpion and @carlgnash)

https://steemit.com/music/@carlgnash/alien-warlord-invades-steemit-sextuple-collaboration-with-juliakponsford-vachemorte-buckydurddle-stickchumpion-and-carlgnash
#music
9/21/2017 1:17 AM

Covering the ladies

https://steemit.com/marijuana/@carlgnash/covering-the-ladies
#marijuana
9/21/2017 8:17 AM

Open Mic Week 51 - "You are not alone" - original song (raw and unrehearsed)

https://steemit.com/openmic/@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

https://steemit.com/music/@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!

https://steemit.com/minnowsupport/@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!

https://steemit.com/flag/@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"

https://steemit.com/portraitcontest/@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

https://steemit.com/artexplosion/@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!)

https://steemit.com/life/@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

https://steemit.com/dsound/@carlgnash/dumpster-burning-original-song
#dsound
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

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 - Carl

Congrats!! 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.