Bugzilla – Attachment 153618 Details for
Bug 12732
Allow sorting by basket creation date to the late orders table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
SQL update to add late orders
testing-late-orders.sql (text/plain), 21.30 KB, created by
Owen Leonard
on 2023-07-18 17:37:59 UTC
(
hide
)
Description:
SQL update to add late orders
Filename:
MIME Type:
Creator:
Owen Leonard
Created:
2023-07-18 17:37:59 UTC
Size:
21.30 KB
patch
obsolete
>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','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<record\n xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xsi:schemaLocation=\"http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd\"\n xmlns=\"http://www.loc.gov/MARC21/slim\">\n\n <leader>01914cam a2200397 i 4500</leader>\n <controlfield tag=\"000\"> nam a22 7a 4500</controlfield>\n <controlfield tag=\"001\">408356</controlfield>\n <controlfield tag=\"005\">20230717120346.0</controlfield>\n <controlfield tag=\"008\">720918s1910 enk b 000 0 engmc</controlfield>\n <datafield tag=\"010\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">a 11001529</subfield>\n </datafield>\n <datafield tag=\"040\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">Enoch Pratt Free Libr.</subfield>\n <subfield code=\"c\">WSU</subfield>\n <subfield code=\"d\">m.c.</subfield>\n <subfield code=\"d\">SER</subfield>\n <subfield code=\"d\">COD</subfield>\n </datafield>\n <datafield tag=\"043\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">ff-----</subfield>\n <subfield code=\"a\">mm-----</subfield>\n </datafield>\n <datafield tag=\"090\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">DG311</subfield>\n <subfield code=\"b\">.G43 1910</subfield>\n </datafield>\n <datafield tag=\"090\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">DG311</subfield>\n <subfield code=\"b\">.G43 1910</subfield>\n </datafield>\n <datafield tag=\"100\" ind1=\"1\" ind2=\" \">\n <subfield code=\"a\">Gibbon, Edward,</subfield>\n <subfield code=\"d\">1737-1794.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/n80005416</subfield>\n <subfield code=\"1\">http://isni.org/isni/0000000121244125.</subfield>\n </datafield>\n <datafield tag=\"245\" ind1=\"1\" ind2=\"4\">\n <subfield code=\"a\">The decline & fall of the Roman Empire /</subfield>\n <subfield code=\"c\">by Edward Gibbon.</subfield>\n </datafield>\n <datafield tag=\"260\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">London :</subfield>\n <subfield code=\"b\">J.M. Dent & Sons, ltd. ;</subfield>\n <subfield code=\"a\">New York :</subfield>\n <subfield code=\"b\">E.P. Dutton & Co.,</subfield>\n <subfield code=\"c\">[1910]</subfield>\n </datafield>\n <datafield tag=\"300\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">6 volumes ;</subfield>\n <subfield code=\"c\">18 cm.</subfield>\n </datafield>\n <datafield tag=\"336\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">text</subfield>\n <subfield code=\"b\">txt</subfield>\n <subfield code=\"2\">rdacontent.</subfield>\n </datafield>\n <datafield tag=\"337\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">unmediated</subfield>\n <subfield code=\"b\">n</subfield>\n <subfield code=\"2\">rdamedia.</subfield>\n </datafield>\n <datafield tag=\"338\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">volume</subfield>\n <subfield code=\"b\">nc</subfield>\n <subfield code=\"2\">rdacarrier.</subfield>\n </datafield>\n <datafield tag=\"490\" ind1=\"1\" ind2=\" \">\n <subfield code=\"a\">Everyman\'s library ;</subfield>\n <subfield code=\"v\">no. 434-436, 474-476.</subfield>\n <subfield code=\"a\">History.</subfield>\n </datafield>\n <datafield tag=\"500\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">Title within ornamental border.</subfield>\n </datafield>\n <datafield tag=\"500\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">\"Edited by Oliphant Smeaton.\"</subfield>\n </datafield>\n <datafield tag=\"500\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">Foot-notes.</subfield>\n </datafield>\n <datafield tag=\"504\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">Bibliography: volume 1, pages xviii-xix.</subfield>\n </datafield>\n <datafield tag=\"504\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">\"Authorities\": volume 1, pages xix-xxii.</subfield>\n </datafield>\n <datafield tag=\"651\" ind1=\" \" ind2=\"0\">\n <subfield code=\"a\">Rome</subfield>\n <subfield code=\"x\">History</subfield>\n <subfield code=\"y\">Empire, 30 B.C.-476 A.D.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/subjects/sh85115128.</subfield>\n </datafield>\n <datafield tag=\"651\" ind1=\" \" ind2=\"0\">\n <subfield code=\"a\">Byzantine Empire</subfield>\n <subfield code=\"x\">History.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/subjects/sh85018483.</subfield>\n </datafield>\n <datafield tag=\"700\" ind1=\"1\" ind2=\" \">\n <subfield code=\"a\">Smeaton, William Henry Oliphant,</subfield>\n <subfield code=\"d\">1856-1914.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/n50012590</subfield>\n <subfield code=\"1\">http://isni.org/isni/0000000108649531.</subfield>\n </datafield>\n <datafield tag=\"830\" ind1=\" \" ind2=\"0\">\n <subfield code=\"a\">Everyman\'s library.</subfield>\n <subfield code=\"p\">History.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/no99028219.</subfield>\n </datafield>\n <datafield tag=\"830\" ind1=\" \" ind2=\"0\">\n <subfield code=\"a\">Everyman\'s library ;</subfield>\n <subfield code=\"v\">no. 434-436.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/n84705233.</subfield>\n </datafield>\n <datafield tag=\"830\" ind1=\" \" ind2=\"0\">\n <subfield code=\"a\">Everyman\'s library ;</subfield>\n <subfield code=\"v\">no. 474-476.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/n84705233.</subfield>\n </datafield>\n <datafield tag=\"856\" ind1=\"4\" ind2=\"2\">\n <subfield code=\"u\">https://www.hathitrust.org/</subfield>\n <subfield code=\"z\">Search for the full-text version of this title in HathiTrust</subfield>\n </datafield>\n <datafield tag=\"907\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">.b113479359</subfield>\n </datafield>\n <datafield tag=\"999\" ind1=\" \" ind2=\" \">\n <subfield code=\"c\">440</subfield>\n <subfield code=\"d\">440</subfield>\n </datafield>\n</record>\n','2023-02-10 12:03:46'),(439,441,'marcxml','MARC21','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<record\n xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xsi:schemaLocation=\"http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd\"\n xmlns=\"http://www.loc.gov/MARC21/slim\">\n\n <leader>00880nam a2200265Ma 4500</leader>\n <controlfield tag=\"000\"> nam a22 7a 4500</controlfield>\n <controlfield tag=\"001\">16674450</controlfield>\n <controlfield tag=\"005\">20230717120455.0</controlfield>\n <controlfield tag=\"008\">870912t19501950nyu 000 1 eng d</controlfield>\n <datafield tag=\"040\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">OQP</subfield>\n <subfield code=\"b\">eng</subfield>\n <subfield code=\"e\">rda</subfield>\n <subfield code=\"c\">OQP</subfield>\n <subfield code=\"d\">DNU</subfield>\n </datafield>\n <datafield tag=\"090\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">PR3714</subfield>\n <subfield code=\"b\">.T7 1950</subfield>\n </datafield>\n <datafield tag=\"100\" ind1=\"1\" ind2=\" \">\n <subfield code=\"a\">Sterne, Laurence,</subfield>\n <subfield code=\"d\">1713-1768</subfield>\n </datafield>\n <datafield tag=\"245\" ind1=\"1\" ind2=\"4\">\n <subfield code=\"a\">The life & opinions of Tristam Shandy, gentleman /</subfield>\n <subfield code=\"c\">by Laurence Sterne ; introduction by Bergen Evans</subfield>\n </datafield>\n <datafield tag=\"246\" ind1=\"3\" ind2=\" \">\n <subfield code=\"a\">Tristam Shandy</subfield>\n </datafield>\n <datafield tag=\"264\" ind1=\" \" ind2=\"1\">\n <subfield code=\"a\">New York :</subfield>\n <subfield code=\"b\">Modern Library,</subfield>\n <subfield code=\"c\">[1950]</subfield>\n </datafield>\n <datafield tag=\"264\" ind1=\" \" ind2=\"4\">\n <subfield code=\"c\">©1950</subfield>\n </datafield>\n <datafield tag=\"300\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">vii, 674 pages ;</subfield>\n <subfield code=\"c\">19 cm</subfield>\n </datafield>\n <datafield tag=\"336\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">text</subfield>\n <subfield code=\"b\">txt</subfield>\n <subfield code=\"2\">rdacontent</subfield>\n </datafield>\n <datafield tag=\"337\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">unmediated</subfield>\n <subfield code=\"b\">n</subfield>\n <subfield code=\"2\">rdamedia</subfield>\n </datafield>\n <datafield tag=\"338\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">volume</subfield>\n <subfield code=\"b\">nc</subfield>\n <subfield code=\"2\">rdacarrier</subfield>\n </datafield>\n <datafield tag=\"490\" ind1=\"1\" ind2=\" \">\n <subfield code=\"a\">Modern library of the world\'s best books</subfield>\n </datafield>\n <datafield tag=\"500\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">Spine title: Tristam Shandy</subfield>\n </datafield>\n <datafield tag=\"655\" ind1=\" \" ind2=\"7\">\n <subfield code=\"a\">Fiction.</subfield>\n <subfield code=\"2\">lcgft</subfield>\n </datafield>\n <datafield tag=\"830\" ind1=\" \" ind2=\"0\">\n <subfield code=\"a\">Modern library of the world\'s best books</subfield>\n </datafield>\n <datafield tag=\"999\" ind1=\" \" ind2=\" \">\n <subfield code=\"c\">441</subfield>\n <subfield code=\"d\">441</subfield>\n </datafield>\n</record>\n','2023-02-10 12:04:55'),(440,442,'marcxml','MARC21','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<record\n xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xsi:schemaLocation=\"http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd\"\n xmlns=\"http://www.loc.gov/MARC21/slim\">\n\n <leader>00555nam a2200169 i 4500</leader>\n <controlfield tag=\"000\"> nam a22 7a 4500</controlfield>\n <controlfield tag=\"001\">5299002</controlfield>\n <controlfield tag=\"005\">20230717120820.0</controlfield>\n <controlfield tag=\"008\">790822s1865 enka 000 0 eng d</controlfield>\n <datafield tag=\"040\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">CDH</subfield>\n <subfield code=\"c\">CDH</subfield>\n <subfield code=\"d\">TOL</subfield>\n <subfield code=\"d\">UtOrBLW</subfield>\n </datafield>\n <datafield tag=\"100\" ind1=\"1\" ind2=\" \">\n <subfield code=\"a\">Lear, Edward,</subfield>\n <subfield code=\"d\">1812-1888</subfield>\n </datafield>\n <datafield tag=\"245\" ind1=\"1\" ind2=\"4\">\n <subfield code=\"a\">The book of nonsense /</subfield>\n <subfield code=\"c\">by Edward Lear ; with all the original pictures and verses</subfield>\n </datafield>\n <datafield tag=\"260\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">London ;</subfield>\n <subfield code=\"a\">New York :</subfield>\n <subfield code=\"b\">F. Warne,</subfield>\n <subfield code=\"c\">[1865?]</subfield>\n </datafield>\n <datafield tag=\"300\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">[102] p. :</subfield>\n <subfield code=\"b\">ill. ;</subfield>\n <subfield code=\"c\">20 cm</subfield>\n </datafield>\n <datafield tag=\"500\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">\"From the original authentic edition.\"</subfield>\n </datafield>\n <datafield tag=\"650\" ind1=\" \" ind2=\"0\">\n <subfield code=\"a\">Nonsense verses</subfield>\n </datafield>\n <datafield tag=\"999\" ind1=\" \" ind2=\" \">\n <subfield code=\"c\">442</subfield>\n <subfield code=\"d\">442</subfield>\n </datafield>\n</record>\n','2023-02-10 12:08:20'),(441,443,'marcxml','MARC21','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<record\n xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xsi:schemaLocation=\"http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd\"\n xmlns=\"http://www.loc.gov/MARC21/slim\">\n\n <leader>01531cam a2200325ia 4500</leader>\n <controlfield tag=\"000\"> nam a22 7a 4500</controlfield>\n <controlfield tag=\"001\">10842017</controlfield>\n <controlfield tag=\"005\">20230717120918.0</controlfield>\n <controlfield tag=\"008\"> m19219999enk b 000 0 eng d</controlfield>\n <datafield tag=\"040\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">CIN</subfield>\n <subfield code=\"c\">CIN</subfield>\n </datafield>\n <datafield tag=\"041\" ind1=\"1\" ind2=\" \">\n <subfield code=\"a\">eng</subfield>\n <subfield code=\"a\">lat</subfield>\n <subfield code=\"h\">lat</subfield>\n </datafield>\n <datafield tag=\"090\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">PA6522.M2</subfield>\n <subfield code=\"b\">M5 1921</subfield>\n </datafield>\n <datafield tag=\"100\" ind1=\"0\" ind2=\" \">\n <subfield code=\"a\">Ovid,</subfield>\n <subfield code=\"d\">43 B.C.-17 A.D. or 18 A.D.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/n79041738</subfield>\n <subfield code=\"1\">http://isni.org/isni/0000000121427757.</subfield>\n </datafield>\n <datafield tag=\"245\" ind1=\"1\" ind2=\"0\">\n <subfield code=\"a\">Metamorphoses /</subfield>\n <subfield code=\"c\">Ovid ; with an English translation by Frank Justus Miller.</subfield>\n </datafield>\n <datafield tag=\"250\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">[2d ed]</subfield>\n </datafield>\n <datafield tag=\"260\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">London :</subfield>\n <subfield code=\"b\">Heinemann ;</subfield>\n <subfield code=\"a\">Cambridge :</subfield>\n <subfield code=\"b\">Harvard University Press,</subfield>\n <subfield code=\"c\">1936 [1921]</subfield>\n </datafield>\n <datafield tag=\"300\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">2 volumes ;</subfield>\n <subfield code=\"c\">17 cm.</subfield>\n </datafield>\n <datafield tag=\"336\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">text</subfield>\n <subfield code=\"b\">txt</subfield>\n <subfield code=\"2\">rdacontent.</subfield>\n </datafield>\n <datafield tag=\"337\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">unmediated</subfield>\n <subfield code=\"b\">n</subfield>\n <subfield code=\"2\">rdamedia.</subfield>\n </datafield>\n <datafield tag=\"338\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">volume</subfield>\n <subfield code=\"b\">nc</subfield>\n <subfield code=\"2\">rdacarrier.</subfield>\n </datafield>\n <datafield tag=\"490\" ind1=\"1\" ind2=\" \">\n <subfield code=\"a\">The Loeb classical library.</subfield>\n </datafield>\n <datafield tag=\"500\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">Latin and English on opposite pages.</subfield>\n </datafield>\n <datafield tag=\"500\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">Volume 2 has imprint: London, Heinemann; New York, Putnam, 1933 [1916]</subfield>\n </datafield>\n <datafield tag=\"504\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">Bibliography: volume 1, pages xiii-xv.</subfield>\n </datafield>\n <datafield tag=\"700\" ind1=\"0\" ind2=\"2\">\n <subfield code=\"a\">Ovid,</subfield>\n <subfield code=\"d\">43 B.C.-17 A.D. or 18 A.D.</subfield>\n <subfield code=\"t\">Metamorphoses.</subfield>\n <subfield code=\"l\">English</subfield>\n <subfield code=\"s\">(Miller)</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/no2013051263.</subfield>\n </datafield>\n <datafield tag=\"700\" ind1=\"0\" ind2=\"2\">\n <subfield code=\"a\">Ovid,</subfield>\n <subfield code=\"d\">43 B.C.-17 A.D. or 18 A.D.</subfield>\n <subfield code=\"t\">Metamorphoses.</subfield>\n <subfield code=\"l\">Latin</subfield>\n <subfield code=\"s\">(Miller)</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/no2013051264.</subfield>\n </datafield>\n <datafield tag=\"700\" ind1=\"1\" ind2=\" \">\n <subfield code=\"a\">Miller, Frank Justus.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/n88232483</subfield>\n <subfield code=\"1\">http://isni.org/isni/0000000120203727.</subfield>\n </datafield>\n <datafield tag=\"830\" ind1=\" \" ind2=\"0\">\n <subfield code=\"a\">Loeb classical library.</subfield>\n <subfield code=\"0\">http://id.loc.gov/authorities/names/n42015580.</subfield>\n </datafield>\n <datafield tag=\"907\" ind1=\" \" ind2=\" \">\n <subfield code=\"a\">.b186808884</subfield>\n </datafield>\n <datafield tag=\"999\" ind1=\" \" ind2=\" \">\n <subfield code=\"c\">443</subfield>\n <subfield code=\"d\">443</subfield>\n </datafield>\n</record>\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');
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=153618">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 12732
:
30592
|
30794
|
31064
|
32298
|
32301
|
32303
|
58232
|
58233
|
153617
| 153618 |
154633
|
156280
|
156291
|
156292