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
(5205, 1, 1014, 2, 0, NULL, 0, '2024-06-13 06:40:04', '2024-06-13 09:12:59', '2024-06-13', 'P4870', '24-06539-06-13', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Belorrieta 2, 2D', 'Aretxabaleta', 'Gipuzkoa', '20550', 'España', 41.50, 0, '2024-06-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130624-JhwmEQ4M493r1-079', '094d7c38-9fd3-4ec0-a985-a7a15768c7d4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130624-JhwmEQ4M493r1-079&s=KOL2024&nf=P4870&i=41.50&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5206, 1, 23, 2, 0, NULL, 0, '2024-06-13 07:15:21', '2024-06-13 10:43:57', '2024-06-13', 'P4871', '24-06540-06-13', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 241.40, 0, '2024-06-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130624-eFHGVeczHkBPQ-247', '7ca71971-afd2-472a-aef4-6af3cb0863e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130624-eFHGVeczHkBPQ-247&s=KOL2024&nf=P4871&i=241.40&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5207, 1, 190, 3, 0, NULL, 0, '2024-06-13 10:55:43', '2024-10-15 16:04:28', '2024-06-13', '', 'Consumo interno', '', 0.00, 1913.40, 401.81, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2315.21, 0, '2024-06-13 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),
(5208, 1, 1303, 2, 0, NULL, 0, '2024-06-13 09:38:31', '2024-06-13 11:54:41', '2024-06-13', 'P4873', '24-06541-06-13', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'Fernando el Católico 4 (local) ', 'Fuentes de Ebro', 'Zaragoza', '50740', 'España', 517.28, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130624-XhT1Y7lupoOql-088', '42242052-6e48-4857-8f50-4736b25323d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130624-XhT1Y7lupoOql-088&s=KOL2024&nf=P4873&i=517.28&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5209, 1, 244, 2, 0, NULL, 0, '2024-06-13 09:44:35', '2024-06-13 12:01:06', '2024-06-13', 'P4872', '24-06542-06-13', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Balmes 79-85 Local 3. Peluquería Maimar', 'Calella', 'Barcelona', '08370', 'España', 103.46, 0, '2024-06-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130624-oM/XdOWSRN1oM-163', 'c272edf9-20df-44db-bc74-95f4a40a195d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130624-oM%2FXdOWSRN1oM-163&s=KOL2024&nf=P4872&i=103.46&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5210, 1, 1070, 2, 0, NULL, 0, '2024-06-13 14:37:34', '2024-06-14 09:55:45', '2024-06-14', 'P4874', '24-06543-06-13', 'Preguntar por Maite Maiora Call Center', 0.00, 108.30, 22.74, 0.00, 0, 0.00, 0.00, 'Bernardo Ezenarro, 13. Ambulatorio Elgoibar', 'Elgoibar', 'Gipuzkoa', '20870', 'España', 131.04, 0, '2024-06-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140624-YWeko+kRdEOxT-000', '1cfcbe1a-dee3-46ba-b25b-4e4185ebfb49', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140624-YWeko%2BkRdEOxT-000&s=KOL2024&nf=P4874&i=131.04&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5211, 1, 1304, 2, 0, NULL, 0, '2024-06-13 14:51:17', '2024-06-14 10:05:55', '2024-06-14', 'P4875', '24-06544-06-13', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'bertsolari uztapide7', 'Irun', 'Gipuzkoa', '20304', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140624-o7lUqHmtITJD3-145', 'e485894f-a736-426e-87d0-c884ceb10171', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140624-o7lUqHmtITJD3-145&s=KOL2024&nf=P4875&i=17.50&cr=151', '[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
(5212, 1, 166, 1, 0, NULL, 0, '2024-06-14 11:11:57', '2024-06-14 11:11:57', '2024-06-14', 'P4876', '', '', 0.00, 167.31, 35.14, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 202.45, 0, '2024-06-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140624-jEYg+0CzFsG+2-248', '33c8b687-2360-4afc-9596-ca2eec92f068', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140624-jEYg%2B0CzFsG%2B2-248&s=KOL2024&nf=P4876&i=202.45&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5213, 1, 145, 2, 0, NULL, 0, '2024-06-14 17:00:14', '2024-06-17 09:32:55', '2024-06-17', 'P4883', '24-06545-06-14', '', 0.00, 228.00, 48.31, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 278.38, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-170624-ZZhQzkCLHXzSw-177', '389a9ba8-9c84-4e40-8c6a-3e91f76b8e3e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-ZZhQzkCLHXzSw-177&s=KOL2024&nf=P4883&i=278.38&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5214, 1, 477, 2, 0, NULL, 0, '2024-06-15 18:34:16', '2024-06-17 09:44:39', '2024-06-17', 'P4877', '24-06546-06-15', '', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'Pedro Elejalde 12, 4° izda', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 95.98, 0, '2024-06-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170624-FzDU5ry/LaG/V-093', '129346c6-4418-4537-9552-f12d31de91c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-FzDU5ry%2FLaG%2FV-093&s=KOL2024&nf=P4877&i=95.98&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5215, 1, 276, 2, 0, NULL, 0, '2024-06-16 07:25:07', '2024-06-17 09:54:15', '2024-06-17', 'P4878', '24-06548-06-16', 'Casa de campo. Llamar antes. ', 0.00, 21.66, 6.07, 0.00, 0, 0.00, 8.76, 'Son Toni Martinet', 'Ciutadella de Menorc', 'Baleares (Illes)', '07760', 'España', 34.97, 0, '2024-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170624-g7ZW1xv2ZjtH6-159', '355ca20d-b83c-4d55-842b-b3470252de11', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-g7ZW1xv2ZjtH6-159&s=KOL2024&nf=P4878&i=34.97&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5216, 1, 1201, 2, 0, NULL, 0, '2024-06-16 12:14:54', '2024-06-17 09:58:50', '2024-06-17', 'P4879', '24-06549-06-16', 'Clínica Veterinaria\r\nHorario de 10-14:00 y de 17-20:00 horas\r\n', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Plaza Bandas de música, 4', 'Valencia', 'Valencia', '46013', 'España', 17.50, 0, '2024-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170624-eI/vV83dZGgWt-162', '7104a1e2-fa81-4681-b6f0-511c75b04411', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-eI%2FvV83dZGgWt-162&s=KOL2024&nf=P4879&i=17.50&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5217, 1, 620, 2, 0, NULL, 0, '2024-06-16 14:26:40', '2024-06-17 10:06:42', '2024-06-17', 'P4880', '24-06550-06-16', 'por favor el pedido que llegue a partir de las 17 horas. gracias', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'plaza central nº1 es. iz. 3ºb', 'Tres Cantos', 'Madrid', '28760', 'España', 43.71, 0, '2024-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170624-HEw3ktOLrCUpO-031', 'edd36bc2-9456-4f28-9eb9-d1c852f405b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-HEw3ktOLrCUpO-031&s=KOL2024&nf=P4880&i=43.71&cr=074', '[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
(5218, 1, 1148, 2, 0, NULL, 0, '2024-06-16 14:36:32', '2024-06-17 10:11:11', '2024-06-17', 'P4881', '24-06551-06-16', 'En el portal nº 6 hay portero 24x7', 0.00, 75.81, 15.92, 0.00, 0, 0.00, 0.00, 'Travesía de Téllez 8, 1º T', 'Madrid', 'Madrid', '28007', 'España', 91.73, 0, '2024-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170624-UU7CoolrPIUmM-123', '96800785-a588-4749-a16b-2ed9f158f5ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-UU7CoolrPIUmM-123&s=KOL2024&nf=P4881&i=91.73&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5219, 1, 694, 2, 0, NULL, 0, '2024-06-16 15:57:42', '2024-06-17 10:15:20', '2024-06-17', 'P4882', '24-06552-06-16', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'DICES 33', 'Rois', 'A Coruña', '15911', 'España', 17.50, 0, '2024-06-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170624-PHHjFxL45NAC1-230', 'fb7d7bc4-232e-4aa9-8c30-e3de07a056a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-PHHjFxL45NAC1-230&s=KOL2024&nf=P4882&i=17.50&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5220, 1, 1011, 2, 0, NULL, 0, '2024-06-17 09:01:03', '2024-06-17 11:32:52', '2024-06-17', 'P4884', '24-06553-06-17', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'AVDA,CONDOMINA,70 ESC 9 6Q BLOQUE 4', 'Alicante/Alacant', 'Alicante', '03540', 'España', 137.94, 0, '2024-06-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170624-jo+vwQMYhWM5T-093', '68706956-c0e0-4500-b62a-29d68f4e3dcf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-jo%2BvwQMYhWM5T-093&s=KOL2024&nf=P4884&i=137.94&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5221, 1, 65, 2, 0, NULL, 0, '2024-06-17 10:32:51', '2024-07-17 13:18:59', '2024-06-17', 'P4886', '24-06554-06-17', '', 0.00, 769.50, 161.60, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 931.10, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170624-kbaOIX8UrFMhl-011', '23ecbf21-fb15-4d55-accd-a8250da6f7b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-kbaOIX8UrFMhl-011&s=KOL2024&nf=P4886&i=931.10&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5222, 1, 166, 1, 0, NULL, 0, '2024-06-17 12:37:14', '2024-06-17 12:37:14', '2024-06-17', '', '', '', 0.00, 25.74, 5.41, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 31.15, 0, '2024-06-17 00:00:00', '', '', 1, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(5223, 1, 166, 1, 0, NULL, 0, '2024-06-17 12:38:35', '2024-06-17 12:38:35', '2024-06-17', 'P4885', '2024-06-17', '', 0.00, 25.74, 5.41, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 31.15, 0, '2024-06-17 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170624-LPKcHR6pzDr/x-133', 'aafb5a66-a59f-4ef6-9614-4b683975eeac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170624-LPKcHR6pzDr%2Fx-133&s=KOL2024&nf=P4885&i=31.15&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5224, 1, 28, 2, 0, NULL, 0, '2024-06-17 13:20:00', '2024-06-18 09:24:13', '2024-06-18', 'P4889', '24-06555-06-17', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 275.88, 0, '2024-06-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180624-FBA8MRRHizJOo-137', 'c7c7f1fc-e2ed-4c3d-83d9-0c6b324e1ea9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180624-FBA8MRRHizJOo-137&s=KOL2024&nf=P4889&i=275.88&cr=239', '[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
(5225, 1, 522, 2, 0, NULL, 0, '2024-06-17 14:43:29', '2024-06-18 09:26:52', '2024-06-18', 'P4887', '24-06556-06-17', '', 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, '2024-06-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180624-mwTAzha2BiB/m-051', 'fb66810e-25dd-4b61-8439-adf7ab97969f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180624-mwTAzha2BiB%2Fm-051&s=KOL2024&nf=P4887&i=206.91&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5226, 1, 164, 2, 0, NULL, 0, '2024-06-17 18:21:30', '2024-06-18 09:29:17', '2024-06-18', 'P4888', '24-06557-06-17', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 137.94, 0, '2024-06-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180624-NLsy4epaH41Eo-014', 'f695d891-61ee-4be1-8349-fa5d3aa0743c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180624-NLsy4epaH41Eo-014&s=KOL2024&nf=P4888&i=137.94&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5227, 1, 765, 2, 0, NULL, 0, '2024-06-17 19:35:05', '2024-06-18 09:35:47', '2024-06-18', 'P4890', '24-06558-06-17', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180624-CLIslWbD4iyf9-231', 'b11bc84b-d457-436d-98b3-eee7ed5b3427', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180624-CLIslWbD4iyf9-231&s=KOL2024&nf=P4890&i=275.88&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5228, 1, 1305, 2, 0, NULL, 0, '2024-06-18 11:45:30', '2024-06-19 10:10:55', '2024-06-19', 'P4891', '24-06560-06-18', 'Llamar antes para acudir', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle de la Cruz Malpelo, 9', 'Arenas de San Pedro', 'Ávila', '05400', 'España', 65.52, 0, '2024-06-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190624-DUPmpQZOf0xWG-231', '1141d961-a6d0-416b-bc98-287d6c329a0c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-DUPmpQZOf0xWG-231&s=KOL2024&nf=P4891&i=65.52&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5229, 1, 870, 2, 0, NULL, 0, '2024-06-18 14:02:58', '2024-06-19 10:18:18', '2024-06-19', 'P4892', '24-06562-06-18', 'Puede entregarse en portería si no estamos ', 0.00, 138.42, 29.07, 0.00, 0, 0.00, 0.00, 'Calle Fuente Carrantona 38C 4 izquierda ', 'Madrid', 'Madrid', '28030', 'España', 167.49, 0, '2024-06-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190624-MbSzaHfXq+6FG-198', 'f1c75fb1-895b-4cb5-bfa8-c4933ffd78c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-MbSzaHfXq%2B6FG-198&s=KOL2024&nf=P4892&i=167.49&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5230, 1, 1008, 2, 0, NULL, 0, '2024-06-18 18:30:20', '2024-06-19 10:22:17', '2024-06-19', 'P4893', '24-06563-06-18', 'Entregar en portería si no estamos en casa.', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Candelario 2 esc. i 2A', 'Salamanca', 'Salamanca', '37007', 'España', 30.61, 0, '2024-06-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190624-O7aazqUjlYNsD-229', 'a3f5056d-5213-4c08-8325-8d247132a229', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-O7aazqUjlYNsD-229&s=KOL2024&nf=P4893&i=30.61&cr=070', '[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
(5231, 1, 1290, 2, 0, NULL, 0, '2024-06-18 19:07:55', '2024-06-19 10:25:57', '2024-06-19', 'P4894', '24-06564-06-18', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Alfonso Batallador 35, 1º izg', 'Sangüesa/Zangoza', 'Navarra', '31400', 'España', 30.61, 0, '2024-06-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190624-lwmno3Thev3gd-180', 'fb4990f3-fa77-42ef-a23a-b286de30afd6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-lwmno3Thev3gd-180&s=KOL2024&nf=P4894&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),
(5232, 1, 121, 2, 0, NULL, 0, '2024-06-19 06:43:51', '2024-06-19 10:31:13', '2024-06-19', 'P4895', '24-06565-06-19', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 172.43, 0, '2024-06-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190624-WpS5TZN3roTMe-214', 'f2baa8bf-f16d-42c1-a1a3-4f659cbf38e4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-WpS5TZN3roTMe-214&s=KOL2024&nf=P4895&i=172.43&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5233, 1, 687, 1, 0, NULL, 0, '2024-06-19 09:34:38', '2024-06-19 09:34:38', '2024-06-19', 'P4896', '2024-06-19', '', 0.00, 81.42, 17.10, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 98.52, 0, '2024-06-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190624-bAtobIHpuDX1J-073', 'deeda043-77cc-4f9c-95dd-93d948950719', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-bAtobIHpuDX1J-073&s=KOL2024&nf=P4896&i=98.52&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5234, 1, 7, 1, 0, NULL, 0, '2024-06-19 09:57:39', '2024-06-19 09:57:39', '2024-06-19', 'P4897', '2024-06-19', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 344.85, 0, '2024-06-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190624-XVD+lSkbm2B1J-024', '35925bdb-a6bf-4eed-9c8e-c2f2d6fdd95a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-XVD%2BlSkbm2B1J-024&s=KOL2024&nf=P4897&i=344.85&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5235, 1, 152, 1, 0, NULL, 0, '2024-06-19 10:03:40', '2024-06-19 10:03:40', '2024-06-19', 'P4898', '2024-06-19', '', 0.00, 55.77, 11.71, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 67.48, 0, '2024-06-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190624-oaWfxCrj8n33G-209', 'ecbd8e07-199f-4ea0-8d48-6c94ef0ecf7c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-oaWfxCrj8n33G-209&s=KOL2024&nf=P4898&i=67.48&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5236, 1, 1306, 2, 0, NULL, 0, '2024-06-19 09:00:35', '2024-06-19 11:24:45', '2024-06-19', 'P4900', '24-06566-06-19', '', 0.00, 59.49, 12.93, 0.00, 0, 0.00, 2.50, 'santa mónica 2, bajo', 'Teruel', 'Teruel', '44003', 'España', 74.48, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-190624-n3KkQSJ7MFgNP-135', '41c494e0-b919-42d0-85f4-9cd902e503d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-n3KkQSJ7MFgNP-135&s=KOL2024&nf=P4900&i=74.48&cr=200', '[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
(5237, 1, 98, 2, 0, NULL, 0, '2024-06-19 09:09:17', '2024-06-19 11:43:31', '2024-06-19', 'P4899', '24-06567-06-19', '', 0.00, 97.70, 20.52, 0.00, 0, 0.00, 0.00, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 118.22, 0, '2024-06-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190624-OZYde5VhbB/NQ-233', 'f6d67bbf-9b68-4509-a721-f9819d3b4851', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-OZYde5VhbB%2FNQ-233&s=KOL2024&nf=P4899&i=118.22&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5238, 1, 687, 1, 0, NULL, 0, '2024-06-19 11:45:31', '2024-06-19 11:46:28', '2024-06-19', 'P4901', '2024-06-19', '', 0.00, 8.14, 1.71, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 9.85, 0, '2024-06-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190624-bBp3rMaWOlaU8-045', 'c1a6e7ba-fb52-40da-8cf3-5e131cc69f9c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-bBp3rMaWOlaU8-045&s=KOL2024&nf=P4901&i=9.85&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5239, 1, 606, 2, 0, NULL, 0, '2024-06-19 10:56:23', '2024-06-19 13:00:18', '2024-06-19', 'P4902', '24-06569-06-19', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Bulevar de mariturri 14, 7b', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 30.61, 0, '2024-06-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190624-fAxNKYO+H7FJR-219', '46b2d443-9024-46fa-9556-7d0b75ac1749', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-fAxNKYO%2BH7FJR-219&s=KOL2024&nf=P4902&i=30.61&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5240, 1, 409, 2, 0, NULL, 0, '2024-06-19 11:11:25', '2024-06-19 13:12:01', '2024-06-19', 'P4903', '24-06570-06-19', 'Por favor dejar en buzón ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Av.  constitución 183,2.2', 'Castelldefels', 'Barcelona', '08860', 'España', 17.50, 0, '2024-06-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190624-OmjW9v3l1xvlN-127', '269d87c2-a1bb-4c6f-9643-386690509e0c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190624-OmjW9v3l1xvlN-127&s=KOL2024&nf=P4903&i=17.50&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5241, 1, 721, 2, 0, NULL, 0, '2024-06-19 20:03:53', '2024-06-20 09:22:35', '2024-06-20', 'P4904', '24-06571-06-19', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Aiotzategi 18 escalera derecha 4C, 4C escalera derecha', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 30.61, 0, '2024-06-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200624-QPNXxDO1cWPez-200', '4c63f25b-04a2-4999-9230-d6f10810042e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200624-QPNXxDO1cWPez-200&s=KOL2024&nf=P4904&i=30.61&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5242, 1, 28, 2, 0, NULL, 0, '2024-06-20 03:21:19', '2024-06-20 09:27:51', '2024-06-20', 'P4905', '24-06572-06-20', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 68.97, 0, '2024-06-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-200624-ZzQ5Ch7ldRK2G-247', '38fede5d-672a-4fab-b25e-fbebd7be2c3c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200624-ZzQ5Ch7ldRK2G-247&s=KOL2024&nf=P4905&i=68.97&cr=048', '[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
(5243, 1, 17, 2, 0, NULL, 0, '2024-06-20 06:45:59', '2024-06-20 09:28:42', '2024-06-20', 'P4906', '24-06573-06-20', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 137.94, 0, '2024-06-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200624-UQfwmmalDvpvN-198', '6f64708d-b742-427b-9876-dba504a47d40', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200624-UQfwmmalDvpvN-198&s=KOL2024&nf=P4906&i=137.94&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5244, 1, 347, 2, 0, NULL, 0, '2024-06-20 07:00:05', '2024-06-20 09:32:26', '2024-06-20', 'P4907', '24-06574-06-20', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/Coruña, 56 - 2ºizquierda', 'Vigo', 'Pontevedra', '36208', 'España', 43.71, 0, '2024-06-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200624-RwthbZt++77mo-044', '87dfd871-6386-4e1b-8726-3730db5d382d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200624-RwthbZt%2B%2B77mo-044&s=KOL2024&nf=P4907&i=43.71&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5245, 1, 152, 1, 0, NULL, 0, '2024-06-20 10:37:37', '2024-06-20 10:37:37', '2024-06-20', 'P4908', '2024-06-20', '', 0.00, 42.90, 9.01, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 51.91, 0, '2024-06-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200624-ZgxnlAbX+hbNH-007', 'd0dd7ef5-0506-4845-92c1-cdd85be0ff53', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200624-ZgxnlAbX%2BhbNH-007&s=KOL2024&nf=P4908&i=51.91&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5246, 1, 152, 1, 0, NULL, 0, '2024-06-20 11:20:08', '2024-06-20 11:20:08', '2024-06-20', 'P4909', '2024-06-20', '', 0.00, 17.16, 3.60, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 20.76, 0, '2024-06-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200624-LS8KDsxh0yUUY-139', '7f2bda29-3a7d-4e4a-99fb-7d50f12d6004', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200624-LS8KDsxh0yUUY-139&s=KOL2024&nf=P4909&i=20.76&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5247, 1, 696, 1, 0, NULL, 0, '2024-06-20 12:17:54', '2024-06-20 12:23:26', '2024-06-20', 'P4910', '2024-06-20', '', 0.00, 592.02, 124.32, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 716.34, 0, '2024-06-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200624-cklZo9PD5C9Sa-027', '66f5e560-ec48-4fae-bb0b-4f81a1913c58', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200624-cklZo9PD5C9Sa-027&s=KOL2024&nf=P4910&i=716.34&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5248, 1, 1307, 2, 0, NULL, 0, '2024-06-20 12:35:44', '2024-06-21 09:52:28', '2024-06-21', 'P4911', '24-06575-06-20', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Escriba Lubna, N°2, bloque 3, 4°F', 'Córdoba', 'Córdoba', '14005', 'España', 28.39, 0, '2024-06-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210624-lS8C5tYIZjGeU-205', '98b74f68-4127-4682-bfcd-52502902990c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210624-lS8C5tYIZjGeU-205&s=KOL2024&nf=P4911&i=28.39&cr=175', '[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
(5249, 1, 1181, 1, 0, NULL, 0, '2024-06-20 18:54:18', '2024-06-20 18:54:24', '2024-06-21', 'P4912', '2024-06-20', '', 0.00, 54.15, 13.69, 0.00, 0, 0.00, 13.35, '8 TOWN MEADOWS', 'Woolsery ', 'Bideford ', 'EX39 5TS', 'Reino Unido', 78.87, 0, '2024-06-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210624-X/9GfK6/yskFz-237', '8407caed-901b-4118-bb7a-2e37c8a8ef50', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210624-X%2F9GfK6%2FyskFz-237&s=KOL2024&nf=P4912&i=78.87&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5250, 1, 115, 2, 0, NULL, 0, '2024-06-20 17:32:02', '2024-06-21 09:56:44', '2024-06-21', 'P4913', '24-06577-06-20', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'MONASTERIO DE URDAX NR. 38', 'Pamplona/Iruña', 'Navarra', '31011', 'España', 517.28, 0, '2024-06-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210624-MDjnYVrfQLiwQ-190', '0da1ab99-158e-48e5-9014-f5fa91ebfc0d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210624-MDjnYVrfQLiwQ-190&s=KOL2024&nf=P4913&i=517.28&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5251, 1, 236, 2, 0, NULL, 0, '2024-06-21 17:59:11', '2024-06-24 09:34:16', '2024-06-24', 'P4914', '24-06580-06-21', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'AVDA. DE LA POLICÍA NACIONAL, EDF. DONI IVES, 24', 'Antequera', 'Málaga', '29200', 'España', 275.88, 0, '2024-06-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240624-jCdUtuP8M95h6-220', '45c85ea0-cea7-4a15-af81-a58bbd2cfc63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240624-jCdUtuP8M95h6-220&s=KOL2024&nf=P4914&i=275.88&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5252, 1, 252, 2, 0, NULL, 0, '2024-06-22 16:39:16', '2024-06-24 09:36:29', '2024-06-24', 'P4915', '24-06581-06-22', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Pl. Pedro Astigarraga N°2 6° PTA 613', 'Bilbao', 'Bizkaia', '48015', 'España', 43.71, 0, '2024-06-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240624-NnXfX5gHKwvY0-052', 'b3d6162e-bfbb-4a3d-9615-c64cdb32c00a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240624-NnXfX5gHKwvY0-052&s=KOL2024&nf=P4915&i=43.71&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5253, 1, 1103, 2, 0, NULL, 0, '2024-06-22 17:55:41', '2024-06-24 09:37:15', '2024-06-24', 'P4916', '24-06582-06-22', '', 0.00, 39.66, 13.11, 0.00, 0, 0.00, 27.57, '8/7 Heriot Place', 'Edimburgo ', 'Escocia ', 'EH39EX', 'Reino Unido', 75.56, 0, '2024-06-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240624-DUI84jsP/k8tQ-147', '052de459-5526-426c-bbe5-1f8db13eb4a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240624-DUI84jsP%2Fk8tQ-147&s=KOL2024&nf=P4916&i=75.56&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5254, 1, 788, 2, 0, NULL, 0, '2024-06-22 20:39:06', '2024-06-24 09:37:40', '2024-06-24', 'P4917', '24-06583-06-22', 'Si no hay nadie entregar al conserje', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida Séneca 26 4/2', 'San Sebastián de los', 'Madrid', '28703', 'España', 30.61, 0, '2024-06-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240624-bUdw2wrHS1Nr5-024', '2c1c5a39-af29-42a4-9dd5-5e1979f7950a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240624-bUdw2wrHS1Nr5-024&s=KOL2024&nf=P4917&i=30.61&cr=004', '[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
(5255, 1, 246, 2, 0, NULL, 0, '2024-06-24 08:44:39', '2024-06-24 11:12:22', '2024-06-24', 'P4918', '24-06584-06-24', 'Alberto Hidalgo atelier', 0.00, 32.56, 7.60, 0.00, 0, 0.00, 4.40, 'Iparraguirre 9bis', 'Bilbao', 'Bizkaia', '48009', 'España', 43.80, 0, '2024-06-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240624-NY7MCor0XEViw-180', '9482d3fe-a11d-44de-85ff-7025f64532c8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240624-NY7MCor0XEViw-180&s=KOL2024&nf=P4918&i=43.80&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5256, 1, 1309, 2, 0, NULL, 0, '2024-06-24 10:52:53', '2024-06-24 12:58:47', '2024-06-24', 'P4919', '24-06585-06-24', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Juan Carlos I, 2', 'Fuentes de León', 'Badajoz', '06280', 'España', 28.39, 0, '2024-06-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240624-aZEi2q6uAnRtj-096', 'f4c01b1e-2b0f-4a14-855c-932fe0c4a776', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240624-aZEi2q6uAnRtj-096&s=KOL2024&nf=P4919&i=28.39&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5257, 1, 137, 2, 0, NULL, 0, '2024-06-24 11:19:24', '2024-06-25 09:46:44', '2024-06-25', 'P4920', '24-06586-06-24', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Pº ERMITA, 10', 'Madrid', 'Madrid', '28023', 'España', 206.91, 0, '2024-06-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250624-cYLKTJv+ryvtS-253', '6ad0f26b-e1fe-4fd5-bafe-d5380d9ceb17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250624-cYLKTJv%2BryvtS-253&s=KOL2024&nf=P4920&i=206.91&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5258, 1, 1310, 2, 0, NULL, 0, '2024-06-24 11:42:48', '2024-06-25 09:49:49', '2024-06-25', 'P4921', '24-06587-06-24', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Eugenio Serrano 7, 1 a', 'Getafe', 'Madrid', '28904', 'España', 17.50, 0, '2024-06-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250624-I62UyoeBWZxv3-202', '8e564116-154e-4b3e-ac90-b3dd78f3ef77', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250624-I62UyoeBWZxv3-202&s=KOL2024&nf=P4921&i=17.50&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5259, 1, 1311, 1, 0, NULL, 0, '2024-06-24 16:59:33', '2024-06-25 09:29:49', '2024-06-25', 'P4922', '2024-06-24', '', 0.00, 197.79, 41.54, 0.00, 0, 0.00, 0.00, 'Emilio Arrieta 25', 'Pamplona', 'Navarra', '31002', 'España', 239.33, 0, '2024-06-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250624-kEeE6MW4xTH16-085', '8fe0dcbb-a77e-4485-9a66-a4ac287798f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250624-kEeE6MW4xTH16-085&s=KOL2024&nf=P4922&i=239.33&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5260, 1, 712, 2, 0, NULL, 0, '2024-06-24 19:38:34', '2024-06-25 09:52:30', '2024-06-25', 'P4923', '24-06588-06-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Río Cubas 7 5°izda/5°dcha', 'Santander', 'Cantabria', '39004', 'España', 30.61, 0, '2024-06-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250624-GWYvvmaZ+SE3I-232', 'b50fe754-ba0e-49ec-b066-e14c9da05b72', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250624-GWYvvmaZ%2BSE3I-232&s=KOL2024&nf=P4923&i=30.61&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
