|
Grand Sorcerer
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Originally Posted by mortimer7
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.
|