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
(5926, 1, 77, 1, 0, NULL, 0, '2024-10-15 12:02:57', '2024-10-15 12:02:57', '2024-10-15', 'P5563', '', '', 0.00, 343.20, 72.07, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 415.27, 0, '2024-10-15 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-151024-Zxw1DX12YFNZt-138', '0714de22-6e13-4cba-b1cb-cb5c0efdfbd1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-Zxw1DX12YFNZt-138&s=KOL2024&nf=P5563&i=415.27&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5927, 1, 1464, 2, 0, NULL, 0, '2024-10-15 10:57:06', '2024-10-15 12:58:40', '2024-10-15', 'P5564', '24-07312-10-15', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Cid Campeador 1-1-4', 'Gandia', 'Valencia', '46702', 'España', 30.61, 0, '2024-10-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-151024-ZNFEHixrNRkol-101', '2bac5329-0c65-444a-af71-4a9617acd67c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-ZNFEHixrNRkol-101&s=KOL2024&nf=P5564&i=30.61&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5928, 1, 1465, 2, 0, NULL, 0, '2024-10-15 11:37:17', '2024-10-15 15:14:09', '2024-10-15', 'P5565', '24-07313-10-15', 'entregar por las mañanas. Puesto aceitunas.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Espronceda 2 Mercado de San Roque', 'Alcoy/Alcoi', 'Alicante', '03803', 'España', 28.39, 0, '2024-10-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-151024-NS3YI/Qt434W4-217', 'c1dec560-3446-497b-9525-1881c8cdb536', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-NS3YI%2FQt434W4-217&s=KOL2024&nf=P5565&i=28.39&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5929, 1, 1466, 2, 0, NULL, 0, '2024-10-15 11:46:39', '2024-10-15 15:20:43', '2024-10-15', 'P5566', '24-07315-10-15', 'Por favor,llamar antes de la entrega ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ Santiago Brouard n 5. 7° A', 'Bilbao', 'Bizkaia', '48012', 'España', 28.39, 0, '2024-10-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151024-HcvWkDz8Ttb4s-098', '3e78a188-9e2f-4b2b-a57a-56e5ee954e99', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-HcvWkDz8Ttb4s-098&s=KOL2024&nf=P5566&i=28.39&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5930, 1, 1467, 2, 0, NULL, 0, '2024-10-15 13:11:48', '2024-10-15 15:21:23', '2024-10-15', 'P5567', '24-07317-10-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'RUA DO TAMBRE Nº 17 1º A (CUALQUIERA DE LAS TRES PUERTAS DE LA FACHADA)', 'Santiago de Composte', 'A Coruña', '15705', 'España', 17.50, 0, '2024-10-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151024-UP+WzhLlNfXFR-014', '9bc81592-ed7e-4bbe-8da0-6488ffe5a4e2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-UP%2BWzhLlNfXFR-014&s=KOL2024&nf=P5567&i=17.50&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5931, 1, 1468, 2, 0, NULL, 0, '2024-10-15 15:48:07', '2024-10-16 08:53:02', '2024-10-16', 'P5568', '24-07318-10-15', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Juan simon gutierrez 11', 'Medina-Sidonia', 'Cádiz', '11170', 'España', 65.52, 0, '2024-10-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-161024-TfeNcRV+EAIrr-078', 'a6a8f0e5-4ae5-45e9-9e8f-0485f2f4e22f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161024-TfeNcRV%2BEAIrr-078&s=KOL2024&nf=P5568&i=65.52&cr=056', '[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
(5932, 1, 1469, 2, 0, NULL, 0, '2024-10-15 20:16:56', '2024-10-16 08:54:54', '2024-10-16', 'P5569', '24-07319-10-15', 'Si estoy ausente en la entrega, dejar a las vecinas: 1B, 2A, 3A.', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Secundino Esnaola 40-1A', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 30.61, 0, '2024-10-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161024-FNJbxwBvSkamJ-119', '2c5d13fb-0883-4913-b7c1-e0fca21a0820', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161024-FNJbxwBvSkamJ-119&s=KOL2024&nf=P5569&i=30.61&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5933, 1, 110, 2, 0, NULL, 0, '2024-10-16 08:49:23', '2024-10-16 10:54:21', '2024-10-16', 'P5570', '24-07320-10-16', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 275.88, 0, '2024-10-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-161024-ElmDHbq5dV0hb-053', 'db484db3-15de-454f-a89b-32ba6b18252e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161024-ElmDHbq5dV0hb-053&s=KOL2024&nf=P5570&i=275.88&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5934, 1, 1470, 2, 0, NULL, 0, '2024-10-16 09:49:47', '2024-10-16 11:50:31', '2024-10-16', 'P5571', '24-07321-10-16', 'Si no hay nadie en el bajo izquierda, puede llamar al bajo centro izquierda y dejárselo al vecino.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Doctor Arce, 2, bajo izquierda ', 'Coslada', 'Madrid', '28821', 'España', 17.50, 0, '2024-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161024-XjY/BwlpABcb4-022', 'd4dce14c-0a4f-4f5f-b71d-37237eb4cd7f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161024-XjY%2FBwlpABcb4-022&s=KOL2024&nf=P5571&i=17.50&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5935, 1, 870, 2, 0, NULL, 0, '2024-10-16 09:55:59', '2024-10-16 11:58:37', '2024-10-16', 'P5572', '24-07322-10-16', 'Se puede entregar en portería si no estoy en casa.', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle Fuente Carrantona 38C 4 izquierda ', 'Madrid', 'Madrid', '28030', 'España', 68.97, 0, '2024-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161024-XjgIum9myvR/8-069', '455a0a80-a94b-48ff-9175-b2402c731617', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161024-XjgIum9myvR%2F8-069&s=KOL2024&nf=P5572&i=68.97&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5936, 1, 174, 2, 0, NULL, 0, '2024-10-16 10:04:43', '2024-10-16 12:09:12', '2024-10-16', 'P5573', '24-07323-10-16', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 275.88, 0, '2024-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161024-CIGJeERYwFPqz-035', '707f6f5a-fd4d-48c1-a1dc-b1a7d0469065', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161024-CIGJeERYwFPqz-035&s=KOL2024&nf=P5573&i=275.88&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5937, 1, 1471, 2, 0, NULL, 0, '2024-10-16 13:14:19', '2024-10-16 16:06:01', '2024-10-16', 'P5574', '24-07324-10-16', 'Horario de oficina:\r\nLunes a viernes: 09:30 a 17:30', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Mercedes Formica 10 local 5', 'Málaga', 'Málaga', '29140', 'España', 17.50, 0, '2024-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161024-SI3E3Xq773/C9-162', 'cc00fce4-770c-495c-96ee-defcd9784e7e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161024-SI3E3Xq773%2FC9-162&s=KOL2024&nf=P5574&i=17.50&cr=113', '[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
(5938, 1, 754, 2, 0, NULL, 0, '2024-10-16 13:51:58', '2024-10-16 16:07:42', '2024-10-16', 'P5575', '24-07325-10-16', '6+1 REGALO RUBIO EXTRACLARO', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161024-Mb8s1uVJdxut8-145', '562300f3-3d25-4e42-9121-3ff5e73fad41', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161024-Mb8s1uVJdxut8-145&s=KOL2024&nf=P5575&i=61.64&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5939, 1, 356, 2, 0, NULL, 0, '2024-10-16 14:03:56', '2024-10-16 16:12:30', '2024-10-16', 'P5576', '24-07326-10-16', 'El portal está en la parte de atrás del edificio.Gracias!', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'c/ Mendarozabal, 5 - 2 izq.', 'Mendaro', 'Gipuzkoa', '2850', 'España', 71.98, 0, '2024-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161024-eAm52RyPYOqN6-104', '0055205f-a1a0-4a88-b72d-c19136435eeb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161024-eAm52RyPYOqN6-104&s=KOL2024&nf=P5576&i=71.98&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5940, 1, 1453, 2, 0, NULL, 0, '2024-10-16 15:19:17', '2024-10-16 15:19:17', '2024-10-16', '', '24-07288-10-13', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Palmanova, Puige Teide 4, Apt 102,', 'Calvià', 'Baleares (Illes)', '07181', 'España', 61.09, 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),
(5941, 1, 164, 2, 0, NULL, 0, '2024-10-16 19:07:52', '2024-10-17 08:25:28', '2024-10-17', 'P5577', '24-07327-10-16', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 172.43, 0, '2024-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171024-BJcI4w8ruFSME-060', 'da68fbd7-eb3a-4473-bbd7-8ddb2078f1c4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171024-BJcI4w8ruFSME-060&s=KOL2024&nf=P5577&i=172.43&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5942, 1, 1472, 2, 0, NULL, 0, '2024-10-17 08:50:29', '2024-10-17 11:15:47', '2024-10-17', 'P5578', '24-07328-10-17', 'si no estoy dejárselo a algún vecino (avisar de ello)', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'PIKETAZAHARRA 41', 'Irun', 'Gipuzkoa', '20303', 'España', 30.61, 0, '2024-10-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171024-PTkliiNm8l8mZ-146', 'b27bb7ec-2665-4cff-8214-58cc01dcc43f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171024-PTkliiNm8l8mZ-146&s=KOL2024&nf=P5578&i=30.61&cr=013', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5943, 1, 589, 2, 0, NULL, 0, '2024-10-17 13:00:02', '2024-10-17 16:35:50', '2024-10-17', 'P5579', '24-07329-10-17', 'Entrega de tarde a partir de las 16', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Avenida Constitución 184, portal 3 , escalera 5 , 1 E', 'Torrejón de Ardoz', 'Madrid', '28850', 'España', 56.82, 0, '2024-10-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171024-A/Jmi1zIv+g24-124', 'eda8e86e-ef91-4dd8-86aa-0036b99cc8d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171024-A%2FJmi1zIv%2Bg24-124&s=KOL2024&nf=P5579&i=56.82&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5944, 1, 1065, 2, 0, NULL, 0, '2024-10-17 13:29:13', '2024-10-17 16:40:37', '2024-10-17', 'P5580', '24-07330-10-17', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Avda. Gran Via Asima, 1 - 07009 Palma', 'Palma de Mallorca', 'Baleares (Illes)', '07009', 'España', 78.63, 0, '2024-10-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171024-bVgrGWKLzZ9xg-031', '5b874b5f-3eb4-49b5-b37c-0b7fdf546ab5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171024-bVgrGWKLzZ9xg-031&s=KOL2024&nf=P5580&i=78.63&cr=187', '[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
(5945, 1, 1473, 2, 0, NULL, 0, '2024-10-17 17:34:20', '2024-10-18 09:12:11', '2024-10-18', 'P5581', '24-07331-10-17', 'Es una oficina de Banco Santander ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Isaac García de Quirós núm 9', 'Valencia de Don Juan', 'León', '24200', 'España', 30.61, 0, '2024-10-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181024-YvmASNYkQsRIS-249', '625c7027-f232-4f24-a79c-745ede2ab785', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181024-YvmASNYkQsRIS-249&s=KOL2024&nf=P5581&i=30.61&cr=075', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5946, 1, 1474, 2, 0, NULL, 0, '2024-10-17 19:44:47', '2024-10-18 09:12:57', '2024-10-18', 'P5582', '24-07333-10-17', 'NO entregar en lunes, está cerrado', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Getafe 1, Bar Katy', 'Pinto', 'Madrid', '28320', 'España', 30.61, 0, '2024-10-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181024-Navw4B47TyQTT-044', '4807f6e1-3441-4b17-9c84-9c63b658bc1b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181024-Navw4B47TyQTT-044&s=KOL2024&nf=P5582&i=30.61&cr=162', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5947, 1, 1475, 2, 0, NULL, 0, '2024-10-19 07:01:03', '2024-10-21 08:50:02', '2024-10-21', 'P5583', '24-07334-10-19', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Gastañudi 2', 'Abadiño', 'Bizkaia', '48220', 'España', 78.63, 0, '2024-10-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211024-NKHhyL/4b5m1N-022', 'f3ecd85b-7f50-4a76-88ef-7f0aaa016d68', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-NKHhyL%2F4b5m1N-022&s=KOL2024&nf=P5583&i=78.63&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5948, 1, 1070, 2, 0, NULL, 0, '2024-10-19 07:50:33', '2024-10-21 08:52:58', '2024-10-21', 'P5584', '24-07335-10-19', '', 0.00, 86.64, 18.19, 0.00, 0, 0.00, 0.00, 'Bernardo Ezenarro. 15. Esc.2-2A', 'Elgoibar', 'Gipuzkoa', '20870', 'España', 104.83, 0, '2024-10-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211024-Dmr3EJvoXrryc-220', '74f51e4b-363e-4edc-86d7-a1a3ad508865', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-Dmr3EJvoXrryc-220&s=KOL2024&nf=P5584&i=104.83&cr=234', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5949, 1, 1476, 2, 0, NULL, 0, '2024-10-19 19:03:08', '2024-10-21 08:54:57', '2024-10-21', 'P5585', '24-07336-10-19', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle de Guadalajara, 21', 'Leganés', 'Madrid', '28914', 'España', 30.61, 0, '2024-10-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211024-KUvlXH2udouq/-119', '904410d4-f693-47e3-9e1f-e1844e401e8e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-KUvlXH2udouq%2F-119&s=KOL2024&nf=P5585&i=30.61&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5950, 1, 1477, 2, 0, NULL, 0, '2024-10-20 19:31:02', '2024-10-21 08:56:51', '2024-10-21', 'P5586', '24-07337-10-20', 'Clínica crea', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle san martín 4, bajo', 'Valencia', 'Valencia', '46003', 'España', 28.39, 0, '2024-10-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211024-aGPkJb0Yyh8nE-192', 'a17ea2fc-985d-4e74-9e86-32c90561fdaa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-aGPkJb0Yyh8nE-192&s=KOL2024&nf=P5586&i=28.39&cr=154', '[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
(5951, 1, 273, 2, 0, NULL, 0, '2024-10-20 21:00:05', '2024-10-21 08:58:57', '2024-10-21', 'P5587', '24-07338-10-20', 'Horario entrega: lunes a viernes de 8:30h a 16:00h', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avda. Eduard Maristany, 46-48', 'Sant Adrià de Besòs', 'Barcelona', '08930', 'España', 52.39, 0, '2024-10-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-211024-gZeAMeM9SA4ik-172', '60cd2dd8-2941-442a-88f9-91aa238bf44d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-gZeAMeM9SA4ik-172&s=KOL2024&nf=P5587&i=52.39&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5952, 1, 1478, 2, 0, NULL, 0, '2024-10-21 07:04:32', '2024-10-21 10:23:46', '2024-10-21', 'P5588', '24-07339-10-21', 'Si no estoy en casa, entregar al portero', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'CALLE YANGUAS Y MIRANDA 19, 8º DCHA', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 30.61, 0, '2024-10-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211024-fScW1Da0/3qcN-032', '7f047711-df40-4c98-9e29-22a025f3ea3b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-fScW1Da0%2F3qcN-032&s=KOL2024&nf=P5588&i=30.61&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5953, 1, 1479, 2, 0, NULL, 0, '2024-10-21 07:22:31', '2024-10-21 10:26:26', '2024-10-21', 'P5589', '24-07340-10-21', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Zumalakarregi kalea 8A, 5 izq', 'Zarautz', 'Gipuzkoa', '20800', 'España', 30.61, 0, '2024-10-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211024-SfBN9K8t8WY45-234', '0620e619-c228-4d18-ac32-cabfe3a1bb2c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-SfBN9K8t8WY45-234&s=KOL2024&nf=P5589&i=30.61&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5954, 1, 248, 2, 0, NULL, 0, '2024-10-21 07:40:41', '2024-10-21 10:28:29', '2024-10-21', 'P5591', '24-07341-10-21', '', 0.00, 48.84, 10.69, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 61.60, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-211024-Mca9br55J9yZX-219', 'd9b54f85-7e3d-4a94-b561-2f9aa1a6c8a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-Mca9br55J9yZX-219&s=KOL2024&nf=P5591&i=61.60&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5955, 1, 166, 1, 0, NULL, 0, '2024-10-21 10:21:49', '2024-10-21 10:21:49', '2024-10-21', 'P5590', '', '', 0.00, 102.96, 21.62, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 124.58, 0, '2024-10-21 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-211024-UXTy2t8FCQQ6e-106', '70549395-7853-4c86-9dbb-7c5524384e75', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-UXTy2t8FCQQ6e-106&s=KOL2024&nf=P5590&i=124.58&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5956, 1, 4, 2, 0, NULL, 0, '2024-10-21 10:40:49', '2024-10-21 13:30:20', '2024-10-21', 'P5592', '24-07342-10-21', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 310.37, 0, '2024-10-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211024-CDYWAWA/5GFCw-211', 'c0fea32b-3957-4581-a397-40bf4b087172', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211024-CDYWAWA%2F5GFCw-211&s=KOL2024&nf=P5592&i=310.37&cr=080', '[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
(5957, 1, 708, 2, 0, NULL, 0, '2024-10-21 13:37:24', '2024-10-22 09:43:37', '2024-10-22', 'P5593', '24-07343-10-21', 'Apretar fuerte el telefonillo. Llamar en caso de ausencia para dejar a un vecino.', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Emigrantes 14, 6 C', 'Madrid', 'Madrid', '28043', 'España', 61.09, 0, '2024-10-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221024-Q9EQOp76YTSJh-231', 'c3be8418-25b1-4888-a906-a59cb2e7fa73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221024-Q9EQOp76YTSJh-231&s=KOL2024&nf=P5593&i=61.09&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5958, 1, 1480, 2, 0, NULL, 0, '2024-10-21 18:59:28', '2024-10-22 09:44:29', '2024-10-22', 'P5594', '24-07346-10-21', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida Mistral 2, 7º 2º', 'Barcelona', 'Barcelona', '08015', 'España', 30.61, 0, '2024-10-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-221024-d5pF5NjPdnY7D-203', 'c86fd20c-3bd2-4f5e-b763-af44af18157a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221024-d5pF5NjPdnY7D-203&s=KOL2024&nf=P5594&i=30.61&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5959, 1, 1278, 2, 0, NULL, 0, '2024-10-21 19:47:36', '2024-10-22 09:45:07', '2024-10-22', 'P5595', '24-07347-10-21', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/Golondrina 4', 'Arahal', 'Sevilla', '41600', 'España', 43.71, 0, '2024-10-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-221024-HP9kwW4bD+gt3-068', '9786d5fc-b51a-4b13-86b2-91fe55547fa2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221024-HP9kwW4bD%2Bgt3-068&s=KOL2024&nf=P5595&i=43.71&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5960, 1, 71, 2, 0, NULL, 0, '2024-10-22 06:57:46', '2024-10-22 09:45:50', '2024-10-22', 'P5596', '24-07348-10-22', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Lagarei 13 sanxenxo', 'Sanxenxo', 'Pontevedra', '36990', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-221024-PXZPtlrVLWUQ7-245', '302581e0-2f11-467f-aa1d-6e6d8311d1b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221024-PXZPtlrVLWUQ7-245&s=KOL2024&nf=P5596&i=137.94&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5961, 1, 108, 2, 0, NULL, 0, '2024-10-22 07:34:42', '2024-10-22 10:02:36', '2024-10-22', 'P5597', '24-07349-10-22', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-221024-VfMDYRAJa6mjw-152', '1a0a95ab-6ed2-4169-9e5b-d583d09cf5cd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221024-VfMDYRAJa6mjw-152&s=KOL2024&nf=P5597&i=275.88&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5962, 1, 391, 2, 0, NULL, 0, '2024-10-22 08:04:50', '2024-10-22 10:09:15', '2024-10-22', 'P5598', '24-07350-10-22', 'Cerrado jueves por tarde .\r\nNo dejar paquete a otra persona ', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Paseo Santxiki num14', 'Pamplona/Iruña', 'Navarra', '31192', 'España', 206.91, 0, '2024-10-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-221024-K/wjsfgLEjQcr-241', '8184ed0a-337a-417a-ac8c-9fe8e91cdbb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221024-K%2FwjsfgLEjQcr-241&s=KOL2024&nf=P5598&i=206.91&cr=015', '[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
(5963, 1, 1325, 2, 0, NULL, 0, '2024-10-22 10:52:52', '2024-10-22 12:54:26', '2024-10-22', 'P5599', '24-07355-10-22', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Travesía Espronceda 10 3 Izq', 'Pamplona/Iruña', 'Navarra', '31015', 'España', 71.98, 0, '2024-10-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221024-bGnuWHolAbGJo-079', '5379db1a-dc90-4a09-9680-9b1e5aac3f51', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221024-bGnuWHolAbGJo-079&s=KOL2024&nf=P5599&i=71.98&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5964, 1, 635, 2, 0, NULL, 0, '2024-10-22 11:14:05', '2024-10-22 13:17:07', '2024-10-22', 'P5600', '24-07356-10-22', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 137.94, 0, '2024-10-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221024-BYMCIIeolWSUJ-089', '118753b0-3c08-4553-bb5f-6ea82d5b18d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221024-BYMCIIeolWSUJ-089&s=KOL2024&nf=P5600&i=137.94&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5965, 1, 1481, 2, 0, NULL, 0, '2024-10-22 11:40:18', '2024-10-22 16:26:53', '2024-10-22', 'P5601', '24-07357-10-22', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Ef. Galileo. Lemon Consulting. Cl Enbros 74', 'Teruel', 'Teruel', '44002', 'España', 28.39, 0, '2024-10-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221024-M8+bVHBwyY+MP-189', '4340f306-f857-49f1-8e89-7c04047bfb70', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221024-M8%2BbVHBwyY%2BMP-189&s=KOL2024&nf=P5601&i=28.39&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5966, 1, 190, 3, 0, NULL, 0, '2024-10-22 15:07:16', '2024-10-22 16:26:30', '2024-10-22', '', 'Consumo interno', '', 0.00, 2430.30, 510.36, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2940.66, 0, '2024-10-22 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),
(5967, 1, 1482, 2, 0, NULL, 0, '2024-10-22 20:18:29', '2024-10-23 09:30:04', '2024-10-23', 'P5602', '24-07364-10-22', '', 0.00, 61.32, 12.88, 0.00, 0, 0.00, 0.00, 'Fray Luis de León, 23 Bajo A', 'San Lorenzo de El Es', 'Madrid', '28200', 'España', 74.20, 0, '2024-10-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-231024-C4ZRNcXlCslkX-006', '18f79e83-cb46-4fa2-8be6-7a8300adb5a9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231024-C4ZRNcXlCslkX-006&s=KOL2024&nf=P5602&i=74.20&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5968, 1, 102, 2, 0, NULL, 0, '2024-10-23 07:16:15', '2024-10-23 09:31:53', '2024-10-23', 'P5603', '24-07365-10-23', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Riera Gavarra  numero 73 local', 'Canet de Mar', 'Barcelona', '08360', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-231024-ccCPFQ4zU9Lvz-147', '0c0411e0-9a15-4973-9e5b-98a6699a93b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231024-ccCPFQ4zU9Lvz-147&s=KOL2024&nf=P5603&i=71.47&cr=175', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5969, 1, 236, 2, 0, NULL, 0, '2024-10-23 12:38:09', '2024-10-24 09:41:00', '2024-10-24', 'P5604', '24-07366-10-23', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'AVDA. DE LA POLICÍA NACIONAL, EDF. DONI IVES, 24', 'Antequera', 'Málaga', '29200', 'España', 103.46, 0, '2024-10-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241024-e2Kn7z/u2Uc6S-207', '183d50c5-3473-4295-9f6e-200ed3492c73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241024-e2Kn7z%2Fu2Uc6S-207&s=KOL2024&nf=P5604&i=103.46&cr=023', '[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
(5970, 1, 1008, 2, 0, NULL, 0, '2024-10-23 13:16:48', '2024-10-24 09:42:12', '2024-10-24', 'P5605', '24-07367-10-23', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Candelario 2-esc.i-2A', 'Salamanca', 'Salamanca', '37007', 'España', 56.82, 0, '2024-10-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241024-cPh+5X1JSB6O5-015', 'e299bb7e-a7f3-480e-b465-9f788eecd1eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241024-cPh%2B5X1JSB6O5-015&s=KOL2024&nf=P5605&i=56.82&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5971, 1, 688, 2, 0, NULL, 0, '2024-10-23 14:31:01', '2024-10-24 09:43:15', '2024-10-24', 'P5606', '24-07368-10-23', 'Peluqueria ADATS \r\nLunes cerrado ', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Plaza Anzaran entreplanta n 1', 'Irun', 'Gipuzkoa', '20301', 'España', 68.97, 0, '2024-10-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241024-X1l0zdaxeri7c-173', '1ea5eb0b-09aa-409f-b211-22171af56737', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241024-X1l0zdaxeri7c-173&s=KOL2024&nf=P5606&i=68.97&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5972, 1, 1483, 2, 0, NULL, 0, '2024-10-23 17:11:45', '2024-10-24 09:44:11', '2024-10-24', 'P5607', '24-07369-10-23', 'Pueblo de Armintza, es un barrio de Lemoiz', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Amorraga 4 Bajo B', 'Lemoiz', 'Bizkaia', '48620', 'España', 17.50, 0, '2024-10-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241024-ajZM6+GbRmV2T-117', '9f260fd4-7394-4e2c-82cf-50da2aad57b3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241024-ajZM6%2BGbRmV2T-117&s=KOL2024&nf=P5607&i=17.50&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5973, 1, 1484, 2, 0, NULL, 0, '2024-10-24 08:49:36', '2024-10-24 11:04:07', '2024-10-24', 'P5608', '24-07370-10-24', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ Sepúlveda, 18, 3E', 'Binéfar', 'Huesca', '22500', 'España', 28.39, 0, '2024-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241024-QvKMXZw7NPv9V-250', 'cebcc3be-51ab-4804-bf76-18e14a344601', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241024-QvKMXZw7NPv9V-250&s=KOL2024&nf=P5608&i=28.39&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5974, 1, 17, 2, 0, NULL, 0, '2024-10-24 09:48:38', '2024-10-24 11:51:48', '2024-10-24', 'P5609', '24-07371-10-24', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 310.37, 0, '2024-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241024-G3d55Qgv0Bv5R-007', 'e6eb2c83-66c4-418b-b692-bd9d318547fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241024-G3d55Qgv0Bv5R-007&s=KOL2024&nf=P5609&i=310.37&cr=013', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5975, 1, 1326, 2, 0, NULL, 0, '2024-10-24 10:23:58', '2024-10-24 12:46:11', '2024-10-24', 'P5610', '24-07372-10-24', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'INAZIO IRIARTE MARGOLARIA 17/5A', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 28.39, 0, '2024-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241024-F7l1fCP4nHCrU-113', 'eef24d38-ec65-44af-9e43-b1ebf7b7b9be', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241024-F7l1fCP4nHCrU-113&s=KOL2024&nf=P5610&i=28.39&cr=045', '[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
(5976, 1, 1347, 2, 0, NULL, 0, '2024-10-24 14:44:36', '2024-10-25 08:48:51', '2024-10-25', 'P5611', '24-07373-10-24', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Fernando el Católico 7,pr. Izda.', 'Zaragoza', 'Zaragoza', '50006', 'España', 56.82, 0, '2024-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251024-POmO/toDNLI4b-212', '262effed-7e82-4d9b-a3b9-0c5f1222b37d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251024-POmO%2FtoDNLI4b-212&s=KOL2024&nf=P5611&i=56.82&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5977, 1, 1214, 2, 0, NULL, 0, '2024-10-24 16:49:34', '2024-10-25 08:51:07', '2024-10-25', 'P5612', '24-07374-10-24', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, '`LAZA POETA AUSIAS MARCH NUM 20 PTA 1', 'Ontinyent', 'Valencia', '46870', 'España', 52.39, 0, '2024-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251024-K4U0hY1PGvJr0-174', 'f422e90b-e91a-4bf5-8b47-0a02b43ff044', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251024-K4U0hY1PGvJr0-174&s=KOL2024&nf=P5612&i=52.39&cr=040', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5978, 1, 1430, 2, 0, NULL, 0, '2024-10-24 17:49:50', '2024-10-25 08:53:09', '2024-10-25', 'P5615', '24-07375-10-24', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'Calle reí en Jaume 90', 'Vila-real', 'Castellón', '12540', 'España', 147.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-251024-VzyOpaK83tXQm-137', 'f4b4d23f-2523-49d0-bb8b-1e9e37e570d7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251024-VzyOpaK83tXQm-137&s=KOL2024&nf=P5615&i=147.79&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5979, 1, 40, 2, 0, NULL, 0, '2024-10-24 17:56:33', '2024-10-25 08:56:28', '2024-10-25', 'P5613', '24-07376-10-24', 'Lunes por la mañana cerrado y martes todo el dia', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 68.97, 0, '2024-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251024-RvkzQP1J4KblZ-155', '2e278b75-da6e-4894-b963-5cdd4468200d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251024-RvkzQP1J4KblZ-155&s=KOL2024&nf=P5613&i=68.97&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5980, 1, 138, 2, 0, NULL, 0, '2024-10-24 22:07:01', '2024-10-25 08:59:46', '2024-10-25', 'P5616', '24-07377-10-24', '', 0.00, 285.00, 60.28, 0.00, 0, 0.00, 2.50, 'Carretera Valladares 382', 'Vigo', 'Pontevedra', '36315', 'España', 347.35, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-251024-WiV10OwWHfboH-055', '45bda892-57a7-4f8a-bec9-b1b559a02c20', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251024-WiV10OwWHfboH-055&s=KOL2024&nf=P5616&i=347.35&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5981, 1, 138, 2, 0, NULL, 0, '2024-10-24 22:07:04', '2024-10-24 22:07:04', '2024-10-24', '', '24-07378-10-24', NULL, 0.00, 285.00, 60.28, 0.00, 0, 0.00, 2.50, 'Carretera Valladares 382', 'Vigo', 'Pontevedra', '36315', 'España', 347.35, 0, '0000-00-00 00:00:00', '', '', 1, 4, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(5982, 1, 1035, 2, 0, NULL, 0, '2024-10-25 05:39:43', '2024-10-25 09:01:24', '2024-10-25', 'P5614', '24-07379-10-25', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Ronda Josep Anselm clavé 2.3-3', 'Canet de Mar', 'Barcelona', '08360', 'España', 71.98, 0, '2024-10-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251024-Rko3K7OtNEWfA-184', '142b22d1-a9d3-4d52-848b-8a765035b8d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251024-Rko3K7OtNEWfA-184&s=KOL2024&nf=P5614&i=71.98&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
