INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4926, 1, 174, 2, 0, NULL, 0, '2024-04-23 06:46:15', '2024-04-23 09:49:57', '2024-04-23', 'P4604', '24-06250-04-23', 'lo antes posible , gracias ', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 241.40, 0, '2024-04-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230424-QF1Tpe0sq+SRr-107', 'ad5d3fa3-53e1-4b14-9aed-bd173b0ea4dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-QF1Tpe0sq%2BSRr-107&s=KOL2024&nf=P4604&i=241.40&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4927, 1, 601, 2, 0, NULL, 0, '2024-04-23 07:38:59', '2024-04-23 09:50:16', '2024-04-23', 'P4605', '24-06251-04-23', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Iturribarri, 11,-1 (puerta granate)', 'Ondarroa', 'Bizkaia', '48700', 'España', 78.63, 0, '2024-04-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230424-hnY0wdMKoDVvL-227', '5d828d94-4751-444a-862b-6abdef8d486b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-hnY0wdMKoDVvL-227&s=KOL2024&nf=P4605&i=78.63&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4928, 1, 152, 1, 0, NULL, 0, '2024-04-23 09:56:35', '2024-04-23 09:57:39', '2024-04-23', 'P4607', '', '', 0.00, 163.02, 34.23, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 197.25, 0, '2024-04-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230424-iFv5JcMvTVRQz-068', '689da788-2016-4806-8b29-327163845bd3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-iFv5JcMvTVRQz-068&s=KOL2024&nf=P4607&i=197.25&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4929, 1, 149, 2, 0, NULL, 0, '2024-04-23 12:01:42', '2024-04-23 14:59:16', '2024-04-23', 'P4608', '24-06252-04-23', '', 0.00, 236.14, 49.59, 0.00, 0, 0.00, 0.00, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 285.73, 0, '2024-04-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230424-H+6r3l+KJW/4w-123', '04b54249-eead-4422-8a4e-b39e3cf15fa3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-H%2B6r3l%2BKJW%2F4w-123&s=KOL2024&nf=P4608&i=285.73&cr=009', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4930, 1, 77, 1, 0, NULL, 0, '2024-04-23 14:58:01', '2024-04-23 14:58:01', '2024-04-23', 'P4609', '', '', 0.00, 793.65, 166.67, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 960.32, 0, '2024-04-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230424-OJzn2gGvnRSGy-078', 'd0e2551d-9399-4d9e-b40a-12a11ff96b18', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-OJzn2gGvnRSGy-078&s=KOL2024&nf=P4609&i=960.32&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4931, 1, 687, 1, 0, NULL, 0, '2024-04-23 15:36:21', '2024-04-23 15:36:21', '2024-04-23', 'P4610', '', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 103.46, 0, '2024-04-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230424-B10ob7K5Q+AHC-011', '29d43404-70ea-4062-823c-c54c08b3f8cc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-B10ob7K5Q%2BAHC-011&s=KOL2024&nf=P4610&i=103.46&cr=089', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4932, 1, 160, 2, 0, NULL, 0, '2024-04-23 13:54:46', '2024-04-23 15:56:00', '2024-04-23', 'P4611', '24-06253-04-23', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 123.15, 0, '2024-04-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230424-MCxWuwuAxG1oJ-048', 'fee90f63-9ecb-4c7e-88cd-99d0ba4ffff7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-MCxWuwuAxG1oJ-048&s=KOL2024&nf=P4611&i=123.15&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4933, 1, 110, 2, 0, NULL, 0, '2024-04-23 15:57:07', '2024-04-24 09:57:47', '2024-04-24', 'P4612', '24-06254-04-23', '', 0.00, 203.56, 42.75, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 246.31, 0, '2024-04-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240424-nmqrmB8lOVH2K-007', '93c4b36a-bb02-41ab-8a49-3f98ecfb4a50', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240424-nmqrmB8lOVH2K-007&s=KOL2024&nf=P4612&i=246.31&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4934, 1, 1238, 2, 0, NULL, 0, '2024-04-23 17:19:09', '2024-04-24 09:58:00', '2024-04-24', 'P4613', '24-06255-04-23', '', 0.00, 32.49, 11.30, 0.00, 0, 0.00, 25.77, 'Van der Vinnestraat 20 ZW', 'Haarlem', 'Noord Holland', '2023AH', 'Países Bajos', 65.08, 0, '2024-04-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240424-f1r7l9BNW/mpl-191', '9151be19-80ec-499e-82ab-30fd199efd54', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240424-f1r7l9BNW%2Fmpl-191&s=KOL2024&nf=P4613&i=65.08&cr=122', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4935, 1, 166, 1, 0, NULL, 0, '2024-04-24 10:01:13', '2024-04-24 10:01:57', '2024-04-24', 'P4614', '', '', 0.00, 171.60, 36.04, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 207.64, 0, '2024-04-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240424-P1+GCGlnt0/FY-036', '19b33b28-345e-4a29-809c-a47bdf4af205', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240424-P1%2BGCGlnt0%2FFY-036&s=KOL2024&nf=P4614&i=207.64&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4936, 1, 220, 2, 0, NULL, 0, '2024-04-24 10:10:13', '2024-04-24 12:16:48', '2024-04-24', 'P4615', '24-06256-04-24', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 344.85, 0, '2024-04-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240424-kfhRF/q6tMuy4-173', '20ac20ae-07c9-41b8-8d2f-876d3e63a804', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240424-kfhRF%2Fq6tMuy4-173&s=KOL2024&nf=P4615&i=344.85&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4937, 1, 53, 2, 0, NULL, 0, '2024-04-24 11:23:53', '2024-04-25 09:35:13', '2024-04-25', 'P4621', '24-06257-04-24', '', 0.00, 93.64, 20.10, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 115.80, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-250424-IB7ch1Z//V0+m-047', '1ae7f710-81be-414a-865d-81f191536c26', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-IB7ch1Z%2F%2FV0%2Bm-047&s=KOL2024&nf=P4621&i=115.80&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4938, 1, 1239, 2, 0, NULL, 0, '2024-04-24 12:08:41', '2024-04-25 09:37:20', '2024-04-25', 'P4616', '24-06258-04-24', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Antigua Auzoa 1-2 ezk', 'Antzuola', 'Gipuzkoa', '20577', 'España', 17.50, 0, '2024-04-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-250424-M8cZOTyBRk4nh-157', 'c1cafe5c-c530-41fc-9622-8e87dbfbf858', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-M8cZOTyBRk4nh-157&s=KOL2024&nf=P4616&i=17.50&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4939, 1, 1154, 2, 0, NULL, 0, '2024-04-24 13:40:22', '2024-04-25 09:40:29', '2024-04-25', 'P4617', '24-06260-04-24', '', 0.00, 86.64, 18.20, 0.00, 0, 0.00, 0.00, 'C/Fueros 10, 6°dcha ', 'Vitoria-Gasteiz', 'Álava', '01004', 'España', 104.83, 0, '2024-04-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250424-ZxHYOuFIFS+TA-237', 'be748820-7bf2-4279-bb44-16cb596af49a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-ZxHYOuFIFS%2BTA-237&s=KOL2024&nf=P4617&i=104.83&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4940, 1, 147, 2, 0, NULL, 0, '2024-04-24 14:10:33', '2024-04-25 09:42:55', '2024-04-25', 'P4618', '24-06261-04-24', 'Tc salón de belleza natural .\r\nCerrado los lunes y horario \r\nDe 10:00 a 17:30  hasta el viernes ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/de la palmera 23 leganes Madrid ', 'Leganés', 'Madrid', '28913', 'España', 137.94, 0, '2024-04-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250424-ae32Q6UgNChn0-081', 'b244d39a-f1f6-441c-af73-97533759c13e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-ae32Q6UgNChn0-081&s=KOL2024&nf=P4618&i=137.94&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4941, 1, 1240, 2, 0, NULL, 0, '2024-04-24 16:53:45', '2024-04-25 09:47:38', '2024-04-25', 'P4619', '24-06262-04-24', 'Farmacia. Al lado de la iglesia.\r\nHorario 9-14 y 17-20h', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Pl Pla de la Vila 16', 'Granadella (La)', 'Lleida', '25177', 'España', 17.50, 0, '2024-04-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-250424-lAyFy51vBp+H9-080', 'a07c7108-0345-45c2-aa34-9bd36f3de769', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-lAyFy51vBp%2BH9-080&s=KOL2024&nf=P4619&i=17.50&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4942, 1, 1241, 2, 0, NULL, 0, '2024-04-24 17:35:07', '2024-04-25 09:50:07', '2024-04-25', 'P4620', '24-06265-04-24', 'Si no estoy en casa dejar en Bar Alfonso ( delante de casa)', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'santiago rusiñol 5-9, bajos 2', 'Pineda de Mar', 'Barcelona', '08397', 'España', 17.50, 0, '2024-04-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-250424-d/7Ih/sO3bepR-122', '6d52d7a6-0820-44ba-97e2-e6ab36c3f051', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-d%2F7Ih%2FsO3bepR-122&s=KOL2024&nf=P4620&i=17.50&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4943, 1, 262, 2, 0, NULL, 0, '2024-04-25 07:39:50', '2024-04-25 09:53:41', '2024-04-25', 'P4622', '24-06266-04-25', 'Lunes cerrado-Sabado tarde cerrado', 0.00, 134.32, 28.21, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 162.53, 0, '2024-04-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250424-GLwY+HujOHYCE-138', '2e8c4be5-447e-4701-a49d-dab8ae229221', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-GLwY%2BHujOHYCE-138&s=KOL2024&nf=P4622&i=162.53&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4944, 1, 1094, 1, 0, NULL, 0, '2024-04-25 09:56:44', '2024-04-25 10:06:21', '2024-04-25', '', '', '', 0.00, 19.83, 4.79, 0.00, 0, 0.00, 3.64, 'Carrer sant Jaume, 37', 'Sant Iscle de Vallal', 'Barcelona', '08359', 'España', 27.63, 0, '2024-04-25 00:00:00', '', '', 5, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4945, 1, 1242, 2, 0, NULL, 0, '2024-04-25 08:11:53', '2024-04-25 10:12:37', '2024-04-25', 'P4623', '24-06267-04-25', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Carrer sant Jaume, 37', 'Sant Iscle de Vallal', 'Barcelona', '08359', 'España', 28.39, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250424-R7laJqSLkYCHg-209', '3e37ae28-81eb-45c1-a94b-fd7b06ee7832', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-R7laJqSLkYCHg-209&s=KOL2024&nf=P4623&i=28.39&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4946, 1, 1243, 2, 0, NULL, 0, '2024-04-25 08:17:14', '2024-04-25 10:22:29', '2024-04-25', 'P4624', '24-06268-04-25', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Pasajes 9-3ºA', 'Donostia-San Sebasti', 'Gipuzkoa', '20013', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-250424-b+VK3klzCgrYN-152', 'bfcb2266-ba97-45d9-8b55-7a5b00d6cc37', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-b%2BVK3klzCgrYN-152&s=KOL2024&nf=P4624&i=33.11&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4947, 1, 166, 1, 0, NULL, 0, '2024-04-25 12:33:56', '2024-04-25 12:34:53', '2024-04-25', 'P4625', '', '', 0.00, 51.48, 10.81, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 62.29, 0, '2024-04-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250424-MhYfAYD019qG6-142', '0366f2fa-11ed-47f9-949e-32de2d9c307d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-MhYfAYD019qG6-142&s=KOL2024&nf=P4625&i=62.29&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4948, 1, 1244, 2, 0, NULL, 0, '2024-04-25 11:05:09', '2024-04-25 13:06:04', '2024-04-25', 'P4626', '24-06270-04-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Nafarroa kalea 9 ( fundación Matia)', 'Zarautz', 'Gipuzkoa', '20800', 'España', 30.61, 0, '2024-04-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250424-ADr3SROiGxTXu-107', 'c69b24c8-3548-4ece-bb5d-f936e2ea7c38', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250424-ADr3SROiGxTXu-107&s=KOL2024&nf=P4626&i=30.61&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4949, 1, 190, 3, 0, NULL, 0, '2024-04-25 13:42:59', '2024-10-15 16:03:54', '2024-04-25', '', 'Consumo interno', '', 0.00, 2890.20, 606.94, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Pendiente de abonar', '20011', 'España', 3497.14, 0, '2024-04-25 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4950, 1, 522, 2, 0, NULL, 0, '2024-04-25 12:19:06', '2024-04-26 10:53:40', '2024-04-26', 'P4627', '24-06271-04-25', '', 0.00, 150.64, 31.63, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 182.27, 0, '2024-04-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260424-mZF0E0/EXbfHx-082', '399ef0f3-f7ac-4e8d-b7b7-ae331243eb66', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260424-mZF0E0%2FEXbfHx-082&s=KOL2024&nf=P4627&i=182.27&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4951, 1, 222, 2, 0, NULL, 0, '2024-04-26 10:47:02', '2024-04-26 12:50:48', '2024-04-26', 'P4628', '24-06273-04-26', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Cartagena 296 ', 'Barcelona', 'Barcelona', '08025', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260424-ZTmX+TsSV0TJv-125', '0d51f816-fb49-45d2-8109-fed8ac493942', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260424-ZTmX%2BTsSV0TJv-125&s=KOL2024&nf=P4628&i=103.46&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4952, 1, 686, 2, 0, NULL, 0, '2024-04-26 11:54:07', '2024-04-29 15:41:45', '2024-04-29', 'P4629', '24-06274-04-26', 'Hola, \r\nLa peluqueria estara cerrada hasta el dia el juves 2 de mayo.\r\nComentarlo para la entrega. \r\nmuchas gracias ', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Sancho el sabio 11. Local 3. UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 206.91, 0, '2024-04-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-J5Ac+srufVIkR-228', '48026518-661a-4e80-9985-10d9a69823f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-J5Ac%2BsrufVIkR-228&s=KOL2024&nf=P4629&i=206.91&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4953, 1, 1245, 2, 0, NULL, 0, '2024-04-26 14:15:08', '2024-04-29 09:26:22', '2024-04-29', 'P4630', '24-06276-04-26', 'Tienda Telfy ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avenida Constitución 9', 'Catral', 'Alicante', '03158', 'España', 28.39, 0, '2024-04-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-ShQ5yYXVAP+bn-219', '666b777c-fd4d-4179-a1bf-63ca87ae58ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-ShQ5yYXVAP%2Bbn-219&s=KOL2024&nf=P4630&i=28.39&cr=197', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4954, 1, 925, 2, 0, NULL, 0, '2024-04-26 18:58:27', '2024-04-29 09:30:40', '2024-04-29', 'P4631', '24-06277-04-26', '', 0.00, 142.50, 29.92, 0.00, 1, 7.41, 0.00, 'Perú número 16 Bloq 2 Bajo DCH', 'ALICANTE', 'ALICANTE', '03008', 'ESPAÑA', 179.83, 0, '2024-04-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-290424-oZIwi8Edll3Zp-133', 'c583e3f4-7c13-49fa-a4a3-e9cb6da5c262', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-oZIwi8Edll3Zp-133&s=KOL2024&nf=P4631&i=179.83&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4955, 1, 568, 2, 0, NULL, 0, '2024-04-27 07:03:19', '2024-04-29 09:32:19', '2024-04-29', 'P4632', '24-06278-04-27', 'peluquería el marco blanco', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'larramendi 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 172.43, 0, '2024-04-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-VXrO2/56jzPkF-206', '0cc4dfb6-e63b-4a14-a29e-917df6225607', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-VXrO2%2F56jzPkF-206&s=KOL2024&nf=P4632&i=172.43&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4956, 1, 23, 2, 0, NULL, 0, '2024-04-27 09:00:02', '2024-04-29 09:37:46', '2024-04-29', 'P4633', '24-06279-04-27', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 137.94, 0, '2024-04-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-J8VpudB203EV6-117', '1d8ec8bc-6b95-441b-b50e-9c4a7f74bc75', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-J8VpudB203EV6-117&s=KOL2024&nf=P4633&i=137.94&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4957, 1, 1072, 2, 0, NULL, 0, '2024-04-27 09:09:40', '2024-04-29 09:39:40', '2024-04-29', 'P4641', '24-06280-04-27', '', 0.00, 50.49, 11.04, 0.00, 0, 0.00, 2.50, 'Calle Santo Cristo de Cadrete número 5 casa 46 ', 'Cadrete', 'Zaragoza', '50420', 'España', 63.59, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290424-OHkeYHOX+1lAe-098', '548111bf-0859-4092-9239-08225bb57664', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-OHkeYHOX%2B1lAe-098&s=KOL2024&nf=P4641&i=63.59&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4958, 1, 604, 2, 0, NULL, 0, '2024-04-27 09:15:06', '2024-04-29 09:41:31', '2024-04-29', 'P4634', '24-06281-04-27', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'c/ Julio caro baroja 6 bajo', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 65.52, 0, '2024-04-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-D7r/Zz37Zr4un-188', 'c8bb1326-ab31-4f9a-af7d-8f351c109b4a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-D7r%2FZz37Zr4un-188&s=KOL2024&nf=P4634&i=65.52&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4959, 1, 1247, 2, 0, NULL, 0, '2024-04-27 15:03:59', '2024-04-29 09:43:39', '2024-04-29', 'P4635', '24-06282-04-27', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ Ramón Jiménez 22 2B ', 'Pozuelo de Alarcón', 'Madrid', '28223', 'España', 65.52, 0, '2024-04-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-290424-MHng9/Olxteca-115', '19e82236-4b8a-4625-a275-172c13099578', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-MHng9%2FOlxteca-115&s=KOL2024&nf=P4635&i=65.52&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4960, 1, 1248, 2, 0, NULL, 0, '2024-04-27 18:40:02', '2024-04-29 09:45:47', '2024-04-29', 'P4636', '24-06283-04-27', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer de Sardenya 398 5.2', 'Barcelona', 'Barcelona', '08025', 'España', 17.50, 0, '2024-04-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-oMg+41d9OwkNB-029', 'bedb8b68-1e13-4bff-9088-f4d5b6e615bb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-oMg%2B41d9OwkNB-029&s=KOL2024&nf=P4636&i=17.50&cr=011', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4961, 1, 1249, 2, 0, NULL, 0, '2024-04-28 08:19:01', '2024-04-29 09:48:05', '2024-04-29', 'P4637', '24-06285-04-28', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle Jorge Guillén, 15, 6B', 'Zaragoza', 'Zaragoza', '50018', 'España', 56.82, 0, '2024-04-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-eGII5YN2Z8Eu0-068', '6830e111-15b6-4b9a-a9f4-27630625c8d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-eGII5YN2Z8Eu0-068&s=KOL2024&nf=P4637&i=56.82&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4962, 1, 310, 2, 0, NULL, 0, '2024-04-28 12:28:36', '2024-04-29 09:50:05', '2024-04-29', 'P4638', '24-06286-04-28', '', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'C/JOSÉ LUIS ISASI Nº 6   3-C', 'Vitoria-Gasteiz', 'Álava', '01006', 'España', 95.98, 0, '2024-04-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-c6E4aWSVj02cv-235', '701fd6f4-6a3c-44a3-b89b-0e9daa73525e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-c6E4aWSVj02cv-235&s=KOL2024&nf=P4638&i=95.98&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4963, 1, 751, 2, 0, NULL, 0, '2024-04-28 13:35:40', '2024-04-29 09:51:22', '2024-04-29', 'P4639', '24-06287-04-28', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Avda Gandía 41 bloque 2 3⁰ pta32', 'Dénia', 'Alicante', '03700', 'España', 43.71, 0, '2024-04-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-JvUgrGUA/OjSf-094', 'da891981-bfeb-42a1-9efa-4da357a850d7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-JvUgrGUA%2FOjSf-094&s=KOL2024&nf=P4639&i=43.71&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4964, 1, 672, 2, 0, NULL, 0, '2024-04-28 20:32:47', '2024-04-29 09:58:14', '2024-04-29', 'P4640', '24-06288-04-28', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'ANDALUZIA KALEA 7, 7 B', 'Vitoria-Gasteiz', 'Álava', '01003', 'España', 71.98, 0, '2024-04-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-T45CYtdlfRbbV-211', 'c8a32620-493f-43ea-92e5-a0471ae3b0d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-T45CYtdlfRbbV-211&s=KOL2024&nf=P4640&i=71.98&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4965, 1, 152, 1, 0, NULL, 0, '2024-04-29 10:03:42', '2024-04-29 10:05:38', '2024-04-29', 'P4642', '', '', 0.00, 205.92, 43.24, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 249.16, 0, '2024-04-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290424-ih5uQG9ysTmk1-019', '39fed8e4-2824-40b7-b83b-d7013bf876dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-ih5uQG9ysTmk1-019&s=KOL2024&nf=P4642&i=249.16&cr=122', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4966, 1, 162, 2, 0, NULL, 0, '2024-04-29 08:09:48', '2024-04-29 10:12:11', '2024-04-29', 'P4643', '24-06289-04-29', 'Entregar en horario de mañana', 0.00, 113.98, 23.94, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 137.92, 0, '2024-04-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-hvS+rObCVU243-047', 'a554f7b3-9a47-4668-861f-4317ddaff1b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-hvS%2BrObCVU243-047&s=KOL2024&nf=P4643&i=137.91&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4967, 1, 1250, 2, 0, NULL, 0, '2024-04-29 09:21:09', '2024-04-29 11:24:46', '2024-04-29', 'P4644', '24-06290-04-29', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sasieta Mankomunitatea. Iturraldetxiko ind. 3, 2.', 'Beasain', 'Gipuzkoa', '20200', 'España', 28.39, 0, '2024-04-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290424-S5ONUPBf4jof6-072', '3b6bed3e-b997-40a9-99d7-b91ad526059f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-S5ONUPBf4jof6-072&s=KOL2024&nf=P4644&i=28.39&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4968, 1, 65, 2, 0, NULL, 0, '2024-04-29 09:58:51', '2024-07-17 13:17:59', '2024-04-29', 'P4645', '24-06291-04-29', '', 0.00, 541.50, 113.71, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 655.21, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290424-W969U0v+cub6y-021', 'd01ac37e-6ffa-4968-bd68-07ef90b2387d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-W969U0v%2Bcub6y-021&s=KOL2024&nf=P4645&i=655.22&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4969, 1, 242, 1, 0, NULL, 0, '2024-04-29 12:11:05', '2024-04-29 12:16:07', '2024-04-29', 'P4646', '', '<p>Mar, te envío otro castaño claro gratis pero no te lo pongo porque me da problema en el que te envío con costes, si meto 1 a cero coste me quita los demás.</p>', 0.00, 195.36, 41.03, 0.00, 1, 10.16, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 246.55, 0, '2024-04-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290424-X5BZ5KdJpyUmi-222', 'ba38f2a9-3356-40a8-b9ce-898a36e96350', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290424-X5BZ5KdJpyUmi-222&s=KOL2024&nf=P4646&i=246.55&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4970, 1, 264, 2, 0, NULL, 0, '2024-04-29 18:59:39', '2024-04-30 09:15:18', '2024-04-30', 'P4647', '24-06292-04-29', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Gran via de les corts catalans 432 ent 2', 'Barcelona', 'Barcelona', '08015', 'España', 17.50, 0, '2024-04-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300424-PefVurX/fPPz8-175', 'a5cd5cb5-d9ff-4b69-b688-3bd465c4d30d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300424-PefVurX%2FfPPz8-175&s=KOL2024&nf=P4647&i=17.50&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4971, 1, 73, 2, 0, NULL, 0, '2024-04-30 06:20:36', '2024-04-30 09:18:50', '2024-04-30', 'P4648', '24-06293-04-30', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'zapatari 2A peluqueria', 'Beasain', 'Gipuzkoa', '20200', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300424-m3+7bkqLIrkYZ-129', '6661849e-1758-46d7-bcbe-f8dc7de5ca4b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300424-m3%2B7bkqLIrkYZ-129&s=KOL2024&nf=P4648&i=206.91&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4972, 1, 859, 2, 0, NULL, 0, '2024-04-30 11:29:42', '2024-05-02 08:58:58', '2024-05-02', 'P4649', '24-06294-04-30', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Carretera EX-208 Kilometro 95', 'Conquista de la Sier', 'Cáceres', '10240', 'España', 52.39, 0, '2024-04-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020524-TGf6yusP849f7-119', 'c0f77200-0f90-479a-8f09-f42210325528', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020524-TGf6yusP849f7-119&s=KOL2024&nf=P4649&i=52.39&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4973, 1, 85, 2, 0, NULL, 0, '2024-04-30 11:33:31', '2024-05-02 09:04:36', '2024-05-02', 'P4654', '24-06295-04-30', '', 0.00, 170.98, 35.91, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 206.89, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020524-L0vCz96uj5x/H-076', '4393b79e-d7b4-4b75-88c7-cda3af3e014e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020524-L0vCz96uj5x%2FH-076&s=KOL2024&nf=P4654&i=206.89&cr=013', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4974, 1, 85, 2, 0, NULL, 0, '2024-04-30 11:33:35', '2024-04-30 11:33:35', '2024-04-30', '', '24-06296-04-30', NULL, 0.00, 170.98, 35.91, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 206.89, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4975, 1, 85, 2, 0, NULL, 0, '2024-04-30 11:33:37', '2024-04-30 11:33:37', '2024-04-30', '', '24-06297-04-30', NULL, 0.00, 170.98, 35.91, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 206.89, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4976, 1, 1251, 2, 0, NULL, 0, '2024-04-30 16:24:40', '2024-05-02 09:10:19', '2024-05-02', 'P4655', '24-06298-04-30', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'santa Clara 38 local peluqueria', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020524-BMjEWnk0kNiKl-077', '12e8ffe3-0ed3-49e5-99f1-b1e3c923a0f3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020524-BMjEWnk0kNiKl-077&s=KOL2024&nf=P4655&i=206.91&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4977, 1, 1252, 2, 0, NULL, 0, '2024-05-01 08:03:33', '2024-05-02 09:14:32', '2024-05-02', 'P4650', '24-06299-05-01', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle de Juan de Velasco 4, N°4-6°iz', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 17.50, 0, '2024-05-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020524-Skp19sdXBOAIP-133', '415343d3-bcdb-418c-9702-9580c35cef57', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020524-Skp19sdXBOAIP-133&s=KOL2024&nf=P4650&i=17.50&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4978, 1, 1253, 2, 0, NULL, 0, '2024-05-01 09:44:44', '2024-05-02 09:18:19', '2024-05-02', 'P4651', '24-06301-05-01', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle La paz nº37 bajo derecha', 'Barakaldo', 'Bizkaia', '48903', 'España', 30.61, 0, '2024-05-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020524-RxCXnuJarmiJe-189', 'c1c49678-07f0-4fea-8eb1-91f9040e61e4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020524-RxCXnuJarmiJe-189&s=KOL2024&nf=P4651&i=30.61&cr=198', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4979, 1, 1227, 2, 0, NULL, 0, '2024-05-01 10:48:41', '2024-05-02 09:21:05', '2024-05-02', 'P4652', '24-06302-05-01', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Calle los cantos 24, 2° B', 'Alcorcón', 'Madrid', '28922', 'España', 61.09, 0, '2024-05-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020524-aKV5SmOlbUflv-090', '75f4fcba-9a57-435c-b0f3-1909076267e2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020524-aKV5SmOlbUflv-090&s=KOL2024&nf=P4652&i=61.09&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4980, 1, 638, 2, 0, NULL, 0, '2024-05-01 22:01:20', '2024-05-02 09:23:11', '2024-05-02', 'P4653', '24-06304-05-01', 'Mayan(Peluquera y estética)/Lunes cerrado.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/Javier Echevarría N°1', 'Castro-Urdiales', 'Cantabria', '39700', 'España', 28.39, 0, '2024-05-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020524-G//QcTX3eJSgI-109', '4fbe052c-38bb-4ed7-a09f-cbdabb5c6516', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020524-G%2F%2FQcTX3eJSgI-109&s=KOL2024&nf=P4653&i=28.39&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4981, 1, 1254, 2, 0, NULL, 0, '2024-05-02 13:08:36', '2024-05-07 09:32:20', '2024-05-07', 'P4673', '24-06307-05-02', 'Esta dirección es de Estados Unidos', 0.00, 39.66, 12.80, 0.00, 0, 0.00, 25.77, '36 Waterford Circle', 'Dighton ', 'Massachusetts ', '02715', 'España', 73.76, 0, '2024-05-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070524-l7EqQgTaBIDD2-199', 'a72f6b10-8358-4be4-b710-b2bb4dec7240', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070524-l7EqQgTaBIDD2-199&s=KOL2024&nf=P4673&i=73.76&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4982, 1, 1190, 2, 0, NULL, 0, '2024-05-02 13:56:46', '2024-05-03 09:08:17', '2024-05-03', 'P4657', '24-06308-05-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sagasti Auzoa N1 SM (PELUQUERIA COT)', 'Antzuola', 'Gipuzkoa', '20577', 'España', 28.39, 0, '2024-05-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030524-abjmYeWXZ+y+2-073', 'a13c3d03-700f-466c-8b70-cd7d4b7fd780', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030524-abjmYeWXZ%2By%2B2-073&s=KOL2024&nf=P4657&i=28.39&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4983, 1, 372, 2, 0, NULL, 0, '2024-05-02 22:34:18', '2024-05-03 09:08:51', '2024-05-03', 'P4656', '24-06309-05-02', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer Arenal n 7', 'Castelló d\'Empúries', 'Girona', '17487', 'España', 17.50, 0, '2024-05-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030524-P3GtdqXrIA2GN-221', '17e2f788-062e-491d-9994-aa60cddb4b58', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030524-P3GtdqXrIA2GN-221&s=KOL2024&nf=P4656&i=17.50&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
