Quote:
Originally Posted by PCreighton
Hi thanks this helped a lot, quesiton any way it can show author as well I am finding duplicate books in dupe.txt however they really are different authors. Am I asking for to much.  |
Try this:
Code:
calibre-debug -c "from calibre.library.database2 import LibraryDatabase2; db = LibraryDatabase2('c:/users/frank/documents/my ebooks/calibre');dupes = db.conn.get('select title, author_sort from books group by title having count(*) > 1;');print dupes;">dupes.txt