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.

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 );

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


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







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!

The Greatest Creation of My Life | Week 39

“Almost over”, says the doctor, “One more week!”

That is not really what I wanted to hear and definitely not what Tina wanted to hear. But that’s what we were told. The doc thinks it’s unlikely that spontaneous labor will happen in the next week, and estimates that we will be back next Friday to schedule an induction. Wonderful.

Have I mentioned that we are both completely tired of the pregnancy situation? Poor Tina. She’s really hurting this week but still putting a smile on that pretty face. Looks like it’ll be a few more days, and if the doctor is correct we will have a son on March 4th or 5th.

We are keeping our fingers crossed that a natural labor will begin sometime soon. Until then we will continue to take our walks around Palm Beach Island and lounge around at home.

See ya next week…

SQL_CALC_FOUND_ROWS and no_found_rows

By default, the WordPress SQL query that selects posts from the database will use “SELECT SQL_CALC_FOUND_ROWS …”. This is mainly for pagination purposes, to speed up subsequent queries for the next set of results. Writing the query that way certainly helps speed up the site as a whole, but is useless in some circumstances.

Remedy: Look through your theme and plugin code for WP_Query objects. On queries that don’t need pagination, add a new query variable to the mix that looks like this:

$a_faster_wp_query = new WP_Query( array(
	'foo' => 'bar',
	'more_foo' => 'extra_bar',
	'no_found_rows' => true,

(The magic is on line 4 – it must be passed as an actual boolean, not a string)

Use this tidbit on every WP_Query that doesn’t need pagination to make WordPress omit the “SQL_CALC_FOUND_ROWS” from it’s query, thus speeding up the post selection query.

The Greatest Creation of My Life | Week 38

Good news and bad news this week – Tina is having contractions! What’s the bad news? – you might ask. Well, just ask Tina. They hurt. (EDIT: Contractions are normal for many weeks before labor, so don’t get too excited)

They’re seldom and very intermittent, but they are definitely happening. At least I have something to talk about in this week’s blog post. Other than my obviously deranged dreams over the past week, nothing much else has been happening. Somehow we thought the end of the pregnancy would be more exciting than it is. It’s actually quite … boring.

But it’s for real. We’re having a baby. Soon.

Last night, we picked up the playpen / bassinet that we ordered online (regretfully) from everyone’s favorite major retailer. Aside from the “wonderful” experience we had in the store and the fact that it won’t fit through the door when put together, it’s a great product sporting a pretty neat airplane design and some really cool features. Obviously I like. Hopefully the baby and the mommy will also enjoy it.

I know I promised some photos in last week’s post, but we just haven’t had a proper day to go do these things. Work has been crazy, and I’m doing my best to leave few tasks open when I take leave for the baby. It’s been tough. We will take some pictures this weekend, for sure.

So anyways, I’m hopping on the be-back-bus … I’ll be-back next week. Cheers!

Lionfish and Hormones


Hormones are a funny thing. I know this because I’m not a dreamer. When I was a kid I had the typical nightmares and occasionally would yell out at night. But pretty much since childhood, I drift off at night and experience a split-second of blackness before I am awakened by the sound of my alarm eight hours later.

I am convinced that during pregnancy certain hormones are shared (or produced in equilibrium) by mother to father by means of sweat while asleep, physiological connection, or possibly some sort of brainwave interaction we don’t yet understand. Whatever it is, over the past nine months I have experienced it and it has reversed my realization of just how in-control of my mind I really am.

I guess that old saying “mind over matter” holds little truth. The mind is matter. We’re simply made of chemicals, which found themselves in the proper combinations in a vast universe and came together to create our consciousness. I though I understood myself, but we are no more in-control than the asteroid circling the galaxy, bound by gravity and guided by mass and energy.

Anyways I’ve never really been a dreamer. However peculiar, lately I have been dreaming of Lionfish. Bright, vivid and entrancing visions of packs of the hungry critters swimming below me in pools fill my head at night. True, the baby has been very much on my mind, and there’s likely some primitive connection between raw nature and parenthood … but Lionfish? Really? Couldn’t it be cute little Lion cubs or something?

I’ve arrived at a quandary: why am I suddenly having trouble sleeping? And why, when I do fall asleep, does my unconscious mind entertain me with images of swirling schools of Lionfish in a pool below me?

I can only find one explanation: It must be the hormones.