Delete All Tags With 0 Posts

Delete all tags with zero posts tagged. Can also be used to delete all tags with one post. Or other amounts … Use at your own risk. From the MySQL command line. Make sure to BACK UP YOUR DATABASE first.

[code language=”sql”]
DELETE a,c FROM dbname.wp_terms AS a
LEFT JOIN dbname.wp_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN dbname.wp_term_relationships AS b on b.term_taxonomy_id = c.term_taxonomy_id
WHERE ( c.taxonomy = ‘post_tag’ AND c.count = 0 );[/code]

On the last line, you could also do c.count < 3 which would remove all tags with less than three posts. Be creative.

Enjoy!

Sweet Sixteen Days

IMAG1950It seems like so long ago already when we proudly stomped down the hospital hall on the way out the door with Rylan for his first trip outside.

Today marks his sixteenth day “on the outside”. He’s a strong little guy, for sure. And he can yell with the best of them. But we still love him to death – just like Don wrote, love at first sight. I always dreaded the idea of an infant in my home screaming at all hours of the night. But it’s not really like they described. I’m far less annoyed, and far more heartbroken because there isn’t much we can do to comfort him at times. Just gotta let him cry, I guess.

Just like everyone always says –  he’s growing up too fast, already. We wish we could savor these days forever, but of course, I can’t wait for him to get a bit older so we can go fishing, camping, snorkeling, and exploring the world. I can’t wait to show him the world! But it’s a bit too soon yet.

Time to focus on planning a wedding. I’ll have more details about that next week. For now, here are a few more photos – just what you asked for. Hope you enjoy them!

Open Your Eyes, Tina

“Open your eyes, Tina!”

The doctor shouts. She opens her strained eyes to welcome her child into the world. He wriggles about and locks eyes with his mother for the first time. An emotion is expressed that no camera could ever capture and no words could ever describe. A tear of happiness falls from her face. Hours of pain come to an end and one of life’s greatest joys begins as he takes his first breath. In a single moment, one becomes two and two becomes three.

A few moments later a nursery rhyme softly plays throughout the halls of the hospital to signal that a baby has been born.

I will spare you the details of childbirth and say only one thing of the experience. I stood next to the love of my life and one of the strongest people I know, holding her hand and comforting her, while she pushed through most of a lengthy and painful labor without any pain medication. She is Wonder Woman.

As I wrote in my first parenthood post nine months ago, we have truly been given love’s greatest gift. Our baby has arrived happy, healthy and incredibly handsome. And an incredible hand-full.

Meet Rylan Alexander, born March 4, 2013 at 5:28 PM. 7 lbs 1 oz.

Rylan Alexander

z_IMG_0029

z_IMG_0090

IMG_0098

IMG_0010

IMG_0067

IMAG1930

The Greatest Creation of My Life | Week 40

Well this week, I can at least guarantee you that this will be the last pregnancy-week post. We’re heading to the hospital tomorrow and Tina will start the induction process and we will most likely have the baby by Monday.

Natural birth really did seem to be happening a week ago until suddenly all of the symptoms went away. Back to square-one. So yesterday, the doctor scheduled to induce labor for the safety of the baby. At least we got another ultrasound image out of this deal. Our first look at our baby’s fully-developed face. So sweet.

Another update soon … stay with us!