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
(4640, 1, 438, 2, 0, NULL, 0, '2024-02-22 21:57:54', '2024-02-23 09:37:19', '2024-02-22', 'P4339', '24-05914-02-22', 'Ofizinak 3.pisuan\r\nAstel-osteg: 8.00-16.30\r\nOstir.: 8.00-13.30', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'CIE LEGAZPI S.A. (ofizinak) Urola kalea 10', 'Legazpi', 'Gipuzkoa', '20230', 'España', 30.61, 0, '2024-02-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220224-SjOQnJynVuuQ3-144', '8a36b96c-d4ea-4a1b-b4cb-d62c15ec5026', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220224-SjOQnJynVuuQ3-144&s=KOL2024&nf=P4339&i=30.61&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4641, 1, 1054, 1, 0, NULL, 0, '2024-02-23 10:19:11', '2024-02-23 10:20:59', '2024-02-23', 'P4342', '2024-02-23', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Ibaiondo 10', 'Orio', 'Gipuzkoa', '20810', 'España', 34.48, 0, '2024-02-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230224-RyXQaWjkOqFVq-097', 'b6057f22-e292-4465-8e34-9a8bbf3103eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230224-RyXQaWjkOqFVq-097&s=KOL2024&nf=P4342&i=34.47&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4642, 1, 239, 1, 0, NULL, 0, '2024-02-23 10:43:51', '2024-02-23 10:44:03', '2024-02-23', 'P4343', '2024-02-23', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'San Marcial 37', 'Donostia', 'Gipuzkoa', '20005', 'España', 68.97, 0, '2024-02-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230224-Tc+m/G2TWI50y-092', 'de12991c-8edf-4ed0-8c13-81a90a0ff77b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230224-Tc%2Bm%2FG2TWI50y-092&s=KOL2024&nf=P4343&i=68.97&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4643, 1, 908, 2, 0, NULL, 0, '2024-02-23 12:49:20', '2024-02-26 09:35:26', '2024-02-23', 'P4344', '24-05915-02-23', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida Sant Jordi 18', 'Sitges', 'Barcelona', '08870', 'España', 30.61, 0, '2024-02-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230224-Y3sO5gt+lgjDd-199', 'd8b6471d-a636-4c06-8153-60a0f8812a61', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230224-Y3sO5gt%2BlgjDd-199&s=KOL2024&nf=P4344&i=30.61&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4644, 1, 120, 2, 0, NULL, 0, '2024-02-23 17:02:02', '2024-02-26 09:36:00', '2024-02-23', 'P4345', '24-05920-02-23', '', 0.00, 248.34, 52.15, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 300.49, 0, '2024-02-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230224-MNKc13TeTH74u-178', '3ba2723f-d1ae-4794-9765-8e0808b97e49', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230224-MNKc13TeTH74u-178&s=KOL2024&nf=P4345&i=300.49&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4645, 1, 425, 2, 0, NULL, 0, '2024-02-24 15:00:01', '2024-02-26 09:36:14', '2024-02-24', 'P4346', '24-05922-02-24', 'Preferiblemente por la tarde', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Calle Concejo de Elorz, 4 bajo B', 'Noáin (Valle de Elor', 'Navarra', '31110', 'España', 71.98, 0, '2024-02-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240224-hGZdM021HGW4X-231', '3e3bdeb1-6ba4-4946-9045-c09475a642a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240224-hGZdM021HGW4X-231&s=KOL2024&nf=P4346&i=71.98&cr=159', '[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
(4646, 1, 1013, 2, 0, NULL, 0, '2024-02-25 09:52:32', '2024-02-26 09:36:30', '2024-02-25', 'P4347', '24-05924-02-25', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Avda Monasterio de silos 38 B 1A', 'Madrid', 'Madrid', '28049', 'España', 43.71, 0, '2024-02-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250224-nTupeZu6xmj3j-065', '93bdfd4f-6cde-475f-ac42-996170bf0b7c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250224-nTupeZu6xmj3j-065&s=KOL2024&nf=P4347&i=43.71&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4647, 1, 1184, 2, 0, NULL, 0, '2024-02-25 18:37:20', '2024-02-26 09:36:48', '2024-02-25', 'P4351', '24-05926-02-25', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Crta. Ant. De Málaga 115, Almudena ', 'Granada', 'Granada', '18015', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-250224-Mne3lfIsDdE1O-073', '5af3a1b9-93c6-4890-9ffa-dc165e143d19', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250224-Mne3lfIsDdE1O-073&s=KOL2024&nf=P4351&i=33.11&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4648, 1, 1185, 2, 0, NULL, 0, '2024-02-25 18:40:48', '2024-02-26 09:36:59', '2024-02-25', 'P4348', '24-05925-02-25', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Zubiondo 10 4ºC', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 56.82, 0, '2024-02-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250224-UbvXsONFDFNy0-105', 'd0697fdb-6c5f-4d0d-8224-39fb0a356df9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250224-UbvXsONFDFNy0-105&s=KOL2024&nf=P4348&i=56.82&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4649, 1, 462, 2, 0, NULL, 0, '2024-02-25 19:16:00', '2024-02-26 09:37:11', '2024-02-25', 'P4349', '24-05927-02-25', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Santa María 12', 'Font-rubí', 'Barcelona', '08736', 'España', 65.52, 0, '2024-02-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250224-h1dWCBIsThK49-078', '6d7af6c2-61fe-4a01-b479-cee7ff5e3a65', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250224-h1dWCBIsThK49-078&s=KOL2024&nf=P4349&i=65.52&cr=123', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4650, 1, 1186, 2, 0, NULL, 0, '2024-02-25 21:36:16', '2024-02-26 09:37:25', '2024-02-25', 'P4350', '24-05928-02-25', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'fernandez alarcon 44', 'Málaga', 'Málaga', '29007', 'España', 43.71, 0, '2024-02-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250224-NMz53e+Isj2Oi-128', '2b57b9ea-fad0-48c9-b406-48e6abca8cc1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250224-NMz53e%2BIsj2Oi-128&s=KOL2024&nf=P4350&i=43.71&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4651, 1, 166, 1, 0, NULL, 0, '2024-02-26 10:16:39', '2024-02-26 10:17:38', '2024-02-26', 'P4352', '2024-02-26', '', 0.00, 265.98, 55.86, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 321.84, 0, '2024-02-26 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260224-atyyYIHGELBsF-221', '069ddce0-f667-4acb-abe5-ce86fd617a9f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260224-atyyYIHGELBsF-221&s=KOL2024&nf=P4352&i=321.83&cr=193', '[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
(4652, 1, 956, 2, 0, NULL, 0, '2024-02-26 09:51:56', '2024-02-26 11:12:16', '2024-02-26', 'P4353', '24-05929-02-26', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1 bajo ', 'Vigo', 'Pontevedra', '36204', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260224-KfLX+0sxXPAJN-200', 'e4709037-baa8-4672-9529-69aef2de1027', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260224-KfLX%2B0sxXPAJN-200&s=KOL2024&nf=P4353&i=172.43&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4653, 1, 121, 2, 0, NULL, 0, '2024-02-26 10:16:20', '2024-02-26 11:42:29', '2024-02-26', 'P4354', '24-05930-02-26', '', 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, '2024-02-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260224-RaFYVq86bHq3X-130', 'd946168b-69df-4e33-bffb-fa7171c18df9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260224-RaFYVq86bHq3X-130&s=KOL2024&nf=P4354&i=310.37&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4654, 1, 1045, 2, 0, NULL, 0, '2024-02-26 16:52:51', '2024-02-27 10:36:41', '2024-02-27', 'P4355', '2024-02-27', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Monasterio del paular 16 bajo F', 'Valladolid', 'Valladolid', '47015', 'España', 43.71, 0, '2024-02-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270224-VS8l6dDUsQKDJ-222', 'a4308856-4216-4dd8-b7e4-42bc5c56789d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270224-VS8l6dDUsQKDJ-222&s=KOL2024&nf=P4355&i=43.71&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4655, 1, 1037, 2, 0, NULL, 0, '2024-02-26 20:33:59', '2024-02-27 10:37:37', '2024-02-27', 'P4356', '2024-02-27', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Av/ Nuestra Señora de la Asunción,  Número 4. 1-1ª', 'Bellvei', 'Tarragona', '43719', 'España', 17.50, 0, '2024-02-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270224-NPQdSACS24CSj-233', '12d8a4c1-791f-4a25-b607-81300390c0ee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270224-NPQdSACS24CSj-233&s=KOL2024&nf=P4356&i=17.50&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4656, 1, 1187, 2, 0, NULL, 0, '2024-02-27 07:23:36', '2024-02-27 10:33:10', '2024-02-27', 'P4357', '24-05933-02-27', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Estación de oroso 27', 'Oroso', 'A Coruña', '15688', 'España', 17.50, 0, '2024-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270224-UjGfWsJ5jXkju-122', '87c8a7ff-1e7d-4cb5-9951-866f224e3d63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270224-UjGfWsJ5jXkju-122&s=KOL2024&nf=P4357&i=17.50&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4657, 1, 367, 2, 0, NULL, 0, '2024-02-27 09:15:13', '2024-02-27 10:34:10', '2024-02-27', 'P4358', '24-05934-02-27', 'Urbanización Mas Nou, detrás del Mercadona a la entrada de Empuriabrava.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Arenal 7, 17486 Castelló d´Empúries, Girona', 'Castelló d\'Empúries', 'Girona', '17486', 'España', 17.50, 0, '2024-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270224-CLisp4c/U/SWu-053', '15c2ee08-c7e8-49a4-b5d5-8cca9600d109', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270224-CLisp4c%2FU%2FSWu-053&s=KOL2024&nf=P4358&i=17.50&cr=026', '[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
(4658, 1, 23, 2, 0, NULL, 0, '2024-02-27 09:31:11', '2024-02-27 10:35:40', '2024-02-27', 'P4359', '24-05935-02-27', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 172.43, 0, '2024-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270224-ke1MyyJmdbMkD-027', '291487da-340f-4ae6-b4ee-efe062ec0917', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270224-ke1MyyJmdbMkD-027&s=KOL2024&nf=P4359&i=172.43&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4659, 1, 306, 2, 0, NULL, 0, '2024-02-27 12:02:49', '2024-02-27 13:03:31', '2024-02-27', 'P4360', '24-05936-02-27', 'de lunes a viernes de 9:00h a 18:30 h sabados de 8:30 a 13:30 h', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'carrer puigmolto n9 local comercial', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 275.88, 0, '2024-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270224-kEngs8l5Ady/o-204', '6821a553-bdea-4e9d-b859-28e63e23866b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270224-kEngs8l5Ady%2Fo-204&s=KOL2024&nf=P4360&i=275.88&cr=252', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4660, 1, 391, 2, 0, NULL, 0, '2024-02-27 12:30:25', '2024-02-27 13:31:16', '2024-02-27', 'P4361', '24-05937-02-27', 'Cambio de Peluquería:\r\nMi cabello & Moi \r\nPaseo Santxiki núm 14\r\n31192 Mutilva alta ', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Paseo Santxiki num14', 'Pamplona/Iruña', 'Navarra', '31192', 'España', 123.15, 0, '2024-02-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270224-DZcKKNsPEfRyx-145', 'a1583905-0ac1-4d04-911a-f7e14cc8cb1f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270224-DZcKKNsPEfRyx-145&s=KOL2024&nf=P4361&i=123.15&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4661, 1, 391, 2, 1, 'falta un lote de producto', 4660, '2024-02-27 13:31:56', '2024-02-27 13:31:56', '2024-02-27', 'R72', 'P4361 RECT.', 'Cambio de Peluquería:\r\nMi cabello & Moi \r\nPaseo Santxiki núm 14\r\n31192 Mutilva alta ', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 123.15, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-270224-bMapZWizJW8i0-082', 'd1c660c4-d8a7-40ae-a3e0-38ea41a12f96', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270224-bMapZWizJW8i0-082&s=KOL2024&nf=R72&i=-123.15&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4662, 1, 391, 1, 0, NULL, 0, '2024-02-27 13:33:40', '2024-02-27 13:33:40', '2024-02-27', 'P4362', '2024-02-27', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'DIVINA PASTORA 13, BAJO', 'ANSOAIN', 'Navarra', '31013', 'España', 123.15, 0, '2024-02-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270224-Xv/IGbyi+EN1n-166', '0461a41a-463d-438b-806c-0fab20004190', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270224-Xv%2FIGbyi%2BEN1n-166&s=KOL2024&nf=P4362&i=123.15&cr=087', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4663, 1, 896, 1, 0, NULL, 0, '2024-02-27 15:30:58', '2024-02-28 09:02:22', '2024-02-28', 'P4363', '2024-02-28', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Marrutxipi 24', 'Donostia-San Sebasti', 'Gipuzkoa', '20013', 'España', 68.97, 0, '2024-02-27 00:00:00', '', '', 3, 6, 1, 'TBAI-B20930640-280224-LIRI1yX6bAOIU-001', 'e913700a-6ffa-4f45-8f0a-9fe99d214c45', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280224-LIRI1yX6bAOIU-001&s=KOL2024&nf=P4363&i=68.97&cr=243', '[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
(4664, 1, 92, 2, 0, NULL, 0, '2024-02-27 16:41:19', '2024-02-28 09:17:32', '2024-02-28', 'P4364', '24-05938-02-28', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'euskal herria 4,bajo  ibarra guipuzkoa ', 'Ibarra', 'Gipuzkoa', '20400', 'España', 59.10, 0, '2024-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280224-QNL9/N3q135BA-121', '6bdcddf7-369e-4c11-93fa-34aab02b79d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280224-QNL9%2FN3q135BA-121&s=KOL2024&nf=P4364&i=59.10&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4665, 1, 1012, 2, 0, NULL, 0, '2024-02-27 23:48:47', '2024-02-28 09:18:18', '2024-02-28', 'P4365', '24-05939-02-28', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Josep de Peray, 17 bjs 1', 'Sant Cugat del Vallè', 'Barcelona', '08173', 'España', 17.50, 0, '2024-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280224-ifS/oBzjTVWfd-023', '25bb2201-fc12-4fc7-a89c-a287a8b271a5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280224-ifS%2FoBzjTVWfd-023&s=KOL2024&nf=P4365&i=17.50&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4666, 1, 28, 2, 0, NULL, 0, '2024-02-28 09:43:53', '2024-02-28 10:46:36', '2024-02-28', 'P4366', '24-05940-02-28', '', 0.00, 207.64, 43.60, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 251.24, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280224-ZX/YN8FN9hbwN-164', 'c27a613d-f9ab-4c08-83e1-6cd600989050', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280224-ZX%2FYN8FN9hbwN-164&s=KOL2024&nf=P4366&i=251.24&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4667, 1, 362, 2, 0, NULL, 0, '2024-02-28 18:03:39', '2024-02-29 09:55:50', '2024-02-29', 'P4367', '24-05941-02-29', 'Mediodías entrega ', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Doctor Jose zaldua n 10,3Bwaqq', 'Portugalete', 'Bizkaia', '48920', 'España', 43.71, 0, '2024-02-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-290224-b468nGfCb6q27-201', 'deeb1bdb-f1ac-463e-ae7e-c746ed2a0ae7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290224-b468nGfCb6q27-201&s=KOL2024&nf=P4367&i=43.71&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4668, 1, 1050, 2, 0, NULL, 0, '2024-02-28 20:38:05', '2024-02-29 09:56:05', '2024-02-29', 'P4368', '24-05942-02-29', '', 0.00, 57.00, 12.40, 0.00, 1, 3.07, 2.50, 'Carlos caamaño ,3', 'Madrid', 'Madrid', '28016', 'España', 74.54, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290224-laqDfq7VLATLX-141', '7531617e-4c26-4316-9d55-f3f990c4ab86', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290224-laqDfq7VLATLX-141&s=KOL2024&nf=P4368&i=74.54&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4669, 1, 794, 2, 0, NULL, 0, '2024-02-29 11:00:14', '2024-02-29 12:02:15', '2024-02-29', 'P4369', '24-05943-02-29', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Idoia 4 bajo', 'Zizur Mayor/Zizur Na', 'Navarra', '31180', 'España', 379.34, 0, '2024-02-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290224-CRf+nbYTcDsr3-246', 'c7fc0eb2-1049-4f0f-89d5-fdd118b07bb6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290224-CRf%2BnbYTcDsr3-246&s=KOL2024&nf=P4369&i=379.34&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4670, 1, 172, 2, 0, NULL, 0, '2024-02-29 11:09:58', '2024-02-29 12:12:31', '2024-02-29', 'P4370', '24-05944-02-29', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Soldevila, 6 baixos', 'Tremp', 'Lleida', '25620', 'España', 123.15, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290224-W8L06TmhiykLw-050', '68da16f5-ff1d-45c5-9f45-572bdf64187b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290224-W8L06TmhiykLw-050&s=KOL2024&nf=P4370&i=123.15&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4671, 1, 92, 2, 1, 'Se han confundido y han pedido formato pequeño en vez de grande', 4664, '2024-02-29 12:30:17', '2024-02-29 12:30:17', '2024-02-29', 'R73', 'P4364 RECT.', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 59.10, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-290224-LUVGathESRyub-178', 'fd7b54ef-5044-471a-8d3d-3ec7fbac02c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290224-LUVGathESRyub-178&s=KOL2024&nf=R73&i=-59.10&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4672, 1, 92, 1, 0, NULL, 0, '2024-02-29 12:32:33', '2024-02-29 12:32:33', '2024-02-29', 'P4371', '', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Euskal herria 4,bajo  ibarra guipuzkoa ', 'Ibarra', 'Gipuzkoa', '20400', 'España', 206.91, 0, '2024-02-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290224-o4vabwuvdYHTQ-134', '7d3525db-b740-400c-83b2-65cb9ff355a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290224-o4vabwuvdYHTQ-134&s=KOL2024&nf=P4371&i=206.91&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4673, 1, 110, 2, 0, NULL, 0, '2024-02-29 14:08:24', '2024-03-01 09:28:40', '2024-03-01', 'P4372', '24-05947-03-01', '', 0.00, 215.78, 45.31, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 261.09, 0, '2024-02-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-010324-XVWiyCE6S4WCi-007', '729dd43e-2be4-45e9-938c-8bcd0c47e0d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010324-XVWiyCE6S4WCi-007&s=KOL2024&nf=P4372&i=261.08&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4674, 1, 1050, 2, 0, NULL, 0, '2024-02-29 17:12:41', '2024-03-01 09:31:07', '2024-03-01', 'P4373', '24-05948-03-01', '', 0.00, 57.00, 12.40, 0.00, 1, 3.07, 2.50, 'Carlos caamaño,3', 'Madrid', 'Madrid', '28016', 'España', 74.54, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-010324-ifraTx8scpDGr-180', 'd4d8407f-3dca-4d10-bde5-774e4bd647dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010324-ifraTx8scpDGr-180&s=KOL2024&nf=P4373&i=74.54&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4675, 1, 1188, 2, 0, NULL, 0, '2024-03-01 09:02:06', '2024-03-01 10:07:07', '2024-03-01', 'P4374', '24-05949-03-01', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Baíñas, Calle C núm. 3 ', 'Vimianzo', 'A Coruña', '15127', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010324-J2Abi4MkSO58b-082', '3703f28b-e9dd-4236-9435-2c0827076023', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010324-J2Abi4MkSO58b-082&s=KOL2024&nf=P4374&i=196.56&cr=222', '[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
(4676, 1, 4, 2, 0, NULL, 0, '2024-03-01 09:11:14', '2024-03-01 10:43:50', '2024-03-01', 'P4375', '24-05950-03-01', '', 0.00, 301.28, 63.27, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 364.55, 0, '2024-03-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010324-hwj9UGoIS7DUy-016', '72a98731-8615-46b2-a7d3-8d29871a1d90', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010324-hwj9UGoIS7DUy-016&s=KOL2024&nf=P4375&i=364.55&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4677, 1, 1189, 2, 0, NULL, 0, '2024-03-01 09:54:03', '2024-03-01 11:19:05', '2024-03-01', 'P4376', '24-05952-03-01', 'Se puede entregar en Pasteleria Mila', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Fuente Suso 7', 'Ólvega', 'Soria', '42110', 'España', 30.61, 0, '2024-03-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010324-eoi55JFS1qCet-088', 'ba2730c3-b2f9-43d7-a7e4-f58e2c1e0cfb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010324-eoi55JFS1qCet-088&s=KOL2024&nf=P4376&i=30.61&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4678, 1, 474, 1, 0, NULL, 0, '2024-03-01 11:22:40', '2024-03-01 11:23:31', '2024-03-01', 'P4377', '2024-03-01', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'C Ntra Sra de los clarines 56', 'Beas', 'Huelva', '21630', 'España', 140.44, 0, '2024-03-01 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-010324-gmRvDwWYOy5Ba-088', 'fec80a08-7323-43ad-bb8a-c345840a4c05', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010324-gmRvDwWYOy5Ba-088&s=KOL2024&nf=P4377&i=140.44&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4679, 1, 870, 2, 0, NULL, 0, '2024-03-01 12:03:04', '2024-03-01 13:05:09', '2024-03-01', 'P4378', '24-05954-03-01', 'Se puede entregar en portería si no estamos en casa.', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle Fuente Carrantona 38C 4 izquierda ', 'Madrid', 'Madrid', '28030', 'España', 68.97, 0, '2024-03-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010324-GrntihY/PEvEb-189', 'b7b056b0-c467-4232-bdc6-cc42835c701c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010324-GrntihY%2FPEvEb-189&s=KOL2024&nf=P4378&i=68.97&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4680, 1, 1190, 2, 0, NULL, 0, '2024-03-01 16:48:27', '2024-03-04 09:43:49', '2024-03-04', 'P4379', '24-05955-03-04', 'lunes cerrado', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sagasti Auzoa N1 SM (PELUQUERIA COT)', 'Antzuola', 'Gipuzkoa', '20577', 'España', 28.39, 0, '2024-03-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040324-It8bc4ZviP+zk-024', '0ab07c21-4ed5-4b79-b112-986ef2f24f1d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040324-It8bc4ZviP%2Bzk-024&s=KOL2024&nf=P4379&i=28.39&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4681, 1, 337, 2, 0, NULL, 0, '2024-03-02 07:36:12', '2024-03-04 09:42:23', '2024-03-04', 'P4385', '24-05956-03-02', '', 0.00, 105.82, 22.22, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaida (La)', 'Zaragoza', '50014', 'España', 128.04, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040324-K+i5LKkIg/ioC-143', '4bd037cc-362b-448d-b95d-85f1b4bb9b3a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040324-K%2Bi5LKkIg%2FioC-143&s=KOL2024&nf=P4385&i=128.04&cr=077', '[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
(4682, 1, 1191, 2, 0, NULL, 0, '2024-03-02 10:35:11', '2024-03-04 09:42:34', '2024-03-04', 'P4380', '24-05958-03-02', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Juan XXIII n 1 quinto B ', 'Zaragoza', 'Zaragoza', '50010', 'España', 43.71, 0, '2024-03-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040324-mv9AmZLV65nQ0-022', '90bd2158-7fec-4ba9-b0f2-cfc4ed15cfda', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040324-mv9AmZLV65nQ0-022&s=KOL2024&nf=P4380&i=43.71&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4683, 1, 1039, 2, 0, NULL, 0, '2024-03-02 13:22:51', '2024-03-04 09:42:43', '2024-03-04', 'P4381', '24-05959-03-02', 'Ondategui', 0.00, 86.64, 18.20, 0.00, 0, 0.00, 0.00, 'Elizalde 19', 'Zigoitia', 'Álava', '01138', 'España', 104.83, 0, '2024-03-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040324-ONXT6NPavDwj8-064', '99c4503b-5474-42cf-a22d-24addfa310a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040324-ONXT6NPavDwj8-064&s=KOL2024&nf=P4381&i=104.83&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4684, 1, 1074, 2, 0, NULL, 0, '2024-03-02 21:25:40', '2024-03-04 09:42:51', '2024-03-04', 'P4382', '24-05960-03-02', 'No funciona interfono. Llamar al movil. Si no estamos se puede dejar en bar cafeteria Syngland en la esquina a Carmen. Gràcies.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Plaça dels Vents, 13, esc. 2, 2-1', 'Calonge', 'Girona', '17252', 'España', 28.39, 0, '2024-03-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040324-WgaR3kk9+Juti-097', '716be11e-d513-459b-80bc-d9f85318ec78', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040324-WgaR3kk9%2BJuti-097&s=KOL2024&nf=P4382&i=28.39&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4685, 1, 1192, 2, 0, NULL, 0, '2024-03-02 22:49:45', '2024-03-04 09:42:59', '2024-03-04', 'P4383', '24-05961-03-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Azoz 7, Arre', 'Ezcabarte', 'Navarra', '31194', 'España', 28.39, 0, '2024-03-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040324-A64Xp0zjEXT4F-147', '7b3d77ba-a833-4261-99f9-bff112fa2468', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040324-A64Xp0zjEXT4F-147&s=KOL2024&nf=P4383&i=28.39&cr=210', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4686, 1, 378, 2, 0, NULL, 0, '2024-03-03 19:54:31', '2024-03-04 09:43:09', '2024-03-04', 'P4384', '24-05963-03-03', 'Entregar de 9,00 a 13,00 o 16,30 a 19,30', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Elizgibela 1 Bajo', 'Burlada/Burlata', 'Navarra', '31600', 'España', 56.82, 0, '2024-03-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040324-DBCEBPfRbkt5I-055', '4ac8973c-7cf6-4e68-b933-e91b9337b3c9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040324-DBCEBPfRbkt5I-055&s=KOL2024&nf=P4384&i=56.82&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4687, 1, 522, 2, 0, NULL, 0, '2024-03-04 10:49:53', '2024-03-04 12:00:51', '2024-03-04', 'P4386', '24-05964-03-04', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 157.64, 0, '2024-03-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040324-KmXxkx745Bxl/-028', '67c38d63-79ed-4a61-9da3-b5670290d7c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040324-KmXxkx745Bxl%2F-028&s=KOL2024&nf=P4386&i=157.63&cr=043', '[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
(4688, 1, 97, 2, 0, NULL, 0, '2024-03-04 11:13:39', '2024-03-04 12:22:58', '2024-03-04', 'P4387', '24-05965-03-04', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Bidasoa 8, Bajo Bera', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 137.94, 0, '2024-03-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040324-hx7oKDsKAd5Kk-169', '2835a404-cdd5-4549-9245-6386e74d53be', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040324-hx7oKDsKAd5Kk-169&s=KOL2024&nf=P4387&i=137.94&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4689, 1, 677, 2, 0, NULL, 0, '2024-03-04 12:52:59', '2024-03-05 10:16:10', '2024-03-05', 'P4388', '24-05966-03-04', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'PORTAL DE BETOÑO 13', 'Vitoria-Gasteiz', 'Álava', '01013', 'España', 65.52, 0, '2024-03-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050324-d6ta9a9wfG1HL-082', '0a7ad3f2-cb46-41a7-b0d7-88d708165b67', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050324-d6ta9a9wfG1HL-082&s=KOL2024&nf=P4388&i=65.52&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4690, 1, 468, 2, 0, NULL, 0, '2024-03-04 15:00:24', '2024-03-05 10:16:38', '2024-03-05', 'P4392', '24-05967-03-04', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'Rof Carballo 1', 'Lugo', 'Lugo', '27002', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-050324-FrmKZrGUiW8cx-043', '1b900aac-aa89-479b-9ea0-9846471a4788', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050324-FrmKZrGUiW8cx-043&s=KOL2024&nf=P4392&i=105.96&cr=138', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4691, 1, 67, 2, 0, NULL, 0, '2024-03-04 15:27:01', '2024-03-05 10:19:05', '2024-03-05', 'P4393', '24-05968-03-04', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 344.85, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050324-IRFo7/K9QQ3es-017', '322fb7f6-6b55-4066-8aac-34dbbc4230e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050324-IRFo7%2FK9QQ3es-017&s=KOL2024&nf=P4393&i=344.85&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4692, 1, 139, 2, 0, NULL, 0, '2024-03-04 17:25:58', '2024-03-04 17:25:58', '2024-03-04', '', '24-05969-03-04', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Rúa Carlos Martínez Barbeito Moras, 6 BAJO IZQ', 'Coruña (A)', 'A Coruña', '15009', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4693, 1, 139, 2, 0, NULL, 0, '2024-03-04 17:36:03', '2024-03-05 10:17:31', '2024-03-05', 'P4389', '24-05970-03-04', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Rúa Carlos Martínez Barbeito Moras, 6 BAJO IZQ', 'Coruña (A)', 'A Coruña', '15009', 'España', 68.97, 0, '2024-03-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050324-g9ZfcUffPdqR4-197', '86712f65-20a5-466f-8cba-eb8d98904e49', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050324-g9ZfcUffPdqR4-197&s=KOL2024&nf=P4389&i=68.97&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4694, 1, 162, 2, 0, NULL, 0, '2024-03-05 08:59:23', '2024-03-05 10:18:03', '2024-03-05', 'P4390', '24-05973-03-05', 'Entregar en horario de mañana', 0.00, 175.06, 36.76, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 211.82, 0, '2024-03-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050324-JYujM3PeePLir-214', '6c1cd4a8-28d9-463a-94c0-b98a9fee86ce', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050324-JYujM3PeePLir-214&s=KOL2024&nf=P4390&i=211.82&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
