[wp-hackers] Cleaning up tags

[Michael E. Hancock]

From: "Lari Elovainio" <lari at kairo.fi>
> What I don’t know, is how to delete the corresponding 8000 rows from the 
> wp_term_relationships table. I guess it requires some kind of join, but i’m 
> not that familiar with mysql. So I need to delete rows from 
> wp_term_relationships where 'term_taxonomy_id' is something that has 
> 'count' lower than 2 in wp_term_taxonomy. How do I do that? I’m sorry if 
> this is trivial but I haven’t been able to figure it out.
>


t31os_ has some code you might find useful

http://wordpress.org/support/topic/311665?replies=13#post-1248204



MichaelH