Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 01-28-2013, 03:58 AM   #1
jpcavri
Microelectronic, retired
jpcavri began at the beginning.
 
jpcavri's Avatar
 
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')
;
jpcavri is offline   Reply With Quote
Old 01-28-2013, 04:32 AM   #2
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,773
Karma: 12516053
Join Date: Feb 2009
Location: North Carolina
Device: 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!
DoctorOhh is online now   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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, Freebies, and Resources (No Self-Promotion) 1 08-19-2006 12:13 PM


All times are GMT -4. The time now is 01:06 AM.


MobileRead.com is a privately owned, operated and funded community.