Thread: Exporting list of authors from KoboReader.sqlite
View Single Post
Old 06-14-2021, 10:29 AM   #4
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
As well as errors in the names, it will also include recommendations and previews. The query calibre uses is roughly:

Code:
SELECT DISTINCT Attribution 
FROM content  
WHERE BookID IS NULL  
AND IsDownloaded in ('true', 1 )
AND Accessibility IN (-1, 1, 2, 8, 9)
davidfor is offline   Reply With Quote