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
(5867, 1, 1440, 2, 0, NULL, 0, '2024-10-07 16:54:37', '2024-10-07 21:45:43', '2024-10-07', 'P5509', '24-07252-10-07', '6°B', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C. Estocolmo, 6', 'Móstoles', 'Madrid', '28937', 'España', 17.50, 0, '2024-10-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-071024-RwMchEWp004bI-175', '5ed8a042-2e7a-4f2b-8357-6382eba7be83', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-RwMchEWp004bI-175&s=KOL2024&nf=P5509&i=17.50&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5868, 1, 1341, 2, 0, NULL, 0, '2024-10-07 16:55:48', '2024-10-07 21:48:06', '2024-10-07', 'P5510', '24-07253-10-07', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Avd. Ferrocarril n54, Peluquería Marzan', 'Coruña (A)', 'A Coruña', '15008', 'España', 137.94, 0, '2024-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-I85dO5n0YuHeq-012', '5ba63806-6504-432f-bd58-a0889b88eb21', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-I85dO5n0YuHeq-012&s=KOL2024&nf=P5510&i=137.94&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5869, 1, 967, 2, 0, NULL, 0, '2024-10-07 19:19:29', '2024-10-07 21:51:44', '2024-10-07', 'P5511', '24-07254-10-07', 'Llamar por teléfono si no hay nadie ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Errepidea asua erletxe15', 'Erandio', 'Bizkaia', '48950', 'España', 17.50, 0, '2024-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071024-ARtJy5gnzzwGc-146', '1b5334eb-649c-4ef4-a7b4-70b482e91260', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071024-ARtJy5gnzzwGc-146&s=KOL2024&nf=P5511&i=17.50&cr=092', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5870, 1, 1441, 2, 0, NULL, 0, '2024-10-07 21:27:32', '2024-10-08 09:09:42', '2024-10-08', 'P5514', '24-07255-10-07', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Asturias 20', 'Villaviciosa de Odón', 'Madrid', '28670', 'España', 17.50, 0, '2024-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-081024-P3xGkX0i9PTMz-147', '596bf126-06e7-4fc3-916f-6d0bc60e980b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081024-P3xGkX0i9PTMz-147&s=KOL2024&nf=P5514&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),
(5871, 1, 1227, 2, 0, NULL, 0, '2024-10-08 00:49:13', '2024-10-08 09:12:41', '2024-10-08', 'P5513', '24-07256-10-08', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle de los Cantos 24 2° B', 'Alcorcón', 'Madrid', '28922', 'España', 43.71, 0, '2024-10-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-081024-O2l67ZYAiCw7W-012', '77b0b20d-972b-4eb6-b7c0-16dc19e26b44', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081024-O2l67ZYAiCw7W-012&s=KOL2024&nf=P5513&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),
(5872, 1, 190, 3, 0, NULL, 0, '2024-10-08 09:24:39', '2024-10-08 09:24:39', '2024-10-08', '', 'Consumo interno', '', 0.00, 1140.00, 239.40, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 1379.40, 0, '2024-10-08 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),
(5873, 1, 242, 1, 0, NULL, 0, '2024-10-08 12:10:36', '2024-10-08 12:12:13', '2024-10-08', 'P5515', '', '', 0.00, 97.68, 20.51, 0.00, 1, 5.08, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 123.27, 0, '2024-10-08 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-081024-PL6sv3VmB5YA3-120', 'deb16ab3-fb3b-4bc0-9e35-791bb3879df7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081024-PL6sv3VmB5YA3-120&s=KOL2024&nf=P5515&i=123.27&cr=216', '[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
(5874, 1, 522, 2, 0, NULL, 0, '2024-10-08 12:11:38', '2024-10-09 08:19:03', '2024-10-09', 'P5516', '24-07257-10-08', '', 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-10-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091024-NBa7N54pUKbyR-077', 'b75f10d8-62de-42a2-a690-0674ffaba99c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091024-NBa7N54pUKbyR-077&s=KOL2024&nf=P5516&i=206.91&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5875, 1, 1442, 2, 0, NULL, 0, '2024-10-08 16:06:45', '2024-10-09 08:21:10', '2024-10-09', 'P5517', '24-07258-10-08', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avenida de la flota n3 1B ', 'Murcia', 'Murcia', '30008', 'España', 28.39, 0, '2024-10-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091024-aD1YdbSi5gFCM-147', '28a51756-658d-4070-85e7-9adf211179b4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091024-aD1YdbSi5gFCM-147&s=KOL2024&nf=P5517&i=28.39&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5876, 1, 1443, 2, 0, NULL, 0, '2024-10-08 21:59:01', '2024-10-08 21:59:01', '2024-10-08', '', '24-07259-10-08', NULL, 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida Deporte, 20', 'Solana (La)', 'Ciudad Real', '13240', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(5877, 1, 262, 2, 0, NULL, 0, '2024-10-09 05:42:31', '2024-10-09 08:24:46', '2024-10-09', 'P5518', '24-07260-10-09', 'sabado tarde y lunes cerrado', 0.00, 134.34, 28.21, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura, peluquería), Local', 'Girona', 'Girona', '17003', 'España', 162.55, 0, '2024-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091024-eTQsr/2D0VGPP-000', '147f18fa-2daf-4ad0-b3bd-8093d9f7f342', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091024-eTQsr%2F2D0VGPP-000&s=KOL2024&nf=P5518&i=162.55&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5878, 1, 1444, 2, 0, NULL, 0, '2024-10-09 10:10:15', '2024-10-09 12:12:03', '2024-10-09', 'P5519', '24-07261-10-09', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Pintor Zubiri 4 trasera, bajo', 'Pamplona/Iruña', 'Navarra', '31008', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-091024-XXpVRoR6HIR3P-165', 'eba281ff-b858-4c10-8a11-3b68b45fe1ab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091024-XXpVRoR6HIR3P-165&s=KOL2024&nf=P5519&i=196.56&cr=123', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5879, 1, 1445, 2, 0, NULL, 0, '2024-10-09 12:09:27', '2024-10-09 14:10:23', '2024-10-09', 'P5520', '24-07262-10-09', 'Por favor avisar antes de entrega', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Urb.Reserva del Higuerón.Gardenia 1H', 'Benalmádena', 'Málaga', '29639', 'España', 30.61, 0, '2024-10-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-091024-OQnI9QgS4a9yZ-105', '52adfde2-a16b-4e6a-a62a-f9e9447d9570', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091024-OQnI9QgS4a9yZ-105&s=KOL2024&nf=P5520&i=30.61&cr=043', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5880, 1, 1025, 2, 0, NULL, 0, '2024-10-09 13:02:57', '2024-10-10 07:04:20', '2024-10-10', 'P5521', '24-07263-10-09', 'no entregar lunes', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Artekale  12  bajo peluqueria', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 241.40, 0, '2024-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101024-TsqHXySW6S6GD-001', '4e45246b-5d2d-4914-a752-72c2eb6d3527', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-TsqHXySW6S6GD-001&s=KOL2024&nf=P5521&i=241.40&cr=186', '[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
(5881, 1, 30, 2, 0, NULL, 0, '2024-10-09 13:30:57', '2024-10-10 07:06:12', '2024-10-10', 'P5522', '24-07264-10-09', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle González tablas, 3 bajo', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 137.94, 0, '2024-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101024-dJXcGYf4G39xE-070', '3f5da8a1-d682-4b8a-8922-8d6fdbec170b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-dJXcGYf4G39xE-070&s=KOL2024&nf=P5522&i=137.94&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5882, 1, 337, 2, 0, NULL, 0, '2024-10-09 13:48:34', '2024-10-10 07:07:26', '2024-10-10', 'P5526', '24-07265-10-09', '', 0.00, 122.10, 25.64, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 147.74, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101024-NJDu5aViTWCse-098', '67b82442-892e-44d8-ae76-1ffafa4f04e0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-NJDu5aViTWCse-098&s=KOL2024&nf=P5526&i=147.74&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5883, 1, 1446, 2, 0, NULL, 0, '2024-10-09 14:19:22', '2024-10-10 07:08:28', '2024-10-10', 'P5523', '24-07266-10-09', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Pintor Pradilla 4', 'Calahorra', 'La Rioja', '26500', 'España', 17.50, 0, '2024-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101024-KS7EAW+x6Xajq-026', '38161e91-d120-4b0e-a8d0-0ec10533d68d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-KS7EAW%2Bx6Xajq-026&s=KOL2024&nf=P5523&i=17.50&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5884, 1, 53, 2, 0, NULL, 0, '2024-10-09 14:25:42', '2024-10-10 07:10:37', '2024-10-10', 'P5527', '24-07267-10-09', '', 0.00, 199.50, 42.33, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 243.90, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-101024-Krx2sWdL2tjcb-100', '96f8dc9a-092e-4fb2-afd3-3aa6508ff288', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-Krx2sWdL2tjcb-100&s=KOL2024&nf=P5527&i=243.90&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5885, 1, 1447, 2, 0, NULL, 0, '2024-10-09 15:21:01', '2024-10-10 07:11:29', '2024-10-10', 'P5524', '24-07268-10-09', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle / El higueral número 6', 'Navas de San Juan', 'Jaén', '23240', 'España', 17.50, 0, '2024-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101024-PyfiOkhP7+njp-038', '17a1912c-764a-4831-a271-39f6eb60f32e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-PyfiOkhP7%2Bnjp-038&s=KOL2024&nf=P5524&i=17.50&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5886, 1, 195, 2, 0, NULL, 0, '2024-10-09 16:37:32', '2024-10-10 07:12:42', '2024-10-10', 'P5528', '24-07269-10-09', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'c/maria de lezonº17 bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101024-R0bRRAJNPp7zc-092', '3a2c2c83-58ca-45a6-9fa5-09765393698a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-R0bRRAJNPp7zc-092&s=KOL2024&nf=P5528&i=103.46&cr=235', '[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
(5887, 1, 1448, 2, 0, NULL, 0, '2024-10-09 16:59:53', '2024-10-10 07:13:20', '2024-10-10', 'P5525', '24-07270-10-09', '', 0.00, 75.81, 15.92, 0.00, 0, 0.00, 0.00, 'Buztinkale 1', 'Zegama', 'Gipuzkoa', '20215', 'España', 91.73, 0, '2024-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101024-H3GI47hwHYrht-049', 'b51fa322-0637-4fa3-b0f5-cccd72ca1ba8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-H3GI47hwHYrht-049&s=KOL2024&nf=P5525&i=91.73&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5888, 1, 1237, 2, 0, NULL, 0, '2024-10-09 20:22:21', '2024-10-10 07:16:26', '2024-10-10', 'P5529', '24-07271-10-09', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Goieta kalea  28 - 3. Izq.', 'Elorrio', 'Bizkaia', '48230', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101024-gApOO2bQBsUZh-079', '4c9552e1-dffa-4464-a8b3-f8af34a8f89a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-gApOO2bQBsUZh-079&s=KOL2024&nf=P5529&i=30.61&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5889, 1, 1449, 2, 0, NULL, 0, '2024-10-10 07:16:56', '2024-10-10 07:16:56', '2024-10-10', '', '24-07272-10-10', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Calle Olimpiadas 13, ', 'Ejido (El)', 'Almería', '04700', '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),
(5890, 1, 1449, 2, 0, NULL, 0, '2024-10-10 07:20:07', '2024-10-10 09:20:37', '2024-10-10', 'P5530', '24-07273-10-10', '', 0.00, 28.50, 7.18, 0.00, 0, 0.00, 6.90, 'Calle Olimpiadas 13, ', 'Ejido (El)', 'Almería', '04700', 'España', 41.39, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-101024-aSH0TbIf6NogN-131', '93b1ea0d-4f23-401e-8ef8-e40ecc8e32d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-aSH0TbIf6NogN-131&s=KOL2024&nf=P5530&i=41.39&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5891, 1, 77, 1, 0, NULL, 0, '2024-10-10 09:40:31', '2024-10-10 09:40:31', '2024-10-10', 'P5531', '', '', 0.00, 1072.50, 225.23, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1297.73, 0, '2024-10-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101024-LjOf3Wk6zoH03-151', '3c776aaa-94cd-4360-b027-4877d640c811', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-LjOf3Wk6zoH03-151&s=KOL2024&nf=P5531&i=1297.73&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5892, 1, 696, 1, 0, NULL, 0, '2024-10-10 09:48:45', '2024-10-10 09:57:19', '2024-10-10', 'P5532', '', '', 0.00, 626.34, 131.53, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 757.87, 0, '2024-10-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101024-FZplLxFJ9FR3I-120', '5253050d-5d9e-4136-894b-74c6a9ce9a7e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-FZplLxFJ9FR3I-120&s=KOL2024&nf=P5532&i=757.87&cr=252', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5893, 1, 113, 1, 0, NULL, 0, '2024-10-10 11:05:00', '2024-10-10 11:06:14', '2024-10-10', 'P5533', '', '', 0.00, 109.92, 23.51, 0.00, 0, 0.00, 2.50, 'AVENIDA DE LOS LABRADORES 5 LOCAL3', 'Tres Cantos', 'Madrid', '28760', 'España', 135.50, 0, '2024-10-10 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-101024-SN8uiRLzXYV20-220', '822762bd-0d3f-4d13-a034-598c9b5da1db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-SN8uiRLzXYV20-220&s=KOL2024&nf=P5533&i=135.50&cr=124', '[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
(5894, 1, 566, 2, 0, NULL, 0, '2024-10-10 11:27:59', '2024-10-10 13:34:09', '2024-10-10', 'P5534', '24-07274-10-10', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 620.73, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101024-G+iOYOxb0AZCE-242', 'dd418b43-4d28-4740-96b4-70a4e7f83e08', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-G%2BiOYOxb0AZCE-242&s=KOL2024&nf=P5534&i=620.73&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5895, 1, 1443, 2, 0, NULL, 0, '2024-10-10 11:52:33', '2024-10-10 13:54:37', '2024-10-10', 'P5535', '24-07275-10-10', 'Si puede ser entregar por la tarde.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida del deporte, 20', 'Solana (La)', 'Ciudad Real', '13240', 'España', 17.50, 0, '2024-10-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101024-FEF+NikBHUljP-221', '4d3746d1-ad1f-4465-85fd-88a3d440beba', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101024-FEF%2BNikBHUljP-221&s=KOL2024&nf=P5535&i=17.50&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5896, 1, 1147, 2, 0, NULL, 0, '2024-10-10 13:40:46', '2024-10-11 09:04:04', '2024-10-11', 'P5536', '24-07276-10-10', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avenida Aragón 14, Primero c', 'Teruel', 'Teruel', '44002', 'España', 52.39, 0, '2024-10-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111024-cnYWqjI0iMlsL-210', '954c340a-d015-40cb-9aa3-91394ec15c95', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111024-cnYWqjI0iMlsL-210&s=KOL2024&nf=P5536&i=52.39&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5897, 1, 4, 2, 0, NULL, 0, '2024-10-10 14:43:17', '2024-10-11 09:07:07', '2024-10-11', 'P5537', '24-07277-10-10', '', 0.00, 260.56, 54.72, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 315.28, 0, '2024-10-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111024-W+HUXrvq0fcSX-251', '54d01a17-edcf-49f8-892b-2c7df8f9747d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111024-W%2BHUXrvq0fcSX-251&s=KOL2024&nf=P5537&i=315.27&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5898, 1, 1450, 2, 0, NULL, 0, '2024-10-10 18:05:55', '2024-10-11 09:08:39', '2024-10-11', 'P5538', '24-07278-10-10', 'Entrega preferible a la tarde a partir de las 15:00', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Francisco Javier Landaburu 78 5º C', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 17.50, 0, '2024-10-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111024-drcNDqu9CsbGl-231', 'b093027c-9a39-4f7f-85a7-72fcc131ebdc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111024-drcNDqu9CsbGl-231&s=KOL2024&nf=P5538&i=17.50&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5899, 1, 1154, 2, 0, NULL, 0, '2024-10-10 19:39:55', '2024-10-11 09:11:01', '2024-10-11', 'P5539', '24-07279-10-10', '', 0.00, 129.96, 27.29, 0.00, 0, 0.00, 0.00, 'Fueros, 10', 'Vitoria-Gasteiz', 'Álava', '01004', 'España', 157.25, 0, '2024-10-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111024-ToHZHvVTLgWGz-225', '950e0119-50d1-48ba-9810-1d3919b6b107', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111024-ToHZHvVTLgWGz-225&s=KOL2024&nf=P5539&i=157.25&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
(5900, 1, 1149, 2, 0, NULL, 0, '2024-10-11 06:30:10', '2024-10-11 09:12:13', '2024-10-11', 'P5540', '24-07280-10-11', 'Horario de lunes a viernes, 10:00 a 19:00', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'calle Fernández de los Ríos 42 (Teatro de La Abadía)', 'Madrid', 'Madrid', '28015', 'España', 52.39, 0, '2024-10-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111024-SJGB6L2HqZsd1-188', '8b945e38-a2ce-4e59-a45a-eb04e765d997', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111024-SJGB6L2HqZsd1-188&s=KOL2024&nf=P5540&i=52.39&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5901, 1, 311, 2, 0, NULL, 0, '2024-10-11 12:15:33', '2024-10-14 08:57:34', '2024-10-14', 'P5541', '24-07281-10-11', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'calle Plaza de las Merindades 3,1ºdrch', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 30.61, 0, '2024-10-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141024-UZoGuxan2pSgz-054', 'd5758e87-7589-4ffe-a604-27a9ec13ee2f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-UZoGuxan2pSgz-054&s=KOL2024&nf=P5541&i=30.61&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5902, 1, 1451, 2, 0, NULL, 0, '2024-10-11 19:07:33', '2024-10-14 09:00:35', '2024-10-14', 'P5542', '24-07283-10-11', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'solano 18 Biguezal', 'Romanzado', 'Navarra', '31454', 'España', 28.39, 0, '2024-10-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141024-FBpgWbVOs0NF4-071', '3d0ba5e5-71b3-451b-a152-20deaf8b562a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-FBpgWbVOs0NF4-071&s=KOL2024&nf=P5542&i=28.39&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5903, 1, 1452, 2, 0, NULL, 0, '2024-10-12 09:07:46', '2024-10-14 09:03:50', '2024-10-14', 'P5543', '24-07284-10-12', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Avd. Barcelona 6, 3A', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 65.52, 0, '2024-10-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141024-GN/pE2UG0ksXu-171', '2d739b97-575b-4d57-96c4-7aff2a2a2afc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-GN%2FpE2UG0ksXu-171&s=KOL2024&nf=P5543&i=65.52&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5904, 1, 1453, 2, 0, NULL, 0, '2024-10-13 09:06:56', '2024-10-14 09:06:45', '2024-10-14', 'P5547', '24-07288-10-13', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Palmanova, Puige Teide 4, Apt 102,', 'Calvià', 'Baleares (Illes)', '07181', 'España', 61.09, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141024-Kfurq/rmHz/zU-011', 'b5baeac3-1adc-47ae-a49b-53e86056c92e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-Kfurq%2FrmHz%2FzU-011&s=KOL2024&nf=P5547&i=61.09&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5905, 1, 1454, 2, 0, NULL, 0, '2024-10-13 13:43:12', '2024-10-14 09:18:42', '2024-10-14', 'P5544', '24-07289-10-13', 'Si no contesto al interfono que me llamen. A veces no funciona', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Camí de la Pava 2, escalera A, 2-1', 'Gavà', 'Barcelona', '08850', 'España', 52.39, 0, '2024-10-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-141024-Jsb2XOQf0f1cj-042', 'c5581e1c-1d89-4c14-931d-a0e633768359', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-Jsb2XOQf0f1cj-042&s=KOL2024&nf=P5544&i=52.39&cr=118', '[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
(5906, 1, 1455, 2, 0, NULL, 0, '2024-10-13 16:11:26', '2024-10-14 09:21:28', '2024-10-14', 'P5545', '24-07290-10-13', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Libertad 18', 'Álamo (El)', 'Madrid', '28607', 'España', 30.61, 0, '2024-10-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141024-TMbSb+8avbuLk-121', '733b5dc3-fff0-4c63-8d0f-14be92dfb065', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-TMbSb%2B8avbuLk-121&s=KOL2024&nf=P5545&i=30.61&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5907, 1, 1456, 2, 0, NULL, 0, '2024-10-13 17:33:58', '2024-10-14 09:23:48', '2024-10-14', 'P5548', '24-07293-10-13', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Camino Nogarido, 24 -1° Covas', 'Viveiro', 'Lugo', '27861', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-141024-O9tpKsb7/tz1N-151', '3c412460-4de9-48b4-84c4-c681477fcb10', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-O9tpKsb7%2Ftz1N-151&s=KOL2024&nf=P5548&i=20.00&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5908, 1, 1013, 2, 0, NULL, 0, '2024-10-13 20:03:52', '2024-10-14 09:25:45', '2024-10-14', 'P5546', '24-07294-10-13', '', 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-10-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-141024-VAvg7BsPMgpcv-108', '48c3d424-c888-4ecd-ba3c-e3fa5108f8dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-VAvg7BsPMgpcv-108&s=KOL2024&nf=P5546&i=43.71&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5909, 1, 438, 2, 0, NULL, 0, '2024-10-14 07:28:40', '2024-10-14 09:48:20', '2024-10-14', 'P5549', '24-07296-10-14', 'Astel-Osteg: 8.00-16.30\r\nOsti: 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-10-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141024-Tdr4gaKsw3rH1-207', 'af65877f-28e8-456d-8d80-d1ced42ba4e6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-Tdr4gaKsw3rH1-207&s=KOL2024&nf=P5549&i=30.61&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5910, 1, 1457, 2, 0, NULL, 0, '2024-10-14 07:31:56', '2024-10-14 09:55:52', '2024-10-14', 'P5550', '24-07297-10-14', 'Pueden entragar en consergería por calle antracita', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Rodio 4a  planta 4b', 'Madrid', 'Madrid', '28045', 'España', 17.50, 0, '2024-10-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141024-W/XPX0j0/N2Ic-210', 'bf7feaee-cdef-4a52-bdea-b89d2aec885e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-W%2FXPX0j0%2FN2Ic-210&s=KOL2024&nf=P5550&i=17.50&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5911, 1, 78, 2, 0, NULL, 0, '2024-10-14 09:31:44', '2024-10-14 12:06:57', '2024-10-14', 'P5551', '24-07299-10-14', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'avd. Satrustegui 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141024-FOTChRwa/x4p0-103', '289b967b-3e93-4dda-8bd0-a035c3b126f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-FOTChRwa%2Fx4p0-103&s=KOL2024&nf=P5551&i=413.82&cr=057', '[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
(5912, 1, 1458, 2, 0, NULL, 0, '2024-10-14 10:24:00', '2024-10-14 12:31:39', '2024-10-14', 'P5552', '24-07300-10-14', 'Ahora la calle se llama Agata Badia i Puig-Rodon, pero en Google Maps sigue saliendo como Santa Àgata', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Santa Àgata 9, 2-1', 'Barcelona', 'Barcelona', '08012', 'España', 17.50, 0, '2024-10-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-141024-FEk/2dSyPbSCm-137', '15dfd392-187c-42fb-9ebe-a5890de340cb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-FEk%2F2dSyPbSCm-137&s=KOL2024&nf=P5552&i=17.50&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5913, 1, 474, 1, 0, NULL, 0, '2024-10-14 12:31:03', '2024-10-14 12:31:18', '2024-10-14', 'P5553', '2024-10-14', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'C Ntra Sra de los clarines 56', 'Beas', 'Huelva', '21630', 'España', 172.42, 0, '2024-10-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141024-V/D6DBwIQrRXV-119', '77cf598e-0018-4739-aeca-24a13bb75c1e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-V%2FD6DBwIQrRXV-119&s=KOL2024&nf=P5553&i=172.42&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5914, 1, 65, 2, 0, NULL, 0, '2024-10-14 11:16:18', '2024-10-14 13:24:44', '2024-10-14', 'P5554', '24-07301-10-14', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 482.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-141024-I84KstPbCJz0C-066', 'c1efe907-f828-452f-a192-a6fb91c97d6a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-I84KstPbCJz0C-066&s=KOL2024&nf=P5554&i=482.79&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5915, 1, 1460, 2, 0, NULL, 0, '2024-10-14 12:10:51', '2024-10-14 15:57:09', '2024-10-14', 'P5555', '24-07302-10-14', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Santa Vicenta María, 1, 2A', 'Pamplona/Iruña', 'Navarra', '31012', 'España', 28.39, 0, '2024-10-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141024-cOVY8TXo8bQUi-139', 'aab537b3-b0e5-4737-90d3-885997758439', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141024-cOVY8TXo8bQUi-139&s=KOL2024&nf=P5555&i=28.39&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5916, 1, 1461, 2, 0, NULL, 0, '2024-10-14 14:26:17', '2024-10-15 09:02:24', '2024-10-15', 'P5556', '24-07304-10-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Nueva n°6', 'Berrioplano', 'Navarra', '31013', 'España', 17.50, 0, '2024-10-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151024-DJh1PYnlXZ8FA-087', '131316d0-78f9-44fc-bea7-6322b987ad8b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-DJh1PYnlXZ8FA-087&s=KOL2024&nf=P5556&i=17.50&cr=187', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5917, 1, 1453, 2, 0, NULL, 0, '2024-10-14 16:33:13', '2024-10-15 09:25:44', '2024-10-14', '', '24-07288-10-13', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Palmanova, Puige Teide 4, Apt 102,', 'Calvià', 'Baleares (Illes)', '07181', 'España', 61.09, 0, '0000-00-00 00:00:00', '', '', 5, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(5918, 1, 1462, 2, 0, NULL, 0, '2024-10-14 17:20:11', '2024-10-15 09:07:05', '2024-10-15', 'P5557', '24-07305-10-14', 'El local es una inmobiliaria. Traer en horario comercial. Gracias.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ L\'Amistat, 7 local', 'Barcelona', 'Barcelona', '08005', 'España', 17.50, 0, '2024-10-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151024-N3Zqsl0tMfn2t-070', 'a26bf362-912f-41e6-a662-3ddc3580d4c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-N3Zqsl0tMfn2t-070&s=KOL2024&nf=P5557&i=17.50&cr=102', '[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
(5919, 1, 1289, 2, 0, NULL, 0, '2024-10-14 17:32:34', '2024-10-15 09:10:49', '2024-10-15', 'P5558', '24-07307-10-14', '', 0.00, 124.47, 26.14, 0.00, 0, 0.00, 0.00, 'Calle Minerva 68', 'Garlitos', 'Badajoz', '06656', 'España', 150.61, 0, '2024-10-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151024-ZNyUa8VgJ5f0s-147', '79bb655d-8525-40d7-bba4-c6efda593187', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-ZNyUa8VgJ5f0s-147&s=KOL2024&nf=P5558&i=150.61&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5920, 1, 996, 2, 0, NULL, 0, '2024-10-14 20:49:23', '2024-10-15 09:13:31', '2024-10-15', 'P5559', '24-07309-10-14', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Urkizu Pasealekua 28-3ºC', 'Eibar', 'Gipuzkoa', '20600', 'España', 52.39, 0, '2024-10-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151024-VJx5CXnuRNGrl-175', '03a14b53-8e0f-4e0f-9ad2-510b103e60a9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-VJx5CXnuRNGrl-175&s=KOL2024&nf=P5559&i=52.39&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5921, 1, 1463, 2, 0, NULL, 0, '2024-10-14 20:53:20', '2024-10-15 09:16:10', '2024-10-15', 'P5560', '24-07310-10-14', 'Por favor, llamar antes de entregar, gracias', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avda/ Puente Zuazo, N° 91', 'San Fernando', 'Cádiz', '11100', 'España', 30.61, 0, '2024-10-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-151024-Y3bsceVC9lKsw-096', '0532d25b-5a8e-467c-96d1-118d5512eb97', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-Y3bsceVC9lKsw-096&s=KOL2024&nf=P5560&i=30.61&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5922, 1, 77, 1, 0, NULL, 0, '2024-10-15 11:34:15', '2024-10-15 11:34:15', '2024-10-15', 'P5561', '', '', 0.00, 214.50, 45.05, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 259.55, 0, '2024-10-15 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-151024-ci7NqiliOVcDO-079', '061209c4-894b-4909-955b-976ddd10eef5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-ci7NqiliOVcDO-079&s=KOL2024&nf=P5561&i=259.55&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(5923, 1, 77, 1, 0, NULL, 0, '2024-10-15 11:35:20', '2024-10-15 11:36:07', '2024-10-15', '', '', '', 0.00, 214.50, 45.05, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 259.55, 0, '2024-10-15 00:00:00', '', '', 5, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(5924, 1, 754, 2, 0, NULL, 0, '2024-10-15 09:45:25', '2024-10-15 11:54:23', '2024-10-15', 'P5562', '24-07311-10-15', '6+1 REGALO RUBIO CLARO', 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-10-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151024-AacDTAKpIEVkw-144', '3bb34291-90d0-4cd4-a18c-7ec1fc754926', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-AacDTAKpIEVkw-144&s=KOL2024&nf=P5562&i=61.64&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5925, 1, 77, 1, 1, 'añadir más productos', 5922, '2024-10-15 12:00:55', '2024-10-15 12:00:55', '2024-10-15', 'R91', 'P5561 RECT.', '', 0.00, 214.50, 45.05, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 259.55, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-151024-d3YIsaq/JbQ1w-100', 'ee8f2427-d5ff-4dd1-b430-59da7d2c3a88', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151024-d3YIsaq%2FJbQ1w-100&s=KOL2024&nf=R91&i=-259.55&cr=252', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1);
