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
(6478, 1, 57, 2, 0, NULL, 0, '2025-01-14 15:43:18', '2025-01-14 17:55:22', '2025-01-14', 'P6090', '25-07929-01-14', '', 0.00, 236.14, 49.59, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 285.73, 0, '2025-01-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140125-aR0h0UUZYyCp3-077', '9c2d5b1d-d440-4d28-b93b-17a6dba0803d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-aR0h0UUZYyCp3-077&s=KOL2025&nf=P6090&i=285.73&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6479, 1, 1212, 2, 0, NULL, 0, '2025-01-14 15:51:04', '2025-01-14 17:56:10', '2025-01-14', 'P6091', '25-07930-01-14', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Narkis Balentziaga 8 1A', 'Zestoa', 'Gipuzkoa', '20749', 'España', 28.39, 0, '2025-01-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140125-A2hBleWS/wZNd-038', '7ef40526-aa01-460f-b469-6ad1ab3e5349', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-A2hBleWS%2FwZNd-038&s=KOL2025&nf=P6091&i=28.39&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6480, 1, 190, 3, 0, NULL, 0, '2025-01-14 17:52:13', '2025-01-14 17:52:13', '2025-01-14', '', 'Consumo interno', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 103.46, 0, '2025-01-14 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6481, 1, 1614, 2, 0, NULL, 0, '2025-01-14 16:53:14', '2025-01-14 17:56:46', '2025-01-14', 'P6092', '25-07931-01-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Rebollar 43 Urb. La Esprilla 107', 'Camargo', 'Cantabria', '39608', 'España', 17.50, 0, '2025-01-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140125-fDbjj6VYifW3R-093', 'c386edac-5884-4bdb-ba4e-ca7c80e37c99', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-fDbjj6VYifW3R-093&s=KOL2025&nf=P6092&i=17.50&cr=054', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6482, 1, 1503, 2, 0, NULL, 0, '2025-01-14 17:19:16', '2025-01-15 08:21:43', '2025-01-15', 'P6096', '25-07932-01-14', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Alejandro de la Sota nº2 portal 4 Bajo B', 'Boadilla del Monte', 'Madrid', '28660', 'España', 30.61, 0, '2025-01-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150125-CI8LLRHe+BdR7-092', '6146d69b-0a1b-4a7f-a7ed-ad19017990eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150125-CI8LLRHe%2BBdR7-092&s=KOL2025&nf=P6096&i=30.61&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6483, 1, 1615, 2, 0, NULL, 0, '2025-01-14 18:49:19', '2025-01-15 08:22:04', '2025-01-15', 'P6094', '25-07934-01-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle San Buenaventura 10-1ºC', 'Madrid', 'Madrid', '28005', 'España', 17.50, 0, '2025-01-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150125-A2ozPNmN2PkRW-036', 'c056a67a-6f57-4231-9be7-9c47978af011', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150125-A2ozPNmN2PkRW-036&s=KOL2025&nf=P6094&i=17.50&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6484, 1, 222, 2, 0, NULL, 0, '2025-01-15 01:17:45', '2025-01-15 08:22:44', '2025-01-15', 'P6095', '25-07935-01-15', 'Si pudiera llegar antes del jueves por la mañana. Ha sido fallo mío de no haber hecho pedido la semana pasada. Disculpas y gracias. ', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Cartagena 296 ', 'Barcelona', 'Barcelona', '08025', 'España', 379.34, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150125-ZIBtx0LolxOrI-134', '16aca91b-15a7-44f4-8185-6d6c5b87a2b0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150125-ZIBtx0LolxOrI-134&s=KOL2025&nf=P6095&i=379.34&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6485, 1, 1513, 1, 0, NULL, 0, '2025-01-15 08:29:11', '2025-01-15 08:29:11', '2025-01-15', '', '', '', 0.00, 454.21, 95.38, 0.00, 1, 23.62, 0.00, 'Amanecer 14, A', 'Adra', 'Almería', '04770', 'España', 573.21, 0, '2025-01-15 00:00:00', '', '', 1, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0),
(6486, 1, 190, 1, 0, NULL, 0, '2025-01-15 08:31:24', '2025-01-15 08:31:24', '2025-01-15', '', '', '', 0.00, 407.14, 85.50, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 492.64, 0, '2025-01-15 00:00:00', '', '', 1, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0);
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
(6487, 1, 84, 1, 0, NULL, 0, '2025-01-15 08:37:37', '2025-01-28 18:05:23', '2025-01-28', 'P6202', '', '', 0.00, 407.14, 85.50, 0.00, 0, 0.00, 0.00, 'Calle Sagasta 5, entreplanta A', 'Pontevedra', 'Pontevedra', '36001', 'ESPAÑA', 492.64, 0, '2025-01-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280125-F4/UN0GJIaQ21-218', '4bcbb782-038f-4c4f-aed9-3f118ab74b1f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-F4%2FUN0GJIaQ21-218&s=KOL2025&nf=P6202&i=492.64&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6488, 1, 397, 2, 0, NULL, 0, '2025-01-15 09:26:55', '2025-01-15 10:35:56', '2025-01-15', 'P6097', '25-07936-01-15', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Alaberga 69. 1 izda.', 'Errenteria', 'Gipuzkoa', '20100', 'España', 56.82, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150125-WZ3IbPkHCKIk8-025', 'a66c3f24-604e-41d8-882d-c7bb30793734', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150125-WZ3IbPkHCKIk8-025&s=KOL2025&nf=P6097&i=56.82&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6489, 1, 77, 1, 0, NULL, 0, '2025-01-15 11:38:52', '2025-01-15 11:38:52', '2025-01-15', 'P6098', '', '', 0.00, 986.70, 207.21, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1193.91, 0, '2025-01-15 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150125-NMBB6xUoLKO2h-138', 'd99e4d05-4869-49d4-a609-0daf95c6bc81', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150125-NMBB6xUoLKO2h-138&s=KOL2025&nf=P6098&i=1193.91&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6490, 1, 1616, 2, 0, NULL, 0, '2025-01-15 12:28:23', '2025-01-15 14:04:20', '2025-01-15', 'P6099', '25-07940-01-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo de morlans 19 4c ', 'Donostia-San Sebasti', 'Gipuzkoa', '20009', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150125-Ru15LP/rCe9oX-197', 'b4ec01eb-5ebb-4b90-ba5d-706c69465603', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150125-Ru15LP%2FrCe9oX-197&s=KOL2025&nf=P6099&i=17.50&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6491, 1, 1617, 2, 0, NULL, 0, '2025-01-15 16:22:59', '2025-01-15 16:22:59', '2025-01-15', '', '25-07942-01-15', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'San Vicente Ferrer 11. 28004 Madrid', 'Madrid', 'Madrid', '28004', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6492, 1, 204, 2, 0, NULL, 0, '2025-01-15 16:38:13', '2025-01-16 09:08:30', '2025-01-16', 'P6100', '25-07943-01-15', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'nou 23 local 1', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 103.46, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160125-XPWwNyMdx+nhD-037', '512a88b8-84d1-4a6c-8b7d-4f4e4e862523', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-XPWwNyMdx%2BnhD-037&s=KOL2025&nf=P6100&i=103.46&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6493, 1, 164, 2, 0, NULL, 0, '2025-01-15 16:42:30', '2025-01-16 09:09:37', '2025-01-16', 'P6101', '25-07944-01-15', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 379.34, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160125-gSpFsJfx1yoqs-021', 'a0418462-162a-45e7-aa4f-c635fb3fb700', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-gSpFsJfx1yoqs-021&s=KOL2025&nf=P6101&i=379.34&cr=062', '[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
(6494, 1, 92, 2, 0, NULL, 0, '2025-01-15 16:53:19', '2025-01-16 09:10:21', '2025-01-16', 'P6102', '25-07945-01-15', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'euskal herria 4,bajo  ibarra guipuzkoa ', 'Ibarra', 'Gipuzkoa', '20400', 'España', 172.43, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160125-cnTOxYum65gVd-166', 'ae74933b-ae86-47ce-a67c-a7f910fb48c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-cnTOxYum65gVd-166&s=KOL2025&nf=P6102&i=172.43&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6495, 1, 1393, 2, 0, NULL, 0, '2025-01-15 17:27:26', '2025-01-16 09:10:51', '2025-01-16', 'P6103', '25-07946-01-15', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Urbialde 1, bajo, buzón Correos Ecomerce ', 'Beasain', 'Gipuzkoa', '20200', 'España', 43.71, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160125-P2oQ6uEsYq5F5-122', '080df21c-c1ec-485c-bb83-dd5b7000e644', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-P2oQ6uEsYq5F5-122&s=KOL2025&nf=P6103&i=43.71&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6496, 1, 1618, 2, 0, NULL, 0, '2025-01-15 17:50:14', '2025-01-16 09:11:27', '2025-01-16', 'P6104', '25-07947-01-15', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C. J.G. Lumbreras, 3-6D', 'Portugalete', 'Bizkaia', '48920', 'España', 65.52, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160125-KC943Wf0Eg50z-069', 'a821c9db-d742-40e8-b708-590d218daec6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-KC943Wf0Eg50z-069&s=KOL2025&nf=P6104&i=65.52&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6497, 1, 192, 2, 0, NULL, 0, '2025-01-15 18:48:25', '2025-01-16 09:12:04', '2025-01-16', 'P6105', '25-07948-01-15', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'plaza San Cristobal 3,bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 172.43, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160125-SktbdD7Zl5Jxo-005', '73dad7a5-3536-40be-ac7b-856f564967a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-SktbdD7Zl5Jxo-005&s=KOL2025&nf=P6105&i=172.43&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6498, 1, 1619, 2, 0, NULL, 0, '2025-01-15 20:26:06', '2025-01-16 09:12:41', '2025-01-16', 'P6106', '25-07949-01-15', 'Eroski city ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'San Juan 44, Bajo (Eroski city)', 'Alegia', 'Gipuzkoa', '20260', 'España', 30.61, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160125-Ql7NmyG+2dkMc-209', '30ff841b-ab0f-4f16-a387-e68b089bf8fb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-Ql7NmyG%2B2dkMc-209&s=KOL2025&nf=P6106&i=30.61&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6499, 1, 269, 2, 0, NULL, 0, '2025-01-15 21:47:24', '2025-01-16 09:13:07', '2025-01-16', 'P6107', '25-07950-01-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Atxutegi 2. 1.E', 'Erandio', 'Bizkaia', '48950', 'España', 17.50, 0, '2025-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160125-QigduQLIi8cI6-219', 'ff910a5f-0140-437b-9862-86eaa0858f02', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-QigduQLIi8cI6-219&s=KOL2025&nf=P6107&i=17.50&cr=221', '[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
(6500, 1, 1620, 2, 0, NULL, 0, '2025-01-16 08:57:02', '2025-01-16 10:35:43', '2025-01-16', 'P6108', '25-07951-01-16', 'Entregar a partir de las 18h', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'CR migdia, n. 22 3-1', 'Sant Joan de Vilator', 'Barcelona', '08250', 'España', 78.63, 0, '2025-01-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160125-DFK0EAKd/hyBr-234', '4a5a4686-7f64-4fe5-a59c-cc35c9a30ee7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-DFK0EAKd%2FhyBr-234&s=KOL2025&nf=P6108&i=78.63&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6501, 1, 671, 2, 0, NULL, 0, '2025-01-16 11:12:22', '2025-01-16 12:19:32', '2025-01-16', 'P6109', '25-07952-01-16', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Carrer Tossal del Coro, 9, Apartament', 'Manresa', 'Barcelona', '08243', 'España', 28.39, 0, '2025-01-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160125-LcSjaEFwbGdpm-229', 'ebc3d9ba-5e01-49cb-a3c6-8c4d47068866', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160125-LcSjaEFwbGdpm-229&s=KOL2025&nf=P6109&i=28.39&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6502, 1, 696, 1, 0, NULL, 0, '2025-01-16 13:22:28', '2025-01-22 10:21:42', '2025-01-22', 'P6146', '', '', 0.00, 2466.75, 518.02, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 2984.77, 0, '2025-01-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220125-bNRFsvCBTg/zl-077', '35c060ee-3c26-4735-9950-2e544821b908', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-bNRFsvCBTg%2Fzl-077&s=KOL2025&nf=P6146&i=2984.77&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6503, 1, 337, 2, 0, NULL, 0, '2025-01-16 17:50:51', '2025-01-17 09:22:23', '2025-01-17', 'P6111', '25-07953-01-16', '', 0.00, 56.98, 11.97, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaragoza', 'Zaragoza', '50014', 'España', 68.95, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170125-ZaXGgtBteex6Q-029', 'a7e9becb-cb92-4c47-8744-c187a614c2da', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170125-ZaXGgtBteex6Q-029&s=KOL2025&nf=P6111&i=68.95&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6504, 1, 1621, 2, 0, NULL, 0, '2025-01-16 18:42:19', '2025-01-17 09:24:27', '2025-01-17', 'P6110', '25-07954-01-16', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Suecia 18', 'Lebrija', 'Sevilla', '41740', 'España', 17.50, 0, '2025-01-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170125-ZwMXBB/W36Mz0-090', 'c6f3e644-c531-4ccb-b57e-c22d50283187', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170125-ZwMXBB%2FW36Mz0-090&s=KOL2025&nf=P6110&i=17.50&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6505, 1, 653, 2, 0, NULL, 0, '2025-01-17 10:15:18', '2025-01-17 11:25:47', '2025-01-17', 'P6112', '25-07956-01-17', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C. de Juan María Guelbenzu Kalea, 4 - 3.ezk', 'Pamplona/Iruña', 'Navarra', '31005', 'España', 28.39, 0, '2025-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170125-XtnEUkRDfCLUt-242', '0ffa3dd4-4ddb-40ca-bab2-498378c2e4f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170125-XtnEUkRDfCLUt-242&s=KOL2025&nf=P6112&i=28.39&cr=211', '[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
(6506, 1, 1622, 2, 0, NULL, 0, '2025-01-17 10:56:13', '2025-01-17 11:57:01', '2025-01-17', 'P6113', '25-07957-01-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Camino del velero 15', 'Chiclana de la Front', 'Cádiz', '11130', 'España', 17.50, 0, '2025-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170125-WUbzkobboY5fJ-008', '4b1ea77f-c841-471a-a2c9-29be1422172a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170125-WUbzkobboY5fJ-008&s=KOL2025&nf=P6113&i=17.50&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6507, 1, 28, 2, 0, NULL, 0, '2025-01-17 14:42:31', '2025-01-21 09:02:00', '2025-01-21', 'P6114', '25-07958-01-17', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 344.85, 0, '2025-01-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210125-FhyYpwPRLvH/R-112', '7d0c95ab-94ad-4a7f-a218-4bd4ad7fcc4b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-FhyYpwPRLvH%2FR-112&s=KOL2025&nf=P6114&i=344.85&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6508, 1, 1623, 2, 0, NULL, 0, '2025-01-17 16:21:52', '2025-01-21 09:04:24', '2025-01-21', 'P6115', '25-07959-01-17', 'En caso de no estar, meter en el buzón o dejar a un vecino. Gracias! ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Langilería 180 3ºE', 'Leioa', 'Bizkaia', '48940', 'España', 28.39, 0, '2025-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-aIj/N84mBkYJT-194', '458b7fa2-ac08-47e5-8684-36efc6a17103', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-aIj%2FN84mBkYJT-194&s=KOL2025&nf=P6115&i=28.39&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6509, 1, 220, 2, 0, NULL, 0, '2025-01-17 17:14:23', '2025-01-21 09:05:40', '2025-01-21', 'P6116', '25-07960-01-17', 'Lunes tarde cerrado', 0.00, 207.64, 43.60, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 251.24, 0, '2025-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-Shuu/MWXYGNvv-046', '80e3d2f1-4d59-46ef-99c2-d70e86975485', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-Shuu%2FMWXYGNvv-046&s=KOL2025&nf=P6116&i=251.24&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6510, 1, 1624, 2, 0, NULL, 0, '2025-01-17 21:12:43', '2025-01-21 09:07:53', '2025-01-21', 'P6117', '25-07961-01-17', 'Entregar en puerta C 203 y tomar foto de la entrega.', 0.00, 21.66, 10.31, 0.00, 0, 0.00, 33.20, '102E 122nd Ave Tampa Florida Apartamento C 203', 'Tampa', 'Florida', '33612', 'Estados Unidos', 59.41, 0, '2025-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-OfIKnjIOaJxHy-209', 'a53a0621-18d3-4146-b72d-b011b3797aa6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-OfIKnjIOaJxHy-209&s=KOL2025&nf=P6117&i=59.41&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6511, 1, 1625, 2, 0, NULL, 0, '2025-01-17 21:35:06', '2025-01-21 09:09:00', '2025-01-21', 'P6118', '25-07962-01-17', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Mendibil 26 bajo A', 'Leioa', 'Bizkaia', '48940', 'España', 30.61, 0, '2025-01-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210125-cMjCSceLfSuvm-007', '87274d8d-fbc8-4b5d-8edf-c14faf1f05ee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-cMjCSceLfSuvm-007&s=KOL2025&nf=P6118&i=30.61&cr=177', '[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
(6512, 1, 226, 2, 0, NULL, 0, '2025-01-17 22:25:39', '2025-01-21 09:10:38', '2025-01-21', 'P6119', '25-07963-01-17', 'no entregar lunes,esta cerrado', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'CALLE LOGROÑO 5 BAJO', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 103.46, 0, '2025-01-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-bYPX6IA8pdwEx-110', '078bc90c-767d-432e-bba9-1f83e3eb0979', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-bYPX6IA8pdwEx-110&s=KOL2025&nf=P6119&i=103.46&cr=110', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6513, 1, 991, 2, 0, NULL, 0, '2025-01-18 10:20:33', '2025-01-21 09:12:52', '2025-01-21', 'P6120', '25-07964-01-18', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/ Doctor Marañón 12', 'Almonte', 'Huelva', '21730', 'España', 137.94, 0, '2025-01-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-QtCgK3Nd6WRmP-011', 'b3cc5381-ad0a-4036-b4da-ea182bd1200e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-QtCgK3Nd6WRmP-011&s=KOL2025&nf=P6120&i=137.94&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6514, 1, 262, 2, 0, NULL, 0, '2025-01-18 12:47:38', '2025-01-21 09:22:37', '2025-01-21', 'P6121', '25-07965-01-18', '', 0.00, 150.62, 31.63, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 182.25, 0, '2025-01-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-atAQ/0jCCkB4m-077', '5e01cd7e-07e2-44a6-9538-a67fc62683ad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-atAQ%2F0jCCkB4m-077&s=KOL2025&nf=P6121&i=182.25&cr=229', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6515, 1, 1626, 2, 0, NULL, 0, '2025-01-18 20:13:34', '2025-01-21 09:26:05', '2025-01-21', 'P6122', '25-07967-01-18', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Doctor Domingo Artes 23, 2.1', 'Almería', 'Almería', '04009', 'España', 65.52, 0, '2025-01-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-IJs4PEiIkYFtd-061', '5b3d0f75-9e9d-4d08-8434-e68e3b25a08d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-IJs4PEiIkYFtd-061&s=KOL2025&nf=P6122&i=65.52&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6516, 1, 1627, 2, 0, NULL, 0, '2025-01-18 20:59:59', '2025-01-21 09:27:45', '2025-01-21', 'P6123', '25-07968-01-18', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ MATEO NUÑEZ, 1', 'Vera', 'Almería', '04620', 'España', 28.39, 0, '2025-01-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-Qx2HaeRuusuGi-150', '121eee33-a358-4445-9d13-2e7b7d39eeee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-Qx2HaeRuusuGi-150&s=KOL2025&nf=P6123&i=28.39&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6517, 1, 610, 2, 0, NULL, 0, '2025-01-19 11:34:45', '2025-01-21 09:29:32', '2025-01-21', 'P6124', '25-07969-01-19', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Ugasko Bidea 29, 3º', 'Bilbao', 'Bizkaia', '48014', 'España', 43.71, 0, '2025-01-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-e4WvJSt8b983O-197', '3166b007-73c4-44bf-8b91-492906ac7112', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-e4WvJSt8b983O-197&s=KOL2025&nf=P6124&i=43.71&cr=065', '[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
(6518, 1, 1628, 2, 0, NULL, 0, '2025-01-19 12:25:40', '2025-01-21 09:31:47', '2025-01-21', 'P6125', '25-07970-01-19', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'C/ San Francisco nº 20. 2º izquierda', 'San Lorenzo de El Es', 'Madrid', '28200', 'España', 56.82, 0, '2025-01-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-L4DaQeULqYRAn-032', '65c87cc9-bfa5-478a-90ba-8967966cd1d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-L4DaQeULqYRAn-032&s=KOL2025&nf=P6125&i=56.82&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6519, 1, 1629, 2, 0, NULL, 0, '2025-01-19 20:08:22', '2025-01-21 09:33:01', '2025-01-21', 'P6126', '25-07971-01-19', 'Lunes no es posible la entrega', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle martin mendia n7 bajo balmaseda', 'Balmaseda', 'Bizkaia', '48800', 'España', 28.39, 0, '2025-01-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210125-Rgb5b7wW8/ZHU-092', '5ee94e7c-100f-4501-ac1f-3b34dc1caf82', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-Rgb5b7wW8%2FZHU-092&s=KOL2025&nf=P6126&i=28.39&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6520, 1, 121, 2, 0, NULL, 0, '2025-01-20 05:08:10', '2025-01-21 09:41:38', '2025-01-21', 'P6127', '25-07972-01-20', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 310.37, 0, '2025-01-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210125-QSHUibQBW4cAA-181', '1c749a9b-41a6-45ec-9638-04d467c71cd1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-QSHUibQBW4cAA-181&s=KOL2025&nf=P6127&i=310.37&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6521, 1, 1413, 2, 0, NULL, 0, '2025-01-20 09:56:13', '2025-01-21 09:43:07', '2025-01-21', 'P6128', '25-07975-01-20', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'TOMAS ZUBIRIA E IBARRA Nº2 6ºB', 'Bilbao', 'Bizkaia', '49007', 'España', 28.39, 0, '2025-01-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210125-ZB+yrArcseOId-042', '6c6564ce-26ee-4f4c-9123-d12a2c342adf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-ZB%2ByrArcseOId-042&s=KOL2025&nf=P6128&i=28.39&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6522, 1, 1147, 2, 0, NULL, 0, '2025-01-20 11:14:37', '2025-01-21 09:44:36', '2025-01-21', 'P6129', '25-07976-01-20', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avenida Aragón 14, Primero C', 'Teruel', 'Teruel', '44002', 'España', 61.09, 0, '2025-01-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-eR39v3ViL1TOs-241', 'dcffb12a-d8d1-44f4-a960-124ffd6aad32', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-eR39v3ViL1TOs-241&s=KOL2025&nf=P6129&i=61.09&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6523, 1, 754, 2, 0, NULL, 0, '2025-01-20 11:31:24', '2025-01-21 09:45:46', '2025-01-21', 'P6130', '25-07977-01-20', '6+1 Gratis Regalo Precolor Ceniza', 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, '2025-01-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-UAus1hLTY+Cv6-075', '5e2eaa64-e2bc-42b5-9228-54d97138c57f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-UAus1hLTY%2BCv6-075&s=KOL2025&nf=P6130&i=61.64&cr=060', '[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
(6524, 1, 522, 2, 0, NULL, 0, '2025-01-20 14:37:05', '2025-01-21 09:46:58', '2025-01-21', 'P6131', '25-07978-01-20', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 206.91, 0, '2025-01-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-NjIBCpiRFju1j-148', 'd8876c2f-597a-4bf3-b903-8593d9816a68', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-NjIBCpiRFju1j-148&s=KOL2025&nf=P6131&i=206.91&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6525, 1, 4, 2, 0, NULL, 0, '2025-01-20 15:01:10', '2025-01-21 09:48:55', '2025-01-21', 'P6132', '25-07979-01-20', '', 0.00, 264.64, 55.57, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 320.21, 0, '2025-01-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-NzgZJJ9FVoqFk-194', '3559e7fa-bf20-4074-9f42-79cc5004cbc9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-NzgZJJ9FVoqFk-194&s=KOL2025&nf=P6132&i=320.20&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6526, 1, 1630, 2, 0, NULL, 0, '2025-01-20 18:26:52', '2025-01-21 09:50:35', '2025-01-21', 'P6133', '25-07980-01-20', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Pare Manyanet, 2 (Bar Drac)', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 17.50, 0, '2025-01-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-dJFT1vyyfbqTq-058', 'e4cd6004-0917-4100-a740-1008db681968', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-dJFT1vyyfbqTq-058&s=KOL2025&nf=P6133&i=17.50&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6527, 1, 1631, 2, 0, NULL, 0, '2025-01-20 19:57:33', '2025-01-21 09:51:06', '2025-01-21', 'P6134', '25-07981-01-20', 'Llamar antes de entregar el paquete', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Alemania 6, Portal 9, Bajo A', 'Meco', 'Madrid', '28880', 'España', 17.50, 0, '2025-01-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210125-J50pe0wdA6/ax-143', 'b7cfd4f0-bc7a-4394-8d3d-2a445889d09f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-J50pe0wdA6%2Fax-143&s=KOL2025&nf=P6134&i=17.50&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6528, 1, 1632, 2, 0, NULL, 0, '2025-01-21 07:48:28', '2025-01-21 09:51:55', '2025-01-21', 'P6135', '25-07982-01-21', 'LLAMAR ANTES AL TELEFONO 661964203', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/VIRGEN DE BEGOÑA 28', 'Bilbao', 'Bizkaia', '48006', 'España', 30.61, 0, '2025-01-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-MDuofxCHVmOmy-123', '512676a6-1a66-4974-a437-78dc458d49e9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-MDuofxCHVmOmy-123&s=KOL2025&nf=P6135&i=30.61&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6529, 1, 1033, 2, 0, NULL, 0, '2025-01-21 08:50:43', '2025-01-21 09:52:57', '2025-01-21', 'P6136', '25-07983-01-21', '', 0.00, 40.70, 9.31, 0.00, 0, 0.00, 4.40, 'Lersundi18 bajo', 'Deba', 'Gipuzkoa', '20820', 'España', 53.65, 0, '2025-01-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-Q+rS/4Jg4p7e1-134', 'fc7c8b2e-9ba1-4546-b870-4149f3d6fbdc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-Q%2BrS%2F4Jg4p7e1-134&s=KOL2025&nf=P6136&i=53.65&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6530, 1, 1617, 2, 0, NULL, 0, '2025-01-21 09:24:20', '2025-01-21 09:24:20', '2025-01-21', '', '25-07984-01-21', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'san vicente ferrer 1', 'Madrid', 'Madrid', '28004', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0);
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
(6531, 1, 76, 1, 0, NULL, 0, '2025-01-21 11:02:46', '2025-01-21 11:03:54', '2025-01-21', 'P6137', '', '', 0.00, 2247.96, 472.07, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 2720.03, 0, '2025-01-21 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210125-BWkmwNkaxdyDL-009', 'ef69e57e-d9a4-4ed6-9f39-a418d80e1e7b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-BWkmwNkaxdyDL-009&s=KOL2025&nf=P6137&i=2720.03&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6532, 1, 1222, 2, 0, NULL, 0, '2025-01-21 10:11:28', '2025-01-21 11:32:24', '2025-01-21', 'P6138', '25-07985-01-21', 'ENTREGAR POR LA MAÑANA POR FAVOR, CASA CON JARDÍN Y COCHERA', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'AVD DE LAS ALPUJARRAS 83', 'Dalías', 'Almería', '04750', 'España', 17.50, 0, '2025-01-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210125-D2wtm26kuUjXi-000', '31fb93ae-0e46-49ec-bb66-0ff546e0b647', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-D2wtm26kuUjXi-000&s=KOL2025&nf=P6138&i=17.50&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6533, 1, 23, 2, 0, NULL, 0, '2025-01-21 11:03:02', '2025-01-21 12:13:12', '2025-01-21', 'P6139', '25-07986-01-21', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 275.88, 0, '2025-01-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-EV5Xo/FLqwTTE-180', 'a87bac90-1c5b-4787-b9e4-c6e2f87976b4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-EV5Xo%2FFLqwTTE-180&s=KOL2025&nf=P6139&i=275.88&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6534, 1, 215, 2, 0, NULL, 0, '2025-01-21 11:58:05', '2025-01-21 13:01:59', '2025-01-21', 'P6140', '25-07987-01-21', '', 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, '2025-01-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210125-AwHdny/uVKoQX-143', 'b034ab0b-505a-4157-a734-b806b3f8fe53', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-AwHdny%2FuVKoQX-143&s=KOL2025&nf=P6140&i=275.88&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6535, 1, 979, 2, 0, NULL, 0, '2025-01-21 14:04:57', '2025-01-21 15:37:47', '2025-01-21', 'P6141', '25-07988-01-21', '', 0.00, 598.50, 125.69, 0.00, 0, 0.00, 0.00, 'Calle palma 58 local 1 (La Nueva Perfecta)', 'Madrid', 'Madrid', '28015', 'España', 724.19, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210125-KWSyrNsDc5Ead-123', '478b3c37-96a4-44a6-8479-c385fac23af2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210125-KWSyrNsDc5Ead-123&s=KOL2025&nf=P6141&i=724.19&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6536, 1, 1423, 2, 0, NULL, 0, '2025-01-21 15:16:58', '2025-01-22 08:46:26', '2025-01-22', 'P6145', '25-07989-01-21', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bo)', 'Bilbao', 'Bizkaia', '48013', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220125-bfemqcA5ZbBMb-226', 'e964ff4a-90a4-473f-a956-1a0d3151dd3f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-bfemqcA5ZbBMb-226&s=KOL2025&nf=P6145&i=413.82&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6537, 1, 1617, 2, 0, NULL, 0, '2025-01-21 15:37:48', '2025-01-21 15:37:48', '2025-01-21', '', '25-07990-01-21', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'san vicente ferrer 11', 'Madrid', 'Madrid', '28004', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0);
