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
(5316, 1, 1325, 2, 0, NULL, 0, '2024-07-05 11:01:46', '2024-07-08 09:04:40', '2024-07-08', 'P4979', '24-06644-07-05', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Travesía de Espronceda 10 3º izquierda', 'Pamplona/Iruña', 'Navarra', '31015', 'España', 52.39, 0, '2024-07-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080724-eayBZCZzjU6IM-097', 'c915bfa5-6f70-45ae-9412-d4b828663332', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080724-eayBZCZzjU6IM-097&s=KOL2024&nf=P4979&i=52.39&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5317, 1, 872, 2, 0, NULL, 0, '2024-07-05 16:50:26', '2024-07-08 09:14:41', '2024-07-08', 'P4980', '24-06645-07-05', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Antonio Machado N ° 7  . 3- C', 'Caudete', 'Albacete', '02660', 'España', 30.61, 0, '2024-07-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080724-LxCUkSD6Dfc8d-042', 'a5ac7413-8289-4c2e-b84b-ac84369b36ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080724-LxCUkSD6Dfc8d-042&s=KOL2024&nf=P4980&i=30.61&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5318, 1, 1035, 2, 0, NULL, 0, '2024-07-06 09:27:42', '2024-07-08 09:19:34', '2024-07-08', 'P4981', '24-06646-07-06', 'Avísame ', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Ronda Josep Anselm clavé 2.3-3', 'Canet de Mar', 'Barcelona', '08360', 'España', 71.98, 0, '2024-07-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080724-B8/i1VeFoTUi+-013', '7364dda3-a661-49ad-9a22-17bde149bbf9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080724-B8%2Fi1VeFoTUi%2B-013&s=KOL2024&nf=P4981&i=71.98&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5319, 1, 455, 2, 0, NULL, 0, '2024-07-06 14:41:58', '2024-07-08 09:24:09', '2024-07-08', 'P4982', '24-06647-07-06', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Venta Peio, alto de Ibardin s/n', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 30.61, 0, '2024-07-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080724-MVYm4TfnUy26b-094', 'e19fc07d-d95b-4711-8d23-9d92d3e5fbd8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080724-MVYm4TfnUy26b-094&s=KOL2024&nf=P4982&i=30.61&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5320, 1, 492, 2, 0, NULL, 0, '2024-07-06 20:20:41', '2024-07-08 09:38:22', '2024-07-08', 'P4983', '24-06648-07-06', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle doctor Laureano Casquero 25 H7', 'Vélez-Málaga', 'Málaga', '29740', 'España', 30.61, 0, '2024-07-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080724-gx2VYYDgDhoGM-090', '4b9792d6-63a4-408c-acf0-845e1f38b21b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080724-gx2VYYDgDhoGM-090&s=KOL2024&nf=P4983&i=30.61&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5321, 1, 284, 2, 0, NULL, 0, '2024-07-07 15:30:47', '2024-07-08 09:43:29', '2024-07-08', 'P4984', '24-06649-07-07', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'AV MIL.LENARI Nº29 3º1ª', 'Viladecans', 'Barcelona', '08840', 'España', 43.71, 0, '2024-07-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080724-X15UQaXZi8YUG-195', '0f08b578-9feb-4bd3-8b88-aad468c35ce9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080724-X15UQaXZi8YUG-195&s=KOL2024&nf=P4984&i=43.71&cr=099', '[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
(5322, 1, 1164, 2, 0, NULL, 0, '2024-07-08 06:17:26', '2024-07-08 09:46:19', '2024-07-08', 'P4985', '24-06650-07-08', 'si no estoy en casa dejar debajjo del felpudo', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'jabier de barkaiztegui 17, 5a', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 30.61, 0, '2024-07-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080724-OG+hJI8jOL7rj-086', '280151b9-1aeb-427e-ad88-19614780ebc1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080724-OG%2BhJI8jOL7rj-086&s=KOL2024&nf=P4985&i=30.61&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5323, 1, 152, 1, 0, NULL, 0, '2024-07-08 09:54:01', '2024-07-08 10:01:18', '2024-07-08', 'P4986', '2024-07-08', '', 0.00, 171.60, 36.04, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 207.64, 0, '2024-07-08 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080724-LrLXL4EgHrfVj-110', '330709c9-f209-488f-86e2-f9e795760d60', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080724-LrLXL4EgHrfVj-110&s=KOL2024&nf=P4986&i=207.64&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5324, 1, 998, 2, 0, NULL, 0, '2024-07-08 10:00:11', '2024-07-08 12:14:28', '2024-07-08', 'P4987', '24-06651-07-08', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Dr. Palomar, 6, 2º Izda', 'Zaragoza', 'Zaragoza', '50002', 'España', 30.61, 0, '2024-07-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080724-QiaaS8nDwBrLF-064', 'c978db51-b321-404c-8b13-ae5b8adbe27e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080724-QiaaS8nDwBrLF-064&s=KOL2024&nf=P4987&i=30.61&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5325, 1, 131, 2, 0, NULL, 0, '2024-07-09 06:03:36', '2024-07-09 09:11:06', '2024-07-09', 'P4988', '24-06652-07-09', '', 0.00, 89.54, 18.80, 0.00, 0, 0.00, 0.00, 'C / general eguia frente al 31, Peluqueria bilbo', 'Bilbao', 'Bizkaia', '48013', 'España', 108.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090724-jeuhK+keN4xbH-141', '9434d6b1-8a81-476d-979d-a851a38f8fe8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090724-jeuhK%2BkeN4xbH-141&s=KOL2024&nf=P4988&i=108.34&cr=010', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5326, 1, 1326, 2, 0, NULL, 0, '2024-07-09 07:52:12', '2024-07-09 10:14:52', '2024-07-09', 'P4989', '24-06656-07-09', '', 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-07-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090724-UfxzQHcmewbNo-050', '21cdd326-3229-4f79-bb7d-76757f74b5f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090724-UfxzQHcmewbNo-050&s=KOL2024&nf=P4989&i=28.39&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5327, 1, 580, 2, 0, NULL, 0, '2024-07-09 07:54:22', '2024-07-09 10:32:31', '2024-07-09', 'P4990', '24-06657-07-09', 'Si me lo entregan de lunes a viernes de 08:00 a 15:00 (entregar en mi trabajo, matia gozará, elizkale 13, 20700 zumarraga) está cerca del domicilio, llamar antes al móvil.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'san martin 4,4º izd', 'Urretxu', 'Gipuzkoa', '20700', 'España', 17.50, 0, '2024-07-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090724-G3MyfE5jb9v4w-156', '39cbb589-e562-49fe-ab88-9fda4ea96666', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090724-G3MyfE5jb9v4w-156&s=KOL2024&nf=P4990&i=17.50&cr=064', '[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
(5328, 1, 1327, 1, 0, NULL, 0, '2024-07-09 10:45:01', '2024-07-09 10:45:12', '2024-07-09', 'P4991', '', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Ilargi plaza 2, baxua', 'Aretxabaleta', 'Gipuzkoa', '20550', '', 34.48, 0, '2024-07-09 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090724-fNuQIIz97kiY8-148', 'bb72af03-6da8-4a6c-926d-0d2b1b9dca06', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090724-fNuQIIz97kiY8-148&s=KOL2024&nf=P4991&i=34.47&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5329, 1, 1328, 2, 0, NULL, 0, '2024-07-09 10:33:29', '2024-07-09 12:38:22', '2024-07-09', 'P4992', '24-06659-07-09', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'CALLE ANTONIO BUERO VALLEJO 39', 'Alcalá de Henares', 'Madrid', '28806', 'España', 52.39, 0, '2024-07-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090724-GTnHn2+9jjWIc-179', '0267a618-abda-4d5a-8b29-d8d7a95fb06d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090724-GTnHn2%2B9jjWIc-179&s=KOL2024&nf=P4992&i=52.39&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5330, 1, 220, 2, 0, NULL, 0, '2024-07-09 10:40:53', '2024-07-09 12:49:16', '2024-07-09', 'P4993', '24-06660-07-09', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 241.40, 0, '2024-07-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090724-SjylJ4OD0Y1b4-034', '6bda0792-ef49-46ad-b9d0-20f5cb063ea6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090724-SjylJ4OD0Y1b4-034&s=KOL2024&nf=P4993&i=241.40&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5331, 1, 1329, 2, 0, NULL, 0, '2024-07-09 13:50:04', '2024-07-10 09:24:10', '2024-07-10', 'P4994', '24-06661-07-09', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Poeta ausias march num 20 pta 1', 'Ontinyent', 'Valencia', '46870', 'España', 52.39, 0, '2024-07-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100724-YkVZHNVZKnKsk-126', 'caacf87b-c792-4d19-b65e-90a519cbd7bb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-YkVZHNVZKnKsk-126&s=KOL2024&nf=P4994&i=52.39&cr=240', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5332, 1, 221, 2, 0, NULL, 0, '2024-07-09 15:21:25', '2024-07-10 09:28:51', '2024-07-10', 'P4995', '24-06662-07-09', '', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 78.82, 0, '2024-07-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100724-BTmW6eJrWCZ6T-199', '0afa4076-c4f0-407b-803f-fe1283bafaf9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-BTmW6eJrWCZ6T-199&s=KOL2024&nf=P4995&i=78.81&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5333, 1, 568, 2, 0, NULL, 0, '2024-07-09 15:51:13', '2024-07-10 09:32:42', '2024-07-10', 'P4996', '24-06663-07-09', 'peluquería el marco blanco', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'larramendi 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 206.91, 0, '2024-07-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100724-NcD4RCsGUHwH4-131', '495aac7e-da48-4ffc-a91b-e75d84ecdf49', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-NcD4RCsGUHwH4-131&s=KOL2024&nf=P4996&i=206.91&cr=155', '[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
(5334, 1, 4, 2, 0, NULL, 0, '2024-07-09 17:54:46', '2024-07-10 09:39:50', '2024-07-10', 'P4997', '24-06665-07-09', '', 0.00, 276.84, 58.14, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 334.98, 0, '2024-07-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100724-oyFRhmcb7euDC-227', '03ca7ca2-4708-46dc-a694-b61fcff35f67', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-oyFRhmcb7euDC-227&s=KOL2024&nf=P4997&i=334.98&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5335, 1, 1330, 2, 0, NULL, 0, '2024-07-09 19:25:23', '2024-07-10 09:43:21', '2024-07-10', 'P4998', '24-06666-07-09', 'Llamar por teléfono ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Sagasta 30', 'Vejer de la Frontera', 'Cádiz', '11150', 'España', 30.61, 0, '2024-07-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100724-nD4eFVZDQKd5p-033', '406425dc-9e3e-4102-86ca-c9b4f34a1074', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-nD4eFVZDQKd5p-033&s=KOL2024&nf=P4998&i=30.61&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5336, 1, 67, 2, 0, NULL, 0, '2024-07-09 20:24:30', '2024-07-10 09:46:39', '2024-07-10', 'P5000', '24-06667-07-09', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 482.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100724-C88XMYiw/TnGC-187', 'b0429913-e844-4649-898b-cfbb51b5d6e5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-C88XMYiw%2FTnGC-187&s=KOL2024&nf=P5000&i=482.79&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5337, 1, 160, 2, 0, NULL, 0, '2024-07-10 07:11:18', '2024-07-10 09:53:50', '2024-07-10', 'P4999', '24-06668-07-10', '', 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-07-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100724-dInKZQdNJOUNu-250', 'bab265df-2d0b-48bc-8f0f-163e59165831', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-dInKZQdNJOUNu-250&s=KOL2024&nf=P4999&i=103.46&cr=112', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5338, 1, 556, 2, 0, NULL, 0, '2024-07-10 07:54:20', '2024-07-10 09:58:39', '2024-07-10', 'P5001', '24-06669-07-10', '', 0.00, 65.14, 14.11, 0.00, 0, 0.00, 2.50, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 81.32, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-100724-Uw39kt0jDdLj1-119', '82e951b2-809d-4b25-9fcf-bb061495b843', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-Uw39kt0jDdLj1-119&s=KOL2024&nf=P5001&i=81.31&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5339, 1, 131, 2, 1, 'La clienta se confundió en el formato', 5325, '2024-07-10 10:35:15', '2024-07-10 10:35:15', '2024-07-10', 'R82', 'P4988 RECT.', '', 0.00, 89.54, 18.80, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 108.34, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-100724-Wvz+/75DJUHRd-249', 'b995ca21-aad7-40f4-a3bf-a30185e564a2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-Wvz%2B%2F75DJUHRd-249&s=KOL2024&nf=R82&i=-108.34&cr=122', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 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
(5340, 1, 1075, 1, 0, NULL, 0, '2024-07-10 10:45:07', '2024-07-10 10:45:18', '2024-07-10', 'P5002', '', '', 0.00, 348.37, 73.16, 0.00, 0, 0.00, 0.00, 'Calle General Egia, frente al 31', 'Bilbao', 'Bizkaia', '48013', 'España', 421.53, 0, '2024-07-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100724-c/u+63pF/BVC5-246', '5a8c544e-dfe8-440a-9f44-494d7722f559', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-c%2Fu%2B63pF%2FBVC5-246&s=KOL2024&nf=P5002&i=421.53&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5341, 1, 1075, 1, 1, 'equivocación en el precio del producto', 5340, '2024-07-10 10:46:29', '2024-07-10 10:50:23', '2024-07-10', 'R83', 'P5002 RECT.', '', 0.00, 348.37, 73.16, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 421.53, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-100724-kiyF+iPZgAX4W-028', '881c6914-966e-4a13-a4cc-65c32738bef1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-kiyF%2BiPZgAX4W-028&s=KOL2024&nf=R83&i=-421.53&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(5342, 1, 131, 1, 0, NULL, 0, '2024-07-10 10:49:22', '2024-07-10 10:49:22', '2024-07-10', 'P5003', '', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 379.34, 0, '2024-07-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100724-RjQaPQwn8ZXs/-002', 'ff54874e-4112-4e82-badb-36ffaae827ac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100724-RjQaPQwn8ZXs%2F-002&s=KOL2024&nf=P5003&i=379.34&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5343, 1, 1318, 2, 0, NULL, 0, '2024-07-10 13:07:52', '2024-07-11 09:12:08', '2024-07-11', 'P5004', '24-06670-07-10', 'Es una casa, tenemos perros, si no estamos por favor dejar el paquete en el buzón del correo o en el armario del contador de la luz.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer San Jaume 37', 'Sant Iscle de Vallal', 'Barcelona', '08359', 'España', 17.50, 0, '2024-07-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110724-FT2LBCjHaKI07-103', 'c8806ea5-4a5c-436b-97bb-e78e32e70a3b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110724-FT2LBCjHaKI07-103&s=KOL2024&nf=P5004&i=17.50&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5344, 1, 471, 2, 0, NULL, 0, '2024-07-10 15:50:06', '2024-07-11 09:16:32', '2024-07-11', 'P5005', '24-06671-07-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Siervas de Jesús nº 4, 2º D', 'Logroño', 'La Rioja', '26001', 'España', 30.61, 0, '2024-07-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110724-jZS9vWY6VkuFV-023', 'd6f0be2b-02e0-48f5-9645-34e1ac6be3d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110724-jZS9vWY6VkuFV-023&s=KOL2024&nf=P5005&i=30.61&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5345, 1, 1331, 2, 0, NULL, 0, '2024-07-10 22:11:30', '2024-07-11 09:19:01', '2024-07-11', 'P5006', '24-06672-07-10', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'TOMAS GROS Nº 3 - 6º IZQ', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 52.39, 0, '2024-07-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110724-jnlrwoR93F8bw-255', 'f9581de8-e901-4c3d-9753-56242e93f3df', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110724-jnlrwoR93F8bw-255&s=KOL2024&nf=P5006&i=52.39&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5346, 1, 190, 3, 0, NULL, 0, '2024-07-11 09:31:28', '2024-10-15 16:08:35', '2024-07-11', '', 'Consumo interno', '', 0.00, 1954.20, 410.38, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2364.58, 0, '2024-07-11 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);
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
(5347, 1, 149, 2, 0, NULL, 0, '2024-07-11 12:59:55', '2024-07-12 07:55:37', '2024-07-12', 'P5007', '24-06673-07-11', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 140.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-120724-XvZvENjmbty/e-103', '1beb100e-5273-4102-973a-c401302a150a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120724-XvZvENjmbty%2Fe-103&s=KOL2024&nf=P5007&i=140.44&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5348, 1, 167, 2, 0, NULL, 0, '2024-07-12 06:30:03', '2024-07-12 09:02:13', '2024-07-12', 'P5008', '24-06674-07-12', '', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 133.00, 0, '2024-07-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120724-IRr2wDR8MDYBt-012', '102eb550-d6db-4448-98fe-239896b68772', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120724-IRr2wDR8MDYBt-012&s=KOL2024&nf=P5008&i=133.00&cr=162', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5349, 1, 248, 2, 0, NULL, 0, '2024-07-12 08:00:31', '2024-07-12 10:21:59', '2024-07-12', 'P5009', '24-06675-07-12', 'Cerrado miércoles ', 0.00, 65.12, 13.68, 0.00, 0, 0.00, 0.00, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 78.80, 0, '2024-07-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120724-XlRye/xRncj0Q-250', 'd99e22fc-0671-4be7-a0fb-90c64b1d28b3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120724-XlRye%2FxRncj0Q-250&s=KOL2024&nf=P5009&i=78.80&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5350, 1, 1332, 2, 0, NULL, 0, '2024-07-12 08:20:47', '2024-07-12 10:23:48', '2024-07-12', 'P5010', '24-06676-07-12', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Juan XXIII, 7, 4A ', 'Barakaldo', 'Bizkaia', '48903', 'España', 30.61, 0, '2024-07-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120724-g93Y15Qi3Xo8l-160', '08107da0-65ee-43da-ac8b-88e55b002a1b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120724-g93Y15Qi3Xo8l-160&s=KOL2024&nf=P5010&i=30.61&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5351, 1, 106, 1, 0, NULL, 0, '2024-07-12 10:36:49', '2024-07-12 10:37:04', '2024-07-12', 'P5011', '', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Hipódromo 10 bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'ESPAÑA', 34.48, 0, '2024-07-12 00:00:00', '', '', 3, 6, 1, 'TBAI-B20930640-120724-NiTDANtOyO6Am-085', '4a9fc2f8-d154-498f-befc-63ab88adf7fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120724-NiTDANtOyO6Am-085&s=KOL2024&nf=P5011&i=34.47&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5352, 1, 696, 1, 0, NULL, 0, '2024-07-12 11:11:01', '2024-07-12 11:11:01', '2024-07-12', 'P5012', '', '', 0.00, 463.32, 97.30, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 560.62, 0, '2024-07-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120724-hJT1t2CEJyUfD-075', 'c419ba71-1723-407a-bc34-473c437dae02', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120724-hJT1t2CEJyUfD-075&s=KOL2024&nf=P5012&i=560.62&cr=079', '[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
(5353, 1, 979, 2, 0, NULL, 0, '2024-07-13 09:32:29', '2024-07-14 21:23:27', '2024-07-14', 'P5018', '24-06677-07-13', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'calle palma 58 local 1', 'Madrid', 'Madrid', '28015', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140724-YHZQdh2vRXdrD-041', 'bb6117a2-3153-49b5-9a88-e6decd500e40', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140724-YHZQdh2vRXdrD-041&s=KOL2024&nf=P5018&i=206.91&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5354, 1, 87, 2, 0, NULL, 0, '2024-07-13 12:14:12', '2024-07-14 21:29:47', '2024-07-14', 'P5013', '24-06678-07-13', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Cc arcco local p 17', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 103.46, 0, '2024-07-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140724-kTkRAdui75Bot-120', '6e2cdb4a-40c9-4f64-ae82-763942245a51', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140724-kTkRAdui75Bot-120&s=KOL2024&nf=P5013&i=103.46&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5355, 1, 226, 2, 0, NULL, 0, '2024-07-14 09:32:10', '2024-07-14 21:35:06', '2024-07-14', 'P5014', '24-06679-07-14', 'lunes no entregar,esta cerrado', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'CALLE LOGROÑO 5 BAJO', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 68.97, 0, '2024-07-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140724-G4JN8GHBc40u4-059', '83494fc5-0d9e-4f32-923f-8a0b194fada9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140724-G4JN8GHBc40u4-059&s=KOL2024&nf=P5014&i=68.97&cr=092', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5356, 1, 106, 2, 0, NULL, 0, '2024-07-14 13:56:16', '2024-07-14 21:41:28', '2024-07-14', 'P5015', '24-06680-07-14', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'Hipodromo 10bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 147.79, 0, '2024-07-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140724-MlawY5cCkd85L-098', 'a57ec7fa-92d0-41b6-bbc2-4a8df19d5a3d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140724-MlawY5cCkd85L-098&s=KOL2024&nf=P5015&i=147.79&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5357, 1, 630, 2, 0, NULL, 0, '2024-07-14 17:00:53', '2024-07-14 21:45:48', '2024-07-14', 'P5016', '24-06682-07-14', 'VIAJES AZULMARINO', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'AVENIDA DE NAVARRA 9', 'Beasain', 'Gipuzkoa', '20200', 'España', 52.39, 0, '2024-07-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140724-CuaILyI2MBBqL-192', '4219e634-2327-4ecd-871c-43f2366a395c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140724-CuaILyI2MBBqL-192&s=KOL2024&nf=P5016&i=52.39&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5358, 1, 754, 2, 0, NULL, 0, '2024-07-14 19:05:11', '2024-07-14 21:49:12', '2024-07-14', 'P5017', '24-06683-07-14', '6+1 Regalo precolor dorado', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2*1*', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-07-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140724-c4v7y3ckeI8rO-182', '1abe0bce-d696-4bb0-80cf-c8ad6e084817', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140724-c4v7y3ckeI8rO-182&s=KOL2024&nf=P5017&i=61.64&cr=167', '[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
(5359, 1, 1280, 2, 0, NULL, 0, '2024-07-14 19:31:11', '2024-07-14 21:51:21', '2024-07-14', 'P5019', '24-06684-07-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer de Joan Alsina, 27 bxs 2a', 'Girona', 'Girona', '17003', 'España', 17.50, 0, '2024-07-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140724-M7kGc2wQWb9kv-146', '4021dd10-a6e2-4e29-bb96-9d6244fb0ad1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140724-M7kGc2wQWb9kv-146&s=KOL2024&nf=P5019&i=17.50&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5360, 1, 121, 2, 0, NULL, 0, '2024-07-15 07:36:38', '2024-07-15 10:01:27', '2024-07-15', 'P5020', '24-06687-07-15', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 103.46, 0, '2024-07-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-150724-OlUIrsvAVChCL-202', '11b27e7b-ec93-4b6e-81f4-07dc3505db74', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150724-OlUIrsvAVChCL-202&s=KOL2024&nf=P5020&i=103.46&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5361, 1, 106, 1, 1, 'confusión al pedir el producto', 5351, '2024-07-15 09:56:50', '2024-07-15 09:56:50', '2024-07-15', 'R84', 'P5011 RECT.', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 34.48, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-150724-XUyZP8eEarfTN-190', 'abf9704f-e3d8-41be-a2e3-36f0115f5387', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150724-XUyZP8eEarfTN-190&s=KOL2024&nf=R84&i=-34.47&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(5362, 1, 420, 2, 0, NULL, 0, '2024-07-15 08:30:05', '2024-07-15 10:38:07', '2024-07-15', 'P5021', '24-06688-07-15', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Sabino Arana N 80. 4A', 'Leioa', 'Bizkaia', '48940', 'España', 78.63, 0, '2024-07-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150724-mxbeREE09paTJ-014', '2c2eedcc-185f-4c66-887a-2f23f4b673cc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150724-mxbeREE09paTJ-014&s=KOL2024&nf=P5021&i=78.63&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5363, 1, 1205, 2, 0, NULL, 0, '2024-07-15 12:03:39', '2024-07-15 14:11:23', '2024-07-15', 'P5022', '24-06689-07-15', '1er piso', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Rúa Número 2, 16', 'Moraña', 'Pontevedra', '36660', 'España', 17.50, 0, '2024-07-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150724-JegqQ2jVJBIjt-160', '26759047-424c-49ae-a0f2-7f554411472a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150724-JegqQ2jVJBIjt-160&s=KOL2024&nf=P5022&i=17.50&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5364, 1, 152, 1, 0, NULL, 0, '2024-07-16 09:07:40', '2024-07-16 09:32:30', '2024-07-16', 'P5023', '', '', 0.00, 175.89, 36.94, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 212.83, 0, '2024-07-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-160724-F8RcghtOVTiAT-177', '5aa703b6-f3d7-42e1-bba1-e9f9a8f3717a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160724-F8RcghtOVTiAT-177&s=KOL2024&nf=P5023&i=212.83&cr=199', '[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
(5365, 1, 111, 2, 0, NULL, 0, '2024-07-16 07:20:16', '2024-07-16 09:41:39', '2024-07-16', 'P5024', '24-06690-07-16', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'c/ Loza, nº1 piso 7b', 'Ansoáin', 'Navarra', '31013', 'España', 137.94, 0, '2024-07-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160724-G+DRujHB8BlSw-200', 'd50d47ed-f4f5-4401-8425-bcf153ebbc43', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160724-G%2BDRujHB8BlSw-200&s=KOL2024&nf=P5024&i=137.94&cr=154', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5366, 1, 3, 1, 0, NULL, 0, '2024-07-16 09:48:37', '2024-07-16 09:48:37', '2024-07-16', 'P5025', '', '', 0.00, 256.50, 53.86, 0.00, 0, 0.00, 0.00, 'C/ PINTOR AURELIO VIRAFAJARDO Nº2 B', 'VITORIA', 'ÁLAVA', '01008', 'España', 310.36, 0, '2024-07-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-160724-iYbFJctepqKig-227', '7702eabe-e127-4ea9-ac10-4c7303034365', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160724-iYbFJctepqKig-227&s=KOL2024&nf=P5025&i=310.36&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5367, 1, 174, 2, 0, NULL, 0, '2024-07-16 09:56:38', '2024-07-16 11:57:26', '2024-07-16', 'P5026', '24-06691-07-16', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 137.94, 0, '2024-07-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160724-kozYUMWmJuC+d-225', '3d31e933-d702-4ef0-b6c6-7d0227388b4f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160724-kozYUMWmJuC%2Bd-225&s=KOL2024&nf=P5026&i=137.94&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5368, 1, 10, 2, 0, NULL, 0, '2024-07-16 10:06:25', '2024-07-16 12:15:21', '2024-07-16', 'P5027', '24-06692-07-16', '', 0.00, 289.06, 60.70, 0.00, 0, 0.00, 0.00, 'Agirre auzunea 1 behea', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 349.76, 0, '2024-07-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160724-G4JWhQAEzXFLg-199', 'ddd974fb-8d7a-41c0-a67e-890b19bbf062', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160724-G4JWhQAEzXFLg-199&s=KOL2024&nf=P5027&i=349.76&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5369, 1, 127, 2, 0, NULL, 0, '2024-07-16 12:29:05', '2024-07-17 09:05:00', '2024-07-17', 'P5032', '24-06694-07-16', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-170724-e/dWjO6C5fsNn-207', 'cd74f6f2-c9ad-498b-97d8-3f973cc35c11', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-e%2FdWjO6C5fsNn-207&s=KOL2024&nf=P5032&i=105.96&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5370, 1, 50, 2, 0, NULL, 0, '2024-07-16 14:09:10', '2024-07-17 09:09:05', '2024-07-17', 'P5028', '24-06695-07-16', '', 0.00, 28.50, 6.74, 0.00, 0, 0.00, 4.40, 'CALLE ELTZETA 3, BAJO', 'LESAKA', 'NAVARRA', '31770', 'ESPAÑA', 38.88, 0, '2024-07-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170724-D9AiTn+SsbkG4-127', '5295083d-f6f4-468e-bd88-b3d71f6f1a9c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170724-D9AiTn%2BSsbkG4-127&s=KOL2024&nf=P5028&i=38.88&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
