INSERT INTO `biblio` VALUES (440,'','Gibbon, Edward,','The decline & fall of the Roman Empire /',NULL,NULL,NULL,NULL,NULL,'Title within ornamental border. | \"Edited by Oliphant Smeaton.\" | Foot-notes.',NULL,'Everyman\'s library ; | History.',1910,'2023-02-10 12:03:46','2023-02-10',NULL),(441,'','Sterne, Laurence,','The life & opinions of Tristam Shandy, gentleman /',NULL,NULL,NULL,NULL,NULL,'Spine title: Tristam Shandy',NULL,'Modern library of the world\'s best books',1950,'2023-02-10 12:04:55','2023-02-10',NULL),(442,'','Lear, Edward,','The book of nonsense /',NULL,NULL,NULL,NULL,NULL,'\"From the original authentic edition.\"',NULL,NULL,1865,'2023-02-10 12:08:20','2023-02-10',NULL),(443,'','Ovid,','Metamorphoses /',NULL,NULL,NULL,NULL,NULL,'Latin and English on opposite pages. | Volume 2 has imprint: London, Heinemann; New York, Putnam, 1933 [1916]',NULL,'The Loeb classical library.',1936,'2023-02-10 12:09:18','2023-02-10',NULL);
INSERT INTO `biblio_metadata` VALUES (438,440,'marcxml','MARC21','\n\n\n 01914cam a2200397 i 4500\n nam a22 7a 4500\n 408356\n 20230717120346.0\n 720918s1910 enk b 000 0 engmc\n \n a 11001529\n \n \n Enoch Pratt Free Libr.\n WSU\n m.c.\n SER\n COD\n \n \n ff-----\n mm-----\n \n \n DG311\n .G43 1910\n \n \n DG311\n .G43 1910\n \n \n Gibbon, Edward,\n 1737-1794.\n http://id.loc.gov/authorities/names/n80005416\n http://isni.org/isni/0000000121244125.\n \n \n The decline & fall of the Roman Empire /\n by Edward Gibbon.\n \n \n London :\n J.M. Dent & Sons, ltd. ;\n New York :\n E.P. Dutton & Co.,\n [1910]\n \n \n 6 volumes ;\n 18 cm.\n \n \n text\n txt\n rdacontent.\n \n \n unmediated\n n\n rdamedia.\n \n \n volume\n nc\n rdacarrier.\n \n \n Everyman\'s library ;\n no. 434-436, 474-476.\n History.\n \n \n Title within ornamental border.\n \n \n \"Edited by Oliphant Smeaton.\"\n \n \n Foot-notes.\n \n \n Bibliography: volume 1, pages xviii-xix.\n \n \n \"Authorities\": volume 1, pages xix-xxii.\n \n \n Rome\n History\n Empire, 30 B.C.-476 A.D.\n http://id.loc.gov/authorities/subjects/sh85115128.\n \n \n Byzantine Empire\n History.\n http://id.loc.gov/authorities/subjects/sh85018483.\n \n \n Smeaton, William Henry Oliphant,\n 1856-1914.\n http://id.loc.gov/authorities/names/n50012590\n http://isni.org/isni/0000000108649531.\n \n \n Everyman\'s library.\n History.\n http://id.loc.gov/authorities/names/no99028219.\n \n \n Everyman\'s library ;\n no. 434-436.\n http://id.loc.gov/authorities/names/n84705233.\n \n \n Everyman\'s library ;\n no. 474-476.\n http://id.loc.gov/authorities/names/n84705233.\n \n \n https://www.hathitrust.org/\n Search for the full-text version of this title in HathiTrust\n \n \n .b113479359\n \n \n 440\n 440\n \n\n','2023-02-10 12:03:46'),(439,441,'marcxml','MARC21','\n\n\n 00880nam a2200265Ma 4500\n nam a22 7a 4500\n 16674450\n 20230717120455.0\n 870912t19501950nyu 000 1 eng d\n \n OQP\n eng\n rda\n OQP\n DNU\n \n \n PR3714\n .T7 1950\n \n \n Sterne, Laurence,\n 1713-1768\n \n \n The life & opinions of Tristam Shandy, gentleman /\n by Laurence Sterne ; introduction by Bergen Evans\n \n \n Tristam Shandy\n \n \n New York :\n Modern Library,\n [1950]\n \n \n ©1950\n \n \n vii, 674 pages ;\n 19 cm\n \n \n text\n txt\n rdacontent\n \n \n unmediated\n n\n rdamedia\n \n \n volume\n nc\n rdacarrier\n \n \n Modern library of the world\'s best books\n \n \n Spine title: Tristam Shandy\n \n \n Fiction.\n lcgft\n \n \n Modern library of the world\'s best books\n \n \n 441\n 441\n \n\n','2023-02-10 12:04:55'),(440,442,'marcxml','MARC21','\n\n\n 00555nam a2200169 i 4500\n nam a22 7a 4500\n 5299002\n 20230717120820.0\n 790822s1865 enka 000 0 eng d\n \n CDH\n CDH\n TOL\n UtOrBLW\n \n \n Lear, Edward,\n 1812-1888\n \n \n The book of nonsense /\n by Edward Lear ; with all the original pictures and verses\n \n \n London ;\n New York :\n F. Warne,\n [1865?]\n \n \n [102] p. :\n ill. ;\n 20 cm\n \n \n \"From the original authentic edition.\"\n \n \n Nonsense verses\n \n \n 442\n 442\n \n\n','2023-02-10 12:08:20'),(441,443,'marcxml','MARC21','\n\n\n 01531cam a2200325ia 4500\n nam a22 7a 4500\n 10842017\n 20230717120918.0\n m19219999enk b 000 0 eng d\n \n CIN\n CIN\n \n \n eng\n lat\n lat\n \n \n PA6522.M2\n M5 1921\n \n \n Ovid,\n 43 B.C.-17 A.D. or 18 A.D.\n http://id.loc.gov/authorities/names/n79041738\n http://isni.org/isni/0000000121427757.\n \n \n Metamorphoses /\n Ovid ; with an English translation by Frank Justus Miller.\n \n \n [2d ed]\n \n \n London :\n Heinemann ;\n Cambridge :\n Harvard University Press,\n 1936 [1921]\n \n \n 2 volumes ;\n 17 cm.\n \n \n text\n txt\n rdacontent.\n \n \n unmediated\n n\n rdamedia.\n \n \n volume\n nc\n rdacarrier.\n \n \n The Loeb classical library.\n \n \n Latin and English on opposite pages.\n \n \n Volume 2 has imprint: London, Heinemann; New York, Putnam, 1933 [1916]\n \n \n Bibliography: volume 1, pages xiii-xv.\n \n \n Ovid,\n 43 B.C.-17 A.D. or 18 A.D.\n Metamorphoses.\n English\n (Miller)\n http://id.loc.gov/authorities/names/no2013051263.\n \n \n Ovid,\n 43 B.C.-17 A.D. or 18 A.D.\n Metamorphoses.\n Latin\n (Miller)\n http://id.loc.gov/authorities/names/no2013051264.\n \n \n Miller, Frank Justus.\n http://id.loc.gov/authorities/names/n88232483\n http://isni.org/isni/0000000120203727.\n \n \n Loeb classical library.\n http://id.loc.gov/authorities/names/n42015580.\n \n \n .b186808884\n \n \n 443\n 443\n \n\n','2023-02-10 12:09:18');
INSERT INTO `biblioitems` VALUES (440,440,'no. 434-436, 474-476.',NULL,NULL,NULL,NULL,NULL,NULL,'J.M. Dent & Sons, ltd. ; | E.P. Dutton & Co.,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-10 12:03:46',NULL,'6 volumes ;',NULL,'18 cm.','London : | New York :','a 11001529','https://www.hathitrust.org/',NULL,NULL,NULL,NULL,'',NULL,NULL),(441,441,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Modern Library,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-10 12:04:55',NULL,'vii, 674 pages ;',NULL,'19 cm','New York :',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(442,442,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F. Warne,',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-10 12:08:20','ill. ;','[102] p. :',NULL,'20 cm','London ; | New York :',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(443,443,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Heinemann ; | Harvard University Press,',NULL,NULL,NULL,NULL,NULL,'[2d ed]',NULL,'2023-02-10 12:09:18',NULL,'2 volumes ;',NULL,'17 cm.','London : | Cambridge :',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL);
INSERT INTO `items` VALUES (974,440,440,NULL,'2023-02-10',NULL,'CPL',NULL,NULL,'2023-02-10',NULL,'2023-02-10 12:04:10',NULL,0,0,NULL,0,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'CPL','2023-02-10 12:04:10',NULL,NULL,NULL,NULL,'ddc','',NULL,NULL,NULL,'BK',NULL,NULL,NULL,NULL,NULL,NULL),(975,441,441,NULL,'2023-02-10',NULL,'CPL',NULL,NULL,'2023-02-10',NULL,'2023-02-10 12:05:11',NULL,0,0,NULL,0,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'CPL','2023-02-10 12:05:11',NULL,NULL,NULL,NULL,'ddc','',NULL,NULL,NULL,'BK',NULL,NULL,NULL,NULL,NULL,NULL),(976,442,442,NULL,'2023-02-10',NULL,'CPL',NULL,NULL,'2023-02-10',NULL,'2023-02-10 12:08:33',NULL,0,0,NULL,0,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'CPL','2023-02-10 12:08:33',NULL,NULL,NULL,NULL,'ddc','',NULL,NULL,NULL,'BK',NULL,NULL,NULL,NULL,NULL,NULL),(977,443,443,NULL,'2023-02-10',NULL,'CPL',NULL,NULL,'2023-02-10',NULL,'2023-02-10 12:09:37',NULL,0,0,NULL,0,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'CPL','2023-02-10 12:09:37',NULL,NULL,NULL,NULL,'ddc','',NULL,NULL,NULL,'BK',NULL,NULL,NULL,NULL,NULL,NULL);
UPDATE `aqbasket` SET `creationdate` = '2023-02-01', `closedate` = '2023-02-25' WHERE `basketno` = 1;
INSERT INTO `aqorders` VALUES
(1,NULL,439,'2023-02-10',1,'USD',39.950000,NULL,NULL,NULL,0.000000,0.000000,0.000000,0,51,'2023-02-10','0','','',NULL,1,'2023-02-10 11:58:14',39.95,39.950000,39.950000,47.800175,35.95,35.955000,43.020158,NULL,0.1965,NULL,NULL,7.065158,NULL,10.0000,2,NULL,'','',NULL,NULL,0,NULL,1,'cancelled',NULL,NULL,NULL,NULL,'2023-02-28',NULL,NULL),
(2,440,NULL,'2023-02-10',1,'USD',29.950000,NULL,NULL,NULL,0.000000,0.000000,0.000000,0,51,NULL,NULL,'','',NULL,1,'2023-02-10 12:04:10',29.95,29.950000,29.950000,35.835175,26.95,26.955000,32.251658,NULL,0.1965,NULL,NULL,5.296658,NULL,10.0000,2,NULL,'','',NULL,NULL,0,NULL,2,'ordered',NULL,NULL,NULL,NULL,'2023-02-28',NULL,NULL),
(3,441,NULL,'2023-02-10',1,'USD',17.880000,NULL,NULL,NULL,0.000000,0.000000,0.000000,0,51,NULL,NULL,'','',NULL,1,'2023-02-10 12:05:11',17.88,17.880000,17.880000,21.393420,16.09,16.092000,19.254078,NULL,0.1965,NULL,NULL,3.162078,NULL,10.0000,2,NULL,'','',NULL,NULL,0,NULL,3,'ordered',NULL,NULL,NULL,NULL,'2023-02-28',NULL,NULL),
(4,442,NULL,'2023-02-10',1,'USD',12.500000,NULL,NULL,NULL,0.000000,0.000000,0.000000,0,51,NULL,NULL,'','',NULL,1,'2023-02-10 12:08:33',12.50,12.500000,12.500000,14.956250,11.25,11.250000,13.460625,NULL,0.1965,NULL,NULL,2.210625,NULL,10.0000,2,NULL,'','',NULL,NULL,0,NULL,4,'ordered',NULL,NULL,NULL,NULL,'2023-02-28',NULL,NULL),
(5,443,NULL,'2023-02-10',1,'USD',44.520000,NULL,NULL,NULL,0.000000,0.000000,0.000000,0,51,NULL,NULL,'','',NULL,1,'2023-02-10 12:09:37',44.52,44.520000,44.520000,53.268180,40.06,40.068000,47.941362,NULL,0.1965,NULL,NULL,7.873362,NULL,10.0000,2,NULL,'','',NULL,NULL,0,NULL,5,'ordered',NULL,NULL,NULL,NULL,'2023-02-28',NULL,NULL);
INSERT INTO `aqorders_items` VALUES (2,973,'2023-02-10 11:51:58'),(2,974,'2023-02-10 12:04:10'),(2,975,'2023-02-10 12:05:11'),(2,976,'2023-02-10 12:08:33'),(2,977,'2023-02-10 12:09:37');