Search files to be fixex

[jpcavri]

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')
;

[DoctorOhh]

Excellent work, but for those less inclined they can put not formats:"=EPUB" in the search bar to find books without epub or comments:false to find all books without comments.

Thanks for sharing your SQLite commands.

Good reading!