Thread: Export list of books from KoboReader.sqlite
View Single Post
Old 06-29-2022, 01: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 04:39 AM.
mortimer7 is offline   Reply With Quote