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
(6538, 1, 1633, 2, 0, NULL, 0, '2025-01-21 17:51:55', '2025-01-22 08:46:50', '2025-01-22', 'P6142', '25-07991-01-21', 'Concretar entrega antes por favor 627147667', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avda da Coruña 51-53 4B ', 'Ribeira', 'A Coruña', '16960', 'España', 30.61, 0, '2025-01-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220125-CGp2lKznEAQ9t-185', '65666561-eca3-4a1b-b529-264a3d081093', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-CGp2lKznEAQ9t-185&s=KOL2025&nf=P6142&i=30.61&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6539, 1, 1617, 2, 0, NULL, 0, '2025-01-21 19:32:19', '2025-01-22 08:47:35', '2025-01-22', 'P6143', '25-07992-01-21', 'Peluquería ', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle San Vicente Ferrer 11', 'Madrid', 'Madrid', '28004', 'España', 68.97, 0, '2025-01-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220125-Osgyb8FhVYseR-209', '778a4332-ed20-49f1-b61f-ad8977616231', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-Osgyb8FhVYseR-209&s=KOL2025&nf=P6143&i=68.97&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6540, 1, 1279, 2, 0, NULL, 0, '2025-01-22 06:04:57', '2025-01-22 08:49:05', '2025-01-22', 'P6144', '25-07993-01-22', 'entregar en Pendennis', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'moll de ponent sin numero', 'Vilanova i la Geltrú', 'Barcelona', '08800', 'España', 65.52, 0, '2025-01-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220125-HL1UgANqlxPna-013', '8b164465-8f49-4530-b80d-9646c8c56eb0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-HL1UgANqlxPna-013&s=KOL2025&nf=P6144&i=65.52&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6541, 1, 259, 2, 0, NULL, 0, '2025-01-22 09:14:19', '2025-01-22 10:23:03', '2025-01-22', 'P6147', '25-07994-01-22', 'entregar 9:00  a 13:00', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'GUIPUZKOA KALEA 53 bajo', 'Zarautz', 'Gipuzkoa', '20800', 'España', 206.91, 0, '2025-01-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220125-DegSB8jlVRaDM-065', '7716d641-d5a1-4f26-8370-da604f8d2b92', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-DegSB8jlVRaDM-065&s=KOL2025&nf=P6147&i=206.91&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6542, 1, 381, 2, 0, NULL, 0, '2025-01-22 09:25:16', '2025-01-22 10:32:10', '2025-01-22', 'P6148', '25-07995-01-22', 'Por favor, avisar antes de la entrega al teléfono móvil 610684114. Gracias', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/Felipe Abad Nº51', 'Santa Coloma', 'La Rioja', '26315', 'España', 65.52, 0, '2025-01-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220125-YuAzXfns2BMw7-244', 'a802f6c0-22c9-4de0-93bc-6edf3abe29c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-YuAzXfns2BMw7-244&s=KOL2025&nf=P6148&i=65.52&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6543, 1, 1316, 2, 0, NULL, 0, '2025-01-22 10:36:16', '2025-01-22 11:47:43', '2025-01-22', 'P6149', '25-07998-01-22', 'no entregar los lunes', 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, '2025-01-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220125-FiF8jNEfEwLl4-035', 'e4aeabb3-2669-4a4b-92db-6ec40a7f0d88', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-FiF8jNEfEwLl4-035&s=KOL2025&nf=P6149&i=241.40&cr=026', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6544, 1, 126, 2, 0, NULL, 0, '2025-01-22 10:46:04', '2025-01-22 11:51:26', '2025-01-22', 'P6150', '25-07999-01-22', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'C/ Santa Lucía Nº 8 ocal', 'Valladolid', 'Valladolid', '47005', 'España', 379.34, 0, '2025-01-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220125-DF7uYmZEs/93O-033', '17c037ab-88d8-47ce-9de1-2fe612386856', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-DF7uYmZEs%2F93O-033&s=KOL2025&nf=P6150&i=379.34&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6545, 1, 99, 2, 0, NULL, 0, '2025-01-22 11:06:29', '2025-01-22 12:15:16', '2025-01-22', 'P6151', '25-08000-01-22', 'Entrega por las mañanas ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Iñigo arista 19 Trasera ', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 137.94, 0, '2025-01-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220125-XYx2HplVsfyzb-115', '50544344-f927-4a67-9592-6cae45f03036', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-XYx2HplVsfyzb-115&s=KOL2025&nf=P6151&i=137.94&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6546, 1, 172, 2, 0, NULL, 0, '2025-01-22 15:06:32', '2025-01-22 16:14:50', '2025-01-22', 'P6152', '25-08001-01-22', '', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'Soldevila, 6 baixos', 'Tremp', 'Lleida', '25620', 'España', 78.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220125-L6TBcCcj9pWKU-218', 'a818ff6c-e84c-4e96-8b5b-91945f8c7e09', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220125-L6TBcCcj9pWKU-218&s=KOL2025&nf=P6152&i=78.81&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6547, 1, 1634, 2, 0, NULL, 0, '2025-01-22 16:20:08', '2025-01-23 07:36:50', '2025-01-23', 'P6153', '25-08002-01-22', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ Feria de Jerez, 13, Portal 5 3ºB', 'Fuengirola', 'Málaga', '29640', 'España', 65.52, 0, '2025-01-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230125-eqoepugx4lme5-119', '8036bf05-f2b0-48c9-9c18-0eca4604cd7c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230125-eqoepugx4lme5-119&s=KOL2025&nf=P6153&i=65.52&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6548, 1, 102, 2, 0, NULL, 0, '2025-01-22 17:09:07', '2025-01-23 07:38:10', '2025-01-23', 'P6154', '25-08003-01-22', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Riera Lledoners 66', 'Canet de Mar', 'Barcelona', '08360', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-230125-UnAltMCc+jDh9-085', 'e6847b22-2e03-4a8d-9524-8bbbb5df7da6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230125-UnAltMCc%2BjDh9-085&s=KOL2025&nf=P6154&i=71.47&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6549, 1, 190, 3, 0, NULL, 0, '2025-01-23 09:36:49', '2025-01-23 09:44:12', '2025-01-23', '', 'Consumo interno', '', 0.00, 4974.60, 999.99, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 6019.27, 0, '2025-01-23 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6550, 1, 1635, 2, 0, NULL, 0, '2025-01-23 10:09:08', '2025-01-23 11:11:19', '2025-01-23', 'P6155', '25-08005-01-23', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Carrer Tirso de Molina, 40', 'Cornellà de Llobrega', 'Barcelona', '08940', 'España', 28.39, 0, '2025-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230125-UD6WLQpjWllRN-176', 'a2aab24a-d04a-400c-8cbe-39283dcf3038', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230125-UD6WLQpjWllRN-176&s=KOL2025&nf=P6155&i=28.39&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6551, 1, 468, 2, 0, NULL, 0, '2025-01-23 10:31:47', '2025-01-23 11:36:53', '2025-01-23', 'P6156', '25-08006-01-23', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'Rof Carballo 1, kimera estilistas', 'Lugo', 'Lugo', '27002', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-230125-Fzq4fGab4tuKb-244', '1c7ab179-437b-4c21-8db1-d8248d20244f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230125-Fzq4fGab4tuKb-244&s=KOL2025&nf=P6156&i=105.96&cr=089', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6552, 1, 1509, 2, 0, NULL, 0, '2025-01-23 10:39:45', '2025-01-23 11:48:10', '2025-01-23', 'P6157', '25-08007-01-23', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida Jun 2. 1°A', 'Pulianas', 'Granada', '18197', 'España', 17.50, 0, '2025-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230125-R8jT4XxVF/eb7-053', '53e951aa-1491-4e4d-8378-acce81574ba5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230125-R8jT4XxVF%2Feb7-053&s=KOL2025&nf=P6157&i=17.50&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6553, 1, 1612, 2, 0, NULL, 0, '2025-01-23 11:27:24', '2025-01-23 11:27:24', '2025-01-23', '', '25-08009-01-23', NULL, 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Urdan ', 'Amoroto', 'Bizkaia', '2006', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6554, 1, 1612, 2, 0, NULL, 0, '2025-01-23 11:30:05', '2025-01-23 11:30:05', '2025-01-23', '', '25-08010-01-23', NULL, 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Urdaneta', 'Altos (Los)', 'Burgos', '20006', 'España', 28.39, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6555, 1, 1636, 2, 0, NULL, 0, '2025-01-23 11:52:12', '2025-01-23 12:57:28', '2025-01-23', 'P6158', '25-08011-01-23', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/ Sierra de Tentudía  2A, 1G', 'Mérida', 'Badajoz', '06800', 'España', 43.71, 0, '2025-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230125-cA0vG9H2G7bZ6-069', 'aa436eeb-af0b-4e57-8de7-173f879dba7d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230125-cA0vG9H2G7bZ6-069&s=KOL2025&nf=P6158&i=43.71&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6556, 1, 1209, 1, 0, NULL, 0, '2025-01-23 12:55:16', '2025-01-23 13:14:37', '2025-01-23', 'P6159', '', '', 0.00, 21.66, 5.90, 0.00, 0, 0.00, 7.80, 'Calle Zaragoza, 12 C', 'Montesinos (Los)', 'Alicante', '03187', 'España', 34.01, 0, '2025-01-23 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-230125-aW9SJhCiuAnBu-061', 'b0f4c3f3-c422-4446-9554-2f2549768af9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230125-aW9SJhCiuAnBu-061&s=KOL2025&nf=P6159&i=34.01&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6557, 1, 1050, 2, 0, NULL, 0, '2025-01-23 13:56:28', '2025-01-24 08:32:22', '2025-01-24', 'P6166', '25-08012-01-23', '', 0.00, 65.14, 14.11, 0.00, 1, 3.49, 2.50, 'Carlos Caamaño,3, Peluquería ', 'Madrid', 'Madrid', '28016', 'España', 84.81, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-240125-b6j9WMkqLyjqL-051', '19b38c95-2769-49e2-aa79-39264a16c130', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-b6j9WMkqLyjqL-051&s=KOL2025&nf=P6166&i=84.81&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6558, 1, 236, 2, 0, NULL, 0, '2025-01-23 15:19:59', '2025-01-24 08:45:13', '2025-01-24', 'P6160', '25-08013-01-23', '', 0.00, 415.28, 87.21, 0.00, 0, 0.00, 0.00, 'AVDA. DE LA POLICÍA NACIONAL, EDF. DONI IVES, 24', 'Antequera', 'Málaga', '29200', 'España', 502.49, 0, '2025-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240125-YvbTrBJ536tsS-064', 'd39f040c-d0bd-49bd-af6b-90b5314ea175', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-YvbTrBJ536tsS-064&s=KOL2025&nf=P6160&i=502.49&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6559, 1, 1637, 2, 0, NULL, 0, '2025-01-23 16:15:43', '2025-01-24 08:46:27', '2025-01-24', 'P6161', '25-08014-01-23', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Magistrado catalá 24 piso 4 puerta 7', 'Gandia', 'Valencia', '46701', 'España', 17.50, 0, '2025-01-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240125-MvE4KgWf09ZMs-187', '6adddb2a-2a80-4aff-8ee2-3857fb4ba150', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-MvE4KgWf09ZMs-187&s=KOL2025&nf=P6161&i=17.50&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6560, 1, 292, 2, 0, NULL, 0, '2025-01-23 18:22:00', '2025-01-24 09:03:54', '2025-01-24', 'P6162', '25-08015-01-23', 'CONTACTAR AL TELÉFONO 655848478 PARA CONCRETAR HORA DE ENTREGA', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'passeig de la terracuita esc A nº1-5 piso 4º1ªª', 'Barcelona', 'Barcelona', '08850', 'España', 95.98, 0, '2025-01-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240125-adnaohCSghFw+-002', '08315870-4dda-450d-8e00-6d8502d686bd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-adnaohCSghFw%2B-002&s=KOL2025&nf=P6162&i=95.98&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6561, 1, 174, 2, 0, NULL, 0, '2025-01-23 19:21:14', '2025-01-24 09:06:54', '2025-01-24', 'P6163', '25-08016-01-23', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 275.88, 0, '2025-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240125-WHrendFIls9E5-152', '00dcfcf7-6b5b-444c-9519-1f8f7ad64746', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-WHrendFIls9E5-152&s=KOL2025&nf=P6163&i=275.88&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6562, 1, 754, 2, 0, NULL, 0, '2025-01-23 20:09:48', '2025-01-24 09:08:22', '2025-01-24', 'P6164', '25-08017-01-23', '6+1 GRATIS \r\nREGALO RUBIO ARENA\r\nGRACIAS', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166, 2°1°', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2025-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240125-BEbD+BdX2bG7H-013', '7b226f2c-60f8-4d38-b0da-54b0c64acbac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-BEbD%2BBdX2bG7H-013&s=KOL2025&nf=P6164&i=61.64&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6563, 1, 1638, 2, 0, NULL, 0, '2025-01-23 21:36:05', '2025-01-24 09:16:16', '2025-01-24', 'P6165', '25-08018-01-23', '', 0.00, 427.50, 89.78, 0.00, 1, 22.23, 0.00, 'C/Domingo Garcia de la Fuente N/7 Bajo', 'Gijón', 'Asturias', '33205', 'España', 539.51, 0, '2025-01-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240125-X7n2eb/S9cWrR-228', 'd17a6f88-64ae-486b-8a12-68bb0b5ede76', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-X7n2eb%2FS9cWrR-228&s=KOL2025&nf=P6165&i=539.51&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6564, 1, 1638, 2, 1, 'tiene que ir sin recargo de equivalencia', 6563, '2025-01-24 09:17:02', '2025-01-24 09:26:14', '2025-01-24', 'R97', 'P6165 RECT.', '', 0.00, 427.50, 89.78, 0.00, 0, 22.23, 0.00, '', '', '', '', '', 539.51, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-240125-RpvaIEo024+BW-079', '7b45ccc8-374e-4537-8502-fb11c0458ad8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-RpvaIEo024%2BBW-079&s=KOL2025&nf=R97&i=-539.51&cr=234', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 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
(6565, 1, 1638, 1, 0, NULL, 0, '2025-01-24 09:20:47', '2025-01-24 09:27:16', '2025-01-24', 'P6167', '', '', 0.00, 427.50, 89.77, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 517.27, 0, '2025-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240125-VZP4BHz+D4AMb-040', '93be8675-e2df-4db1-a87c-48e3a56d0cf6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-VZP4BHz%2BD4AMb-040&s=KOL2025&nf=P6167&i=517.27&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6566, 1, 118, 1, 0, NULL, 0, '2025-01-24 09:41:24', '2025-01-24 09:41:24', '2025-01-24', 'P6168', '', '', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'C/Amezketa , 7 bajo , peluquería Yulane', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 78.82, 0, '2025-01-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240125-Pw+yJu8EoHbh5-117', 'ece36537-b897-45d2-83ab-4044a30ca03e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-Pw%2ByJu8EoHbh5-117&s=KOL2025&nf=P6168&i=78.81&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6567, 1, 754, 2, 1, 'faltan productos', 6562, '2025-01-24 10:48:45', '2025-01-24 10:48:45', '2025-01-24', 'R98', 'P6164 RECT.', '6+1 GRATIS \r\nREGALO RUBIO ARENA\r\nGRACIAS', 0.00, 48.84, 10.26, 0.00, 0, 2.54, 0.00, '', '', '', '', '', 61.64, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-240125-LUJkElHqwQA2F-229', '305ed081-fd63-422b-b65b-193a9c7bf4de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-LUJkElHqwQA2F-229&s=KOL2025&nf=R98&i=-61.64&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(6568, 1, 754, 1, 0, NULL, 0, '2025-01-24 10:51:36', '2025-01-24 10:51:36', '2025-01-24', 'P6169', '2025-01-24', '', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2025-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240125-ehCmb4Ltq4UlD-233', '09350214-0d33-4733-96df-ca95bdbdb692', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-ehCmb4Ltq4UlD-233&s=KOL2025&nf=P6169&i=61.64&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6569, 1, 1639, 2, 0, NULL, 0, '2025-01-24 11:24:01', '2025-01-24 12:41:07', '2025-01-24', 'P6171', '25-08020-01-24', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Clavel 7', 'Alicante/Alacant', 'Alicante', '03320', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240125-Og780sRmPMCZa-059', '3d4b2bdc-1f4d-4d6a-83b3-4d21f4317482', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-Og780sRmPMCZa-059&s=KOL2025&nf=P6171&i=17.50&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6570, 1, 33, 1, 0, NULL, 0, '2025-01-24 12:38:23', '2025-01-24 12:38:23', '2025-01-24', 'P6170', '', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Medio N 24 bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 103.46, 0, '2025-01-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240125-XxlkOdghBxqs1-089', 'b6b724d5-d770-4f2d-8d1b-489050e20a3a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-XxlkOdghBxqs1-089&s=KOL2025&nf=P6170&i=103.46&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6571, 1, 78, 2, 0, NULL, 0, '2025-01-24 12:05:39', '2025-01-24 13:14:19', '2025-01-24', 'P6172', '25-08021-01-24', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'AVD. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 620.73, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240125-F7gmvYp/+26P4-140', 'b187da4e-6f67-43fc-9f51-56a05053a928', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-F7gmvYp%2F%2B26P4-140&s=KOL2025&nf=P6172&i=620.73&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6572, 1, 306, 2, 0, NULL, 0, '2025-01-24 12:42:37', '2025-01-27 09:50:11', '2025-01-24', 'P6173', '25-08022-01-24', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Puigmoltó 9', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 206.91, 0, '2025-01-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240125-D8gQx0HXd2Cbi-190', 'b98aad83-5c13-4402-ae22-b3a741b8e283', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240125-D8gQx0HXd2Cbi-190&s=KOL2025&nf=P6173&i=206.91&cr=199', '[BLOB]', 0, 'PKANHY071000270B', '2025-01-27 09:50:20', '[BLOB]', 2, '', '2025-01-27', 'S0235', 20, 30, 35, 2400, 0, '', 1, 1);
