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
(4003, 1, 23, 2, 0, NULL, 0, '2023-10-30 08:04:41', '2023-10-30 11:53:40', '2023-10-30', 'P3762', '23-05245-10-30', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 172.43, 0, '2023-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301023-BRVPXrvqZCgHS-217', '000637cb-74f4-4a4a-b3c7-f441d0c3ea62', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301023-BRVPXrvqZCgHS-217&s=KOL2023&nf=P3762&i=172.43&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4004, 1, 0, 4, 0, NULL, 0, '2023-10-30 10:41:23', '2023-10-30 10:41:23', '2023-10-30', '', 'PROMOCIÓN', '', 0.00, 10.83, 2.27, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 13.10, 0, '2023-10-30 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),
(4005, 1, 474, 1, 0, NULL, 0, '2023-10-30 11:31:07', '2023-10-30 11:31:07', '2023-10-30', 'P3751', '', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'C Ntra Sra de los clarines 56', 'Beas', 'Huelva', '21630', 'España', 157.64, 0, '2023-10-30 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-261023-T+lCyPYoWyFIz-122', '783343db-63fd-4e83-95a5-fc1a5dc9452d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261023-T%2BlCyPYoWyFIz-122&s=KOL2023&nf=P3751&i=157.63&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4006, 1, 474, 1, 1, 'Confusión artículos', 4005, '2023-10-30 11:49:23', '2023-10-30 11:49:23', '2023-10-30', 'R57', 'P3751 RECT.', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 157.64, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-301023-bmduoWmkQVBpN-217', '27d6df63-4e02-47d0-9c8c-3196454c69d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301023-bmduoWmkQVBpN-217&s=KOL2023&nf=R57&i=-157.63&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4007, 1, 1016, 2, 0, NULL, 0, '2023-10-30 11:34:42', '2023-10-30 12:46:24', '2023-10-30', 'P3763', '23-05246-10-30', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle el pinar 4', 'Puçol', 'Valencia', '46530', 'España', 28.39, 0, '2023-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301023-DO14zVn3tZRMa-145', '94597f83-301c-434b-965f-1d0366f3bfb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301023-DO14zVn3tZRMa-145&s=KOL2023&nf=P3763&i=28.39&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4008, 1, 1017, 2, 0, NULL, 0, '2023-10-30 13:02:33', '2023-10-30 15:24:52', '2023-10-30', 'P3764', '23-05247-10-30', '', 0.00, 54.15, 13.97, 0.00, 0, 0.00, 15.00, '13 rue travot', 'Cholet', 'Maine-et-Loire', '49300', 'Francia', 81.29, 0, '2023-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301023-cZ9eOCBkk4Tim-137', '48a6fdf6-2117-4214-ae89-2a00c764b467', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301023-cZ9eOCBkk4Tim-137&s=KOL2023&nf=P3764&i=81.29&cr=010', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4009, 1, 862, 2, 1, 'La clienta devuelve el pedido por no tener dinero para realizar el pago por contrareembolso', 3953, '2023-10-30 16:21:16', '2024-03-20 11:36:34', '2023-10-30', 'R58', 'P3717 RECT.', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, '', '', '', '', '', 20.00, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4010, 1, 1018, 2, 0, NULL, 0, '2023-10-30 17:05:41', '2023-10-31 09:00:14', '2023-10-30', 'P3765', '23-05248-10-30', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'calle camino 5 piso 2C, 20004', 'Donostia-San Sebasti', 'Gipuzkoa', '20002', 'España', 28.39, 0, '2023-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301023-oJVJ00LY9dHm7-183', 'd159db52-87bc-4c88-a2c6-88d589bb75a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301023-oJVJ00LY9dHm7-183&s=KOL2023&nf=P3765&i=28.39&cr=052', '[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
(4011, 1, 868, 2, 0, NULL, 0, '2023-10-30 18:04:28', '2023-10-31 09:03:13', '2023-10-30', 'P3766', '23-05249-10-30', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Jordi Pujol 9', 'Benavent de Segrià', 'Lleida', '25132', 'España', 43.71, 0, '2023-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301023-bLXwXc72GgJAM-040', '8d2f20f4-734c-4dbe-ad63-af6058285a3c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301023-bLXwXc72GgJAM-040&s=KOL2023&nf=P3766&i=43.71&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4012, 1, 1019, 2, 0, NULL, 0, '2023-10-30 18:36:41', '2023-10-31 09:05:48', '2023-10-30', 'P3767', '23-05250-10-30', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Antonio Fernández Molina 10 1.A', 'Zaragoza', 'Zaragoza', '50016', 'España', 17.50, 0, '2023-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301023-QS60W70vj849D-150', '67f1acbe-82ef-4558-8b48-07e11c7a23d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301023-QS60W70vj849D-150&s=KOL2023&nf=P3767&i=17.50&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4013, 1, 1020, 2, 0, NULL, 0, '2023-10-30 21:45:15', '2023-10-31 09:09:22', '2023-10-30', 'P3768', '23-05251-10-30', 'Llamar antes de entregar', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'C/ Pescaderia 14', 'Donostia-San Sebasti', 'Gipuzkoa', '20003', 'España', 196.56, 0, '2023-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301023-RKRuG+E8HpEL4-025', '00944327-932d-4aad-9653-6907890a24ae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301023-RKRuG%2BE8HpEL4-025&s=KOL2023&nf=P3768&i=196.56&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4014, 1, 1020, 2, 0, NULL, 0, '2023-10-30 21:50:03', '2023-10-31 09:11:45', '2023-10-30', 'P3769', '23-05252-10-30', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/ Pescaderia 14', 'Donostia-San Sebasti', 'Gipuzkoa', '20003', 'España', 137.94, 0, '2023-10-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301023-bppGOKyWj6e1+-146', '82e22534-d58a-45de-b460-cd9f4b8ba145', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301023-bppGOKyWj6e1%2B-146&s=KOL2023&nf=P3769&i=137.94&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4015, 1, 838, 2, 0, NULL, 0, '2023-10-31 05:28:18', '2023-10-31 09:15:47', '2023-10-31', 'P3770', '23-05255-10-31', 'En caso de ausencia entregar en portería ', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Gaztañeta 1, 2d', 'Bilbao', 'Bizkaia', '48012', 'España', 61.09, 0, '2023-10-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-311023-fb3O7rpYJsAcH-218', '06d5f5a6-76fd-4d6d-a6aa-a7a6280673f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311023-fb3O7rpYJsAcH-218&s=KOL2023&nf=P3770&i=61.09&cr=110', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4016, 1, 1007, 2, 0, NULL, 0, '2023-10-31 13:18:51', '2023-11-02 08:39:21', '2023-10-31', 'P3771', '23-05257-10-31', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Las Violetas, 56', 'Cáceres', 'Cáceres', '10004', 'España', 17.50, 0, '2023-10-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-311023-b0FYtckPAHcHq-113', '13343c34-962e-4c00-ab8e-c1e6c6922fe7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311023-b0FYtckPAHcHq-113&s=KOL2023&nf=P3771&i=17.50&cr=022', '[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
(4017, 1, 160, 2, 0, NULL, 0, '2023-10-31 13:29:57', '2023-11-02 08:41:05', '2023-10-31', 'P3772', '23-05258-10-31', '', 0.00, 138.42, 29.07, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 167.49, 0, '2023-10-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-311023-Vet3YYx6WwM80-047', 'be989e98-f28f-4628-9846-8ba60671e28a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311023-Vet3YYx6WwM80-047&s=KOL2023&nf=P3772&i=167.49&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4018, 1, 240, 2, 0, NULL, 0, '2023-10-31 15:11:57', '2023-11-02 08:53:42', '2023-10-31', 'P3773', '23-05260-10-31', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'Elkano 35, bajo', 'Hernani', 'Gipuzkoa', '20120', 'ESPAÑA', 147.79, 0, '2023-10-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-311023-olCa1UgE7C3N8-218', 'd7357d9f-a864-4d83-b60c-ae1870656bbf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311023-olCa1UgE7C3N8-218&s=KOL2023&nf=P3773&i=147.79&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4019, 1, 941, 2, 0, NULL, 0, '2023-10-31 15:24:23', '2023-11-02 08:48:06', '2023-10-31', 'P3774', '23-05261-10-31', 'Si no estuviera en casa dejar en portería all conserje gracias', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Limonita n.7, 3C', 'Madrid', 'Madrid', '28021', 'España', 30.61, 0, '2023-10-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-311023-GZsijufjo4MbH-223', 'ce7411d4-2c9a-4ecf-bdd1-87473c11bc91', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-311023-GZsijufjo4MbH-223&s=KOL2023&nf=P3774&i=30.61&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4020, 1, 138, 2, 0, NULL, 0, '2023-11-01 16:55:33', '2023-11-02 08:51:47', '2023-11-01', 'P3775', '23-05262-11-01', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Carretera Valladares 382', 'Vigo', 'Pontevedra', '36315', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-011123-RrrQ+lcgWWhLy-170', '54b177d0-aace-4d9a-8979-ae065ac19881', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011123-RrrQ%2BlcgWWhLy-170&s=KOL2023&nf=P3775&i=206.91&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4021, 1, 1021, 2, 0, NULL, 0, '2023-11-02 10:20:22', '2023-11-02 11:24:08', '2023-11-02', 'P3776', '23-05263-11-02', '', 0.00, 32.49, 8.02, 0.00, 0, 0.00, 6.90, 'Calle El Tajo nº 7', 'Benalup-Casas Viejas', 'Cádiz', '11190', 'España', 46.21, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-021123-KzlETRgX5aNJf-192', 'c80ee151-9f81-4ac6-88e5-310dc1149531', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-KzlETRgX5aNJf-192&s=KOL2023&nf=P3776&i=46.21&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4022, 1, 1021, 2, 0, NULL, 0, '2023-11-02 10:20:25', '2023-11-02 10:20:25', '2023-11-02', '', '23-05264-11-02', NULL, 0.00, 32.49, 8.02, 0.00, 0, 0.00, 6.90, 'Calle El Tajo nº 7', 'Benalup-Casas Viejas', 'Cádiz', '11190', 'España', 46.21, 0, '0000-00-00 00:00:00', '', '', 1, 4, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4023, 1, 154, 2, 0, NULL, 0, '2023-11-02 11:53:09', '2023-11-02 13:02:03', '2023-11-02', 'P3777', '23-05265-11-02', '', 0.00, 150.64, 31.63, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 182.27, 0, '2023-11-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021123-LjJ6nFGRUqudQ-106', 'e796bea0-41ad-40ee-9596-e7000bf46b09', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-LjJ6nFGRUqudQ-106&s=KOL2023&nf=P3777&i=182.27&cr=001', '[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
(4024, 1, 898, 2, 0, NULL, 0, '2023-11-02 12:39:05', '2023-11-03 09:13:07', '2023-11-02', 'P3778', '23-05266-11-02', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'beato tomas de zumarraga n2 3C', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 17.50, 0, '2023-11-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021123-QAmtqSXg0p91c-113', '0d98df15-c78b-4641-81e9-80b0247e10f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-QAmtqSXg0p91c-113&s=KOL2023&nf=P3778&i=17.50&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4025, 1, 1022, 2, 0, NULL, 0, '2023-11-02 13:13:05', '2023-11-03 09:22:21', '2023-11-02', 'P3779', '23-05267-11-02', 'La Torre de Atotxa.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Duque De Mandas 30, ', 'Donostia-San Sebasti', 'Gipuzkoa', '20012', 'España', 17.50, 0, '2023-11-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021123-KgjFUpBct9pRa-048', 'e7dc8e04-edc2-492b-98f0-346bdb14de76', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-KgjFUpBct9pRa-048&s=KOL2023&nf=P3779&i=17.50&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4026, 1, 568, 2, 0, NULL, 0, '2023-11-02 13:50:05', '2023-11-03 09:36:24', '2023-11-02', 'P3780', '23-05268-11-02', 'peluquería el marco blanco', 0.00, 28.50, 6.75, 0.00, 0, 0.00, 4.40, 'larramendi 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 38.89, 0, '2023-11-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021123-OqbnECXNLYuUK-159', '0cac5c70-1fe4-47f1-a7e1-fa3397f07766', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-OqbnECXNLYuUK-159&s=KOL2023&nf=P3780&i=38.89&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4027, 1, 17, 2, 0, NULL, 0, '2023-11-02 14:34:05', '2023-11-03 09:53:55', '2023-11-02', 'P3781', '23-05269-11-02', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 206.91, 0, '2023-11-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021123-YTP1yWkfAqMvT-052', '29a06ebe-be47-4fa6-96c1-038bb7314760', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-YTP1yWkfAqMvT-052&s=KOL2023&nf=P3781&i=206.91&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4028, 1, 1023, 2, 0, NULL, 0, '2023-11-02 15:07:43', '2023-11-03 09:58:20', '2023-11-02', 'P3782', '23-05270-11-02', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'La QUimera del Oro, 14 - 2ºi', 'Zaragoza', 'Zaragoza', '50019', 'España', 65.52, 0, '2023-11-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-021123-bPINtKmj2UpV9-112', '3c8912ce-b855-494d-ae18-e3d4ea84b8ff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-bPINtKmj2UpV9-112&s=KOL2023&nf=P3782&i=65.52&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4029, 1, 1024, 2, 0, NULL, 0, '2023-11-02 15:44:05', '2023-11-03 10:05:14', '2023-11-02', 'P3783', '23-05271-11-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle de Ulises, 4', 'Mairena del Aljarafe', 'Sevilla', '41927', 'España', 28.39, 0, '2023-11-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-021123-eW0eEAaffsCbK-071', '3095f5e3-e9a1-4b68-8afa-f20891a90051', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-eW0eEAaffsCbK-071&s=KOL2023&nf=P3783&i=28.39&cr=096', '[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
(4030, 1, 1025, 2, 0, NULL, 0, '2023-11-02 15:56:03', '2023-11-03 10:45:59', '2023-11-02', 'P3786', '23-05272-11-02', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Artekale  12  bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-021123-aJLmBM4e4TrVF-197', 'f6ce046d-177a-4220-90a1-97c192c1de3a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-aJLmBM4e4TrVF-197&s=KOL2023&nf=P3786&i=241.40&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4031, 1, 613, 2, 0, NULL, 0, '2023-11-02 16:16:42', '2023-11-03 10:45:27', '2023-11-02', 'P3784', '23-05273-11-02', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Joaquín Zurita 11,3-A', 'Boadilla del Monte', 'Madrid', '28660', 'España', 17.50, 0, '2023-11-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021123-XooL3BS+FV7Lg-183', '5f2b7e99-7db5-49df-a8e6-3fb1bc064c6c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-XooL3BS%2BFV7Lg-183&s=KOL2023&nf=P3784&i=17.50&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4032, 1, 818, 2, 0, NULL, 0, '2023-11-02 21:54:25', '2023-11-03 10:48:19', '2023-11-02', 'P3785', '23-05274-11-02', 'Llamar antes de venir al domicilio ', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'C/ Península Ibérica, 13', 'Ponferrada', 'León', '24411', 'España', 78.63, 0, '2023-11-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021123-DcWX9EMqViiYG-069', 'a3d6bee4-5e76-483a-8b0b-7f9427cd7399', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021123-DcWX9EMqViiYG-069&s=KOL2023&nf=P3785&i=78.63&cr=146', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4033, 1, 1026, 2, 0, NULL, 0, '2023-11-03 11:11:14', '2023-11-03 12:13:43', '2023-11-03', 'P3787', '23-05276-11-03', 'Solo estoy en casa a partir de las 16.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle cuatro de agosto 11, 4B', 'Zaragoza', 'Zaragoza', '50003', 'España', 17.50, 0, '2023-11-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031123-f9M7M4qjRgXzg-057', '9a4a1f0a-fa30-45b5-a1e7-0141085ee52f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031123-f9M7M4qjRgXzg-057&s=KOL2023&nf=P3787&i=17.50&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4034, 1, 1027, 2, 0, NULL, 0, '2023-11-03 15:49:00', '2023-11-06 08:44:01', '2023-11-03', 'P3788', '23-05277-11-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Plaza palacio Góngora 8 4b', 'Aranguren', 'Navarra', '31192', 'España', 30.61, 0, '2023-11-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031123-BLwSj+khh0o4U-095', 'a1156d29-766c-4556-a18d-3b0539a22d5c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031123-BLwSj%2Bkhh0o4U-095&s=KOL2023&nf=P3788&i=30.61&cr=197', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4035, 1, 312, 2, 0, NULL, 0, '2023-11-03 19:38:46', '2023-11-06 08:46:44', '2023-11-03', 'P3789', '23-05278-11-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle 25 de noviembre bloque 7 letra F', 'Conil de la Frontera', 'Cádiz', '11140', 'España', 17.50, 0, '2023-11-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-031123-J/8Ciuf3fBgb5-169', '9b0942d4-08ba-4e0a-8226-4421cc5e3e61', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031123-J%2F8Ciuf3fBgb5-169&s=KOL2023&nf=P3789&i=17.50&cr=164', '[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
(4036, 1, 1028, 2, 0, NULL, 0, '2023-11-04 07:34:20', '2023-11-06 08:48:23', '2023-11-04', 'P3790', '23-05279-11-04', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paraje Rejuela MT 24', 'Monóvar/Monòver', 'Alicante', '03640', 'España', 30.61, 0, '2023-11-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-041123-g9lM20mf8Ex+K-196', '9a8f5bd3-c0de-4342-af62-97fc93d2c69a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041123-g9lM20mf8Ex%2BK-196&s=KOL2023&nf=P3790&i=30.61&cr=010', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4037, 1, 888, 2, 0, NULL, 0, '2023-11-04 16:03:18', '2023-11-06 08:52:28', '2023-11-04', 'P3791', '23-05280-11-04', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'c/arenal 23', 'Yuncos', 'Toledo', '45210', 'España', 61.09, 0, '2023-11-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041123-jXhFyovmhBeM5-185', '3f7bc408-71bc-46e4-9c39-528d3b41aa54', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041123-jXhFyovmhBeM5-185&s=KOL2023&nf=P3791&i=61.09&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4038, 1, 572, 2, 0, NULL, 0, '2023-11-04 18:57:17', '2023-11-06 08:54:09', '2023-11-04', 'P3792', '23-05281-11-04', 'Empresa LLENARI', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Uzbina, 24, Pab. C1, Polígono industrial de Júndiz, Llenari', 'Vitoria-Gasteiz', 'Álava', '01015 ', 'España', 30.61, 0, '2023-11-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041123-Y8ZvZ4ope80N6-052', 'ba14bc36-6378-417b-9b01-788ffff6e2b4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041123-Y8ZvZ4ope80N6-052&s=KOL2023&nf=P3792&i=30.61&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4039, 1, 754, 2, 0, NULL, 0, '2023-11-05 15:46:45', '2023-11-06 08:57:30', '2023-11-05', 'P3793', '23-05282-11-05', 'de forma puntual enviar al mismo municipio\r\nCALLE MALLORCA Nº5 LOCAL\r\n43870 AMPOSTA', 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, '2023-11-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-051123-oOQKfBVEMCft+-014', '9ac5af3e-229a-4210-8337-b9478e056f39', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051123-oOQKfBVEMCft%2B-014&s=KOL2023&nf=P3793&i=61.64&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4040, 1, 324, 2, 0, NULL, 0, '2023-11-05 19:33:02', '2023-11-06 09:00:04', '2023-11-05', 'P3794', '23-05283-11-05', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/Martinez Izquierdo 84, 2º dc', 'Madrid', 'Madrid', '28028', 'España', 43.71, 0, '2023-11-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051123-dEZ/x+Gd0qiY3-236', 'e74890b4-f9f2-4063-be77-932382c6c1c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051123-dEZ%2Fx%2BGd0qiY3-236&s=KOL2023&nf=P3794&i=43.71&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4041, 1, 121, 2, 0, NULL, 0, '2023-11-05 23:45:20', '2023-11-06 09:04:46', '2023-11-05', 'P3795', '23-05284-11-05', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 379.34, 0, '2023-11-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051123-X8HaTYwidedTX-152', 'c1251e80-b45c-484e-8b3d-44c0730cc19e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051123-X8HaTYwidedTX-152&s=KOL2023&nf=P3795&i=379.34&cr=075', '[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
(4042, 1, 1029, 2, 0, NULL, 0, '2023-11-06 00:29:34', '2023-11-06 09:06:25', '2023-11-06', 'P3796', '23-05285-11-06', 'Por favor llamar antes de entregar, al 606124585', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Periodista Quesada Chacon N°2..bloque 3,4°f', 'Córdoba', 'Córdoba', '14005', 'España', 30.61, 0, '2023-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061123-HIcHXn3etPZ1C-106', '19e7947c-02f2-43f2-a68d-a5e13858bc04', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061123-HIcHXn3etPZ1C-106&s=KOL2023&nf=P3796&i=30.61&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4043, 1, 4, 2, 0, NULL, 0, '2023-11-06 09:46:03', '2023-11-06 10:49:22', '2023-11-06', 'P3797', '23-05286-11-06', '', 0.00, 317.56, 66.69, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 384.25, 0, '2023-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061123-e9LIxD5cArrvt-018', '76a264fc-1320-44ec-bcb9-c4adc184c6a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061123-e9LIxD5cArrvt-018&s=KOL2023&nf=P3797&i=384.25&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4044, 1, 190, 3, 0, NULL, 0, '2023-11-06 10:56:53', '2023-11-06 10:56:53', '2023-11-06', '', 'consumo peluquería', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 34.48, 0, '2023-11-06 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),
(4045, 1, 397, 2, 0, NULL, 0, '2023-11-06 11:02:03', '2023-11-07 09:46:51', '2023-11-06', 'P3800', '23-05287-11-06', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Alberga 69 -1° izda', 'Errenteria', 'Gipuzkoa', '20100', 'España', 43.71, 0, '0000-00-00 00:00:00', '', '', 5, 3, 1, 'TBAI-B20930640-061123-SJlxDNJE8QxRd-172', '08469b1e-f4b4-41d6-8da4-c39ce0bb2ebd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061123-SJlxDNJE8QxRd-172&s=KOL2023&nf=P3800&i=43.71&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(4046, 1, 542, 2, 0, NULL, 0, '2023-11-06 20:25:56', '2023-11-07 08:29:53', '2023-11-06', 'P3798', '23-05288-11-06', 'Si no estamos dejarlo al portero', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avenida Niceto Alcalá Zamora 11; portal E; 1-D', 'Madrid', 'Madrid', '28050', 'España', 61.09, 0, '2023-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061123-aedA76HPB53f3-197', '1e3b867c-00d9-4e62-9f45-398e223f1833', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061123-aedA76HPB53f3-197&s=KOL2023&nf=P3798&i=61.09&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4047, 1, 528, 2, 0, NULL, 0, '2023-11-06 21:21:15', '2023-11-07 08:31:28', '2023-11-06', 'P3799', '23-05289-11-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Ibaizabal 6-1 Ctro', 'Getxo', 'Bizkaia', '48991', 'España', 17.50, 0, '2023-11-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-061123-O6FcaUIY9HWzS-171', '49ae733e-11e1-42e8-99fe-5b9127a5c5b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061123-O6FcaUIY9HWzS-171&s=KOL2023&nf=P3799&i=17.50&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4048, 1, 397, 2, 0, NULL, 0, '2023-11-07 08:44:17', '2023-11-07 09:49:09', '2023-11-07', 'P3801', '23-05292-11-07', '', 0.00, 32.49, 8.02, 0.00, 0, 0.00, 6.90, 'Alberga 69 1. Izda', 'Errenteria', 'Gipuzkoa', '20100', 'España', 46.21, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-071123-NU+fzjk6Pyd8Y-138', '875e4247-cd6f-4e91-880c-5a0418678d04', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-NU%2Bfzjk6Pyd8Y-138&s=KOL2023&nf=P3801&i=46.21&cr=060', '[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
(4049, 1, 397, 2, 1, 'fallo en transferencia', 4045, '2023-11-07 09:48:00', '2023-11-07 09:48:00', '2023-11-07', 'R59', 'P3800 RECT.', '<p>fallo en transferencia<br></p>', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, '', '', '', '', '', 43.71, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-071123-LGgthwDe66Qwr-209', 'a0063036-ce12-45f2-a178-cca20f21e46d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-LGgthwDe66Qwr-209&s=KOL2023&nf=R59&i=-43.71&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4050, 1, 947, 2, 0, NULL, 0, '2023-11-07 09:09:53', '2023-11-07 10:13:33', '2023-11-07', 'P3802', '23-05293-11-07', 'Primer piso', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Av/ profesor sanchis guarner n62-25 vinalesa, 1°piso', 'Vinalesa', 'Valencia', '46114', 'España', 30.61, 0, '2023-11-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071123-AEIG9QuRETAo7-255', 'fc50e71c-e75d-4a80-ab5e-bdbccc56ab82', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-AEIG9QuRETAo7-255&s=KOL2023&nf=P3802&i=30.61&cr=175', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4051, 1, 67, 2, 0, NULL, 0, '2023-11-07 09:27:45', '2023-11-07 10:28:48', '2023-11-07', 'P3803', '23-05294-11-07', '', 0.00, 370.50, 77.81, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 448.31, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-071123-os8zL91Cz+Pq7-039', '26026aef-f3ae-4831-8f78-37f4d9a21b36', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-os8zL91Cz%2BPq7-039&s=KOL2023&nf=P3803&i=448.31&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4052, 1, 1030, 2, 0, NULL, 0, '2023-11-07 11:07:17', '2023-11-07 12:09:18', '2023-11-07', 'P3804', '23-05295-11-07', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle arzobispo apaolaza 39, 3 izquierda', 'Zaragoza', 'Zaragoza', '50009', 'España', 17.50, 0, '2023-11-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-071123-NX5wS2elJv/aH-101', '0ab0a65f-dd1c-4ddd-977a-09eab0f0a072', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-NX5wS2elJv%2FaH-101&s=KOL2023&nf=P3804&i=17.50&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4053, 1, 821, 2, 0, NULL, 0, '2023-11-07 11:40:48', '2023-11-07 12:49:43', '2023-11-07', 'P3805', '23-05296-11-07', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'gurutzeaga 9 bajo, 72438407e', 'Zestoa', 'Gipuzkoa', '20740', 'España', 68.97, 0, '2023-11-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071123-k6QdZasVzL9pI-152', '7e63817c-7aa8-4d3f-aafb-f6f36e5724f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-k6QdZasVzL9pI-152&s=KOL2023&nf=P3805&i=68.97&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4054, 1, 979, 2, 0, NULL, 0, '2023-11-07 12:02:18', '2023-11-07 13:04:02', '2023-11-07', 'P3806', '23-05297-11-07', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'calle palma 58 local 1', 'Madrid', 'Madrid', '28015', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-071123-eS8TB5yvb3q8I-016', '66ee59d1-ed24-495d-893a-20ec3ff84f99', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-eS8TB5yvb3q8I-016&s=KOL2023&nf=P3806&i=379.34&cr=233', '[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
(4055, 1, 1031, 2, 0, NULL, 0, '2023-11-07 12:34:46', '2023-11-07 13:37:41', '2023-11-07', 'P3807', '23-05298-11-07', 'ENTREGAR DE LUNES A VIERNES DE 8:00 A 14:00 HORAS', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'CARRETERA DEL MOLINO 25', 'Irun', 'Gipuzkoa', '20303', 'España', 30.61, 0, '2023-11-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071123-SdFmpnnjKUteJ-203', 'e9a81615-9a49-4069-8d9a-9831ef7e7418', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-SdFmpnnjKUteJ-203&s=KOL2023&nf=P3807&i=30.61&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4056, 1, 1032, 2, 0, NULL, 0, '2023-11-07 13:09:33', '2023-11-08 08:50:21', '2023-11-07', 'P3808', '23-05299-11-07', 'Entregar factura por\r\nfavor´,y si no estoy en el local dejarlo en local de enfrente en la floristeria o el de al lado', 0.00, 97.47, 20.47, 0.00, 0, 0.00, 0.00, 'Calle Santa Isabel 9 Local', 'Zaragoza', 'Zaragoza', '50003', 'España', 117.94, 0, '2023-11-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071123-fKn3V0uvD0xlo-084', 'a624e4fe-5e68-476b-95b8-b40cffad37ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-fKn3V0uvD0xlo-084&s=KOL2023&nf=P3808&i=117.94&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4057, 1, 686, 2, 0, NULL, 0, '2023-11-07 14:36:15', '2023-11-08 08:53:22', '2023-11-07', 'P3809', '23-05300-11-07', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Sancho el sabio 11. Local 3. UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 241.40, 0, '2023-11-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071123-WgTDJmb3emu2F-083', '7f6297db-0712-4152-9abc-7d3eaa700f6d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-WgTDJmb3emu2F-083&s=KOL2023&nf=P3809&i=241.40&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4058, 1, 220, 2, 0, NULL, 0, '2023-11-07 15:50:03', '2023-11-08 08:55:34', '2023-11-07', 'P3811', '23-05303-11-07', '', 0.00, 321.64, 67.54, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 389.18, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-071123-ET4l48XSjF9DM-001', '4d502ead-222b-4b39-a628-35c8557cd926', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-ET4l48XSjF9DM-001&s=KOL2023&nf=P3811&i=389.18&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4059, 1, 581, 2, 0, NULL, 0, '2023-11-07 17:43:50', '2023-11-08 08:58:39', '2023-11-07', 'P3810', '23-05304-11-07', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'P. Arcillero 3, 6 D', 'Santander', 'Cantabria', '39001', 'España', 30.61, 0, '2023-11-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071123-Vl/V4GMTUCDwm-218', '75a1c6e6-ffb9-4f2e-ba1d-7cf438e3087f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071123-Vl%2FV4GMTUCDwm-218&s=KOL2023&nf=P3810&i=30.61&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4060, 1, 337, 2, 0, NULL, 0, '2023-11-08 07:06:55', '2023-11-08 09:00:53', '2023-11-08', 'P3812', '23-05305-11-08', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaida (La)', 'Zaragoza', '50014 ', 'España', 59.10, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-081123-jV5ew59AvsBmC-252', '9662fa90-9918-4e5c-822d-084181ab9596', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081123-jV5ew59AvsBmC-252&s=KOL2023&nf=P3812&i=59.10&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
