View Single Post
Old 04-29-2011, 10:58 PM   #3
jacr
Junior Member
jacr began at the beginning.
 
Posts: 5
Karma: 12
Join Date: Apr 2011
Device: Kindle 3
I found a way to do this. I did the following
1) Backed up the calibre database (metadata.db)
2) Downloaded SQLite Administrator
3) Ran the following SQL against the database:

Quote:
delete from books_tags_link
where id in
(
select id from books_tags_link
where tag in
(
select tag from books_tags_link
group by tag
having count(tag) < 30
)
)
This deleted all tags that are on less than 30 books.
jacr is offline   Reply With Quote