Drupal Tip #6: Removing Unused Taxonomy Terms
One not so great side effect of using free tagging with Drupal is that you will gradually build up a huge list of taxonomy terms that aren't being used. Typically this happens when nodes are delete that have some random taxonomy terms which arent used by any other nodes. There is a simple SQL statement you can run that will remove all unused taxonomy terms:
DELETE FROM term_data USING term_data LEFT JOIN term_node ON term_data.tid = term_node.tid WHERE term_node.tid IS NULL AND term_data.vid = vocabulary_id_#
Remember to add the Vocabulary ID you want to clean up. You wouldn't want to accidentally remove terms from a large static vocabulary. I use the SQL Cron module to run this statement automatically everytime cron.php is executed. This way I never have to worry about manually cleaning up my vocabularies.
Comments
Luxury Channel
Nothing I had said made an impression on him. Nothing Sebold said made any impression on him. He had an idea and he was holding it like a sick baby. You know a little rat named Frisky Lavon? he sighed. Used to be a dummy-chucker, then found out he could bug his way Luxury Channel outa raps. Been doing that for say twelve years. Totes a gun and acts simple. But he quit acting tonight at seventhirty about. Quit cold-with a slug in his head. Never heard of him, I said. You bumped anybody off tonight? I'd have to look at my notebook. Sebold leaned forward politely. Would you care Luxury Channel for a smack in the kisser? he inquired. Finlayson held his hand out sharply. Cut it, Ben. Cut it. Listen, Marlowe. Maybe we're going at this wrong. We're not talking about murder. Could have been legitimate. This Frisky Lavon got froze off tonight on Calvello Drive in Bel-Air. Out in the middle Luxury Channel of the street. Nobody seen or heard anything. So we kind of want to know. All right, I growled. What makes it my business? And keep that piano tuner out of my hair. He has a nice suit and his nails are clean, but he bears down on his shield too hard. Nuts Luxury Channel to you, Sebold said. We got a funny phone call, Finlayson said. Which is where you come in. We ain't just throwing our weight around. And we want a forty-five. They ain't sure what kind yet. He's smart. He threw it under the bar at Levy's, Sebold sneered. I never had a forty-five.
Fred will be expecting word
As I said, I'm at his place. Fred will be expecting word from you; he won't be working. We're going to have him come, and we'll decide what to do, us three. I divx movies have an idea, but we'll discuss it. As far as I'm concerned, you're out of it. You told us your emotions had taken over on Nixon and Watergate, and they have certainly divx movies taken over on this-what you thought you knew about me. So. I won't hang up; I'll listen if you want to talk. He hung up. I went to the piano and spread my fingers divx movies to hit a chord that shows you've decided something, according to Lily. When I turned, Saul was standing there. He didn't say anything, just stood with his brows raised. I spoke. I was dvd movies just following instructions. He instructed us to ignore his decisions and instructions. That's a funny sentence. I feel funny. So do I. Do you want to call Fred, or shall I? I said that since Fred psp movies was being invited to his place, I thought he should, and he went to the desk and dialed, and didn't have to wait for an answer. Fred must have been sticking near the divx movies phone. He would; he hates unfinished business more than either of us. . Saul hung up. He's on his way. Half an hour, maybe less. Milk or bourbon or what? .