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
(5536, 1, 1209, 1, 0, NULL, 0, '2024-08-13 09:58:44', '2024-08-13 10:02:59', '2024-08-13', 'P5189', '', '', 0.00, 21.66, 5.66, 0.00, 1, 1.40, 6.40, 'Calle Zaragoza, 12 C', 'Montesinos (Los)', 'Alicante', '03187', 'España', 34.01, 0, '2024-08-13 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130824-ZDOA9K4MvBQ8u-142', 'c0d79709-64e0-49ed-89b6-7592889ff002', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130824-ZDOA9K4MvBQ8u-142&s=KOL2024&nf=P5189&i=34.01&cr=045', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5537, 1, 33, 2, 1, 'Confusión en el formato del producto', 5512, '2024-08-13 11:15:27', '2024-08-13 11:15:27', '2024-08-13', 'R88', 'P5166 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-130824-cGjWYEMev7ZVD-101', '44eef712-03fa-426d-9d9a-724c98be5afb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130824-cGjWYEMev7ZVD-101&s=KOL2024&nf=R88&i=-59.10&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(5538, 1, 33, 1, 0, NULL, 0, '2024-08-13 11:17:05', '2024-08-13 11:17:05', '2024-08-13', 'P5190', '', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Calle Medio N 24 bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 206.91, 0, '2024-08-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130824-dekIj43sKJgrM-148', '7851d93c-8a8e-45d7-a242-8a4a30c0f60d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130824-dekIj43sKJgrM-148&s=KOL2024&nf=P5190&i=206.91&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5539, 1, 1011, 2, 0, NULL, 0, '2024-08-13 10:58:24', '2024-08-13 13:00:49', '2024-08-13', 'P5191', '24-06896-08-13', '', 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-08-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130824-PyWr6qZknsIlQ-028', '98e8f819-9843-458f-94d1-34e37fee81a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130824-PyWr6qZknsIlQ-028&s=KOL2024&nf=P5191&i=137.94&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5540, 1, 1370, 2, 0, NULL, 0, '2024-08-13 12:51:30', '2024-08-14 08:30:05', '2024-08-14', 'P5192', '24-06897-08-13', 'Llamar al 652259415 porque no va el timbre, es una cuesta llamar antes tambien para dar indicaciones de como llegar facilmente', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C veronica n 24', 'Sant Cugat del Vallè', 'Barcelona', '08196', 'España', 17.50, 0, '2024-08-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140824-VTLfEsEwZOmTm-132', 'd49dac56-c497-46b7-8fa7-47630aba088b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-VTLfEsEwZOmTm-132&s=KOL2024&nf=P5192&i=17.50&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5541, 1, 932, 2, 0, NULL, 0, '2024-08-13 13:05:57', '2024-08-14 08:33:31', '2024-08-14', 'P5197', '24-06898-08-13', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'Calle acera del pilar edificio residencial casa fuerte local 2 peluquería ', 'Almuñécar', 'Granada', '18697', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-140824-X2A8TCClfah8Q-134', '652d6dfd-0e47-4d0b-8282-7098b731a5f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-X2A8TCClfah8Q-134&s=KOL2024&nf=P5197&i=174.93&cr=188', '[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
(5542, 1, 991, 2, 0, NULL, 0, '2024-08-13 13:42:53', '2024-08-14 08:35:20', '2024-08-14', 'P5193', '24-06901-08-13', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'C/ Pedro Barrera Abreu 11', 'Almonte', 'Huelva', '21730', 'España', 103.46, 0, '2024-08-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140824-PnZuAjs3lx2HX-105', '1490747c-7d02-499d-abbd-ed7aa05b9aa6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-PnZuAjs3lx2HX-105&s=KOL2024&nf=P5193&i=103.46&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5543, 1, 754, 2, 0, NULL, 0, '2024-08-13 16:37:58', '2024-08-14 08:37:09', '2024-08-14', 'P5194', '24-06902-08-13', '6+1 gratis el color rubio extraclaro. Gracias', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-08-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140824-Y5cFQyS8teNig-077', 'a2a112ef-d9f3-4d45-9735-5890ad85b299', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-Y5cFQyS8teNig-077&s=KOL2024&nf=P5194&i=61.64&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5544, 1, 634, 2, 0, NULL, 0, '2024-08-13 21:36:48', '2024-08-14 08:38:25', '2024-08-14', 'P5195', '24-06903-08-13', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Río Duero 52 ,Urb el soto', 'Aldeamayor de San Ma', 'Valladolid', '47162', 'España', 30.61, 0, '2024-08-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140824-Hc3ne/9ER2x6y-026', 'fad47366-30fd-462a-9b7c-3970c908e71e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-Hc3ne%2F9ER2x6y-026&s=KOL2024&nf=P5195&i=30.61&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5545, 1, 1371, 2, 0, NULL, 0, '2024-08-13 22:24:24', '2024-08-14 08:41:11', '2024-08-14', 'P5196', '24-06905-08-13', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Silveiro Moreda Albarino n1. Panderia Herminia.', 'Laracha (A)', 'A Coruña', '15145', 'España', 41.50, 0, '2024-08-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140824-Kq/bmTpS8kvGJ-190', '15c31e96-df5b-4518-94d9-c599ec845442', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-Kq%2FbmTpS8kvGJ-190&s=KOL2024&nf=P5196&i=41.50&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5546, 1, 1140, 2, 0, NULL, 0, '2024-08-14 08:53:27', '2024-08-14 11:01:17', '2024-08-14', 'P5198', '24-06914-08-14', 'Si no estoy en domicilio dejar en Porteria', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'C/ Limonita 7 3 A Madrid 28021, Si no estoy en domicilio. Entrega a Portero.', 'Madrid', 'Madrid', '28021', 'España', 56.82, 0, '2024-08-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140824-kJtWfXHjV0QLE-057', 'e9957239-f7bb-45f4-b726-e4ac9954eaca', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-kJtWfXHjV0QLE-057&s=KOL2024&nf=P5198&i=56.82&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5547, 1, 1254, 2, 0, NULL, 0, '2024-08-14 08:57:16', '2024-08-14 11:04:27', '2024-08-14', 'P5199', '24-06917-08-14', '', 0.00, 41.49, 9.91, 0.00, 0, 0.00, 6.90, 'C/ Pedregales 6', 'Don Benito', 'Badajoz', '06400', 'España', 57.10, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-140824-AO3Wg7oew2Mdb-240', 'fb0f463a-fa0e-4679-a797-83c231b0d306', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-AO3Wg7oew2Mdb-240&s=KOL2024&nf=P5199&i=57.10&cr=029', '[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
(5548, 1, 882, 2, 0, NULL, 0, '2024-08-14 09:29:55', '2024-08-14 11:33:42', '2024-08-14', 'P5200', '24-06919-08-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Clavileño 27', 'Madrid', 'Madrid', '28002', 'España', 17.50, 0, '2024-08-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140824-ClVyzLX5MW2Ka-233', 'a88f3ad6-d908-4445-82ca-c2a690ae6489', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-ClVyzLX5MW2Ka-233&s=KOL2024&nf=P5200&i=17.50&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5549, 1, 1372, 2, 0, NULL, 0, '2024-08-14 09:36:48', '2024-08-14 11:39:03', '2024-08-14', 'P5201', '24-06918-08-14', 'DEPURADORA DE LOGROÑO', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'camino Madre de Dios 3 .', 'Logroño', 'La Rioja', '26006', 'España', 52.39, 0, '2024-08-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140824-KoE7KTBPwBa1f-092', 'd119b7e5-67f8-4bfb-b018-592acab1c498', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-KoE7KTBPwBa1f-092&s=KOL2024&nf=P5201&i=52.39&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5550, 1, 788, 2, 0, NULL, 0, '2024-08-14 10:00:57', '2024-08-14 12:21:14', '2024-08-14', 'P5202', '24-06920-08-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida Séneca 26 4,2', 'San Sebastián de los', 'Madrid', '28703', 'España', 17.50, 0, '2024-08-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140824-Rh/poC4zgpGUz-124', 'a1272162-016f-4867-99be-e7613b347881', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-Rh%2FpoC4zgpGUz-124&s=KOL2024&nf=P5202&i=17.50&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5551, 1, 618, 2, 0, NULL, 0, '2024-08-14 10:05:45', '2024-08-14 12:23:10', '2024-08-14', 'P5203', '24-06921-08-14', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle domenec sugrañes y gras n6 bajo7', 'Salou', 'Tarragona', '43840', 'España', 65.52, 0, '2024-08-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140824-nQJCRb/nO0chW-060', '6d9bf139-678e-4473-944e-fe66f219b566', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140824-nQJCRb%2FnO0chW-060&s=KOL2024&nf=P5203&i=65.52&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5552, 1, 1373, 2, 0, NULL, 0, '2024-08-14 13:42:50', '2024-08-15 22:20:48', '2024-08-15', 'P5204', '24-06922-08-14', 'llamar antes de la entrega', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Almike bidea 5, 3izda', 'Bermeo', 'Bizkaia', '48370', 'España', 28.39, 0, '2024-08-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150824-PkablGQz8fOed-130', 'add07870-dee9-4b6e-b520-f85f329d5228', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150824-PkablGQz8fOed-130&s=KOL2024&nf=P5204&i=28.39&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5553, 1, 1374, 2, 0, NULL, 0, '2024-08-14 20:16:39', '2024-08-15 22:40:06', '2024-08-15', 'P5205', '24-06923-08-14', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle Canal 19 5B', 'Pamplona/Iruña', 'Navarra', '31015', 'España', 65.52, 0, '2024-08-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150824-KoZHETmsb9eMb-114', '57c4686e-9ea1-454c-a427-e97eda81f197', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150824-KoZHETmsb9eMb-114&s=KOL2024&nf=P5205&i=65.52&cr=226', '[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
(5554, 1, 1375, 2, 0, NULL, 0, '2024-08-14 20:35:52', '2024-08-15 22:42:01', '2024-08-15', 'P5208', '24-06924-08-14', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Paseo 30 entreplanta Radio Ourense', 'Ourense', 'Ourense', '32003', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-150824-n38NFjMF9Qxg3-175', '73ef8c3d-ed1e-4ecf-a9d9-981a5ee34bfd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150824-n38NFjMF9Qxg3-175&s=KOL2024&nf=P5208&i=20.00&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5555, 1, 916, 2, 0, NULL, 0, '2024-08-15 08:13:48', '2024-08-15 22:48:38', '2024-08-15', 'P5206', '24-06925-08-15', 'Para la entrega NO habrá nadie en casa de 12:00 a 14:00 ni de 17:00 a 20:00', 0.00, 21.66, 5.31, 0.00, 1, 1.32, 4.40, 'Plaza Kontxa Etxeberria, 9, piso 5 D', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 31.93, 0, '2024-08-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150824-PY7548NSpznaT-135', 'd742c308-8a99-4a2b-8ef0-8a2073b27250', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150824-PY7548NSpznaT-135&s=KOL2024&nf=P5206&i=31.93&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5556, 1, 1376, 2, 0, NULL, 0, '2024-08-15 14:53:49', '2024-08-15 22:53:08', '2024-08-15', 'P5207', '24-06926-08-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Ardantzabidea 11 1B', 'Zumaia', 'Gipuzkoa', '20750', 'España', 17.50, 0, '2024-08-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150824-Srmt6QZzops3Q-071', 'cd3c13b3-ddb2-4cc1-bc23-41d7046399b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150824-Srmt6QZzops3Q-071&s=KOL2024&nf=P5207&i=17.50&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5557, 1, 1377, 2, 0, NULL, 0, '2024-08-16 10:51:48', '2024-08-16 13:00:34', '2024-08-16', 'P5209', '24-06927-08-16', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Rúa Juan XXIII, 22- 1B', 'Chantada', 'Lugo', '27500', 'España', 30.61, 0, '2024-08-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160824-kWM1IiVTPUHR4-173', '5b5da2fc-37f3-428d-a965-a2e80b59a6b9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160824-kWM1IiVTPUHR4-173&s=KOL2024&nf=P5209&i=30.61&cr=023', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5558, 1, 1378, 2, 0, NULL, 0, '2024-08-16 12:16:39', '2024-08-18 21:58:40', '2024-08-18', 'P5210', '24-06929-08-16', 'Dep. Finanzas. Planta 2. Dejar a los compañeros de seguridad, en la entrada. ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Alameda Urquijo 19', 'Bilbao', 'Bizkaia', '48008', 'España', 28.39, 0, '2024-08-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180824-AO2dnn0yYal3Y-095', '7485a130-bcef-4121-a73f-eb1d406686b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-AO2dnn0yYal3Y-095&s=KOL2024&nf=P5210&i=28.39&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5559, 1, 114, 2, 0, NULL, 0, '2024-08-16 13:22:23', '2024-08-18 22:01:30', '2024-08-18', 'P5219', '24-06930-08-16', '', 0.00, 370.50, 77.81, 0.00, 0, 0.00, 0.00, 'Catalina de Erauso 10 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 448.31, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180824-kVnt8cDyfZG7T-107', 'ffc3849d-cd83-4f18-ab90-6071aabe81b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-kVnt8cDyfZG7T-107&s=KOL2024&nf=P5219&i=448.31&cr=204', '[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
(5560, 1, 1188, 2, 0, NULL, 0, '2024-08-16 14:21:57', '2024-08-18 22:04:52', '2024-08-18', 'P5211', '24-06931-08-16', 'jiaNa Peluquería Orgánica\r\n722217699', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Baíñas Calle C número 3', 'Vimianzo', 'A Coruña', '15127', 'España', 103.46, 0, '2024-08-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180824-mRxgliZL3mjyy-043', '4a918dcd-0772-4bd5-9262-5f2a27248580', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-mRxgliZL3mjyy-043&s=KOL2024&nf=P5211&i=103.46&cr=158', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5561, 1, 1316, 2, 0, NULL, 0, '2024-08-17 08:19:14', '2024-08-18 22:07:31', '2024-08-18', 'P5212', '24-06933-08-17', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'AVENIDA DE SANTIAGO 18', 'Pino (O)', 'A Coruña', '15821', 'España', 241.40, 0, '2024-08-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180824-btolaklw9Y5+0-237', 'df4b524e-37ba-4f30-a707-0e013dfc8e4c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-btolaklw9Y5%2B0-237&s=KOL2024&nf=P5212&i=241.40&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5562, 1, 1298, 2, 0, NULL, 0, '2024-08-17 11:32:19', '2024-08-18 23:06:25', '2024-08-18', 'P5213', '24-06934-08-17', '', 0.00, 43.32, 10.62, 0.00, 0, 0.00, 8.76, 'Calle Virtud, 3  atico 5 ', 'Puerto de la Cruz', 'Santa Cruz de Teneri', '33430', 'España', 61.18, 0, '2024-08-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180824-TUwUyIJICDSmo-228', '9fba16fa-234f-41b2-ad1a-676d667c670f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-TUwUyIJICDSmo-228&s=KOL2024&nf=P5213&i=61.18&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5563, 1, 1199, 2, 0, NULL, 0, '2024-08-17 17:54:08', '2024-08-18 23:13:37', '2024-08-18', 'P5214', '24-06935-08-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'MAINERROTA 7, 3D', 'Otxandio', 'Bizkaia', '48210', 'España', 17.50, 0, '2024-08-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180824-ht76bTVEM2QIo-241', 'c7bc817b-6654-41b7-b6c5-c66f1e7321ac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-ht76bTVEM2QIo-241&s=KOL2024&nf=P5214&i=17.50&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5564, 1, 1314, 2, 0, NULL, 0, '2024-08-17 19:41:06', '2024-08-18 23:15:57', '2024-08-18', 'P5215', '24-06936-08-17', 'Llamar en el momento de la entrega, el timbre no funciona \r\nGracias ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Altos de Mentrida #26', 'Méntrida', 'Toledo', '45930', 'España', 28.39, 0, '2024-08-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180824-j4NJYezrRRBtH-108', '06f2396d-edba-443b-8c2a-0b07cfe6bcf3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-j4NJYezrRRBtH-108&s=KOL2024&nf=P5215&i=28.39&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5565, 1, 340, 2, 0, NULL, 0, '2024-08-18 08:00:19', '2024-08-18 23:18:23', '2024-08-18', 'P5216', '24-06937-08-18', 'entrega en el horario de 9.30 a 1.30 y 4.30 a 7.30\r\nmiercoles cerrado', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'juan carlos 1 17, ', 'Sesma', 'Navarra', '31293', 'España', 68.97, 0, '2024-08-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180824-Wv09UGjCAImuD-161', 'cf5d4412-c89a-404a-b392-868662bb0746', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-Wv09UGjCAImuD-161&s=KOL2024&nf=P5216&i=68.97&cr=065', '[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
(5566, 1, 386, 2, 0, NULL, 0, '2024-08-18 08:40:40', '2024-08-18 23:20:16', '2024-08-18', 'P5217', '24-06938-08-18', 'Take away LekuOna', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'GETARIA KALEA 21 BAJO', 'Donostia-San Sebasti', 'Gipuzkoa', '20005', 'España', 65.52, 0, '2024-08-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180824-mvfvYgQn244Z5-085', '27e82089-6149-4d3f-8be1-46e70cc800a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-mvfvYgQn244Z5-085&s=KOL2024&nf=P5217&i=65.52&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5567, 1, 802, 2, 0, NULL, 0, '2024-08-18 17:00:33', '2024-08-18 23:24:34', '2024-08-18', 'P5218', '24-06939-08-18', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'calle Poeta Blas de Otero, nº 14, piso:3ºB', 'Madrid', 'Madrid', '28017', 'España', 30.61, 0, '2024-08-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180824-kIl/dDjqvaCB+-204', '2e4043c6-cdf0-4113-82dd-afb75da6feae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180824-kIl%2FdDjqvaCB%2B-204&s=KOL2024&nf=P5218&i=30.61&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5568, 1, 108, 2, 0, NULL, 0, '2024-08-18 22:14:33', '2024-08-19 08:37:05', '2024-08-19', 'P5220', '24-06940-08-18', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190824-edpWxrp8MakOj-068', '25199735-c64d-4ed3-be2f-731a53e87819', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190824-edpWxrp8MakOj-068&s=KOL2024&nf=P5220&i=275.88&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5569, 1, 1379, 2, 0, NULL, 0, '2024-08-19 06:30:27', '2024-08-19 08:42:57', '2024-08-19', 'P5221', '24-06941-08-19', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle puente la reina 28 3c', 'Valladolid', 'Valladolid', '47011', 'España', 17.50, 0, '2024-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190824-cRr7p3VLrkbtT-098', 'b6a4ba8a-fbe3-4086-97d8-abfc44a3718e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190824-cRr7p3VLrkbtT-098&s=KOL2024&nf=P5221&i=17.50&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5570, 1, 314, 2, 0, NULL, 0, '2024-08-19 08:29:24', '2024-08-19 10:49:39', '2024-08-19', 'P5222', '24-06942-08-19', 'Si es posible agradecería la entrega por la tarde o que me llamen antes de entregar. Gracias de antemano', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'calle mateo miguel ayllon 2, 3C', 'Cuenca', 'Cuenca', '16002', 'España', 71.98, 0, '2024-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190824-pO1YV3bNZr5Yi-228', '8829d60d-0484-47a1-b469-a403cf662011', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190824-pO1YV3bNZr5Yi-228&s=KOL2024&nf=P5222&i=71.98&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5571, 1, 1380, 2, 0, NULL, 0, '2024-08-19 12:06:04', '2024-08-20 07:59:29', '2024-08-20', 'P5223', '24-06943-08-19', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'AVDA. REQUEJO N24 PTAL 5 PISO 9B', 'Zamora', 'Zamora', '49029', 'España', 41.50, 0, '2024-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200824-MlIOMHlKw/t9U-031', 'a3cd0371-f6ca-4f5e-bcfa-4a623cdaee9f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200824-MlIOMHlKw%2Ft9U-031&s=KOL2024&nf=P5223&i=41.50&cr=044', '[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
(5572, 1, 215, 2, 0, NULL, 0, '2024-08-19 12:56:06', '2024-08-20 08:02:35', '2024-08-20', 'P5224', '24-06944-08-19', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 206.91, 0, '2024-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200824-Jq+92qWAwVfbo-015', 'c0ec2b5e-78ba-45fd-b0eb-1cdcdde1dae1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200824-Jq%2B92qWAwVfbo-015&s=KOL2024&nf=P5224&i=206.91&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5573, 1, 844, 2, 0, NULL, 0, '2024-08-19 13:55:43', '2024-08-20 08:04:31', '2024-08-20', 'P5225', '24-06945-08-19', 'Llamar al telefono, no hay timbre. GRacias!', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Camí del Coll del Perelló, num 2', 'Castellvell del Camp', 'Tarragona', '43392', 'España', 43.71, 0, '2024-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200824-KPaG5osXTLZJv-016', '97ee454f-7c9e-4798-911b-843ebd39ddc6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200824-KPaG5osXTLZJv-016&s=KOL2024&nf=P5225&i=43.71&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5574, 1, 1381, 2, 0, NULL, 0, '2024-08-19 17:14:46', '2024-08-20 08:06:24', '2024-08-20', 'P5226', '24-06946-08-19', 'Entrega de 09,00 a 14,00', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Oficina Prestaciones SEPE   Avda. Andalucía s/n', 'Archidona', 'Málaga', '29300', 'España', 17.50, 0, '2024-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200824-K2AfbgbjbdfJi-067', '38d31528-3bb0-402a-b6c9-322d3023eff7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200824-K2AfbgbjbdfJi-067&s=KOL2024&nf=P5226&i=17.50&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5575, 1, 1127, 2, 0, NULL, 0, '2024-08-19 17:20:04', '2024-08-20 08:08:24', '2024-08-20', 'P5227', '24-06947-08-19', 'Sino hay nadie en casa se puede dejar en portería ', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Avda santuario de Valverde 20 D 4 B ', 'Madrid', 'Madrid', '28049', 'España', 41.50, 0, '2024-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200824-Yiz8moLqkqHuI-091', 'b5c2155f-914b-4afb-bd27-a6a35a489185', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200824-Yiz8moLqkqHuI-091&s=KOL2024&nf=P5227&i=41.50&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5576, 1, 696, 1, 0, NULL, 0, '2024-08-20 08:14:04', '2024-08-20 08:31:06', '2024-08-20', 'P5228', '2024-08-20', '', 0.00, 866.58, 181.98, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 1048.56, 0, '2024-08-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200824-cD5wxrrAhvuwv-057', '707d40e0-6232-4de6-b52e-512b27a069a9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200824-cD5wxrrAhvuwv-057&s=KOL2024&nf=P5228&i=1048.56&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5577, 1, 67, 2, 0, NULL, 0, '2024-08-20 08:34:58', '2024-08-20 10:54:18', '2024-08-20', 'P5229', '24-06948-08-20', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200824-YrTNS7WWoEl0r-241', '72321274-9422-4e24-878f-24db010fab6e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200824-YrTNS7WWoEl0r-241&s=KOL2024&nf=P5229&i=275.88&cr=248', '[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
(5578, 1, 896, 1, 0, NULL, 0, '2024-08-20 12:48:15', '2024-08-20 12:51:37', '2024-08-20', 'P5230', '', '', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'Marrutxipi 24', 'Donostia-San Sebasti', 'Gipuzkoa', '20013', 'España', 113.30, 0, '2024-08-20 00:00:00', '', '', 3, 6, 1, 'TBAI-B20930640-200824-jhspcO0PMxWFl-083', '08e357ac-9362-4625-aefc-ac5e6b72625e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200824-jhspcO0PMxWFl-083&s=KOL2024&nf=P5230&i=113.30&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5579, 1, 1382, 2, 0, NULL, 0, '2024-08-20 17:33:54', '2024-08-21 09:01:39', '2024-08-21', 'P5231', '24-06949-08-20', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'CASTELLÓ, 8 ', 'Gavà', 'Barcelona', '08850', 'España', 30.61, 0, '2024-08-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210824-Z+1uh640rRiwl-085', '7b0cf9a9-1d20-4573-b75f-b75faeae926e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-Z%2B1uh640rRiwl-085&s=KOL2024&nf=P5231&i=30.61&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5580, 1, 1383, 2, 0, NULL, 0, '2024-08-20 18:09:43', '2024-08-21 09:03:59', '2024-08-21', 'P5232', '24-06951-08-20', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Ekuador kalea 5, 3. eskuin', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 30.61, 0, '2024-08-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210824-gqvTqlWifiL3a-098', '2ca12bea-552b-4886-8a6f-a89c801679c5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-gqvTqlWifiL3a-098&s=KOL2024&nf=P5232&i=30.61&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5581, 1, 1384, 2, 0, NULL, 0, '2024-08-20 20:00:02', '2024-08-22 09:40:22', '2024-08-22', 'P5243', '24-06952-08-20', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Pintor Urbano Lugrís 4-3°B', 'Santiago de Composte', 'A Coruña', '15702', 'España', 43.71, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220824-fRoxv2AorBO4C-035', 'bde244e6-419a-49ca-b86d-77114a3943ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220824-fRoxv2AorBO4C-035&s=KOL2024&nf=P5243&i=43.71&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5582, 1, 1385, 2, 0, NULL, 0, '2024-08-21 07:06:37', '2024-08-21 09:20:52', '2024-08-21', 'P5233', '24-06954-08-21', 'Que me llamen 2 minutos antes de la entrega para que me acerque. Mi mvl:644662206.', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Calle Conde de Montornés,2,13', 'Valencia', 'Valencia', '46003', 'España', 71.98, 0, '2024-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210824-HgHI0X8hAMqt1-004', 'c1535510-ab7a-4edb-8bdc-63cd3fea5094', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-HgHI0X8hAMqt1-004&s=KOL2024&nf=P5233&i=71.98&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(5583, 1, 1385, 2, 1, 'lote incorrecto', 5582, '2024-08-21 09:26:26', '2024-08-21 09:26:26', '2024-08-21', 'R89', 'P5233 RECT.', 'Que me llamen 2 minutos antes de la entrega para que me acerque. Mi mvl:644662206.', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 71.98, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-210824-Mr2ed5QEBb2je-056', 'b3dee0dd-2d1d-440d-ada9-62399847e0a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-Mr2ed5QEBb2je-056&s=KOL2024&nf=R89&i=-71.98&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(5584, 1, 1385, 1, 0, NULL, 0, '2024-08-21 09:28:41', '2024-08-21 09:30:47', '2024-08-21', 'P5234', '2024-08-21', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Calle Conde de Montornés,2,13', 'Valencia', 'Valencia', '46003', 'España', 71.98, 0, '2024-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210824-RksQWRjDjAtyU-101', 'a9db0036-0cbf-4b0a-8901-2c1b59653c37', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-RksQWRjDjAtyU-101&s=KOL2024&nf=P5234&i=71.98&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5585, 1, 754, 2, 0, NULL, 0, '2024-08-21 08:15:45', '2024-08-21 10:32:27', '2024-08-21', 'P5235', '24-06955-08-21', '6+1 Regalo CASTAÑO', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210824-ovgS74iffdFFk-001', '9404d4cf-29b5-4c3d-a6be-fc432384bdaa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-ovgS74iffdFFk-001&s=KOL2024&nf=P5235&i=61.64&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5586, 1, 91, 2, 0, NULL, 0, '2024-08-21 10:26:47', '2024-08-21 12:39:06', '2024-08-21', 'P5236', '24-06956-08-21', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 137.94, 0, '2024-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210824-JhdOeF5Gb7ned-053', '7e3567ac-90b8-48c9-8f74-8d7feb88c63a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-JhdOeF5Gb7ned-053&s=KOL2024&nf=P5236&i=137.94&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5587, 1, 520, 2, 0, NULL, 0, '2024-08-21 10:35:02', '2024-08-21 12:40:43', '2024-08-21', 'P5237', '24-06957-08-21', '', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'ZAR Peluqueria, Calle Andreszar, 34', 'Villava/Atarrabia', 'Navarra', '31610', 'España', 113.30, 0, '2024-08-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210824-oTXmjH2iKJu5b-058', '1d44e6f0-5e54-46e2-9803-c1ac84f6cc54', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-oTXmjH2iKJu5b-058&s=KOL2024&nf=P5237&i=113.30&cr=160', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5588, 1, 267, 2, 0, NULL, 0, '2024-08-21 11:16:54', '2024-08-21 13:24:50', '2024-08-21', 'P5238', '24-06958-08-21', 'llamar por teléfono antes de entregar, gracias', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'camiño do Carballar 2 Vilar de Arriba Pedoernes', 'Oia', 'Pontevedra', '36309', 'España', 56.82, 0, '2024-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210824-bNxkorROqMG4Q-082', 'dc52fec5-069e-494d-a956-4c8f1f9b7210', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-bNxkorROqMG4Q-082&s=KOL2024&nf=P5238&i=56.82&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5589, 1, 80, 2, 0, NULL, 0, '2024-08-21 11:29:00', '2024-08-21 13:36:04', '2024-08-21', 'P5239', '24-06959-08-21', '', 0.00, 855.00, 179.55, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 1034.55, 0, '2024-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210824-aw0QhobuGpUG6-143', 'cc3e1db0-ce1b-4646-8b64-1db5df7b781a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210824-aw0QhobuGpUG6-143&s=KOL2024&nf=P5239&i=1034.55&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
