Search files to be fixex
Hi,
Since I started with CALIBRE, I also learn SQL langage:
I create two helpful SQLite commands one to find the books without comments and the second to find the books without EPUB file (replaced by PDF):
----------------------------------------------
No Comment text
SELECT title, author_sort FROM books
WHERE Books.id IN (
SELECT book
FROM books_ratings_link
EXCEPT
SELECT book
FROM comments)
;
----------------------------------------------
No EPUB File
SELECT title, author_sort FROM books
WHERE Books.id IN (
SELECT book
FROM books_ratings_link
EXCEPT
SELECT book
FROM data WHERE format = 'EPUB')
;
|