MobileRead Forums - View Single Post

PeterT · 10-25-2012, 10:04 AM

Try

Code:

select Title from CONTENT 
     where BookID is null and ContentType=6 and Accessibility <> 6 and Accessibility <> 4
     order by title;

I'm not certain about Accessibility but a quick perusal seemed to show those were books I did not actually have, possibly previews

EDIT: From browsing DavidFor's calibre driver it looks like 4 is Recommendations and 6 Previews.

10-25-2012, 10:04 AM	#4
PeterT Grand Sorcerer Posts: 12,166 Karma: 73448616 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	Try Code: select Title from CONTENT where BookID is null and ContentType=6 and Accessibility <> 6 and Accessibility <> 4 order by title; I'm not certain about Accessibility but a quick perusal seemed to show those were books I did not actually have, possibly previews EDIT: From browsing DavidFor's calibre driver it looks like 4 is Recommendations and 6 Previews. Last edited by PeterT; 10-25-2012 at 10:10 AM.