View Single Post
Old 06-03-2013, 04:06 AM   #7
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,772
Karma: 30237628
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by DedTV View Post
Edit: Decided to play around with it and I've gotten close. The best I could do is get is (what I think is) the counts via a "select tag, count(*) from books_tags_link group by tag;" query but I haven't figured out how to link that up with a query to link it with the actual tag name.

Although, thinking about it, I could simply just export the tag table and the result of the query and match them up in Excel.
Yup. That worked!
Great

Something like INNER JOIN tags ON books_tags_link.tag=tags.id might have done the trick too, not on calibre system so i can't test.

Glad I could help - sounds like you're in the home straight.

BR

Last edited by BetterRed; 06-04-2013 at 01:33 AM.
BetterRed is offline   Reply With Quote