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
(6958, 1, 4, 2, 0, NULL, 0, '2025-03-21 11:29:04', '2025-03-21 12:53:15', '2025-03-21', 'P6541', '25-08454-03-21', '', 0.00, 235.76, 49.51, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 285.27, 0, '2025-03-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210325-cOnAKzUjsQWc9-236', '680dc6bd-481a-482d-9774-e2e58e153713', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210325-cOnAKzUjsQWc9-236&s=KOL2025&nf=P6541&i=285.27&cr=072', '[BLOB]', 0, 'PKANHY071000651Z', '2025-03-21 12:53:20', '[BLOB]', 2, '', '2025-03-24', 'S0235', 35, 20, 30, 3200, 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
(6959, 1, 1742, 2, 0, NULL, 0, '2025-03-21 12:03:29', '2025-03-24 07:34:18', '2025-03-24', 'P6553', '25-08455-03-21', '', 0.00, 22.40, 5.80, 0.00, 0, 0.00, 6.34, 'urb ibargarai,8', 'Gordexola', 'Bizkaia', '48192', 'España', 33.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-240325-IVtU68lhsv5Tg-212', '6fb91d39-5774-4fa5-aa84-8420e4688652', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-IVtU68lhsv5Tg-212&s=KOL2025&nf=P6553&i=33.44&cr=013', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6960, 1, 468, 2, 0, NULL, 0, '2025-03-21 12:46:41', '2025-03-24 07:37:28', '2025-03-24', 'P6542', '25-08456-03-21', 'Si ausente dejar en Byta Fitness', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'Rof Carballo , 1 Bajo kimera', 'Lugo', 'Lugo', '27002', 'España', 142.63, 0, '2025-03-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240325-EME77ZlVPQFtT-080', '4ea4812f-8103-43ab-88ce-b23ee2d8a66a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-EME77ZlVPQFtT-080&s=KOL2025&nf=P6542&i=142.63&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6961, 1, 1341, 2, 0, NULL, 0, '2025-03-21 14:06:58', '2025-03-24 07:39:37', '2025-03-24', 'P6543', '25-08457-03-21', '', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'Avd ferrocarril n54 bajo', 'Coruña (A)', 'A Coruña', '15008', 'España', 142.63, 0, '2025-03-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-A7DWkranOXYxN-003', '59a95fe0-61db-4ef9-b9ff-b890d8ae4250', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-A7DWkranOXYxN-003&s=KOL2025&nf=P6543&i=142.63&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6962, 1, 222, 2, 0, NULL, 0, '2025-03-21 15:48:41', '2025-03-24 07:42:53', '2025-03-24', 'P6554', '25-08458-03-21', '', 0.00, 147.35, 30.95, 0.00, 0, 0.00, 0.00, 'Cartagena 296 ', 'Barcelona', 'Barcelona', '08025', 'España', 178.29, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240325-bx2TIbHJa9gbL-131', 'fb058a8d-9996-4c09-a5f4-c918d2db4087', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-bx2TIbHJa9gbL-131&s=KOL2025&nf=P6554&i=178.29&cr=154', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6963, 1, 1743, 2, 0, NULL, 0, '2025-03-21 16:47:41', '2025-03-24 08:44:56', '2025-03-24', 'P6544', '25-08459-03-21', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Calle Los Pájaros 31 5°dcha', 'Zaragoza', 'Zaragoza', '50019', 'España', 31.27, 0, '2025-03-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240325-X7qRhKGHgSH6H-057', 'b6660943-1894-4687-90b8-8824076996b9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-X7qRhKGHgSH6H-057&s=KOL2025&nf=P6544&i=31.27&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6964, 1, 1744, 2, 0, NULL, 0, '2025-03-21 19:03:05', '2025-03-24 08:45:53', '2025-03-24', 'P6545', '25-08460-03-21', '', 0.00, 33.60, 7.78, 0.00, 0, 0.00, 4.17, 'Plaza del Duque 7A', 'Osuna', 'Sevilla', '41640', 'España', 44.83, 0, '2025-03-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240325-XYtJCJTDYrhtl-152', 'f227663c-e0d6-4a4f-8730-3473d31a2692', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-XYtJCJTDYrhtl-152&s=KOL2025&nf=P6545&i=44.83&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6965, 1, 1167, 2, 0, NULL, 0, '2025-03-22 11:30:25', '2025-03-24 08:47:00', '2025-03-24', 'P6546', '25-08464-03-22', '', 0.00, 44.80, 10.13, 0.00, 0, 0.00, 4.17, 'Calle Juan Carlos, I n° 10 , casa', 'Ainzón', 'Zaragoza', '50570', 'España', 58.38, 0, '2025-03-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-Ns/su3UI5YpCT-122', 'c79b9653-c66a-4937-97d7-9739388e8818', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-Ns%2Fsu3UI5YpCT-122&s=KOL2025&nf=P6546&i=58.38&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6966, 1, 764, 2, 0, NULL, 0, '2025-03-23 10:21:55', '2025-03-24 08:50:32', '2025-03-24', 'P6547', '25-08470-03-23', '', 0.00, 54.10, 11.36, 0.00, 0, 0.00, 0.00, 'Calle Fermín caballero 56, 5A', 'Madrid', 'Madrid', '28034', 'España', 65.46, 0, '2025-03-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-Aj3BNGMueRUXD-071', 'e12eacf0-fc7a-4197-9890-b9904bebfb91', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-Aj3BNGMueRUXD-071&s=KOL2025&nf=P6547&i=65.45&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6967, 1, 1745, 2, 0, NULL, 0, '2025-03-23 10:35:57', '2025-03-24 08:51:17', '2025-03-24', 'P6548', '25-08471-03-23', 'Buenos días por favor entreguen el paquete a partir de las 16:30h', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'PASEO ANELIER           17, 4°J', 'Pamplona/Iruña', 'Navarra', '31014', 'España', 28.98, 0, '2025-03-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-V50OKcTEjIXLu-192', 'e91121c6-8516-4496-964e-5dd145da2046', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-V50OKcTEjIXLu-192&s=KOL2025&nf=P6548&i=28.98&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6968, 1, 635, 2, 0, NULL, 0, '2025-03-23 11:28:25', '2025-03-24 08:52:12', '2025-03-24', 'P6549', '25-08472-03-23', 'SI ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703. GRACIAS.', 0.00, 147.35, 30.94, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 178.29, 0, '2025-03-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-BBeBpwP55Y6OR-029', 'ab49c409-2314-4ed6-829d-ca3f6086d0dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-BBeBpwP55Y6OR-029&s=KOL2025&nf=P6549&i=178.29&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6969, 1, 1269, 2, 0, NULL, 0, '2025-03-23 15:24:16', '2025-03-24 08:54:34', '2025-03-24', 'P6550', '25-08473-03-23', 'Ojo! Nueva dirección de facturación y de entrega!\r\nCalle Cristóbal Colón, 13, local izquierda\r\n50007 Zaragoza\r\n25169200R', 0.00, 67.36, 14.14, 0.00, 0, 0.00, 0.00, 'Cristóbal Colon, 13, local izquierda', 'Zaragoza', 'Zaragoza', '50007', 'España', 81.51, 0, '2025-03-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-MkTa5d8bVm28s-217', 'c51edf17-f7f7-46ff-adf0-8c8fcc2347ca', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-MkTa5d8bVm28s-217&s=KOL2025&nf=P6550&i=81.51&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6970, 1, 754, 2, 0, NULL, 0, '2025-03-23 16:38:51', '2025-03-24 08:55:38', '2025-03-24', 'P6551', '25-08474-03-23', '6+1 GRATIS\r\nREGALO TRATAMIENTO NEUTRAL\r\nGRACIAS', 0.00, 50.52, 10.61, 0.00, 1, 2.63, 0.00, 'jOSEP TARRADELLAS 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 63.76, 0, '2025-03-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-Kq6ElILg9iibN-169', '27bd961c-1eb5-462c-bc4c-4ad919a177e2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-Kq6ElILg9iibN-169&s=KOL2025&nf=P6551&i=63.76&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6971, 1, 1199, 2, 0, NULL, 0, '2025-03-23 20:03:08', '2025-03-24 08:56:37', '2025-03-24', 'P6552', '25-08478-03-23', '', 0.00, 22.40, 5.37, 0.00, 0, 0.00, 3.84, 'MAINERROTA 7, 3D', 'Otxandio', 'Bizkaia', '48210', 'España', 30.94, 0, '2025-03-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240325-dGy21IaUZqECd-235', 'd541bb3f-4227-4b2e-85bc-877e29eab9f8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-dGy21IaUZqECd-235&s=KOL2025&nf=P6552&i=30.94&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6972, 1, 121, 2, 0, NULL, 0, '2025-03-24 08:39:14', '2025-03-24 10:36:49', '2025-03-24', 'P6556', '25-08479-03-24', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 106.98, 0, '2025-03-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240325-F5JL8Bjnvslxi-235', '0fee4617-6254-4b33-8756-5b2a2447bc94', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-F5JL8Bjnvslxi-235&s=KOL2025&nf=P6556&i=106.98&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6973, 1, 764, 2, 1, 'cliente incorrecto', 6966, '2025-03-24 10:24:35', '2025-03-24 10:24:35', '2025-03-24', 'R107', 'P6547 RECT.', '', 0.00, 54.10, 11.36, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 65.46, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-240325-glg7sYxsnfe0P-220', '218ebb7e-453f-40e9-bf41-ee78d5b4a585', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-glg7sYxsnfe0P-220&s=KOL2025&nf=R107&i=-65.45&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(6974, 1, 1746, 1, 0, NULL, 0, '2025-03-24 10:27:56', '2025-03-24 10:28:47', '2025-03-24', 'P6555', '2025-03-24', '', 0.00, 54.11, 11.36, 0.00, 0, 0.00, 0.00, 'Calle Fermín caballero 56, 5A', 'Madrid', 'Madrid', '28034 ', 'España', 65.47, 0, '2025-03-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-cGt1sO06v2Orf-200', '930d4ee1-3167-4342-b3fd-7518b9bba174', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-cGt1sO06v2Orf-200&s=KOL2025&nf=P6555&i=65.47&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6975, 1, 1623, 2, 0, NULL, 0, '2025-03-24 09:43:15', '2025-03-24 10:54:05', '2025-03-24', 'P6557', '25-08480-03-24', 'Oficina Jon Uriarte Arquitecto', 0.00, 22.40, 5.37, 0.00, 0, 0.00, 3.84, 'Calle Ibaigane 15, Piso 2 Dpto 2', 'Getxo', 'Bizkaia', '48930', 'España', 30.94, 0, '2025-03-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-RCJRYT9oXSwIk-121', '1a267971-d212-4576-89ad-67a2c3c65a28', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-RCJRYT9oXSwIk-121&s=KOL2025&nf=P6557&i=30.94&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6976, 1, 1747, 1, 0, NULL, 0, '2025-03-24 11:08:36', '2025-03-24 11:12:26', '2025-03-24', 'P6558', '', '', 0.00, 168.00, 35.28, 0.00, 0, 0.00, 0.00, 'Calle Santamaria 10, bajo', 'Renteria', 'Gipuzkoa', '20100', 'España', 203.28, 0, '2025-03-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240325-ZHP3uVwVeOkiU-129', 'd0f0412d-0077-450d-9138-5ac9790712d7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-ZHP3uVwVeOkiU-129&s=KOL2025&nf=P6558&i=203.28&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6977, 1, 221, 2, 0, NULL, 0, '2025-03-24 10:26:03', '2025-03-24 11:28:49', '2025-03-24', 'P6559', '25-08481-03-24', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 106.98, 0, '2025-03-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240325-bztQLX/FC7FWU-043', 'e992224d-1272-4c5a-9e47-fb95fd1c8e89', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-bztQLX%2FFC7FWU-043&s=KOL2025&nf=P6559&i=106.98&cr=112', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6978, 1, 1681, 1, 0, NULL, 0, '2025-03-24 11:36:13', '2025-03-24 11:36:13', '2025-03-24', 'P6560', '', '', 0.00, 75.78, 15.91, 0.00, 0, 0.00, 0.00, ' Ihurrita bidea 14,  ', 'Oiartzun ', 'Guipúzcoa', '20180', 'España', 91.69, 0, '2025-03-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240325-HSDTszK51+MuA-078', 'a54782c7-b529-4120-8da9-7ab3969f45bc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-HSDTszK51%2BMuA-078&s=KOL2025&nf=P6560&i=91.69&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6979, 1, 696, 1, 0, NULL, 0, '2025-03-24 12:40:15', '2025-03-24 12:40:15', '2025-03-24', 'P6561', '', '', 0.00, 574.86, 120.72, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 695.58, 0, '2025-03-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240325-WKa/9FKZCnD25-222', 'fbae29c0-1bbe-4a62-8853-f62fc4d7d714', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-WKa%2F9FKZCnD25-222&s=KOL2025&nf=P6561&i=695.58&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6980, 1, 696, 1, 0, NULL, 0, '2025-03-24 12:42:08', '2025-03-24 12:42:08', '2025-03-24', 'P6562', '', '', 0.00, 266.40, 55.94, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 322.34, 0, '2025-03-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240325-UcUqwYn9qeSSD-083', 'e10788c3-bbe4-4f30-be75-092cf8d01226', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-UcUqwYn9qeSSD-083&s=KOL2025&nf=P6562&i=322.33&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6981, 1, 152, 1, 0, NULL, 0, '2025-03-24 12:49:21', '2025-03-24 12:57:43', '2025-03-24', 'P6563', '2025-03-24', '', 0.00, 168.61, 35.41, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 204.02, 0, '2025-03-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240325-JgQedZceL8A3c-074', '0dfd06b1-74f3-4871-8232-490a029f2016', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240325-JgQedZceL8A3c-074&s=KOL2025&nf=P6563&i=204.02&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6982, 1, 1748, 2, 0, NULL, 0, '2025-03-24 12:37:58', '2025-03-25 07:32:49', '2025-03-25', 'P6564', '25-08483-03-24', 'Escalera 7.apart 194.', 0.00, 74.60, 15.67, 0.00, 0, 0.00, 0.00, 'avenida de los cines s/n.urb  los albatros escalera 7.apart 194.     n Albatros.                         a 7..Urbanizacion Albatros, apartamento 194', 'Ayamonte', 'Huelva', '21409', 'España', 90.27, 0, '2025-03-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250325-cngbDvF5N5RlN-216', '165e4f53-9111-42bb-8234-7b82da5e1dce', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250325-cngbDvF5N5RlN-216&s=KOL2025&nf=P6564&i=90.27&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6983, 1, 1430, 1, 0, NULL, 0, '2025-03-24 18:02:01', '2025-03-24 18:02:01', '2025-03-25', 'P6565', '', '', 0.00, 117.88, 24.75, 0.00, 0, 0.00, 0.00, 'Carrer Rei en Jaume 90, bajo', 'Vila-real', 'Castellón', '12540', 'España', 142.63, 0, '2025-03-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250325-RhkttX2fKljUM-070', '26585d42-cfff-4a2f-b9b5-b5f563a7968e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250325-RhkttX2fKljUM-070&s=KOL2025&nf=P6565&i=142.63&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6984, 1, 1749, 2, 0, NULL, 0, '2025-03-25 07:49:40', '2025-03-25 08:56:40', '2025-03-25', 'P6566', '25-08476-03-23', '', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'C/torrentera bloque 2, portal 4, primero, puerta 3', 'Arroyo de la Encomienda', 'Valladolid', '47195', 'España', 28.98, 0, '0000-00-00 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250325-SPkEnE+nt6iuK-009', '773cc97c-c6dd-4b7a-964f-e6a78ba51146', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250325-SPkEnE%2Bnt6iuK-009&s=KOL2025&nf=P6566&i=28.98&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6985, 1, 1740, 2, 1, 'prueba interna no existe pedido', 6955, '2025-03-25 09:19:08', '2025-03-25 09:19:08', '2025-03-25', 'R108', 'P6538 RECT.', 'Test', 0.00, 11.20, 2.99, 0.00, 0, 0.00, 3.67, '', '', '', '', '', 17.22, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-250325-dnXvtZWBgEL52-112', 'db840a20-bbb5-4d9f-a3a9-5229909d00b0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250325-dnXvtZWBgEL52-112&s=KOL2025&nf=R108&i=-17.22&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(6986, 1, 1740, 2, 1, 'prueba interna no existe pedido', 6956, '2025-03-25 09:20:00', '2025-03-25 09:20:00', '2025-03-25', 'R109', 'P6539 RECT.', 'Test', 0.00, 22.40, 5.34, 0.00, 0, 0.00, 3.67, '', '', '', '', '', 30.77, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-250325-EWLkP0yDGGSLL-143', '7ece7be0-1ae9-4c38-8e30-8b2983e594d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250325-EWLkP0yDGGSLL-143&s=KOL2025&nf=R109&i=-30.77&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(6987, 1, 520, 2, 0, NULL, 0, '2025-03-25 11:02:35', '2025-03-25 15:23:20', '2025-03-25', 'P6567', '25-08486-03-25', 'miércoles  a la mañana cerrado y lunes a la tarde cerrado', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'Calle Andreszar, 34, ZAR Peluqueria', 'Villava/Atarrabia', 'Navarra', '31610', 'España', 106.98, 0, '2025-03-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-250325-e6bptJVMU88Kk-139', 'bc28b866-886a-495a-a57f-2ae70d56a855', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250325-e6bptJVMU88Kk-139&s=KOL2025&nf=P6567&i=106.98&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6988, 1, 76, 1, 0, NULL, 0, '2025-03-25 12:54:18', '2025-03-25 12:54:18', '2025-03-26', 'P6568', '', '', 0.00, 1332.00, 279.72, 0.00, 0, 0.00, 0.00, 'VELLUTERS, 1 NAVE 1', 'PATERNA', 'VALENCIA', '46980', 'ESPAÑA', 1611.72, 0, '2025-03-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260325-U8DKFSvbwDvH+-145', 'b5ca975e-b501-4ba9-9a19-48d0dcf47f1e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260325-U8DKFSvbwDvH%2B-145&s=KOL2025&nf=P6568&i=1611.72&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
