View Single Post
Old 10-25-2012, 10:04 AM   #4
PeterT
Taking a break; Fed up
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 6,682
Karma: 43902502
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
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.
PeterT is online now   Reply With Quote