01-28-2013, 03:58 AM | #1 |
Microelectronic, retired
Posts: 6
Karma: 10
Join Date: Jan 2013
Device: EEPAD ASUS transformer
|
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') ; |
01-28-2013, 04:32 AM | #2 |
US Navy, Retired
Posts: 9,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
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! |
Advert | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Different search results by file and by all html files? | bfollowell | Sigil | 4 | 04-20-2012 02:03 AM |
Search and Replace in CSS Files | afakler | Calibre | 0 | 03-10-2012 04:46 AM |
Problem using 'Advanced Search' with 'Search in Forum' | Wetdogeared | Feedback | 6 | 06-21-2011 09:37 AM |
Search for files by content string? | nekokami | iRex | 4 | 12-01-2006 12:14 PM |
Google Book Search to search full-text books online | Bob Russell | Deals and Resources (No Self-Promotion or Affiliate Links) | 1 | 08-19-2006 12:13 PM |