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
(3498, 1, 881, 2, 0, NULL, 0, '2023-07-12 11:47:45', '2023-07-12 13:59:45', '2023-07-12', 'P3283', '23-04676-07-12', 'Si puede ser de tarde mejor, por las mañanas me encuentro en el ayuntamiento de NOvelda. Se me puede llamar al móvil y salgo a la calle', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Padre Lorenzo 23 2C', 'Novelda', 'Alicante', '03660', 'España', 17.50, 0, '2023-07-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120723-TmWh64HLdcJyz-095', '156ef85b-81fb-482f-847e-f9442556384c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-TmWh64HLdcJyz-095&s=KOL2023&nf=P3283&i=17.50&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3499, 1, 805, 2, 0, NULL, 0, '2023-07-12 12:59:11', '2023-07-12 15:32:14', '2023-07-12', 'P3284', '23-04677-07-12', 'Llamar antes de entregar, por favor.', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Zabalbide 7 1° izquierda ', 'Bilbao', 'Bizkaia', '48006', 'España', 30.61, 0, '2023-07-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120723-GK1pDvtZ2F1UG-043', 'dda1df10-b346-403f-9e37-36860731f5d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-GK1pDvtZ2F1UG-043&s=KOL2023&nf=P3284&i=30.61&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3500, 1, 329, 2, 0, NULL, 0, '2023-07-12 15:06:19', '2023-07-13 09:11:08', '2023-07-12', 'P3286', '23-04678-07-12', '', 0.00, 32.49, 8.02, 0.00, 0, 0.00, 6.90, 'JUAN BAUTISTA ZABALA nº9 GAURKO', 'Getxo', 'Bizkaia', '48991', 'España', 46.21, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-120723-mbxECyEye0VCc-209', '76be8715-676b-41a4-9b07-a839ee25996a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-mbxECyEye0VCc-209&s=KOL2023&nf=P3286&i=46.21&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3501, 1, 882, 2, 0, NULL, 0, '2023-07-12 17:37:41', '2023-07-13 09:14:24', '2023-07-12', 'P3285', '23-04679-07-12', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Clavileño 27, chalet', 'Madrid', 'Madrid', '28016', 'España', 17.50, 0, '2023-07-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120723-Miz5R87sgI/m9-248', 'dd4c83ba-8fc8-4771-b64d-51c18d7e6d75', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120723-Miz5R87sgI%2Fm9-248&s=KOL2023&nf=P3285&i=17.50&cr=095', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3502, 1, 359, 2, 0, NULL, 0, '2023-07-13 15:25:46', '2023-07-14 09:15:07', '2023-07-13', 'P3289', '23-04682-07-13', 'Si no estoy en casa dejarlo en buzon, gracias', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer reixac 5', 'Montcada i Reixac', 'Barcelona', '08110', 'España', 30.61, 0, '2023-07-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130723-eHIc+95YGcKTI-039', 'e35b7853-09b7-4e60-a87a-0d1afd1e8a92', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130723-eHIc%2B95YGcKTI-039&s=KOL2023&nf=P3289&i=30.61&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3503, 1, 215, 2, 0, NULL, 0, '2023-07-13 18:22:15', '2023-07-14 09:19:30', '2023-07-13', 'P3287', '23-04686-07-13', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 275.88, 0, '2023-07-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130723-SV+L2F5a/Q8ge-143', '956aa252-abd9-48df-ae11-071108a2ef53', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130723-SV%2BL2F5a%2FQ8ge-143&s=KOL2023&nf=P3287&i=275.88&cr=219', '[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
(3504, 1, 640, 2, 0, NULL, 0, '2023-07-14 06:15:04', '2023-07-14 09:22:01', '2023-07-14', 'P3288', '23-04687-07-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Alcover, 2-12 Casa 12', 'Castelldefels', 'Barcelona', '08860', 'España', 17.50, 0, '2023-07-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140723-X1M/AdHqliPpl-081', 'a3e2eba5-aeab-4e2e-8473-ff03bd503dcc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140723-X1M%2FAdHqliPpl-081&s=KOL2023&nf=P3288&i=17.50&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3505, 1, 304, 2, 0, NULL, 0, '2023-07-14 14:48:56', '2023-07-17 09:07:44', '2023-07-14', 'P3294', '2023-07-14', 'Si puede ser,mejor hacer la entrega antes de las once de la mañana,muchas gracias', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Berdolari txirrita ñ 5 4°c', 'Donostia-San Sebasti', 'Gipuzkoa', '20017', 'España', 71.98, 0, '2023-07-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140723-CVajc/05A05u/-037', 'fef5dcac-1681-4e3b-aef2-148b34b3499b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140723-CVajc%2F05A05u%2F-037&s=KOL2023&nf=P3294&i=71.98&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3506, 1, 883, 2, 0, NULL, 0, '2023-07-14 20:23:09', '2023-07-17 09:15:50', '2023-07-14', 'P3290', '23-04689-07-14', '', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'San Lázaro, 11', 'Medina del Campo', 'Valladolid', '47400', 'España', 54.60, 0, '2023-07-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140723-B+JVMi9AM3xtu-212', 'fa74a473-18da-4902-b748-711591c4526b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140723-B%2BJVMi9AM3xtu-212&s=KOL2023&nf=P3290&i=54.60&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3507, 1, 91, 2, 0, NULL, 0, '2023-07-15 13:58:07', '2023-07-17 09:18:19', '2023-07-15', 'P3291', '23-04690-07-15', '', 0.00, 232.06, 48.73, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 280.79, 0, '2023-07-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150723-ftQQV7f2EzmgQ-156', 'd4fe6bce-cd35-44d0-a492-c7146eb625d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150723-ftQQV7f2EzmgQ-156&s=KOL2023&nf=P3291&i=280.79&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3508, 1, 884, 2, 0, NULL, 0, '2023-07-15 20:32:40', '2023-07-17 09:20:40', '2023-07-15', 'P3292', '23-04691-07-15', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Lapurdi kalea 31 2b', 'Zarautz', 'Gipuzkoa', '20800', 'España', 30.61, 0, '2023-07-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150723-gDIkKmKVedl/9-074', '883733d8-4e6d-4a05-82d2-d2b15deda66d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150723-gDIkKmKVedl%2F9-074&s=KOL2023&nf=P3292&i=30.61&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3509, 1, 885, 2, 0, NULL, 0, '2023-07-16 19:16:34', '2023-07-17 09:22:57', '2023-07-16', 'P3293', '23-04692-07-16', '', 0.00, 86.64, 18.20, 0.00, 0, 0.00, 0.00, 'Calle Pintor Antonio Hidalgo, 16, 1D', 'Vélez-Málaga', 'Málaga', '29700', 'España', 104.83, 0, '2023-07-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160723-HjwYTOGyTxib8-247', 'ca6d3192-d33a-4cf3-9985-915781f15cb0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160723-HjwYTOGyTxib8-247&s=KOL2023&nf=P3293&i=104.83&cr=027', '[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
(3510, 1, 581, 2, 0, NULL, 0, '2023-07-17 09:23:21', '2023-07-17 11:27:28', '2023-07-17', 'P3295', '23-04693-07-17', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'P. Arcillero 3, 6 D', 'Santander', 'Cantabria', '39001', 'España', 28.39, 0, '2023-07-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170723-oYHG5DGnceabL-184', '3a820650-8dc3-498f-94c2-7c4887c8a674', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170723-oYHG5DGnceabL-184&s=KOL2023&nf=P3295&i=28.39&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3511, 1, 522, 2, 0, NULL, 0, '2023-07-17 13:39:30', '2023-07-18 08:49:09', '2023-07-17', 'P3296', '23-04694-07-17', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 241.40, 0, '2023-07-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170723-k4KrlFVvDEL/a-054', '945d68d3-88ad-4395-8901-43ffb1da4500', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170723-k4KrlFVvDEL%2Fa-054&s=KOL2023&nf=P3296&i=241.40&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3512, 1, 4, 2, 0, NULL, 0, '2023-07-17 15:38:21', '2023-07-18 08:51:14', '2023-07-17', 'P3297', '23-04695-07-17', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 310.37, 0, '2023-07-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170723-drBMWrhCTLoAr-252', 'd069baee-3f05-4412-a3bb-d84d1307eadd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170723-drBMWrhCTLoAr-252&s=KOL2023&nf=P3297&i=310.37&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3513, 1, 170, 2, 0, NULL, 0, '2023-07-17 18:10:07', '2023-07-18 08:53:33', '2023-07-17', 'P3298', '23-04696-07-17', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Plaza de las agustinas N°5  ', 'Hernani', 'Gipuzkoa', '20120', 'España', 137.94, 0, '2023-07-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170723-GkS2ArDUuVR9G-235', '854878d7-4597-4377-ae42-7da9a42422a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170723-GkS2ArDUuVR9G-235&s=KOL2023&nf=P3298&i=137.94&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3514, 1, 870, 2, 0, NULL, 0, '2023-07-18 09:16:06', '2023-07-18 11:22:07', '2023-07-18', 'P3299', '23-04704-07-18', 'Si no estamos en casa, se puede entregar en portería.', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'Calle Fuente Carrantona 38 C 4 izquierda ', 'Madrid', 'Madrid', '28030', 'España', 113.30, 0, '2023-07-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180723-cMYXgQzDSQXWi-148', 'c1cb7ab2-828d-4009-beba-2fc49fb49b85', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180723-cMYXgQzDSQXWi-148&s=KOL2023&nf=P3299&i=113.30&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3515, 1, 765, 2, 0, NULL, 0, '2023-07-18 12:38:00', '2023-07-19 09:01:30', '2023-07-18', 'P3301', '23-04705-07-18', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-180723-RKsuiz2FvdZbw-052', '9fcbf16a-e57d-4711-88c4-baf03a8bb717', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180723-RKsuiz2FvdZbw-052&s=KOL2023&nf=P3301&i=174.93&cr=125', '[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
(3516, 1, 886, 2, 0, NULL, 0, '2023-07-18 20:01:05', '2023-07-19 09:04:07', '2023-07-18', 'P3300', '23-04706-07-18', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Menendez Pelayo 88 , 1', 'Santander', 'Cantabria', '39006', 'España', 17.50, 0, '2023-07-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180723-cbjV+w7YKy0y6-225', '6df5a2cd-2291-4293-a726-10afdfc017b0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180723-cbjV%2Bw7YKy0y6-225&s=KOL2023&nf=P3300&i=17.50&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3517, 1, 77, 1, 0, NULL, 0, '2023-07-19 11:45:28', '2023-07-19 11:51:35', '2023-07-19', 'P3302', '2023-07-19', '', 0.00, 579.15, 121.62, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 700.77, 0, '2023-07-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190723-feAkelWpcMnlG-148', 'dbbdfb0a-b16d-4e28-87c7-70607e870bd8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190723-feAkelWpcMnlG-148&s=KOL2023&nf=P3302&i=545.04&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3518, 1, 887, 2, 0, NULL, 0, '2023-07-19 09:50:04', '2023-07-19 12:37:56', '2023-07-19', 'P3303', '23-04707-07-19', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, ' avenida de san pedro nº3', 'Donostia-San Sebasti', 'Gipuzkoa', '20017', 'España', 28.39, 0, '2023-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190723-Gm+gilq0Ig2H9-237', '59e93149-2ebf-46a6-ab38-86cc2505f06e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190723-Gm%2Bgilq0Ig2H9-237&s=KOL2023&nf=P3303&i=28.39&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3519, 1, 888, 2, 0, NULL, 0, '2023-07-19 10:16:45', '2023-07-19 12:38:35', '2023-07-19', 'P3304', '23-04708-07-19', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'c/Arenal 23', 'Yuncos', 'Toledo', '45210', 'España', 52.39, 0, '2023-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190723-eX0VbZ8Ewdjy/-163', 'cea6d2f1-57af-4cd0-afa2-5046554c4086', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190723-eX0VbZ8Ewdjy%2F-163&s=KOL2023&nf=P3304&i=52.39&cr=122', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3520, 1, 190, 3, 0, NULL, 0, '2023-07-19 13:37:32', '2023-07-19 13:37:32', '2023-07-19', '', '2023-07-19', '', 0.00, 138.42, 29.07, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 167.49, 0, '2023-07-19 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),
(3521, 1, 34, 2, 0, NULL, 0, '2023-07-19 12:47:12', '2023-07-20 09:27:38', '2023-07-19', 'P3305', '23-04709-07-19', 'Entregar de martes a viernes de 9 a 12', 0.00, 370.50, 77.81, 0.00, 0, 0.00, 0.00, 'peluqueria Marzo21 calle iparraguirre34 plaza trasera   Leioa Bizkaia', 'Leioa', 'Bizkaia', '48940', 'España', 448.31, 0, '2023-07-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190723-m6/b2hiWAEjt9-092', 'a3018a45-a3fd-4612-b170-36492cf5d2c3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190723-m6%2Fb2hiWAEjt9-092&s=KOL2023&nf=P3305&i=448.31&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3522, 1, 889, 2, 0, NULL, 0, '2023-07-19 13:46:53', '2023-07-20 09:33:02', '2023-07-19', 'P3306', '23-04710-07-19', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Rua Forcarey N4, Portal 2 2H', 'Pino (O)', 'A Coruña', '15821', 'España', 43.71, 0, '2023-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190723-F9N3sfPqxrPMI-129', '3a6459ce-41b3-49ea-994a-11c8ab99508f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190723-F9N3sfPqxrPMI-129&s=KOL2023&nf=P3306&i=43.71&cr=059', '[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
(3523, 1, 444, 2, 0, NULL, 0, '2023-07-19 14:43:44', '2023-07-20 09:35:46', '2023-07-19', 'P3307', '23-04711-07-19', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Antziola 9,3ºdcha', 'Hernani', 'Gipuzkoa', '20120', 'España', 28.39, 0, '2023-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190723-TMxANJbDoeAu+-143', 'c4bb3b8f-41ea-412c-a928-7494c5b7ce09', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190723-TMxANJbDoeAu%2B-143&s=KOL2023&nf=P3307&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),
(3524, 1, 71, 2, 0, NULL, 0, '2023-07-19 21:26:14', '2023-07-20 09:38:03', '2023-07-19', 'P3308', '23-04712-07-19', '', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'Rua de vilariño 31', 'Nigrán', 'Pontevedra', '36370', 'España', 133.00, 0, '2023-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190723-HkzYu/vihcb7f-186', '554b3b6f-9279-4345-a33e-9538c6a18c1f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190723-HkzYu%2Fvihcb7f-186&s=KOL2023&nf=P3308&i=133.00&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3525, 1, 638, 2, 0, NULL, 0, '2023-07-19 22:14:37', '2023-07-20 09:41:01', '2023-07-19', 'P3309', '23-04714-07-19', 'Peluquería Mayan', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'C/Javier Echevarría 1', 'Castro-Urdiales', 'Cantabria', '39700', 'España', 52.39, 0, '2023-07-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190723-ZDCZvj6HAQNlo-108', 'ee986d43-1ea2-4362-9fa6-0362d1ad0f3c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190723-ZDCZvj6HAQNlo-108&s=KOL2023&nf=P3309&i=52.39&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3526, 1, 259, 2, 0, NULL, 0, '2023-07-20 06:18:03', '2023-07-20 09:44:12', '2023-07-20', 'P3310', '23-04715-07-20', 'PARA ENTREGA ENTRE 9:00 Y 13:00 AVISAR CON ANTELACION AL 680750573', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'GIPUZKOA KALEA 53 BAJO', 'Zarautz', 'Gipuzkoa', '20800', 'España', 379.34, 0, '2023-07-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200723-Q2+Kc5iZ8Fl6K-214', 'fa14e5bd-d29b-4b45-bacc-f87174530d80', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200723-Q2%2BKc5iZ8Fl6K-214&s=KOL2023&nf=P3310&i=379.34&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3527, 1, 162, 2, 0, NULL, 0, '2023-07-20 07:59:24', '2023-07-20 10:14:47', '2023-07-20', 'P3311', '23-04716-07-20', 'Entregar en horario de mañana,hasta las 14h.', 0.00, 73.26, 15.39, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 88.64, 0, '2023-07-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200723-CBgU6WQvYZ2fr-127', '48b06389-63c0-46f9-a2eb-40d3346b4bc0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200723-CBgU6WQvYZ2fr-127&s=KOL2023&nf=P3311&i=88.64&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3528, 1, 890, 2, 0, NULL, 0, '2023-07-20 08:28:13', '2023-07-20 10:32:35', '2023-07-20', 'P3312', '23-04717-07-20', 'Solo por las mañanas de lunes a viernes.', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Avda de Asturias, 11. Bajo', 'Ribadeo', 'Lugo', '27700', 'España', 65.52, 0, '2023-07-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200723-KO7bt9DgUsDRx-214', '388f2676-e364-40a5-9269-1992453ca013', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200723-KO7bt9DgUsDRx-214&s=KOL2023&nf=P3312&i=65.52&cr=213', '[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
(3529, 1, 640, 2, 0, NULL, 0, '2023-07-20 08:51:02', '2023-07-20 08:51:02', '2023-07-20', 'P3313', '23-04718-07-20', 'Enviar a Charo Garay López\r\nMarqués de la Valdivia 53 Esc 1 4°A\r\n28100 Alcobendas Madrid\r\nTlf 636392183\r\nSin factura, muchísimas gracias!', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Alcover, 2-12 Casa 12', 'Castelldefels', 'Barcelona', '08860', 'España', 17.50, 0, '2023-07-20 08:51:02', '', '', 3, 1, 1, 'TBAI-B20930640-200723-Pl0M8Xn/ECwtv-046', 'ca6461e9-5607-484b-9718-a5286da10413', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200723-Pl0M8Xn%2FECwtv-046&s=KOL2023&nf=P3313&i=17.50&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(3530, 1, 7, 1, 0, NULL, 0, '2023-07-20 15:12:45', '2023-07-20 15:12:45', '2023-07-20', 'P3314', '2023-07-20', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 206.91, 0, '2023-07-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200723-ZdcQP462GMkCi-013', '176a8322-8f39-405a-94d8-4f30022affb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200723-ZdcQP462GMkCi-013&s=KOL2023&nf=P3314&i=206.91&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3531, 1, 891, 2, 0, NULL, 0, '2023-07-20 14:34:41', '2023-07-20 17:19:23', '2023-07-20', 'P3315', '23-04720-07-20', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Plaza de los Atano 1-1', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200723-B66rT9PT0s3ZG-065', '29d972c2-c3aa-475d-8dea-e28d33ab5673', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200723-B66rT9PT0s3ZG-065&s=KOL2023&nf=P3315&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),
(3532, 1, 568, 2, 0, NULL, 0, '2023-07-20 17:12:09', '2023-07-21 09:33:06', '2023-07-20', 'P3316', '23-04721-07-20', 'peluquería El marco blanco', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'larramendi 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 137.94, 0, '2023-07-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200723-aAVacJMVBMwj8-088', '121eaca5-a6ba-46d0-a5d4-5f36c7351e2d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200723-aAVacJMVBMwj8-088&s=KOL2023&nf=P3316&i=137.94&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3533, 1, 381, 2, 0, NULL, 0, '2023-07-21 08:07:43', '2023-07-21 10:21:17', '2023-07-21', 'P3317', '23-04722-07-21', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'C/ Felipe Abad León Nº 51, Embutidos Mariano Martínez', 'Santa Coloma', 'La Rioja', '26315', 'España', 71.98, 0, '2023-07-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210723-OKSox+n8vxaFp-157', 'ed659b57-5714-41bd-9df5-e94444454cf8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210723-OKSox%2Bn8vxaFp-157&s=KOL2023&nf=P3317&i=71.98&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3534, 1, 391, 2, 0, NULL, 0, '2023-07-21 08:37:31', '2023-07-21 10:41:20', '2023-07-21', 'P3318', '23-04723-07-21', '', 0.00, 150.64, 31.63, 0.00, 0, 0.00, 0.00, 'Calle divina pastora 13 bajo', 'Ansoáin', 'Navarra', '31013', 'España', 182.27, 0, '2023-07-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210723-DkNBdKjvb/scT-152', '7f6d5d15-85f9-4517-b10b-f8dda6f39c4a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210723-DkNBdKjvb%2FscT-152&s=KOL2023&nf=P3318&i=182.27&cr=180', '[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
(3535, 1, 262, 2, 0, NULL, 0, '2023-07-21 08:53:13', '2023-07-21 11:42:32', '2023-07-21', 'P3319', '23-04724-07-21', 'Lunes cerrado', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 133.00, 0, '2023-07-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210723-gm3sAJKNv/xKN-132', '603fc6a2-05de-4ae0-97ae-f15ae41ad7b0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210723-gm3sAJKNv%2FxKN-132&s=KOL2023&nf=P3319&i=133.00&cr=154', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3536, 1, 892, 2, 0, NULL, 0, '2023-07-21 09:18:12', '2023-07-21 11:45:00', '2023-07-21', 'P3320', '23-04725-07-21', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/ Mokarte 5, 6C-3C', 'Burlada/Burlata', 'Navarra', '31600', 'España', 43.71, 0, '2023-07-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210723-RBo+N3wcaivJJ-093', 'dc9a448a-4a53-4694-81bf-66fd10cdc30e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210723-RBo%2BN3wcaivJJ-093&s=KOL2023&nf=P3320&i=43.71&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3537, 1, 687, 1, 0, NULL, 0, '2023-07-21 14:04:42', '2023-07-21 14:05:07', '2023-07-21', 'P3321', '2023-07-21', '', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 88.67, 0, '2023-07-21 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210723-cb0Arsx5xUJI2-158', '6eea0699-43db-4aa5-81a6-26fa8ebb74bd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210723-cb0Arsx5xUJI2-158&s=KOL2023&nf=P3321&i=88.67&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3538, 1, 30, 2, 0, NULL, 0, '2023-07-21 12:44:17', '2023-07-24 09:01:26', '2023-07-21', 'P3322', '23-04727-07-21', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'Calle González tablas, 3 bajo', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 620.73, 0, '2023-07-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210723-dbxOlY9SXFuzX-216', '5e8c70e5-e73a-406a-9a9b-4b7cf4044e3e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210723-dbxOlY9SXFuzX-216&s=KOL2023&nf=P3322&i=620.73&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3539, 1, 893, 2, 0, NULL, 0, '2023-07-21 16:37:16', '2023-07-24 09:06:37', '2023-07-21', 'P3323', '23-04728-07-21', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Mayor 12', 'Asteasu', 'Gipuzkoa', '20159', 'España', 30.61, 0, '2023-07-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210723-WVz2CK9IF3LfR-072', 'a33bb8c7-aaf6-4d7a-b866-d56bc1ee78b0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210723-WVz2CK9IF3LfR-072&s=KOL2023&nf=P3323&i=30.61&cr=240', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3540, 1, 17, 2, 0, NULL, 0, '2023-07-22 08:09:46', '2023-07-24 09:08:14', '2023-07-22', 'P3324', '23-04729-07-22', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 172.43, 0, '2023-07-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220723-hU35tEnZTYIHX-005', '9d4e28b6-00f1-4408-b281-5a834da3715a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220723-hU35tEnZTYIHX-005&s=KOL2023&nf=P3324&i=172.43&cr=000', '[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
(3541, 1, 68, 2, 0, NULL, 0, '2023-07-22 08:59:49', '2023-07-24 09:10:08', '2023-07-22', 'P3327', '23-04730-07-22', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'murgis 45', 'Ejido (El)', 'Almería', '04700', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-220723-Pg3TopC+FHsm3-067', '4fc27449-4136-47f3-a54d-1ce11a112506', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220723-Pg3TopC%2BFHsm3-067&s=KOL2023&nf=P3327&i=174.93&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3542, 1, 372, 2, 0, NULL, 0, '2023-07-22 14:08:37', '2023-07-24 09:12:16', '2023-07-22', 'P3325', '23-04731-07-22', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer Arenal n 7', 'Castelló d\'Empúries', 'Girona', '17487', 'España', 30.61, 0, '2023-07-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220723-fEVI1Md6Uhh3k-199', '40482d32-0834-4d22-b436-909e9326093a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220723-fEVI1Md6Uhh3k-199&s=KOL2023&nf=P3325&i=30.61&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3543, 1, 894, 2, 0, NULL, 0, '2023-07-22 17:16:02', '2023-07-24 09:13:36', '2023-07-22', 'P3326', '23-04732-07-22', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Lubiana n°2 5°A', 'Vitoria-Gasteiz', 'Álava', '01003', 'España', 17.50, 0, '2023-07-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220723-PvDwF0JdMVKq/-026', 'b98c99b3-c077-4f1b-a1c3-5e56b18dc426', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220723-PvDwF0JdMVKq%2F-026&s=KOL2023&nf=P3326&i=17.50&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3544, 1, 580, 2, 0, NULL, 0, '2023-07-24 07:33:21', '2023-07-24 09:40:06', '2023-07-24', 'P3328', '23-04733-07-24', 'Si no estamos en casa pueden dejarlo en el buzón o en el celpudo de la puerta.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'San martín 4, 4 izd.', 'Urretxu', 'Gipuzkoa', '20700', 'España', 17.50, 0, '2023-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240723-P0Qh95UYzKED3-226', 'ce5029fb-1868-40bb-a3c2-0f9799d951a5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240723-P0Qh95UYzKED3-226&s=KOL2023&nf=P3328&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),
(3545, 1, 307, 2, 0, NULL, 0, '2023-07-24 08:09:28', '2023-07-24 10:18:26', '2023-07-24', 'P3329', '23-04734-07-24', 'Es mi lugar de trabajo. Enviadlo a mi atención\r\nFundación Ibercaja\r\nA/A. Beatriz Compadre\r\nC/ Joquiín Costa, 13.\r\n50001. Zaragoza', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Joaquin Costa, 13', 'Zaragoza', 'Zaragoza', '50001', 'España', 30.61, 0, '2023-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240723-E1XqyG/yivQwl-136', '5c4af4a2-2336-4464-95eb-a0b71d7f9076', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240723-E1XqyG%2FyivQwl-136&s=KOL2023&nf=P3329&i=30.61&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3546, 1, 65, 2, 0, NULL, 0, '2023-07-24 09:07:36', '2023-07-24 11:14:34', '2023-07-24', 'P3330', '2023-07-24', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 620.73, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240723-oK2B7t/BGYnlN-080', '09613f46-67d5-4707-ab23-b3b9071db8d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240723-oK2B7t%2FBGYnlN-080&s=KOL2023&nf=P3330&i=620.73&cr=164', '[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
(3547, 1, 798, 2, 0, NULL, 0, '2023-07-24 09:53:13', '2023-07-24 11:57:22', '2023-07-24', 'P3331', '23-04736-07-24', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Lepanto ,3. 1C', 'Arrigorriaga', 'Bizkaia', '48480', 'España', 17.50, 0, '2023-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240723-pJG/A9vFJEfK4-183', '0de3fa11-2f0c-49d3-942b-4bed70b280fd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240723-pJG%2FA9vFJEfK4-183&s=KOL2023&nf=P3331&i=17.50&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3548, 1, 483, 2, 0, NULL, 0, '2023-07-24 10:43:38', '2023-07-24 12:45:11', '2023-07-24', 'P3332', '23-04737-07-24', 'Llamar antes de entregar.', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Pintor Teodoro Dublang 53 3Dcha', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 71.98, 0, '2023-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240723-DHlCSoiDMQeDl-187', 'dc9c610c-35dc-4e01-a161-b2118b6ed385', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240723-DHlCSoiDMQeDl-187&s=KOL2023&nf=P3332&i=71.98&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3549, 1, 895, 2, 0, NULL, 0, '2023-07-24 18:57:52', '2023-07-25 10:02:36', '2023-07-24', 'P3333', '23-04740-07-24', 'Entregar antes de las 12', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Casa Echebeste n°6 bajo', 'Oiartzun', 'Gipuzkoa', '20180', 'España', 30.61, 0, '2023-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240723-HaGlAEg73jbXZ-240', 'ebbfefd2-22ab-428a-a810-b6953e9f3d3c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240723-HaGlAEg73jbXZ-240&s=KOL2023&nf=P3333&i=30.61&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3550, 1, 120, 2, 0, NULL, 0, '2023-07-25 10:58:10', '2023-07-26 09:04:06', '2023-07-25', 'P3334', '23-04741-07-25', '', 0.00, 240.20, 50.44, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 290.64, 0, '2023-07-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250723-OfDZ7DgL3ViCs-098', '383a415e-4318-4fa5-bd30-6cc9304009af', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250723-OfDZ7DgL3ViCs-098&s=KOL2023&nf=P3334&i=290.64&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3551, 1, 896, 2, 0, NULL, 0, '2023-07-25 11:29:16', '2023-07-26 09:08:35', '2023-07-25', 'P3335', '23-04742-07-25', 'Peluqueria Eider', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Marrutxipi 24', 'Donostia-San Sebasti', 'Gipuzkoa', '20013', 'España', 196.56, 0, '2023-07-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250723-MNtg92G1FmJ+S-239', '10bde15a-4406-487f-a955-93cf5574e1d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250723-MNtg92G1FmJ%2BS-239&s=KOL2023&nf=P3335&i=196.56&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3552, 1, 65, 2, 0, NULL, 0, '2023-07-25 11:32:10', '2024-07-17 13:07:04', '2023-07-25', 'P3337', '23-04743-07-25', '', 0.00, 427.50, 89.77, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 517.27, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250723-KwbEoQEBZHBXu-205', '0c88de19-2aeb-4e7b-8682-4d95e072c7a2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250723-KwbEoQEBZHBXu-205&s=KOL2023&nf=P3337&i=517.28&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
