MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader
Reload this Page Export list of books from KoboReader.sqlite

Notices

Reply
 
Thread Tools Search this Thread
Old 06-28-2022, 03:52 AM   #1
mortimer7
Connoisseur
mortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-books
 
Posts: 70
Karma: 798
Join Date: Apr 2012
Device: iLiad, Kobo Aura 6"
Export list of books from KoboReader.sqlite
hi,
can i export list of all books (and folder) from a KoboReader.sqlite file?
mortimer7 is offline   Reply With Quote
Old 06-28-2022, 04:21 AM   #2
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: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Yes you can. You just need to write the appropriate SQL statement and run it against the database.
davidfor is offline   Reply With Quote
Advert
Old 06-28-2022, 01:42 PM   #3
mortimer7
Connoisseur
mortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-books
 
Posts: 70
Karma: 798
Join Date: Apr 2012
Device: iLiad, Kobo Aura 6"
Quote:
Originally Posted by davidfor View Post
Yes you can. You just need to write the appropriate SQL statement and run it against the database.
Thanks, than i have tried to open it with DB Browser for SQLite and i have found list of ebooks on "content". can I also see the reading percentage?
mortimer7 is offline   Reply With Quote
Old 06-28-2022, 08:24 PM   #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: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
As there is a column in the table called "___PercentRead", then probably.

For the record, the query that calibre uses to get the list of books is:

Code:
SELECT Title, Attribution, DateCreated, ContentID, MimeType, ContentType, ImageId, ReadStatus, Description, Publisher , ___ExpirationStatus, FavouritesIndex, Accessibility, Language, IsDownloaded, ISBN, Series, SeriesNumber, ___UserID, ExternalId, Subtitle, SeriesID, SeriesNumberFloat, StorePages, StoreWordCount, StoreTimeToReadLowerEstimate, StoreTimeToReadUpperEstimate FROM content  WHERE BookID IS NULL  AND ((Accessibility = -1 AND IsDownloaded in ('true', 1 ))       OR (Accessibility IN (1,2,8,9) and IsDownloaded in ('true', 1))         )  AND (externalId IS NULL OR externalId = '') AND contentId NOT LIKE 'file:///mnt/sd/%'
And to get the reading status, Kobo Utilities uses:

Code:
SELECT c1.ChapterIDBookmarked, c1.adobe_location, c1.ReadStatus, c1.___PercentRead, c1.Attribution, c1.DateLastRead, c1.Title, c1.MimeType, r.rating, c1.contentId FROM content c1 LEFT OUTER JOIN ratings r ON c1.ContentID = r.ContentID WHERE c1.ContentID = ?
Merging those and dropping the columns you are not interested should not be to hard.
davidfor is offline   Reply With Quote
Old 06-29-2022, 02:59 AM   #5
mortimer7
Connoisseur
mortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-books
 
Posts: 70
Karma: 798
Join Date: Apr 2012
Device: iLiad, Kobo Aura 6"
Quote:
Originally Posted by davidfor View Post
As there is a column in the table called "___PercentRead", then probably.

For the record, the query that calibre uses to get the list of books is:

Code:
SELECT Title, Attribution, DateCreated, ContentID, MimeType, ContentType, ImageId, ReadStatus, Description, Publisher , ___ExpirationStatus, FavouritesIndex, Accessibility, Language, IsDownloaded, ISBN, Series, SeriesNumber, ___UserID, ExternalId, Subtitle, SeriesID, SeriesNumberFloat, StorePages, StoreWordCount, StoreTimeToReadLowerEstimate, StoreTimeToReadUpperEstimate FROM content  WHERE BookID IS NULL  AND ((Accessibility = -1 AND IsDownloaded in ('true', 1 ))       OR (Accessibility IN (1,2,8,9) and IsDownloaded in ('true', 1))         )  AND (externalId IS NULL OR externalId = '') AND contentId NOT LIKE 'file:///mnt/sd/%'
And to get the reading status, Kobo Utilities uses:

Code:
SELECT c1.ChapterIDBookmarked, c1.adobe_location, c1.ReadStatus, c1.___PercentRead, c1.Attribution, c1.DateLastRead, c1.Title, c1.MimeType, r.rating, c1.contentId FROM content c1 LEFT OUTER JOIN ratings r ON c1.ContentID = r.ContentID WHERE c1.ContentID = ?
Merging those and dropping the columns you are not interested should not be to hard.
Thanks, but where should I type those commands? On DB Browser for SQLite i can't see ___PercentRead table

EDIT:
this is what i see with DB Browser "content" for one book:
Code:
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(0)OEBPS/Text/part0001.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Il gatto venuto dal cielo','','',NULL,NULL,'OEBPS/Text/part0001.html','','false',NULL,'true','',0,0,NULL,0,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(3)OEBPS/Text/part0004.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo terzo','','',NULL,NULL,'OEBPS/Text/part0004.html','','false',NULL,'true','',0,0,NULL,3,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(4)OEBPS/Text/part0005.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo quarto','','',NULL,NULL,'OEBPS/Text/part0005.html','','false',NULL,'true','',0,0,NULL,4,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(5)OEBPS/Text/part0006.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo quinto','','',NULL,NULL,'OEBPS/Text/part0006.html','','false',NULL,'true','',0,0,NULL,5,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(6)OEBPS/Text/part0007.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo sesto','','',NULL,NULL,'OEBPS/Text/part0007.html','','false',NULL,'true','',0,0,NULL,6,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(7)OEBPS/Text/part0008.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo settimo','','',NULL,NULL,'OEBPS/Text/part0008.html','','false',NULL,'true','',0,0,NULL,7,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(8)OEBPS/Text/part0009.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ottavo','','',NULL,NULL,'OEBPS/Text/part0009.html','','false',NULL,'true','',0,0,NULL,8,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(9)OEBPS/Text/part0010.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo nono','','',NULL,NULL,'OEBPS/Text/part0010.html','','false',NULL,'true','',0,0,NULL,9,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(10)OEBPS/Text/part0011.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo decimo','','',NULL,NULL,'OEBPS/Text/part0011.html','','false',NULL,'true','',0,0,NULL,10,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(11)OEBPS/Text/part0012.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo undicesimo','','',NULL,NULL,'OEBPS/Text/part0012.html','','false',NULL,'true','',0,0,NULL,11,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(12)OEBPS/Text/part0013.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo dodicesimo','','',NULL,NULL,'OEBPS/Text/part0013.html','','false',NULL,'true','',0,0,NULL,12,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(13)OEBPS/Text/part0014.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo tredicesimo','','',NULL,NULL,'OEBPS/Text/part0014.html','','false',NULL,'true','',0,0,NULL,13,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(14)OEBPS/Text/part0015.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo quattordicesimo','','',NULL,NULL,'OEBPS/Text/part0015.html','','false',NULL,'true','',0,0,NULL,14,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(15)OEBPS/Text/part0016.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo quindicesimo','','',NULL,NULL,'OEBPS/Text/part0016.html','','false',NULL,'true','',0,0,NULL,15,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(16)OEBPS/Text/part0017.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo sedicesimo','','',NULL,NULL,'OEBPS/Text/part0017.html','','false',NULL,'true','',0,0,NULL,16,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(17)OEBPS/Text/part0018.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo diciassettesimo','','',NULL,NULL,'OEBPS/Text/part0018.html','','false',NULL,'true','',0,0,NULL,17,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(18)OEBPS/Text/part0019.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo diciottesimo','','',NULL,NULL,'OEBPS/Text/part0019.html','','false',NULL,'true','',0,0,NULL,18,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(19)OEBPS/Text/part0020.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo diciannovesimo','','',NULL,NULL,'OEBPS/Text/part0020.html','','false',NULL,'true','',0,0,NULL,19,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(20)OEBPS/Text/part0021.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventesimo','','',NULL,NULL,'OEBPS/Text/part0021.html','','false',NULL,'true','',0,0,NULL,20,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(21)OEBPS/Text/part0022.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventunesimo','','',NULL,NULL,'OEBPS/Text/part0022.html','','false',NULL,'true','',0,0,NULL,21,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(22)OEBPS/Text/part0023.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventiduesimo','','',NULL,NULL,'OEBPS/Text/part0023.html','','false',NULL,'true','',0,0,NULL,22,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(23)OEBPS/Text/part0024.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventitreesimo','','',NULL,NULL,'OEBPS/Text/part0024.html','','false',NULL,'true','',0,0,NULL,23,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(24)OEBPS/Text/part0025.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventiquattresimo','','',NULL,NULL,'OEBPS/Text/part0025.html','','false',NULL,'true','',0,0,NULL,24,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(25)OEBPS/Text/part0026.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo venticinquesimo','','',NULL,NULL,'OEBPS/Text/part0026.html','','false',NULL,'true','',0,0,NULL,25,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(26)OEBPS/Text/part0027.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventiseiesimo','','',NULL,NULL,'OEBPS/Text/part0027.html','','false',NULL,'true','',0,0,NULL,26,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(27)OEBPS/Text/part0028.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventisettesimo','','',NULL,NULL,'OEBPS/Text/part0028.html','','false',NULL,'true','',0,0,NULL,27,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(28)OEBPS/Text/part0029.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventottesimo','','',NULL,NULL,'OEBPS/Text/part0029.html','','false',NULL,'true','',0,0,NULL,28,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(29)OEBPS/Text/part0030.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventinovesimo','','',NULL,NULL,'OEBPS/Text/part0030.html','','false',NULL,'true','',0,0,NULL,29,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(30)OEBPS/Text/part0031.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','La posizione del fulmine','','',NULL,NULL,'OEBPS/Text/part0031.html','','false',NULL,'true','',0,0,NULL,30,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(31)OEBPS/Text/part0032.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Glossario','','',NULL,NULL,'OEBPS/Text/part0032.html','','false',NULL,'true','',0,0,NULL,31,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(32)OEBPS/Text/part0033.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Il libro','','',NULL,NULL,'OEBPS/Text/part0033.html','','false',NULL,'true','',0,0,NULL,32,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(33)OEBPS/Text/part0034.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','L’autore','','',NULL,NULL,'OEBPS/Text/part0034.html','','false',NULL,'true','',0,0,NULL,33,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(34)OEBPS/Text/part0035.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Copyright','','',NULL,NULL,'OEBPS/Text/part0035.html','','false',NULL,'true','',0,0,NULL,34,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(1)OEBPS/Text/part0002.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo primo','','',NULL,NULL,'OEBPS/Text/part0002.html#point(/1/4/2/2/1:0)','','false',NULL,'true','',0,0,NULL,1,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(2)OEBPS/Text/part0003.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo secondo','','',NULL,NULL,'OEBPS/Text/part0003.html#point(/1/4/2/2/1:0)','','false',NULL,'true','',0,0,NULL,2,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','6','application/epub+zip',NULL,NULL,'file____mnt_onboard_Il_gatto_venuto_dal_cielo_-_Hiraide_Takashi_epub','Il gatto venuto dal cielo','Hiraide Takashi','',NULL,NULL,'','','false','2019-07-10T10:34:37Z','false','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(2)OEBPS/Text/part0003.html',0,0,35,0,0,1,'2019-06-13T08:33:55Z','adobe_user',NULL,NULL,837784,5,0,-1,-1,'','it','','true',0,0,0,'default','false','9788858419120',NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,0,0,0.0,0,'','',NULL,'','','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
where is "___PercentRead"?
Last edited by mortimer7; 06-29-2022 at 05:39 AM.
mortimer7 is offline   Reply With Quote
Advert
Old 06-29-2022, 11:36 AM   #6
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: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by mortimer7 View Post
Thanks, but where should I type those commands?
In DB Browser for SQLite, there is a tab titled "Execute SQL". Paste the statements there and run them.
Quote:
On DB Browser for SQLite i can't see ___PercentRead table
Correct, there isn't a table called "___PercentRead". What I said is that the table "content", has a column called "___PercentRead".
Quote:
EDIT:
this is what i see with DB Browser "content" for one book:
Code:
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(0)OEBPS/Text/part0001.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Il gatto venuto dal cielo','','',NULL,NULL,'OEBPS/Text/part0001.html','','false',NULL,'true','',0,0,NULL,0,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(3)OEBPS/Text/part0004.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo terzo','','',NULL,NULL,'OEBPS/Text/part0004.html','','false',NULL,'true','',0,0,NULL,3,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(4)OEBPS/Text/part0005.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo quarto','','',NULL,NULL,'OEBPS/Text/part0005.html','','false',NULL,'true','',0,0,NULL,4,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(5)OEBPS/Text/part0006.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo quinto','','',NULL,NULL,'OEBPS/Text/part0006.html','','false',NULL,'true','',0,0,NULL,5,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(6)OEBPS/Text/part0007.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo sesto','','',NULL,NULL,'OEBPS/Text/part0007.html','','false',NULL,'true','',0,0,NULL,6,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(7)OEBPS/Text/part0008.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo settimo','','',NULL,NULL,'OEBPS/Text/part0008.html','','false',NULL,'true','',0,0,NULL,7,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(8)OEBPS/Text/part0009.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ottavo','','',NULL,NULL,'OEBPS/Text/part0009.html','','false',NULL,'true','',0,0,NULL,8,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(9)OEBPS/Text/part0010.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo nono','','',NULL,NULL,'OEBPS/Text/part0010.html','','false',NULL,'true','',0,0,NULL,9,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(10)OEBPS/Text/part0011.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo decimo','','',NULL,NULL,'OEBPS/Text/part0011.html','','false',NULL,'true','',0,0,NULL,10,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(11)OEBPS/Text/part0012.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo undicesimo','','',NULL,NULL,'OEBPS/Text/part0012.html','','false',NULL,'true','',0,0,NULL,11,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(12)OEBPS/Text/part0013.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo dodicesimo','','',NULL,NULL,'OEBPS/Text/part0013.html','','false',NULL,'true','',0,0,NULL,12,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(13)OEBPS/Text/part0014.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo tredicesimo','','',NULL,NULL,'OEBPS/Text/part0014.html','','false',NULL,'true','',0,0,NULL,13,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(14)OEBPS/Text/part0015.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo quattordicesimo','','',NULL,NULL,'OEBPS/Text/part0015.html','','false',NULL,'true','',0,0,NULL,14,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(15)OEBPS/Text/part0016.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo quindicesimo','','',NULL,NULL,'OEBPS/Text/part0016.html','','false',NULL,'true','',0,0,NULL,15,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(16)OEBPS/Text/part0017.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo sedicesimo','','',NULL,NULL,'OEBPS/Text/part0017.html','','false',NULL,'true','',0,0,NULL,16,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(17)OEBPS/Text/part0018.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo diciassettesimo','','',NULL,NULL,'OEBPS/Text/part0018.html','','false',NULL,'true','',0,0,NULL,17,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(18)OEBPS/Text/part0019.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo diciottesimo','','',NULL,NULL,'OEBPS/Text/part0019.html','','false',NULL,'true','',0,0,NULL,18,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(19)OEBPS/Text/part0020.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo diciannovesimo','','',NULL,NULL,'OEBPS/Text/part0020.html','','false',NULL,'true','',0,0,NULL,19,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(20)OEBPS/Text/part0021.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventesimo','','',NULL,NULL,'OEBPS/Text/part0021.html','','false',NULL,'true','',0,0,NULL,20,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(21)OEBPS/Text/part0022.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventunesimo','','',NULL,NULL,'OEBPS/Text/part0022.html','','false',NULL,'true','',0,0,NULL,21,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(22)OEBPS/Text/part0023.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventiduesimo','','',NULL,NULL,'OEBPS/Text/part0023.html','','false',NULL,'true','',0,0,NULL,22,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(23)OEBPS/Text/part0024.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventitreesimo','','',NULL,NULL,'OEBPS/Text/part0024.html','','false',NULL,'true','',0,0,NULL,23,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(24)OEBPS/Text/part0025.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventiquattresimo','','',NULL,NULL,'OEBPS/Text/part0025.html','','false',NULL,'true','',0,0,NULL,24,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(25)OEBPS/Text/part0026.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo venticinquesimo','','',NULL,NULL,'OEBPS/Text/part0026.html','','false',NULL,'true','',0,0,NULL,25,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(26)OEBPS/Text/part0027.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventiseiesimo','','',NULL,NULL,'OEBPS/Text/part0027.html','','false',NULL,'true','',0,0,NULL,26,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(27)OEBPS/Text/part0028.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventisettesimo','','',NULL,NULL,'OEBPS/Text/part0028.html','','false',NULL,'true','',0,0,NULL,27,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(28)OEBPS/Text/part0029.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventottesimo','','',NULL,NULL,'OEBPS/Text/part0029.html','','false',NULL,'true','',0,0,NULL,28,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(29)OEBPS/Text/part0030.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo ventinovesimo','','',NULL,NULL,'OEBPS/Text/part0030.html','','false',NULL,'true','',0,0,NULL,29,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(30)OEBPS/Text/part0031.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','La posizione del fulmine','','',NULL,NULL,'OEBPS/Text/part0031.html','','false',NULL,'true','',0,0,NULL,30,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(31)OEBPS/Text/part0032.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Glossario','','',NULL,NULL,'OEBPS/Text/part0032.html','','false',NULL,'true','',0,0,NULL,31,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(32)OEBPS/Text/part0033.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Il libro','','',NULL,NULL,'OEBPS/Text/part0033.html','','false',NULL,'true','',0,0,NULL,32,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(33)OEBPS/Text/part0034.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','L’autore','','',NULL,NULL,'OEBPS/Text/part0034.html','','false',NULL,'true','',0,0,NULL,33,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(34)OEBPS/Text/part0035.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Copyright','','',NULL,NULL,'OEBPS/Text/part0035.html','','false',NULL,'true','',0,0,NULL,34,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(1)OEBPS/Text/part0002.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo primo','','',NULL,NULL,'OEBPS/Text/part0002.html#point(/1/4/2/2/1:0)','','false',NULL,'true','',0,0,NULL,1,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(2)OEBPS/Text/part0003.html','9','application/epub+zip','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','Il gatto venuto dal cielo','','Capitolo secondo','','',NULL,NULL,'OEBPS/Text/part0003.html#point(/1/4/2/2/1:0)','','false',NULL,'true','',0,0,NULL,2,-1,0,'2019-06-13T08:33:55Z','adobe_user',NULL,0,0,0,NULL,-1,-1,NULL,NULL,NULL,1,0,0,0,NULL,'false',NULL,NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,NULL,NULL,NULL,0,NULL,'',NULL,'','',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','6','application/epub+zip',NULL,NULL,'file____mnt_onboard_Il_gatto_venuto_dal_cielo_-_Hiraide_Takashi_epub','Il gatto venuto dal cielo','Hiraide Takashi','',NULL,NULL,'','','false','2019-07-10T10:34:37Z','false','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(2)OEBPS/Text/part0003.html',0,0,35,0,0,1,'2019-06-13T08:33:55Z','adobe_user',NULL,NULL,837784,5,0,-1,-1,'','it','','true',0,0,0,'default','false','9788858419120',NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,0,0,0.0,0,'','',NULL,'','','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
where is "___PercentRead"?
I have no idea how you got that, but, only the last line is relavent. That is the one referring to the book, the other refer to the chapter. And it has a "___PercentRead" value of 5.


And, I'm sorry, but these questions suggest you have very little knowledge about SQL. Right now, I'm not in the position to teach you how to do all this. Helping to get the SQL statement right is one thing, but, beyond that is not something I am willing to do.
davidfor is offline   Reply With Quote
Old 06-29-2022, 01:32 PM   #7
mortimer7
Connoisseur
mortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-books
 
Posts: 70
Karma: 798
Join Date: Apr 2012
Device: iLiad, Kobo Aura 6"
Quote:
Originally Posted by davidfor View Post
I have no idea how you got that
DB Browser for SQLite-> File-> Export-> Database to SQL-> and i select only "content". Then i open it with text editor.


Quote:
Originally Posted by davidfor View Post
but, only the last line is relavent. That is the one referring to the book, the other refer to the chapter. And it has a "___PercentRead" value of 5.
thank you, now i have understand! PercentRead is the fourth value after "adobe_user" in the line which starts with "name.epub','6','application/epub+zip',"



Quote:
Originally Posted by davidfor View Post
And, I'm sorry, but these questions suggest you have very little knowledge about SQL. Right now, I'm not in the position to teach you how to do all this.
mortimer7 is offline   Reply With Quote
Old 06-29-2022, 04:30 PM   #8
Quoth
the rook, bossing Never.
Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.
 
Quoth's Avatar
 
Posts: 12,365
Karma: 92073397
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
Make a copy of the file and use that. Eject ereader. Then mistakes don't matter.
Quoth is offline   Reply With Quote
Old 06-30-2022, 01:31 PM   #9
mortimer7
Connoisseur
mortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-books
 
Posts: 70
Karma: 798
Join Date: Apr 2012
Device: iLiad, Kobo Aura 6"
Hello, someone knows what is the column of readed books? In percentage column there isn't 100%, maybe because after read percentage returns to 0%
mortimer7 is offline   Reply With Quote
Old 06-30-2022, 09:50 PM   #10
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: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by mortimer7 View Post
Hello, someone knows what is the column of readed books? In percentage column there isn't 100%, maybe because after read percentage returns to 0%
As clearly stated above, the percent read is stored in the column "___PercentRead". Please, believe me on that. That is where my Kobo Utilities plugin is fetching the percent read.

But, there is also a reading status column. This is "ReadStatus". It has values of "0" for unread, "1" for reading and "2" for finished. Under some circumstances, the book can be marked as read, but the reading percent is not set to 100. That can happen mainly for epubs but probably also happens when you mark the book as finished on the device rather than page past the end when reading.

And, my Kobo Utilities plugin takes this into account when is fetching the reading status, or when you restore the reading status to the device.
davidfor is offline   Reply With Quote
Old 07-01-2022, 03:43 PM   #11
mortimer7
Connoisseur
mortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-booksmortimer7 has learned how to read e-books
 
Posts: 70
Karma: 798
Join Date: Apr 2012
Device: iLiad, Kobo Aura 6"
Quote:
Originally Posted by davidfor View Post
But, there is also a reading status column. This is "ReadStatus". It has values of "0" for unread, "1" for reading and "2" for finished.
i believe in you but i can't find "ReadStatus" column.
For example, in this book where is it?

Code:
INSERT INTO "content" VALUES ('file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub','6','application/epub+zip',NULL,NULL,'file____mnt_onboard_Il_gatto_venuto_dal_cielo_-_Hiraide_Takashi_epub','Il gatto venuto dal cielo','Hiraide Takashi','',NULL,NULL,'','','false','2019-07-10T10:34:37Z','false','file:///mnt/onboard/Il gatto venuto dal cielo - Hiraide Takashi.epub#(2)OEBPS/Text/part0003.html',0,0,35,0,0,1,'2019-06-13T08:33:55Z','adobe_user',NULL,NULL,837784,5,0,-1,-1,'','it','','true',0,0,0,'default','false','9788858419120',NULL,0,'true',-1,2,NULL,NULL,NULL,NULL,-1,NULL,0,0,0.0,0,'','',NULL,'','','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FALSE',NULL,NULL,NULL,NULL,NULL,'TRUE','TRUE');
It's "1" (the value before the date '2019-06-13T08:33:55Z')?

This is the list of columns which is at the beginning of the file sql, but maybe it's not in order:
Code:
	"ContentID"	TEXT NOT NULL,
	"ContentType"	TEXT NOT NULL,
	"MimeType"	TEXT NOT NULL,
	"BookID"	TEXT,
	"BookTitle"	TEXT,
	"ImageId"	TEXT,
	"Title"	TEXT COLLATE NOCASE,
	"Attribution"	TEXT COLLATE NOCASE,
	"Description"	TEXT,
	"DateCreated"	TEXT,
	"ShortCoverKey"	TEXT,
	"adobe_location"	TEXT,
	"Publisher"	TEXT,
	"IsEncrypted"	BOOL,
	"DateLastRead"	TEXT,
	"FirstTimeReading"	BOOL,
	"ChapterIDBookmarked"	TEXT,
	"ParagraphBookmarked"	INTEGER,
	"BookmarkWordOffset"	INTEGER,
	"NumShortcovers"	INTEGER,
	"VolumeIndex"	INTEGER,
	"___NumPages"	INTEGER,
	"ReadStatus"	INTEGER,
	"___SyncTime"	TEXT,
	"___UserID"	TEXT NOT NULL,
	"PublicationId"	TEXT,
	"___FileOffset"	INTEGER,
	"___FileSize"	INTEGER,
	"___PercentRead"	INTEGER,
	"___ExpirationStatus"	INTEGER,
	"FavouritesIndex"	 NOT NULL DEFAULT -1,
	"Accessibility"	INTEGER DEFAULT 1,
	"ContentURL"	TEXT,
	"Language"	TEXT,
	"BookshelfTags"	TEXT,
	"IsDownloaded"	BIT NOT NULL DEFAULT 1,
	"FeedbackType"	INTEGER DEFAULT 0,
	"AverageRating"	INTEGER DEFAULT 0,
	"Depth"	INTEGER,
	"PageProgressDirection"	TEXT,
	"InWishlist"	BOOL NOT NULL DEFAULT FALSE,
	"ISBN"	TEXT,
	"WishlistedDate"	TEXT DEFAULT 0000-00-00T00:00:00.000,
	"FeedbackTypeSynced"	INTEGER DEFAULT 0,
	"IsSocialEnabled"	BOOL NOT NULL DEFAULT TRUE,
	"EpubType"	INT NOT NULL DEFAULT -1,
	"Monetization"	INTEGER DEFAULT 2,
	"ExternalId"	TEXT,
	"Series"	TEXT,
	"SeriesNumber"	TEXT,
	"Subtitle"	TEXT,
	"WordCount"	INTEGER DEFAULT -1,
	"Fallback"	TEXT,
	"RestOfBookEstimate"	INTEGER,
	"CurrentChapterEstimate"	INTEGER,
	"CurrentChapterProgress"	FLOAT,
	"PocketStatus"	INTEGER DEFAULT 0,
	"UnsyncedPocketChanges"	TEXT,
	"ImageUrl"	TEXT,
	"DateAdded"	TEXT,
	"WorkId"	TEXT,
	"Properties"	TEXT,
	"RenditionSpread"	TEXT,
	"RatingCount"	INTEGER DEFAULT 0,
	"ReviewsSyncDate"	TEXT,
	"MediaOverlay"	TEXT,
	"MediaOverlayType"	TEXT,
	"RedirectPreviewUrl"	TEXT,
	"PreviewFileSize"	INTEGER,
	"EntitlementId"	TEXT,
	"CrossRevisionId"	TEXT,
	"DownloadUrl"	TEXT,
	"ReadStateSynced"	BIT NOT NULL DEFAULT false,
	"TimesStartedReading"	INTEGER,
	"TimeSpentReading"	INTEGER,
	"LastTimeStartedReading"	TEXT,
	"LastTimeFinishedReading"	TEXT,
	"ApplicableSubscriptions"	TEXT,
	"ExternalIds"	TEXT,
	"PurchaseRevisionId"	TEXT,
	"SeriesID"	TEXT,
	"SeriesNumberFloat"	REAL,
	"AdobeLoanExpiration"	TEXT,
	"HideFromHomePage"	bit,
	"IsInternetArchive"	BOOL NOT NULL DEFAULT FALSE,
	"titleKana"	TEXT,
	"subtitleKana"	TEXT,
	"seriesKana"	TEXT,
	"attributionKana"	TEXT,
	"publisherKana"	TEXT,
	"IsPurchaseable"	BOOL DEFAULT TRUE,
	"IsSupported"	BOOL DEFAULT TRUE,
	PRIMARY KEY("ContentID")
);
Last edited by mortimer7; 07-01-2022 at 03:47 PM.
mortimer7 is offline   Reply With Quote
Old 07-01-2022, 04:20 PM   #12
Quoth
the rook, bossing Never.
Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.
 
Quoth's Avatar
 
Posts: 12,365
Karma: 92073397
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
Why do you keep pasting INSERT commands?

I think you need to study how SQL works and ask SQL questions on some suitable forum. This is not a Kobo issue, but SQL issue.

I can clearly see what davidfor is writing if I use "DB Browser for SQLite" (which also lets me edit and export), but I was using SQL before Sony, Kindle or Kobo ereaders existed.

The Table definitions show the column definitions without the data.
Data browsing shows the rows of an instance of a table. They have the actual data.
A table is a little tiny bit like a spreadsheet.
A database is one or more tables with usually some sort of interconnectedness.
Then there are indexes. Advanced databases have constraints, triggers and stored procedures.
But davidfor has been very patient and I'm not going to teach SQL here.

The difference between SQLite and an SQL Server is that the SQLite is simply a file and thus single user. An SQL server hides how the tables are stored and may use a separate file internally for each kind of thing. It's usually able to be multiuser.
A Kobo or Calibre doesn't need the overhead of an SQL server, so SQLite is used. Always work on a copy of the Kobo file. Unless you are writing an application (like Calibre) that modifies the Kobo database you don't want at all ever to use the actual file on the Kobo, but a copy on your computer.
Last edited by Quoth; 07-01-2022 at 04:31 PM.
Quoth is offline   Reply With Quote
Old 07-01-2022, 04:34 PM   #13
Quoth
the rook, bossing Never.
Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.Quoth ought to be getting tired of karma fortunes by now.
 
Quoth's Avatar
 
Posts: 12,365
Karma: 92073397
Join Date: Jun 2017
Location: Ireland
Device: All 4 Kinds: epub eink, Kindle, android eink, NxtPaper11
Oh, and don't interpret the SQL file DIRECTLY! Use a GUI SQLite tool to examine a copy of the file!
Quoth is offline   Reply With Quote
Old 07-01-2022, 04:54 PM   #14
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 40,555
Karma: 157444380
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
I would suggest visiting the SQLite Tutorial site before continuing to post here. You may also want to visit the SQLite Resources page.
DNSB is offline   Reply With Quote
Old 07-01-2022, 11:19 PM   #15
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: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by mortimer7 View Post
i believe in you but i can't find "ReadStatus" column.
For example, in this book where is it?
Really? If you can't see it, then I suggest copying the word and doing a search in this thread to find it. You have pasted it as part of the list of columns.

And for that book, the value is "1" and you are 5% through it.

And, as to @Quoth's comments, I can see a simplicity in pasting the INSERT statement. DB Browser does make it easy to copy in that format. But, I would not trust those insert statements. They do not have the list of columns, so the order of the values must match the order in the database and there must be a value for each column. Using INSERT statements like that is dangerous and should get rejected in any code review. And as the others have said, if you are intending to follow this at all, you need to go and do a SQL course of some sort.
davidfor is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting list of authors from KoboReader.sqlite Semwize Kobo Reader 4 06-14-2021 11:57 AM
KoboReader.sqlite: export and reimport annotations or edit gabryele Kobo Reader 1 05-25-2017 01:15 AM
Aura KoboReader.Sqlite help (stats lost) Skyfall Kobo Developer's Corner 6 03-29-2015 06:21 AM
Glo koboreader.sqlite File LaLaLia Kobo Reader 3 10-05-2014 09:05 PM
Koboreader.sqlite gundged maxwelledison Kobo Reader 21 01-12-2011 09:24 AM


All times are GMT -4. The time now is 05:51 PM.

Contact Us - FAQ - Guidelines - Privacy - Top

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