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
(5480, 1, 40, 2, 0, NULL, 0, '2024-08-01 12:18:46', '2024-08-02 07:50:17', '2024-08-02', 'P5136', '24-06826-08-01', 'lunes por la mañana cerrado ,se habre a partir de las 15 h el martes cerrado todo el dia , y los demas dias de 9 a 17 h', 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-08-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020824-VmTG72fuT6Xvh-019', '8af4be70-e734-417d-ba1c-23684d3a3b01', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020824-VmTG72fuT6Xvh-019&s=KOL2024&nf=P5136&i=68.97&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5481, 1, 220, 2, 0, NULL, 0, '2024-08-01 13:52:52', '2024-08-02 07:54:26', '2024-08-02', 'P5137', '24-06827-08-01', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-020824-VdMi0ir2R2lJp-147', '060b97fb-ea01-4cc1-94b6-feb5e4b8626d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020824-VdMi0ir2R2lJp-147&s=KOL2024&nf=P5137&i=105.96&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5482, 1, 1320, 2, 1, 'rechaza el producto', 5287, '2024-08-02 09:09:30', '2024-08-02 09:09:58', '2024-08-02', 'R87', 'P4948 RECT.', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, '', '', '', '', '', 30.61, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-020824-TstXXRLcdPrOA-156', '46c431f6-a688-4bff-92db-019a7645b4e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020824-TstXXRLcdPrOA-156&s=KOL2024&nf=R87&i=-30.61&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(5483, 1, 23, 2, 0, NULL, 0, '2024-08-02 08:53:05', '2024-08-02 10:54:59', '2024-08-02', 'P5138', '24-06829-08-02', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 103.46, 0, '2024-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020824-dOgCAy9SpeYDi-000', '4e9e3f71-0b4e-42a9-bc31-f16c2e7db3d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020824-dOgCAy9SpeYDi-000&s=KOL2024&nf=P5138&i=103.46&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5484, 1, 1081, 2, 0, NULL, 0, '2024-08-02 10:53:25', '2024-08-02 13:04:20', '2024-08-02', 'P5139', '24-06830-08-02', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle la dorada 2 BW 22', 'Alicante/Alacant', 'Alicante', '03540', 'España', 30.61, 0, '2024-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020824-Bpa56JHoBZBgl-111', 'c8ddfc5c-4aa7-4714-b125-77f8b78903c9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020824-Bpa56JHoBZBgl-111&s=KOL2024&nf=P5139&i=30.61&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5485, 1, 1351, 2, 0, NULL, 0, '2024-08-02 14:41:22', '2024-08-05 08:48:47', '2024-08-05', 'P5140', '24-06831-08-02', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Cerco de fuera, 6, 2D', 'Olite', 'Navarra', '31390', 'España', 56.82, 0, '2024-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-G+w7cqQLQHlLa-145', '914b25c0-8c78-4011-8b72-294c6482b8ee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-G%2Bw7cqQLQHlLa-145&s=KOL2024&nf=P5140&i=56.82&cr=153', '[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
(5486, 1, 1326, 2, 0, NULL, 0, '2024-08-02 14:47:04', '2024-08-05 08:51:04', '2024-08-05', 'P5141', '24-06832-08-02', '', 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-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-WtRZFjn3ehSJ/-149', 'f80252a1-57a9-49e8-baf5-6c348a2b3741', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-WtRZFjn3ehSJ%2F-149&s=KOL2024&nf=P5141&i=28.39&cr=237', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5487, 1, 1352, 2, 0, NULL, 0, '2024-08-02 17:53:08', '2024-08-05 08:55:20', '2024-08-05', 'P5142', '24-06836-08-02', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Altamirazpi 1, 2°dcha', 'Arrasate/Mondragón', 'Gipuzkoa', '20500', 'España', 56.82, 0, '2024-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-AtKuYwO6RosKr-093', 'e1571a60-6402-4311-8646-8f4c1d11770f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-AtKuYwO6RosKr-093&s=KOL2024&nf=P5142&i=56.82&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5488, 1, 1353, 2, 0, NULL, 0, '2024-08-02 20:30:23', '2024-08-05 08:57:54', '2024-08-05', 'P5143', '24-06837-08-02', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Felipe de la guerra 19', 'Pozuelo de Alarcón', 'Madrid', '28224', 'España', 71.98, 0, '2024-08-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-Af8rvSpsvMAfr-108', '5d00cc4f-efca-4f4e-b2b2-a8eb3702698d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-Af8rvSpsvMAfr-108&s=KOL2024&nf=P5143&i=71.98&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5489, 1, 635, 2, 0, NULL, 0, '2024-08-03 08:54:12', '2024-08-05 09:01:00', '2024-08-05', 'P5144', '24-06838-08-03', 'SI EL LOCAL ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703. GRACIAS.', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 172.43, 0, '2024-08-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-WEPcrgHYvGvSG-201', '91480c7d-b2d3-4fe7-a277-72b7f6b6cd5e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-WEPcrgHYvGvSG-201&s=KOL2024&nf=P5144&i=172.43&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5490, 1, 397, 2, 0, NULL, 0, '2024-08-03 12:14:05', '2024-08-05 09:04:13', '2024-08-05', 'P5145', '24-06839-08-03', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Alberga 69 1° Izda', 'Errenteria', 'Gipuzkoa', '20100', 'España', 65.52, 0, '2024-08-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-HIsgOHkgVFsFP-006', '438d8895-04f1-4cbb-bf47-519988fb1bb8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-HIsgOHkgVFsFP-006&s=KOL2024&nf=P5145&i=65.52&cr=010', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5491, 1, 1354, 2, 0, NULL, 0, '2024-08-03 15:20:12', '2024-08-05 09:08:24', '2024-08-05', 'P5146', '24-06840-08-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Párroco Antonio Pardo 48', 'Santa Cruz de Mudela', 'Ciudad Real', '13730', 'España', 17.50, 0, '2024-08-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-d9jDs/F+wWPHE-079', 'd63024b3-4cf3-4bcb-8cc2-1f0abc4bd65e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-d9jDs%2FF%2BwWPHE-079&s=KOL2024&nf=P5146&i=17.50&cr=081', '[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
(5492, 1, 1073, 2, 0, NULL, 0, '2024-08-03 16:13:34', '2024-08-05 09:11:58', '2024-08-05', 'P5147', '24-06842-08-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ San Esteban 50', 'Murieta', 'Navarra', '31280', 'España', 17.50, 0, '2024-08-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-C+wAielc8jAg7-218', '4163c3bd-b24c-41dc-80d8-1fbe3f0331a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-C%2BwAielc8jAg7-218&s=KOL2024&nf=P5147&i=17.50&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5493, 1, 145, 2, 0, NULL, 0, '2024-08-03 19:26:42', '2024-08-05 09:15:22', '2024-08-05', 'P5148', '24-06843-08-03', '', 0.00, 199.50, 42.33, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 243.90, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-050824-YsQGDDyiALUse-018', '07a3ca06-d4da-4636-bf36-ef54af30ae36', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-YsQGDDyiALUse-018&s=KOL2024&nf=P5148&i=243.90&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5494, 1, 1355, 2, 0, NULL, 0, '2024-08-05 08:53:28', '2024-08-05 11:43:04', '2024-08-05', 'P5149', '24-06844-08-05', '', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'CALLE LA PEÑA, 6', 'Binaced', 'Huesca', '22510', 'España', 54.60, 0, '2024-08-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-M71TLb7K8YqQV-254', '1dc4405c-716e-4f0f-91c7-02e1526273ad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-M71TLb7K8YqQV-254&s=KOL2024&nf=P5149&i=54.60&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5495, 1, 1227, 2, 0, NULL, 0, '2024-08-05 12:00:55', '2024-08-05 21:14:01', '2024-08-05', 'P5150', '24-06845-08-05', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle de los Cantos 24 2° B', 'Alcorcón', 'Madrid', '28922', 'España', 17.50, 0, '2024-08-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-050824-Fme3Ra3GF5Ime-096', 'f2dcf53e-6f36-447f-915e-9a99ae1424ab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-Fme3Ra3GF5Ime-096&s=KOL2024&nf=P5150&i=17.50&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5496, 1, 94, 2, 0, NULL, 0, '2024-08-05 12:48:07', '2024-08-05 21:19:13', '2024-08-05', 'P5151', '24-06846-08-05', '', 0.00, 183.20, 38.47, 0.00, 0, 0.00, 0.00, 'C/mayor número 11', 'Ausejo', 'La Rioja', '26513', 'España', 221.67, 0, '2024-08-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-FUFPb0+QBmu9A-162', '47327ab4-b97d-4891-ad19-6dc72f41fb16', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-FUFPb0%2BQBmu9A-162&s=KOL2024&nf=P5151&i=221.67&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5497, 1, 973, 2, 0, NULL, 0, '2024-08-05 14:06:09', '2024-08-05 21:22:06', '2024-08-05', 'P5152', '24-06848-08-05', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Plaza del Pilón, 10 ', 'Peraleda de San Romá', 'Cáceres', '10334', 'España', 71.98, 0, '2024-08-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-dA+D6hMx9pyrB-176', '9db7b501-8a79-489a-ac2a-3c05734d4f42', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-dA%2BD6hMx9pyrB-176&s=KOL2024&nf=P5152&i=71.98&cr=121', '[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
(5498, 1, 1356, 2, 0, NULL, 0, '2024-08-05 14:57:33', '2024-08-05 21:25:31', '2024-08-05', 'P5153', '24-06849-08-05', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Alicún número 8 piso 1B', 'Madrid', 'Madrid', '28033', 'España', 30.61, 0, '2024-08-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-050824-TIPronRu+pX3h-007', '38e3e4e8-a535-4fad-918e-8a427e5acafe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-TIPronRu%2BpX3h-007&s=KOL2024&nf=P5153&i=30.61&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5499, 1, 160, 2, 0, NULL, 0, '2024-08-05 15:24:56', '2024-08-05 21:28:01', '2024-08-05', 'P5154', '24-06850-08-05', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 103.46, 0, '2024-08-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-J6x2b6wTOkk5L-118', 'c0df1cbb-5120-497d-bc26-873ef11310af', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-J6x2b6wTOkk5L-118&s=KOL2024&nf=P5154&i=103.46&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5500, 1, 1357, 2, 0, NULL, 0, '2024-08-05 15:30:11', '2024-08-05 21:30:06', '2024-08-05', 'P5155', '24-06851-08-05', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'PLAÇA CELLERA, 6', 'Mieres', 'Girona', '17830', 'España', 17.50, 0, '2024-08-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-OsMYwCTyZHmoV-146', '1f263141-f780-403a-adba-bb2d1d44b6a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-OsMYwCTyZHmoV-146&s=KOL2024&nf=P5155&i=17.50&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5501, 1, 244, 2, 0, NULL, 0, '2024-08-05 16:35:19', '2024-08-05 22:07:53', '2024-08-05', 'P5156', '24-06852-08-05', ' Si no estoy, lo pueden dejar en la barbería', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'Balmes, 79 Local 3 Peluquería Maimar', 'Calella', 'Barcelona', '08370', 'España', 113.30, 0, '2024-08-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050824-NON0z/ghe0fFu-043', '1b351ee3-1f28-4155-ba61-7a678585f5b7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050824-NON0z%2Fghe0fFu-043&s=KOL2024&nf=P5156&i=113.30&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5502, 1, 930, 2, 0, NULL, 0, '2024-08-06 09:20:23', '2024-08-06 11:46:30', '2024-08-06', 'P5157', '24-06854-08-06', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/Recreo , 38, 2', 'Ordes', 'A Coruña', '15680', 'España', 43.71, 0, '2024-08-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060824-PQ+W8X2kvaH9W-108', '8b731e25-ada6-4889-ae2b-d85a922f194e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060824-PQ%2BW8X2kvaH9W-108&s=KOL2024&nf=P5157&i=43.71&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5503, 1, 174, 2, 0, NULL, 0, '2024-08-06 12:32:06', '2024-08-07 08:14:18', '2024-08-07', 'P5158', '24-06856-08-06', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 275.88, 0, '2024-08-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070824-k0wf36QpAtSD0-254', 'dc7938a1-e14f-47fb-8552-73f8b468312a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070824-k0wf36QpAtSD0-254&s=KOL2024&nf=P5158&i=275.88&cr=017', '[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
(5504, 1, 676, 2, 0, NULL, 0, '2024-08-06 14:17:26', '2024-08-07 08:17:04', '2024-08-07', 'P5159', '24-06857-08-06', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Monjardín 11, 1ºA', 'Pamplona/Iruña', 'Navarra', '31006', 'España', 30.61, 0, '2024-08-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070824-kGHBdAv6c05Xa-061', 'e900ac6a-3182-45ac-9d0c-4f6074eb7ec0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070824-kGHBdAv6c05Xa-061&s=KOL2024&nf=P5159&i=30.61&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5505, 1, 78, 2, 0, NULL, 0, '2024-08-06 16:50:16', '2024-08-07 08:20:39', '2024-08-07', 'P5160', '24-06858-08-06', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'AVND, SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070824-d3QTYobwO2U9j-039', '761d454a-8dde-4041-8afe-db6d841bf173', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070824-d3QTYobwO2U9j-039&s=KOL2024&nf=P5160&i=241.40&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5506, 1, 152, 1, 0, NULL, 0, '2024-08-07 08:26:21', '2024-08-07 08:26:21', '2024-08-07', 'P5161', '', '', 0.00, 184.47, 38.74, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 223.21, 0, '2024-08-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070824-cvt5NudJke0SE-036', 'f0d3b0da-2256-41da-b9c0-13980653f9c3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070824-cvt5NudJke0SE-036&s=KOL2024&nf=P5161&i=223.21&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5507, 1, 152, 1, 0, NULL, 0, '2024-08-07 11:36:52', '2024-08-07 11:37:00', '2024-08-07', 'P5162', '2024-08-07', '', 0.00, 25.74, 5.41, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 31.15, 0, '2024-08-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070824-eXOnxv+IxDB8c-245', '665e02f9-9c07-4584-94a3-01d0beab9b70', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070824-eXOnxv%2BIxDB8c-245&s=KOL2024&nf=P5162&i=31.15&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5508, 1, 530, 2, 0, NULL, 0, '2024-08-07 10:37:31', '2024-08-07 12:54:30', '2024-08-07', 'P5163', '24-06859-08-07', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Ronda 2, escalera izquierda, tercero derecha', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 28.39, 0, '2024-08-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070824-j3b0ywyjh2Z5X-198', '124e4c3b-2c9d-4848-bdec-906841f2bf24', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070824-j3b0ywyjh2Z5X-198&s=KOL2024&nf=P5163&i=28.39&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5509, 1, 1358, 2, 0, NULL, 0, '2024-08-07 13:20:49', '2024-08-08 08:55:23', '2024-08-08', 'P5164', '24-06860-08-07', 'Mejor lunes, miércoles o viernes ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Plaza corachan 5', 'Barcelona', 'Barcelona', '08017', 'España', 30.61, 0, '2024-08-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080824-J+WGGsNYvIaPj-027', '3c4db1b8-ba07-4d68-a613-5cb84c5ca2ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080824-J%2BWGGsNYvIaPj-027&s=KOL2024&nf=P5164&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);
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
(5510, 1, 350, 2, 0, NULL, 0, '2024-08-07 14:20:47', '2024-08-08 08:59:41', '2024-08-08', 'P5167', '24-06861-08-07', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Calle Balleneros 19 Bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080824-jBzA6RMLmrKeJ-224', '2b5b3778-1b3b-4ed2-8c34-5d411fd51775', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080824-jBzA6RMLmrKeJ-224&s=KOL2024&nf=P5167&i=275.88&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5511, 1, 1359, 2, 0, NULL, 0, '2024-08-07 15:10:10', '2024-08-08 09:02:31', '2024-08-08', 'P5165', '24-06864-08-07', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Avenida de la Peseta, 22 Portal K piso 4°A', 'Madrid', 'Madrid', '28054', 'España', 43.71, 0, '2024-08-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080824-CunDb44f/s2f7-222', '9f09b5a8-a129-48b7-9df0-d6f717278d07', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080824-CunDb44f%2Fs2f7-222&s=KOL2024&nf=P5165&i=43.71&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5512, 1, 33, 2, 0, NULL, 0, '2024-08-07 16:30:50', '2024-08-08 09:16:50', '2024-08-08', 'P5166', '24-06865-08-07', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'Calle Medio N 24 bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 59.10, 0, '2024-08-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080824-XE2XBbTXUbFnN-201', 'b7e18dac-fdbd-4efa-b81a-9bc2fb9bd4d4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080824-XE2XBbTXUbFnN-201&s=KOL2024&nf=P5166&i=59.10&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5513, 1, 1360, 2, 0, NULL, 0, '2024-08-08 10:12:16', '2024-08-08 12:25:23', '2024-08-08', 'P5168', '24-06867-08-08', 'Avisar con antelación.', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'C/ Maestro D. Francisco Rodriguez Rodriguez , numero 8 ', 'Bormujos', 'Sevilla', '41930', 'España', 41.50, 0, '2024-08-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080824-jniQnVYcuycKG-236', 'b5f59cd4-f3cb-4f9a-82ff-8f0ff47a4079', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080824-jniQnVYcuycKG-236&s=KOL2024&nf=P5168&i=41.50&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5514, 1, 367, 2, 0, NULL, 0, '2024-08-08 10:48:00', '2024-08-09 07:25:30', '2024-08-09', 'P5169', '24-06868-08-08', 'Urbanización Mas Nou (Detrás del Mercadona de Empuriabrava)', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Arenal 7', 'Castelló d\'Empúries', 'Girona', '17486', 'España', 17.50, 0, '2024-08-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090824-Gyd+qo4H5IHzc-150', 'a45dc935-db1c-4db7-8ec5-0830457fb36a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090824-Gyd%2Bqo4H5IHzc-150&s=KOL2024&nf=P5169&i=17.50&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5515, 1, 110, 2, 0, NULL, 0, '2024-08-08 12:31:31', '2024-08-09 07:27:46', '2024-08-09', 'P5170', '24-06869-08-08', '', 0.00, 236.14, 49.59, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 285.73, 0, '2024-08-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090824-ahZV6Aw/AKWnP-175', 'd0af75d7-6f9c-482b-9b18-5fa2055fa6f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090824-ahZV6Aw%2FAKWnP-175&s=KOL2024&nf=P5170&i=285.73&cr=005', '[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
(5516, 1, 1361, 2, 0, NULL, 0, '2024-08-08 12:43:02', '2024-08-09 07:32:02', '2024-08-09', 'P5171', '24-06870-08-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Ximenez De rada, 59', 'Tudela', 'Navarra', '31500', 'España', 17.50, 0, '2024-08-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090824-gJBTZ1RUBZEeI-023', 'db2a3359-6808-4f37-8b79-62b1e09ef7b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090824-gJBTZ1RUBZEeI-023&s=KOL2024&nf=P5171&i=17.50&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5517, 1, 97, 2, 0, NULL, 0, '2024-08-08 13:38:32', '2024-08-09 07:37:56', '2024-08-09', 'P5172', '24-06871-08-08', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Bidasoa 8, Bajo Bera', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 137.94, 0, '2024-08-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090824-IP4rg4sB6kfvr-169', 'd89c208b-4904-4406-ac4e-1eb1fee701dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090824-IP4rg4sB6kfvr-169&s=KOL2024&nf=P5172&i=137.94&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5518, 1, 1362, 2, 0, NULL, 0, '2024-08-08 14:12:54', '2024-08-09 07:39:12', '2024-08-09', 'P5173', '24-06872-08-08', 'Es en la asociación contra el cáncer ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Plaza Porticada 1, bajo', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 17.50, 0, '2024-08-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090824-GHCLhz4U+Qh5N-156', 'f4c7a1e4-4de6-4319-9927-9d13eab2d149', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090824-GHCLhz4U%2BQh5N-156&s=KOL2024&nf=P5173&i=17.50&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5519, 1, 1363, 2, 0, NULL, 0, '2024-08-08 22:26:59', '2024-08-09 07:42:21', '2024-08-09', 'P5174', '24-06876-08-08', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Reina Sofía 6 ', 'Monterrubio', 'Segovia', '40142', 'España', 30.61, 0, '2024-08-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090824-Tgv3IRNpHrvxA-071', '7c5f39ba-7c9d-47f6-9f82-fd73518fbde5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090824-Tgv3IRNpHrvxA-071&s=KOL2024&nf=P5174&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),
(5520, 1, 253, 2, 0, NULL, 0, '2024-08-09 08:58:00', '2024-08-09 11:17:09', '2024-08-09', 'P5175', '24-06878-08-09', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Avinguda de les flors, 3 L\'Alboçar', 'Avinyonet del Penedè', 'Barcelona', '08734', 'España', 41.50, 0, '2024-08-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090824-MoAKH9VDBM4ln-145', '987c8e9a-6dda-4102-84f9-7c6d51cd0353', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090824-MoAKH9VDBM4ln-145&s=KOL2024&nf=P5175&i=41.50&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5521, 1, 162, 2, 0, NULL, 0, '2024-08-09 09:17:05', '2024-08-09 11:21:16', '2024-08-09', 'P5176', '24-06879-08-09', 'Entrega en horario de mañana: 10 a 14h.', 0.00, 191.32, 40.18, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 231.50, 0, '2024-08-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090824-GGZISnhFJtH6R-079', 'ceb0e446-3040-40c6-a6e9-f4eff2691a2a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090824-GGZISnhFJtH6R-079&s=KOL2024&nf=P5176&i=231.50&cr=146', '[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
(5522, 1, 1364, 2, 0, NULL, 0, '2024-08-09 10:50:46', '2024-08-09 13:11:10', '2024-08-09', 'P5177', '24-06880-08-09', 'Si no estamos en casa, dejar a las taquillas Ferrimax 847527', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Angeles Santos, 10 2-1', 'Hospitalet de Llobre', 'Barcelona', '08907', 'España', 17.50, 0, '2024-08-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090824-auIRzt8fAao3r-144', '7e1cdc1b-41eb-4274-8d35-d4eba3bd1c61', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090824-auIRzt8fAao3r-144&s=KOL2024&nf=P5177&i=17.50&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5523, 1, 1365, 2, 0, NULL, 0, '2024-08-09 16:49:47', '2024-08-12 08:55:53', '2024-08-12', 'P5178', '24-06881-08-09', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Plaza de los Atano 1-1°', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 52.39, 0, '2024-08-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120824-ia6sJ2oMTADvY-233', 'cd66e7d7-6126-46b2-b4d2-a1e623ee1abb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-ia6sJ2oMTADvY-233&s=KOL2024&nf=P5178&i=52.39&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5524, 1, 1026, 2, 0, NULL, 0, '2024-08-09 17:48:16', '2024-08-12 08:59:53', '2024-08-12', 'P5179', '24-06882-08-09', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Paseo María Agustin 15-17-19 6D', 'Zaragoza', 'Zaragoza', '50004', 'España', 43.71, 0, '2024-08-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120824-CpnVZJgnQ5KOu-221', 'fd0b9388-75b8-4b64-9cf5-e74e01581eb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-CpnVZJgnQ5KOu-221&s=KOL2024&nf=P5179&i=43.71&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5525, 1, 1114, 2, 0, NULL, 0, '2024-08-10 09:49:43', '2024-08-12 09:03:48', '2024-08-12', 'P5180', '24-06883-08-10', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Felipe Gorriti Nº22 bajo', 'Pamplona/Iruña', 'Navarra', '31004', 'España', 65.52, 0, '2024-08-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120824-CnxbrfmEttlJb-149', '7e940ead-7517-4f1d-96a6-a5c910c55641', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-CnxbrfmEttlJb-149&s=KOL2024&nf=P5180&i=65.52&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5526, 1, 812, 2, 0, NULL, 0, '2024-08-10 10:53:28', '2024-08-12 09:08:13', '2024-08-12', 'P5181', '24-06884-08-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida Tenientes Txurruka 9, 2a/b', 'Mutriku', 'Gipuzkoa', '20830', 'España', 30.61, 0, '2024-08-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120824-BFwy/16QretRl-127', '68c96130-6591-4929-95f0-0bee0e855761', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-BFwy%2F16QretRl-127&s=KOL2024&nf=P5181&i=30.61&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5527, 1, 1366, 2, 0, NULL, 0, '2024-08-11 19:51:22', '2024-08-12 09:11:15', '2024-08-12', 'P5182', '24-06886-08-11', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'calle virgen consolación 40', 'Lebrija', 'Sevilla', '41740', 'España', 17.50, 0, '2024-08-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120824-lS2IMFwOwpUmu-245', 'b8ea90ce-3928-45b1-8865-b0be9df5db64', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-lS2IMFwOwpUmu-245&s=KOL2024&nf=P5182&i=17.50&cr=072', '[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
(5528, 1, 1279, 2, 0, NULL, 0, '2024-08-11 20:41:46', '2024-08-12 09:16:01', '2024-08-12', 'P5183', '24-06887-08-11', 'Entregar en Pendennis ', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Moll de ponent sn', 'Vilanova i la Geltrú', 'Barcelona', '08800', 'España', 78.63, 0, '2024-08-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120824-lRJXOvrq5RT7p-051', 'ea5d4990-4837-4e4b-b69e-244549e9ce2e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-lRJXOvrq5RT7p-051&s=KOL2024&nf=P5183&i=78.63&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5529, 1, 838, 2, 0, NULL, 0, '2024-08-12 06:18:02', '2024-08-12 09:18:41', '2024-08-12', 'P5184', '24-06888-08-12', 'En caso de ausencia entregar a conserje (Gabriela)', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'AVENIDA PAPA LUNA 28, 7E', 'Peñíscola', 'Castellón', '12598', 'España', 61.09, 0, '2024-08-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120824-HDD8cHTac9CZU-182', '679bdb0f-82e8-4156-b19a-86f0ece533fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-HDD8cHTac9CZU-182&s=KOL2024&nf=P5184&i=61.09&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5530, 1, 190, 3, 0, NULL, 0, '2024-08-12 09:33:14', '2024-10-15 16:09:12', '2024-08-12', '', 'Consumo interno', '', 0.00, 1628.40, 341.96, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 1970.36, 0, '2024-08-12 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),
(5531, 1, 1367, 2, 0, NULL, 0, '2024-08-12 08:50:00', '2024-08-12 10:55:00', '2024-08-12', 'P5185', '24-06889-08-12', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Río Sorbe N°3   6° C', 'Alcalá de Henares', 'Madrid', '28803', 'España', 17.50, 0, '2024-08-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120824-IzWe8Yu+fVEbE-186', '7c5716f5-030b-4249-b25a-460af671066d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-IzWe8Yu%2BfVEbE-186&s=KOL2024&nf=P5185&i=17.50&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5532, 1, 1368, 2, 0, NULL, 0, '2024-08-12 11:52:32', '2024-08-12 13:58:05', '2024-08-12', 'P5186', '24-06891-08-12', 'Es una casa', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'calle JARDÍN 10', 'Hiendelaencina', 'Guadalajara', '19242', 'España', 28.39, 0, '2024-08-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120824-RMxwqvcUj1qOe-247', '5139e398-c0a2-4caa-80d9-43b6ef173559', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-RMxwqvcUj1qOe-247&s=KOL2024&nf=P5186&i=28.39&cr=112', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5533, 1, 1369, 2, 0, NULL, 0, '2024-08-12 15:41:33', '2024-08-12 22:02:58', '2024-08-12', 'P5187', '24-06892-08-12', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Portuetxe Kalea 53a oficina 105', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 28.39, 0, '2024-08-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120824-BWNAQ2HRvPyz+-003', '13924856-c074-4695-b727-dde1ec63bef3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-BWNAQ2HRvPyz%2B-003&s=KOL2024&nf=P5187&i=28.39&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5534, 1, 1000, 2, 0, NULL, 0, '2024-08-12 18:28:40', '2024-08-12 18:28:40', '2024-08-12', '', '24-06894-08-12', NULL, 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Del Abanico , 34', 'Cartagena', 'Murcia', '30330', 'España', 17.50, 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),
(5535, 1, 1000, 2, 0, NULL, 0, '2024-08-12 18:32:11', '2024-08-12 22:07:05', '2024-08-12', 'P5188', '24-06895-08-12', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Del Abanico , 34', 'Cartagena', 'Murcia', '30330', 'España', 17.50, 0, '2024-08-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120824-SGo66Mp7PFfNX-161', '7b8e870a-4f94-4165-92ec-ecd63c715f9a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120824-SGo66Mp7PFfNX-161&s=KOL2024&nf=P5188&i=17.50&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
