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
(6205, 1, 1407, 2, 0, NULL, 0, '2024-12-03 15:28:18', '2024-12-04 08:18:38', '2024-12-04', 'P5832', '24-07614-12-03', 'También pueden entregar el paquete en C/ Castelló nº 3. Gracias', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Carrer de Castelló, 8', 'Gavà', 'Barcelona', '08850', 'España', 56.82, 0, '2024-12-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041224-IBwkxICu03lh9-251', 'e026bb67-6b9a-4010-9dc8-aa9bdc3b9adc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041224-IBwkxICu03lh9-251&s=KOL2024&nf=P5832&i=56.82&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6206, 1, 976, 2, 0, NULL, 0, '2024-12-03 16:12:49', '2024-12-04 08:19:06', '2024-12-04', 'P5833', '24-07615-12-03', 'Peluquería Néstor Savi\r\n', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle Bolivia n1 bajo puerta 3', 'Coruña (A)', 'A Coruña', '15004', 'España', 68.97, 0, '2024-12-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041224-J7ZUU/qmv5/3j-234', '0886c04d-92b8-47f7-9d74-15324a39bc83', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041224-J7ZUU%2Fqmv5%2F3j-234&s=KOL2024&nf=P5833&i=68.97&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6207, 1, 239, 1, 0, NULL, 0, '2024-12-04 11:13:21', '2024-12-04 11:14:04', '2024-12-04', 'P5834', '', '', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'San Marcial 37', 'Donostia', 'Gipuzkoa', '20005', 'España', 113.30, 0, '2024-12-04 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-041224-Lrz72hIWlkmhX-119', '2c75853b-3f7f-413c-9252-0ee774b97fb6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041224-Lrz72hIWlkmhX-119&s=KOL2024&nf=P5834&i=113.30&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6208, 1, 67, 1, 0, NULL, 0, '2024-12-04 11:54:53', '2024-12-04 12:03:25', '2024-12-04', 'P5835', '', '', 0.00, 285.00, 60.28, 0.00, 0, 0.00, 2.50, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 347.35, 0, '2024-12-04 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-041224-ge8H6NUzvtLhk-219', '8dea2708-d42c-4103-b151-6d5b71299e23', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041224-ge8H6NUzvtLhk-219&s=KOL2024&nf=P5835&i=347.35&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6209, 1, 1316, 2, 0, NULL, 0, '2024-12-04 11:10:22', '2024-12-04 12:12:12', '2024-12-04', 'P5836', '24-07627-12-04', 'Cerrado los lunes', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'AVENIDA DE SANTIAGO 18', 'Pino (O)', 'A Coruña', '15821', 'España', 172.43, 0, '2024-12-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041224-V5XeS6y42Wi20-122', '03162aef-bb33-486b-a280-1e44eef4a632', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041224-V5XeS6y42Wi20-122&s=KOL2024&nf=P5836&i=172.43&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6210, 1, 1554, 2, 0, NULL, 0, '2024-12-04 12:16:11', '2024-12-04 13:19:29', '2024-12-04', 'P5837', '24-07628-12-04', 'Chalet', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Italia, 55', 'Valdemoro', 'Madrid', '28341', 'España', 43.71, 0, '2024-12-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-041224-CD2+tjxMhM6c9-071', '447b97fd-ec80-45bd-9a7a-b8865d8ec947', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041224-CD2%2BtjxMhM6c9-071&s=KOL2024&nf=P5837&i=43.71&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
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
(6211, 1, 310, 2, 0, NULL, 0, '2024-12-04 17:10:27', '2024-12-05 07:28:38', '2024-12-05', 'P5838', '24-07629-12-04', 'Os llamé por teléfono para comentaros que he cambiado de dirección. La dirección correcta es la que he más arriba. Para que no haya dudas vuelvo a indicarla aquí de nuevo: \r\nC/José Luis Isasi, 6  3-C (Vitoria-Gasteiz).', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'C/ JOSÉ LUIS ISASI,6  3-C', 'Vitoria-Gasteiz', 'Álava', '01006', 'España', 71.98, 0, '2024-12-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051224-ApMZ+7p24w3U1-066', 'c56ba57a-dfa6-405a-a8a3-3a1373c4128c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051224-ApMZ%2B7p24w3U1-066&s=KOL2024&nf=P5838&i=71.98&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6212, 1, 304, 2, 0, NULL, 0, '2024-12-04 17:53:18', '2024-12-10 12:16:51', '2024-12-10', 'P5862', '24-07630-12-04', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Bersolari Txirrita ñ5 4°C', 'Donostia-San Sebasti', 'Gipuzkoa', '20017', 'España', 71.98, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101224-Q6ykASdeSsRvQ-097', '272b89b5-a400-4442-8c2f-215a33c20491', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101224-Q6ykASdeSsRvQ-097&s=KOL2024&nf=P5862&i=71.98&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6213, 1, 1555, 2, 0, NULL, 0, '2024-12-04 19:20:46', '2024-12-05 12:05:59', '2024-12-05', 'P5839', '24-07631-12-04', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Constitución 47B 14', 'Torrent', 'Valencia', '46900', 'España', 30.61, 0, '2024-12-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051224-fH7x0jpr53eaP-100', '5485fd04-ff4f-4b76-97cc-72f48e29f367', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051224-fH7x0jpr53eaP-100&s=KOL2024&nf=P5839&i=30.61&cr=182', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6214, 1, 696, 1, 0, NULL, 0, '2024-12-05 07:31:16', '2024-12-05 10:11:37', '2024-12-05', 'P5840', '', '', 0.00, 514.80, 108.11, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 622.91, 0, '2024-12-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-051224-DbI4Sdyh0H81F-148', '66ab635c-c732-46ba-be5b-8f5fdafcd2c9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051224-DbI4Sdyh0H81F-148&s=KOL2024&nf=P5840&i=622.91&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6215, 1, 77, 1, 1, 'faltan artículos', 6203, '2024-12-05 09:26:30', '2024-12-05 09:26:30', '2024-12-05', 'R95', 'P5830 RECT.', '', 0.00, 519.09, 109.01, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 628.10, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-051224-CoJt9i/DmQE8i-133', '197a6911-05a1-4c17-b025-02ac1d36a427', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051224-CoJt9i%2FDmQE8i-133&s=KOL2024&nf=R95&i=-628.10&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(6216, 1, 77, 1, 0, NULL, 0, '2024-12-05 09:32:12', '2024-12-05 09:32:12', '2024-12-05', 'P5841', '', '', 0.00, 561.99, 118.02, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 680.01, 0, '2024-12-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-051224-LuO9jd7nfwxV3-192', '3414cf90-c466-4f5b-8418-61a2d2076d76', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051224-LuO9jd7nfwxV3-192&s=KOL2024&nf=P5841&i=680.01&cr=130', '[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
(6217, 1, 1404, 2, 0, NULL, 0, '2024-12-05 08:45:53', '2024-12-05 10:13:06', '2024-12-05', 'P5843', '24-07633-12-05', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Avenida de Marín Nº 5   3º G', 'Pontevedra', 'Pontevedra', '36003', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-051224-Gr3pQQhAVvM2i-040', 'a0c97857-71fc-4f86-b99d-2cbe0e50a360', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051224-Gr3pQQhAVvM2i-040&s=KOL2024&nf=P5843&i=33.11&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6218, 1, 1421, 2, 0, NULL, 0, '2024-12-05 08:46:13', '2024-12-05 10:13:43', '2024-12-05', 'P5842', '24-07632-12-05', 'Piel de Artemisa ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Juan XXIII, 6, Bajo', 'Logroño', 'La Rioja', '26003', 'España', 30.61, 0, '2024-12-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-051224-FVFaCfhU+72XI-103', 'add272e4-31fc-4406-b75e-4dc1e13ffb5f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051224-FVFaCfhU%2B72XI-103&s=KOL2024&nf=P5842&i=30.61&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6219, 1, 0, 5, 0, NULL, 0, '2024-12-05 10:01:13', '2024-12-05 10:01:13', '2024-12-05', '', 'muestroteca', '', 0.00, 10.83, 2.27, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 13.10, 0, '2024-12-05 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),
(6220, 1, 1556, 2, 0, NULL, 0, '2024-12-05 20:11:02', '2024-12-08 08:23:12', '2024-12-08', 'P5844', '24-07634-12-05', 'Dejar en el buzon', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo Berio 11 2B', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 17.50, 0, '2024-12-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-081224-XfJuleiY8LnTq-029', '7aff4094-6a24-4527-a125-7a32ff2e0b9c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081224-XfJuleiY8LnTq-029&s=KOL2024&nf=P5844&i=17.50&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6221, 1, 1557, 2, 0, NULL, 0, '2024-12-06 11:12:50', '2024-12-08 08:24:12', '2024-12-08', 'P5845', '24-07635-12-06', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Parque Arturo Leon, A2, 3°D', 'Valladolid', 'Valladolid', '47008', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-081224-SONQS+ahaRWTP-122', 'b33b739b-368f-4ffd-8cdd-da07a3f45229', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081224-SONQS%2BahaRWTP-122&s=KOL2024&nf=P5845&i=33.11&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6222, 1, 172, 2, 0, NULL, 0, '2024-12-07 16:10:40', '2024-12-08 08:24:47', '2024-12-08', 'P5846', '24-07636-12-07', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Soldevila, 6 baixos', 'Tremp', 'Lleida', '25620', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-081224-AVJlcBbhVh/tx-113', '37296b5d-2fae-4332-9d1e-d3dd5286679b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081224-AVJlcBbhVh%2Ftx-113&s=KOL2024&nf=P5846&i=68.97&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6223, 1, 1558, 2, 0, NULL, 0, '2024-12-08 12:15:36', '2024-12-09 09:11:54', '2024-12-09', 'P5851', '24-07637-12-08', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Avda V Centenario, 28 bajo A', 'Sanlúcar de Barramed', 'Cádiz', '11540', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-091224-c+fQtxeoZBE+M-245', '76d9bf5c-d280-4b76-98fb-e80799f6106a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-c%2BfQtxeoZBE%2BM-245&s=KOL2024&nf=P5851&i=33.11&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6224, 1, 1559, 2, 0, NULL, 0, '2024-12-08 15:00:30', '2024-12-09 09:12:32', '2024-12-09', 'P5847', '24-07638-12-08', 'La dirección pertenece a una pedanía que pertenece al municipio de humilladero pero no está en humilladero. Si ponen en el GPS el código postal y los Carvajales les traerá sin problemas. ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Santillán 1, 1', 'Humilladero', 'Málaga', '29533', 'España', 28.39, 0, '2024-12-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091224-PJmpY+a45Ite0-238', '687634b4-8465-4ef9-a804-ad117f8a7f35', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-PJmpY%2Ba45Ite0-238&s=KOL2024&nf=P5847&i=28.39&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6225, 1, 388, 2, 0, NULL, 0, '2024-12-08 17:22:21', '2024-12-09 09:17:08', '2024-12-09', 'P5848', '24-07639-12-08', 'Entrega por la tarde', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Calle León Felipe, nº 27, 7ºE', 'Zaragoza', 'Zaragoza', '50018', 'España', 52.39, 0, '2024-12-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091224-dD/y2DehBf6w4-232', 'dfff8009-882b-4f36-84a1-2525b86b582d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-dD%2Fy2DehBf6w4-232&s=KOL2024&nf=P5848&i=52.39&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6226, 1, 108, 2, 0, NULL, 0, '2024-12-08 17:29:43', '2024-12-09 09:18:08', '2024-12-09', 'P5852', '24-07640-12-08', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-091224-ZuwiSe3DxQ66u-067', 'ff1875a9-99cd-48e4-98e2-104c16f3a1ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-ZuwiSe3DxQ66u-067&s=KOL2024&nf=P5852&i=137.94&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6227, 1, 240, 2, 0, NULL, 0, '2024-12-08 18:29:03', '2024-12-09 09:42:48', '2024-12-09', 'P5849', '24-07641-12-08', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Elkano 35, bajo', 'Hernani', 'Gipuzkoa', '20120', 'ESPAÑA', 103.46, 0, '2024-12-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-091224-ZIJjTlg7XIz/a-058', 'c2bd466f-4436-4c31-a90e-381a9f91499d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-ZIJjTlg7XIz%2Fa-058&s=KOL2024&nf=P5849&i=103.46&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6228, 1, 1561, 2, 0, NULL, 0, '2024-12-08 20:26:02', '2024-12-09 09:19:31', '2024-12-09', 'P5850', '24-07642-12-08', 'Es una casa', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'calle Torralba de Calatrava 10', 'Ciudad Real', 'Ciudad Real', '13005', 'España', 28.39, 0, '2024-12-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091224-NxRxwSf0LX0BB-062', 'bf5e4c62-9905-480b-a421-884917303d63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-NxRxwSf0LX0BB-062&s=KOL2024&nf=P5850&i=28.39&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6229, 1, 23, 2, 0, NULL, 0, '2024-12-09 10:31:05', '2024-12-09 11:58:22', '2024-12-09', 'P5853', '24-07643-12-09', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 137.94, 0, '2024-12-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091224-fYYxpJBx0VIfV-038', 'fb426839-7f01-4a0d-a0e0-d3390c7a88df', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-fYYxpJBx0VIfV-038&s=KOL2024&nf=P5853&i=137.94&cr=171', '[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
(6230, 1, 4, 2, 0, NULL, 0, '2024-12-09 10:55:23', '2024-12-09 11:59:25', '2024-12-09', 'P5854', '24-07644-12-09', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 310.37, 0, '2024-12-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091224-RQqZT7sA3U8V2-208', '95db6b54-2826-4904-a610-4474919dfdf5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-RQqZT7sA3U8V2-208&s=KOL2024&nf=P5854&i=310.37&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6231, 1, 152, 1, 0, NULL, 0, '2024-12-09 12:06:07', '2024-12-09 12:19:57', '2024-12-09', 'P5855', '', '', 0.00, 265.98, 55.86, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 321.84, 0, '2024-12-09 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-091224-DOgP3wfVfTEcE-103', '0b0f687a-23b5-41d5-92b2-988c31d0950e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-DOgP3wfVfTEcE-103&s=KOL2024&nf=P5855&i=321.83&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6232, 1, 686, 2, 0, NULL, 0, '2024-12-09 12:17:51', '2024-12-09 13:23:50', '2024-12-09', 'P5856', '24-07647-12-09', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'calle del parque . 3 UDARA peluqueria ', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 241.40, 0, '2024-12-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-091224-ZomrRZqerDUMh-067', '6c930c4d-e31a-49c6-844c-1be53211f8ab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091224-ZomrRZqerDUMh-067&s=KOL2024&nf=P5856&i=241.40&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6233, 1, 190, 3, 0, NULL, 0, '2024-12-09 13:22:50', '2024-12-16 12:23:20', '2024-12-09', '', 'Consumo interno', '', 0.00, 17424.00, 999.99, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 21083.04, 0, '2024-12-09 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),
(6234, 1, 1562, 2, 0, NULL, 0, '2024-12-09 20:48:02', '2024-12-10 09:06:49', '2024-12-10', 'P5857', '24-07648-12-09', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/julian baena de castro, nº 4, 3º IZD', 'Alcobendas', 'Madrid', '28100', 'España', 17.50, 0, '2024-12-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101224-G0B1AVl1HTzfr-206', '0a7a2340-9154-496b-b455-2c59141add5f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101224-G0B1AVl1HTzfr-206&s=KOL2024&nf=P5857&i=17.50&cr=247', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6235, 1, 1477, 2, 0, NULL, 0, '2024-12-10 07:01:13', '2024-12-10 09:11:35', '2024-12-10', 'P5858', '24-07649-12-10', 'Clínica Crea ', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Carrer de Sant Martí, 4, Bajo', 'Valencia', 'Valencia', '46003', 'España', 71.98, 0, '2024-12-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101224-BCU514ANrx56X-042', 'cf612604-bc6a-456b-bce6-c56d5ca10de3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101224-BCU514ANrx56X-042&s=KOL2024&nf=P5858&i=71.98&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6236, 1, 1563, 2, 0, NULL, 0, '2024-12-10 08:33:58', '2024-12-10 09:34:37', '2024-12-10', 'P5859', '24-07595-11-29', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle del Corazón de María, 13, 2-B', 'Madrid', 'Madrid', '28002', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101224-Bh20pOfSXcvrG-081', '56a60a96-b343-425a-a5da-9a14b23fdeb7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101224-Bh20pOfSXcvrG-081&s=KOL2024&nf=P5859&i=30.61&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
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
(6237, 1, 1174, 2, 0, NULL, 0, '2024-12-10 10:06:55', '2024-12-10 12:04:07', '2024-12-10', 'P5860', '24-07650-12-10', '', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'C/Bizkaia N10 2D', 'Zarautz', 'Gipuzkoa', '20800', 'España', 95.98, 0, '2024-12-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101224-di0u3Rx6k8Oya-110', 'e5a632e4-d60d-4353-857e-1d742f6d4f53', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101224-di0u3Rx6k8Oya-110&s=KOL2024&nf=P5860&i=95.98&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6238, 1, 1564, 2, 0, NULL, 0, '2024-12-10 10:18:11', '2024-12-10 11:58:39', '2024-12-10', 'P5861', '24-07651-12-10', '', 0.00, 43.32, 10.29, 0.00, 0, 0.00, 6.90, 'Calle legia 45 bajo izquierda', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 59.32, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-101224-Tcdaic8eU+WkV-076', '2b4b17a8-8079-4dee-9cb2-5c6fde3a436e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101224-Tcdaic8eU%2BWkV-076&s=KOL2024&nf=P5861&i=59.32&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6239, 1, 391, 2, 0, NULL, 0, '2024-12-10 12:04:13', '2024-12-10 13:07:24', '2024-12-10', 'P5863', '24-07652-12-10', 'Lunes y jueves por tarde cerrado \r\nNo entregar a otra persona ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Paseo Santxiki num14 ', 'Pamplona/Iruña', 'Navarra', '31192', 'España', 137.94, 0, '2024-12-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-101224-gBPmxt64IFHB7-128', 'b3c8cd8c-3b03-4168-90c1-5ded3420d0bf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101224-gBPmxt64IFHB7-128&s=KOL2024&nf=P5863&i=137.94&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6240, 1, 1535, 2, 0, NULL, 0, '2024-12-10 15:38:42', '2024-12-11 09:08:52', '2024-12-11', 'P5864', '24-07653-12-10', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Bustamante 43, 1C', 'Madrid', 'Madrid', '28045', 'España', 17.50, 0, '2024-12-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-111224-ecU83dbTUp0nu-055', 'f8987284-d7af-4f49-964a-84008efeb97d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-ecU83dbTUp0nu-055&s=KOL2024&nf=P5864&i=17.50&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6241, 1, 10, 2, 0, NULL, 0, '2024-12-10 15:49:56', '2024-12-11 09:10:29', '2024-12-11', 'P5865', '24-07654-12-10', '', 0.00, 260.56, 54.72, 0.00, 0, 0.00, 0.00, 'Agirre auzunea 1 behea', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 315.28, 0, '2024-12-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-UYvRoStUysSiV-225', '9bd2020c-1355-4182-a718-4b0b688f98fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-UYvRoStUysSiV-225&s=KOL2024&nf=P5865&i=315.27&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6242, 1, 1565, 2, 0, NULL, 0, '2024-12-10 16:16:15', '2024-12-11 09:12:20', '2024-12-11', 'P5866', '24-07657-12-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Plaza Pablo Iglesias 7, 2F', 'Torrelavega', 'Cantabria', '39300', 'España', 30.61, 0, '2024-12-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-gnSdzZzdRMiFu-052', 'b1180d41-a85a-41d8-9b46-76e7e52b4317', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-gnSdzZzdRMiFu-052&s=KOL2024&nf=P5866&i=30.61&cr=208', '[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
(6243, 1, 794, 2, 0, NULL, 0, '2024-12-10 16:24:06', '2024-12-11 09:13:35', '2024-12-11', 'P5873', '24-07658-12-10', '', 0.00, 150.64, 32.07, 0.00, 0, 0.00, 2.50, 'Idoia 4 bajo', 'Zizur Mayor/Zizur Na', 'Navarra', '31180', 'España', 184.77, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-111224-SYhMXBCjQYMVE-094', '0ab24529-d74d-4443-9495-6849d8301ec7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-SYhMXBCjQYMVE-094&s=KOL2024&nf=P5873&i=184.77&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6244, 1, 174, 2, 0, NULL, 0, '2024-12-10 18:39:46', '2024-12-11 09:57:34', '2024-12-11', 'P5867', '24-07659-12-10', 'Hola ,he visto que no tenéis rubio extra claro disponible .\r\nMe hacia falta , me lo podríais enviar aunque sea en el envase de 100ml?', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 172.43, 0, '2024-12-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-baJDWUMqFuADO-127', 'e989aa02-cef3-47ae-b804-2f01c6ea5ddf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-baJDWUMqFuADO-127&s=KOL2024&nf=P5867&i=172.43&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6245, 1, 693, 2, 0, NULL, 0, '2024-12-10 18:45:18', '2024-12-11 09:15:50', '2024-12-11', 'P5868', '24-07660-12-10', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Gran Vía 45, 3ª planta (SRB)', 'Bilbao', 'Bizkaia', '48011', 'España', 17.50, 0, '2024-12-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-XLJ2BJck6KKWq-022', 'a559bb0e-aea1-4543-a02e-5885decf351f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-XLJ2BJck6KKWq-022&s=KOL2024&nf=P5868&i=17.50&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6246, 1, 30, 2, 0, NULL, 0, '2024-12-10 20:43:38', '2024-12-11 09:18:17', '2024-12-11', 'P5869', '24-07661-12-10', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Calle González tablas, 3 bajo', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 206.91, 0, '2024-12-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-eo3xKEwyZ89q+-230', '990b02e8-a667-422d-85ac-eb369095168c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-eo3xKEwyZ89q%2B-230&s=KOL2024&nf=P5869&i=206.91&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6247, 1, 1566, 2, 0, NULL, 0, '2024-12-10 20:59:49', '2024-12-11 09:23:45', '2024-12-11', 'P5870', '24-07664-12-10', 'Lanon Caldereria', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Polígono industrial sansinena erreka', 'Zestoa', 'Gipuzkoa', '20749', 'España', 30.61, 0, '2024-12-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-cd9X4SipfeTFX-064', '58426dfc-4ea6-433f-bba2-360c543f8307', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-cd9X4SipfeTFX-064&s=KOL2024&nf=P5870&i=30.61&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6248, 1, 1567, 2, 0, NULL, 0, '2024-12-10 21:18:17', '2024-12-11 09:26:39', '2024-12-11', 'P5871', '24-07665-12-10', 'LARRAZ ASESORES. lunes a viernes 8 a 16', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'C/Pedro I 25 bajo', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 52.39, 0, '2024-12-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-VbEItlG7Qp7an-112', 'fb88595e-8ad4-451f-8af0-2c2b6a0e6c1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-VbEItlG7Qp7an-112&s=KOL2024&nf=P5871&i=52.39&cr=091', '[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
(6249, 1, 1568, 2, 0, NULL, 0, '2024-12-11 08:03:28', '2024-12-11 09:27:14', '2024-12-11', 'P5872', '24-07667-12-11', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Ángel postigo mejias, 6 - 5B', 'Pamplona/Iruña', 'Navarra', '31016', 'España', 17.50, 0, '2024-12-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-A8BLl1OL5uqnC-136', '169164e3-4f1c-4145-87e5-cd24d30f34a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-A8BLl1OL5uqnC-136&s=KOL2024&nf=P5872&i=17.50&cr=229', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6250, 1, 30, 1, 0, NULL, 0, '2024-12-11 09:19:30', '2024-12-11 09:19:59', '2024-12-11', 'P5874', '', '', 0.00, 44.78, 9.40, 0.00, 0, 0.00, 0.00, 'Calle González tablas, 3 bajo', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 54.18, 0, '2024-12-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111224-LRlaHqQfmJCmJ-122', '4fa5fef3-4f9b-46fb-9931-9e9acbc91fb5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-LRlaHqQfmJCmJ-122&s=KOL2024&nf=P5874&i=54.18&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6251, 1, 1430, 1, 0, NULL, 0, '2024-12-11 09:32:51', '2024-12-11 09:32:51', '2024-12-11', 'P5875', '', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Carrer Rei en Jaume 90, bajo', 'Vila-real', 'Castellón', '12540', 'España', 103.46, 0, '2024-12-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111224-Oa6MTokJsVEfD-138', 'eb30bfd9-f8c4-440e-b191-f04a8a9cbe33', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-Oa6MTokJsVEfD-138&s=KOL2024&nf=P5875&i=103.46&cr=197', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6252, 1, 1158, 2, 0, NULL, 0, '2024-12-11 09:20:50', '2024-12-11 10:21:54', '2024-12-11', 'P5876', '24-07668-12-11', 'Peluquería Marai', 0.00, 65.12, 13.68, 0.00, 0, 0.00, 0.00, 'Republica argentina 3, bajo 2', 'Irun', 'Gipuzkoa', '20302', 'España', 78.80, 0, '2024-12-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-Zzg7vZLcQcdVz-232', 'facad23b-4cf0-48d5-add3-80022d41490f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-Zzg7vZLcQcdVz-232&s=KOL2024&nf=P5876&i=78.80&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6253, 1, 1569, 2, 0, NULL, 0, '2024-12-11 09:36:02', '2024-12-11 10:41:21', '2024-12-11', 'P5877', '24-07669-12-11', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Jorge Oteiza 3 -1°A', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 17.50, 0, '2024-12-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-b1oz7nXxUrCol-196', '881793e1-2beb-431a-91ee-e1060aa7c14a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-b1oz7nXxUrCol-196&s=KOL2024&nf=P5877&i=17.50&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6254, 1, 1423, 1, 0, NULL, 0, '2024-12-11 13:01:40', '2024-12-11 13:01:40', '2024-12-11', 'P5878', '', '', 0.00, 443.38, 93.11, 0.00, 0, 0.00, 0.00, 'General eguia frente al 31', 'Bilbao', 'Bizkaia', '48013', 'España', 536.49, 0, '2024-12-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111224-EKyMBlK6XHgeg-073', 'df6f9997-f997-4241-9434-62b57b697877', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-EKyMBlK6XHgeg-073&s=KOL2024&nf=P5878&i=536.49&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6255, 1, 244, 2, 0, NULL, 0, '2024-12-11 12:25:25', '2024-12-11 13:29:46', '2024-12-11', 'P5879', '24-07670-12-11', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'C/ Balmes, 79 Local 3', 'Calella', 'Barcelona', '08370', 'España', 103.46, 0, '2024-12-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111224-QUJ4O5+IMPJzL-132', 'bfb0b6b5-d760-4f22-a4be-99eabaeece78', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111224-QUJ4O5%2BIMPJzL-132&s=KOL2024&nf=P5879&i=103.46&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6256, 1, 75, 2, 0, NULL, 0, '2024-12-11 14:43:42', '2024-12-12 09:28:49', '2024-12-12', 'P5880', '24-07671-12-11', 'De martes a viernes de 10:00 a 19:00', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 172.43, 0, '2024-12-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121224-JYMWi4qYZFW38-180', '7649afcd-6350-4f2c-915d-8fa867d19dca', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121224-JYMWi4qYZFW38-180&s=KOL2024&nf=P5880&i=172.43&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6257, 1, 754, 2, 0, NULL, 0, '2024-12-11 15:53:36', '2024-12-12 09:29:50', '2024-12-12', 'P5881', '24-07672-12-11', '6+1 regalo 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, '2024-12-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121224-AnW7oTwOw8YL6-124', '76afbd26-0d70-4166-b201-434991e87927', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121224-AnW7oTwOw8YL6-124&s=KOL2024&nf=P5881&i=61.64&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6258, 1, 94, 2, 0, NULL, 0, '2024-12-12 09:35:40', '2024-12-12 10:38:01', '2024-12-12', 'P5882', '24-07676-12-12', '', 0.00, 232.06, 48.73, 0.00, 0, 0.00, 0.00, 'C/mayor número 11', 'Ausejo', 'La Rioja', '26513', 'España', 280.79, 0, '2024-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121224-Y0vWf6tatcvGN-048', 'f1f0e66c-a882-46ff-92d3-f195fb389c8e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121224-Y0vWf6tatcvGN-048&s=KOL2024&nf=P5882&i=280.79&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6259, 1, 678, 2, 0, NULL, 0, '2024-12-12 09:58:17', '2024-12-12 11:47:15', '2024-12-12', 'P5883', '24-07677-12-12', '', 0.00, 19.83, 5.36, 0.00, 0, 0.00, 6.90, 'Carre Cort De Cádiz ', 'Castelldefels', 'Barcelona', '08860', 'España', 30.89, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-121224-IzXoQuMS0zEih-235', '0bc7ff8d-cd64-43a9-932e-5ff4e70bf834', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121224-IzXoQuMS0zEih-235&s=KOL2024&nf=P5883&i=30.89&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6260, 1, 991, 2, 0, NULL, 0, '2024-12-12 11:02:23', '2024-12-12 12:15:52', '2024-12-12', 'P5884', '24-07678-12-12', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'C/ Doctor Marañón 12', 'Almonte', 'Huelva', '21730', 'España', 206.91, 0, '2024-12-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121224-Z7bcl4BprtHlu-050', 'bb0086db-1955-4c60-a079-fe7f290e92f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121224-Z7bcl4BprtHlu-050&s=KOL2024&nf=P5884&i=206.91&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
