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
(3889, 1, 239, 1, 0, NULL, 0, '2023-10-06 12:35:09', '2023-10-06 12:53:35', '2023-10-06', 'P3654', '2023-10-06', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'San Marcial 37', 'Donostia', 'Gipuzkoa', '20005', 'España', 34.48, 0, '2023-10-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061023-BNTIN4aDRkKGy-074', '563a27f3-49aa-420e-a5ec-e7fb23e49456', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061023-BNTIN4aDRkKGy-074&s=KOL2023&nf=P3654&i=34.47&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3890, 1, 106, 1, 0, NULL, 0, '2023-10-06 12:58:42', '2023-10-06 12:59:06', '2023-10-06', 'P3655', '2023-10-06', '', 0.00, 65.12, 13.68, 0.00, 0, 0.00, 0.00, 'Hipódromo 10 bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'ESPAÑA', 78.80, 0, '2023-10-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061023-m6K8WCmyGGrQI-250', '181889df-1c96-4c63-8ca4-dbfe1a5c7b3f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061023-m6K8WCmyGGrQI-250&s=KOL2023&nf=P3655&i=78.80&cr=240', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3891, 1, 604, 2, 0, NULL, 0, '2023-10-06 17:03:28', '2023-10-09 09:18:07', '2023-10-06', 'P3656', '23-05138-10-06', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Julio caro Baroja 6 Bajo', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 43.71, 0, '2023-10-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061023-VxEyvaWvE6Qpq-059', '0629455f-b886-42f0-8164-521a13f0a56e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061023-VxEyvaWvE6Qpq-059&s=KOL2023&nf=P3656&i=43.71&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3892, 1, 993, 2, 0, NULL, 0, '2023-10-07 08:13:24', '2023-10-09 09:24:47', '2023-10-07', 'P3657', '23-05139-10-07', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/ Sorolla 40 1A', 'Rincón de la Victori', 'Málaga', '29720', 'España', 43.71, 0, '2023-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071023-derBFaBVKEPDy-089', 'f1c3b1fc-4d88-464a-b562-3d52bb55c346', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071023-derBFaBVKEPDy-089&s=KOL2023&nf=P3657&i=43.71&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3893, 1, 53, 2, 0, NULL, 0, '2023-10-07 11:57:44', '2023-10-09 09:30:03', '2023-10-07', 'P3660', '23-05140-10-07', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-071023-UgbnPPeNaJ41T-122', 'c7cba221-a39c-4762-94ca-6dd740995720', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071023-UgbnPPeNaJ41T-122&s=KOL2023&nf=P3660&i=209.41&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3894, 1, 855, 2, 0, NULL, 0, '2023-10-07 13:39:52', '2023-10-09 09:32:54', '2023-10-07', 'P3658', '23-05141-10-07', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida Valdegudin 13', 'Villamuriel de Cerra', 'Palencia', '34190', 'España', 30.61, 0, '2023-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071023-bskb8oj9kZCDk-117', 'db2cb4e4-8970-4b0f-913a-f5b2c09ac1f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071023-bskb8oj9kZCDk-117&s=KOL2023&nf=P3658&i=30.61&cr=036', '[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
(3895, 1, 617, 2, 0, NULL, 0, '2023-10-07 17:59:43', '2023-10-09 09:38:09', '2023-10-07', 'P3659', '23-05142-10-07', 'Quiero factura \r\nPeluqueria Barros Couso SL\r\nB94103199\r\nC/ Riestra 14\r\nPontevedra 36003\r\n\r\nMuchas gracias', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Riestra, 14', 'Pontevedra', 'Pontevedra', '36001', 'España', 379.34, 0, '2023-10-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071023-b25+D0wQJ+OsP-167', 'a7917f68-1416-444a-b4d0-5292c5a3a0db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071023-b25%2BD0wQJ%2BOsP-167&s=KOL2023&nf=P3659&i=379.34&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3896, 1, 190, 1, 0, NULL, 0, '2023-10-09 09:50:22', '2023-10-09 09:50:22', '2023-10-09', '', 'consumo peluquería', '', 0.00, 2442.60, 512.95, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2955.55, 0, '2023-10-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),
(3897, 1, 783, 2, 0, NULL, 0, '2023-10-09 08:32:34', '2023-10-09 11:48:02', '2023-10-09', 'P3661', '23-05144-10-09', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Alvaro Cunqueiro, nº 15, 7º A', 'Vigo', 'Pontevedra', '36211', 'España', 61.09, 0, '2023-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091023-U08WJobp+eLxF-164', 'c05570cf-d44b-401b-a0cc-735a12917050', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091023-U08WJobp%2BeLxF-164&s=KOL2023&nf=P3661&i=61.09&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3898, 1, 65, 2, 0, NULL, 0, '2023-10-09 10:41:50', '2024-07-17 13:12:00', '2023-10-09', 'P3662', '23-05145-10-09', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 551.76, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-091023-jaKzwyyTWFdCg-135', '460fc627-7c60-4e15-9299-90d606e0102c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091023-jaKzwyyTWFdCg-135&s=KOL2023&nf=P3662&i=551.76&cr=190', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3899, 1, 994, 2, 0, NULL, 0, '2023-10-09 13:57:19', '2023-10-10 09:17:10', '2023-10-09', 'P3663', '23-05146-10-09', 'CHALET 1', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'BARRIO LA IGLESIA. RESIDENCIAL CUBAS 2. CHALET 1', 'Ribamontán al Monte', 'Cantabria', '39793', 'España', 28.39, 0, '2023-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091023-eMin2eZCdbr13-201', '784b3c92-3483-4f16-8a33-647c813cc4c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091023-eMin2eZCdbr13-201&s=KOL2023&nf=P3663&i=28.39&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3900, 1, 121, 2, 0, NULL, 0, '2023-10-09 19:55:09', '2023-10-10 09:21:34', '2023-10-09', 'P3664', '23-05147-10-09', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 241.40, 0, '2023-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091023-H+VFMCRtnob+J-197', '9374e82a-293c-4139-9476-119784e8a0df', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091023-H%2BVFMCRtnob%2BJ-197&s=KOL2023&nf=P3664&i=241.40&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3901, 1, 139, 2, 0, NULL, 0, '2023-10-09 20:45:50', '2023-10-10 09:30:19', '2023-10-09', 'P3666', '23-05148-10-09', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'A Coruña', 'Coruña (A)', 'A Coruña', '15009', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-091023-XKmJR3wSG3a0k-078', '534f4cc3-53d8-4178-9be4-8c996d8086df', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091023-XKmJR3wSG3a0k-078&s=KOL2023&nf=P3666&i=20.00&cr=173', '[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
(3902, 1, 296, 2, 0, NULL, 0, '2023-10-09 21:14:55', '2023-10-10 09:39:26', '2023-10-09', 'P3665', '23-05149-10-09', 'De lunes a viernes de 9 a 18 hrs. Los fines de semana NO', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'Via Laietana 23, Entresuelo C', 'Barcelona', 'Barcelona', '08003', 'España', 54.60, 0, '2023-10-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091023-VusoPBOlVYj0A-016', '45d1dc0a-878f-476e-9529-3cd5605a94fd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091023-VusoPBOlVYj0A-016&s=KOL2023&nf=P3665&i=54.60&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3903, 1, 242, 1, 0, NULL, 0, '2023-10-10 09:46:22', '2023-10-10 09:47:49', '2023-10-10', 'P3667', '2023-10-10', '', 0.00, 97.68, 20.51, 0.00, 1, 5.08, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 123.27, 0, '2023-10-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101023-Ofjk1BTDhm3mD-066', 'f82fa8ff-e477-4981-92a5-143fb995c400', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101023-Ofjk1BTDhm3mD-066&s=KOL2023&nf=P3667&i=123.27&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3904, 1, 77, 1, 0, NULL, 0, '2023-10-10 10:01:42', '2023-10-10 10:01:42', '2023-10-10', 'P3668', '2023-10-10', '', 0.00, 686.40, 144.14, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 830.54, 0, '2023-10-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101023-ekB585h/QohFX-148', '793a1cbe-cfad-4bc1-bf12-2aef34281d2a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101023-ekB585h%2FQohFX-148&s=KOL2023&nf=P3668&i=830.54&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3905, 1, 995, 2, 0, NULL, 0, '2023-10-10 08:58:34', '2023-10-10 11:30:14', '2023-10-10', 'P3669', '23-05151-10-10', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Pablo Neruda 21 bajo', 'Paiporta', 'Valencia', '46200', 'España', 28.39, 0, '2023-10-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-101023-DXBeVBkAylLRH-209', '0baf5235-6ab1-45ef-9746-e172265d9626', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101023-DXBeVBkAylLRH-209&s=KOL2023&nf=P3669&i=28.39&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3906, 1, 154, 2, 0, NULL, 0, '2023-10-10 09:00:34', '2023-10-10 11:33:04', '2023-10-10', 'P3670', '23-05152-10-10', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 103.46, 0, '2023-10-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101023-A+eEw0ij+cPda-046', 'c94f47e9-8b26-41a9-ab15-6a39021bc733', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101023-A%2BeEw0ij%2BcPda-046&s=KOL2023&nf=P3670&i=103.46&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3907, 1, 337, 2, 0, NULL, 0, '2023-10-10 20:47:46', '2023-10-11 08:49:05', '2023-10-10', 'P3672', '23-05153-10-10', '', 0.00, 89.54, 18.80, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaragoza', 'Zaragoza', '50014 ', 'España', 108.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101023-krklWJBCcNYo0-136', '06c50679-19be-4bf2-8c26-25f4012f4f28', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101023-krklWJBCcNYo0-136&s=KOL2023&nf=P3672&i=108.34&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
(3908, 1, 996, 2, 0, NULL, 0, '2023-10-10 22:44:40', '2023-10-11 08:52:00', '2023-10-10', 'P3671', '23-05154-10-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Urkizu 28-3º C', 'Eibar', 'Gipuzkoa', '20600', 'España', 30.61, 0, '2023-10-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101023-bxYrpS4CDGRsV-070', 'd135915b-dbf3-4c01-9d8c-8fc86b2728db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101023-bxYrpS4CDGRsV-070&s=KOL2023&nf=P3671&i=30.61&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3909, 1, 696, 1, 0, NULL, 0, '2023-10-11 08:56:43', '2023-10-11 08:57:26', '2023-10-11', 'P3673', '2023-10-11', '', 0.00, 334.62, 70.27, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 404.89, 0, '2023-10-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111023-OopQ7aU8nm2D/-184', '3f20ac67-37d4-4cac-9adf-13c8ee4e1c45', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111023-OopQ7aU8nm2D%2F-184&s=KOL2023&nf=P3673&i=404.89&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3910, 1, 812, 2, 0, NULL, 0, '2023-10-11 09:28:33', '2023-10-11 11:35:31', '2023-10-11', 'P3674', '23-05157-10-11', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Amezketarrak 10, entresuelo derecha puerta 4', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 56.82, 0, '2023-10-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-111023-JjSkiV5ciHoe1-251', '8a1dab62-8847-418d-8da5-918c4ddde239', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111023-JjSkiV5ciHoe1-251&s=KOL2023&nf=P3674&i=56.82&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3911, 1, 110, 2, 0, NULL, 0, '2023-10-11 10:47:18', '2023-10-11 12:57:23', '2023-10-11', 'P3675', '23-05159-10-11', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 310.37, 0, '2023-10-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-111023-LivO+Oo7xHj8g-025', 'd61a1818-5e23-44a1-8285-51a09326cf96', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111023-LivO%2BOo7xHj8g-025&s=KOL2023&nf=P3675&i=310.37&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3912, 1, 672, 2, 0, NULL, 0, '2023-10-11 12:54:55', '2023-10-13 09:20:46', '2023-10-11', 'P3676', '23-05160-10-11', '', 0.00, 72.15, 15.15, 0.00, 0, 0.00, 0.00, 'ANDALUCIA KALEA 7, 7 B', 'Vitoria-Gasteiz', 'Álava', '01003', 'España', 87.30, 0, '2023-10-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111023-XFpVkuqbRZKOg-253', 'c707e280-62e7-4126-beca-93fe8b2583d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111023-XFpVkuqbRZKOg-253&s=KOL2023&nf=P3676&i=87.30&cr=122', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3913, 1, 197, 2, 0, NULL, 0, '2023-10-11 14:11:12', '2023-10-13 09:25:18', '2023-10-11', 'P3677', '23-05161-10-11', '', 0.00, 195.42, 41.04, 0.00, 0, 0.00, 0.00, 'Esquiroz 28 a la vuelta', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 236.46, 0, '2023-10-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111023-UCpmHmo+NcuHq-213', 'c86c1e94-d067-4add-bc9d-e273f0f87e82', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111023-UCpmHmo%2BNcuHq-213&s=KOL2023&nf=P3677&i=236.46&cr=230', '[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
(3914, 1, 11, 2, 0, NULL, 0, '2023-10-11 16:24:16', '2023-10-13 09:27:52', '2023-10-11', 'P3680', '23-05162-10-11', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'calle Colomeres 36 local 2', 'Gavà', 'Barcelona', '08840', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111023-Viwzwjjvpz/1I-145', 'cf79514a-f3ab-4694-ba9e-5747db7b4d07', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111023-Viwzwjjvpz%2F1I-145&s=KOL2023&nf=P3680&i=68.97&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3915, 1, 997, 2, 0, NULL, 0, '2023-10-12 20:19:42', '2023-10-13 09:30:46', '2023-10-12', 'P3678', '23-05163-10-12', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Rua/Descanso n6 Baixo B', 'Muros', 'A Coruña', '15250', 'España', 17.50, 0, '2023-10-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-121023-jJSuH2M5GuuvY-169', 'c1b6f7d8-5a7d-4c71-8207-bcd01e4b7b3d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121023-jJSuH2M5GuuvY-169&s=KOL2023&nf=P3678&i=17.50&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3916, 1, 7, 1, 0, NULL, 0, '2023-10-13 09:17:25', '2023-10-13 09:17:25', '2023-10-13', 'P3679', '2023-10-13', '', 0.00, 256.50, 53.86, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 310.36, 0, '2023-10-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-131023-gjzP6Yf4v8MlQ-050', '55509444-a34d-4b9a-ac19-09f982035bb4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131023-gjzP6Yf4v8MlQ-050&s=KOL2023&nf=P3679&i=310.36&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3917, 1, 998, 2, 0, NULL, 0, '2023-10-13 07:42:43', '2023-10-13 09:52:33', '2023-10-13', 'P3681', '23-05164-10-13', 'Mejor si se entrega por la tarde', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Dr. Palomar, 6, 2º Izda', 'Zaragoza', 'Zaragoza', '50002', 'España', 30.61, 0, '2023-10-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131023-lfFJUWQMK/R2x-198', '60b19ce5-b1a2-4f9e-8ace-b965cc399fd8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131023-lfFJUWQMK%2FR2x-198&s=KOL2023&nf=P3681&i=30.61&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3918, 1, 75, 2, 0, NULL, 0, '2023-10-13 08:28:14', '2023-10-13 10:51:45', '2023-10-13', 'P3682', '23-05165-10-13', 'Horario 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, '2023-10-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131023-OVWBQFxGPgC/l-034', '6e2cfa21-b4cc-4eaa-9a13-0b68ff46c2a2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131023-OVWBQFxGPgC%2Fl-034&s=KOL2023&nf=P3682&i=172.43&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3919, 1, 999, 2, 0, NULL, 0, '2023-10-13 10:06:52', '2023-10-13 12:07:41', '2023-10-13', 'P3683', '23-05166-10-13', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Calle La Matiella Nº 5-2ºD', 'Carreño', 'Asturias', '33430', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-131023-Mp+PyUyD6ZQgg-064', 'fcc5ece1-ed55-427b-8397-6ebe48790734', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131023-Mp%2BPyUyD6ZQgg-064&s=KOL2023&nf=P3683&i=33.11&cr=214', '[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
(3920, 1, 40, 2, 0, NULL, 0, '2023-10-13 10:39:33', '2023-10-13 12:59:13', '2023-10-13', 'P3684', '23-05167-10-13', 'martes cerrado y lunes a partir de las 3 abierto', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 78.82, 0, '2023-10-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131023-aGJ1oQkDtvRxj-077', '937a48b8-b62e-4430-b505-573ad3605b81', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131023-aGJ1oQkDtvRxj-077&s=KOL2023&nf=P3684&i=78.81&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3921, 1, 754, 2, 0, NULL, 0, '2023-10-13 12:38:04', '2023-10-16 09:08:35', '2023-10-13', 'P3685', '23-05168-10-13', '', 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-10-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-131023-IB9G9S1xQaL1d-210', '44e5750f-41b7-4f5d-af7e-89781938e40d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131023-IB9G9S1xQaL1d-210&s=KOL2023&nf=P3685&i=61.64&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3922, 1, 204, 2, 0, NULL, 0, '2023-10-13 15:54:29', '2023-10-16 09:10:25', '2023-10-13', 'P3686', '23-05169-10-13', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'nou 23 local 1', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 137.94, 0, '2023-10-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131023-fiDgUGjyG1qVT-146', '35fc1452-df59-4319-9861-b3fe45c1e41b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131023-fiDgUGjyG1qVT-146&s=KOL2023&nf=P3686&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),
(3923, 1, 1000, 2, 0, NULL, 0, '2023-10-13 17:17:35', '2023-10-16 09:11:57', '2023-10-13', 'P3687', '23-05170-10-13', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Del Abanico , 34', 'Cartagena', 'Murcia', '30330', 'España', 17.50, 0, '2023-10-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131023-W7jSQXYphgnkz-025', '6c1a56d1-5a9a-4db3-91fe-4a7b92fa827f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131023-W7jSQXYphgnkz-025&s=KOL2023&nf=P3687&i=17.50&cr=043', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3924, 1, 689, 2, 0, NULL, 0, '2023-10-14 08:29:04', '2023-10-16 09:17:13', '2023-10-14', 'P3688', '23-05171-10-14', 'Horario comercial mediodía cerrado', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Dr Espinosa Oribe 19 bajo', 'Bilbao', 'Bizkaia', '48003', 'España', 30.61, 0, '2023-10-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141023-WEr/jnnBjksS/-120', '18eadcb6-744e-4156-bf88-8398dd773069', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141023-WEr%2FjnnBjksS%2F-120&s=KOL2023&nf=P3688&i=30.61&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3925, 1, 215, 2, 0, NULL, 0, '2023-10-14 09:49:07', '2023-10-16 09:20:18', '2023-10-14', 'P3689', '23-05173-10-14', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 379.34, 0, '2023-10-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141023-M24p+hPwKM9yB-168', 'b3d61774-a5e8-40c0-bb4d-513fc2b055a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141023-M24p%2BhPwKM9yB-168&s=KOL2023&nf=P3689&i=379.34&cr=201', '[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
(3926, 1, 894, 2, 0, NULL, 0, '2023-10-15 12:42:43', '2023-10-16 09:22:38', '2023-10-15', 'P3690', '23-05174-10-15', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ Lubiana n°2 5°A', 'Vitoria-Gasteiz', 'Álava', '01003', 'España', 65.52, 0, '2023-10-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-151023-aGSG6TdwepDm+-005', 'b2405c4f-11b6-4078-9622-691c68c7466d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151023-aGSG6TdwepDm%2B-005&s=KOL2023&nf=P3690&i=65.52&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3927, 1, 942, 2, 0, NULL, 0, '2023-10-15 18:10:11', '2023-10-16 09:25:23', '2023-10-15', 'P3691', '23-05176-10-15', 'El lugar de entrega es una escuela. Horario de entrega de Lunes a Jueves de 9h a 17h.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/Bronce 18', 'Barcelona', 'Barcelona', '08038', 'España', 28.39, 0, '2023-10-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151023-ox3G5o5pAdf7V-189', 'a6fcca88-d420-4e85-979e-596e13c50f64', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151023-ox3G5o5pAdf7V-189&s=KOL2023&nf=P3691&i=28.39&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3928, 1, 857, 2, 1, '', 3883, '2023-10-16 10:15:27', '2023-10-16 10:15:27', '2023-10-16', 'R56', 'P3647 RECT.', '<p>Se le ha cargado recargo de equivalencia cuando no debería.</p>', 0.00, 162.45, 34.11, 0.00, 0, 8.45, 0.00, '', '', '', '', '', 205.01, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-161023-Z6+zsj/XomMzm-012', 'e97ab14d-f4ce-44fd-9d66-4a99739b63b0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161023-Z6%2Bzsj%2FXomMzm-012&s=KOL2023&nf=R56&i=-205.01&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3929, 1, 857, 1, 0, NULL, 0, '2023-10-16 10:39:12', '2023-10-16 10:40:26', '2023-10-16', 'P3692', '', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'C/ Doctor Marañón 12', 'Almonte', 'Huelva', '21730', 'España', 196.56, 0, '2023-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161023-gOqvTbD+tRghl-239', 'c7b5735e-9bea-458a-8ac6-fa1b4b8457d7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161023-gOqvTbD%2BtRghl-239&s=KOL2023&nf=P3692&i=196.56&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3930, 1, 1001, 2, 0, NULL, 0, '2023-10-16 10:59:21', '2023-10-16 13:14:01', '2023-10-16', 'P3693', '23-05177-10-16', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Vista Alegre 1 2°dcha', 'Barakaldo', 'Bizkaia', '48903', 'España', 17.50, 0, '2023-10-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-161023-V7Ac5DTYwIiP1-067', '6388a018-9517-409b-9641-a95ccc27d26d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161023-V7Ac5DTYwIiP1-067&s=KOL2023&nf=P3693&i=17.50&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3931, 1, 1002, 2, 0, NULL, 0, '2023-10-16 15:08:27', '2023-10-17 09:04:56', '2023-10-16', 'P3694', '23-05178-10-16', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle palamios  N 21 bajo', 'Pontevedra', 'Pontevedra', '36001', 'España', 65.52, 0, '2023-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161023-PZpkAmKFGWvMY-152', '9805467b-ab31-44a9-8a41-9074ac70c1e3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161023-PZpkAmKFGWvMY-152&s=KOL2023&nf=P3694&i=65.52&cr=148', '[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
(3932, 1, 4, 2, 0, NULL, 0, '2023-10-16 16:50:47', '2023-10-17 09:08:21', '2023-10-16', 'P3695', '23-05179-10-16', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 413.82, 0, '2023-10-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161023-m1cqcOKZec9fi-163', '13adf20b-f91b-4862-9eb6-9ecda4c50c23', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161023-m1cqcOKZec9fi-163&s=KOL2023&nf=P3695&i=413.82&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3933, 1, 131, 2, 0, NULL, 0, '2023-10-17 06:20:28', '2023-10-17 09:10:44', '2023-10-17', 'P3697', '23-05180-10-17', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-171023-dZpHKEqPtJ2Al-091', '1de51150-d086-4519-806f-36dd167a30b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171023-dZpHKEqPtJ2Al-091&s=KOL2023&nf=P3697&i=413.82&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3934, 1, 754, 2, 0, NULL, 0, '2023-10-17 07:09:30', '2023-10-17 09:11:25', '2023-10-17', 'P3696', '23-05181-10-17', '', 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-10-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-171023-OA5y9PN+9m6BK-042', 'c0ffff46-49b2-44d6-ad9c-b101fb6f7b29', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171023-OA5y9PN%2B9m6BK-042&s=KOL2023&nf=P3696&i=61.64&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3935, 1, 923, 2, 0, NULL, 0, '2023-10-17 07:12:12', '2023-10-17 09:14:15', '2023-10-17', 'P3698', '23-05182-10-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Zarautz', 'Zarautz', 'Gipuzkoa', '20800', 'España', 17.50, 0, '2023-10-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171023-CWbmGHJ8fP9ks-033', '853e1851-c0ef-4bf3-95ce-eb1e2c2a6196', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171023-CWbmGHJ8fP9ks-033&s=KOL2023&nf=P3698&i=17.50&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3936, 1, 28, 2, 0, NULL, 0, '2023-10-17 08:12:11', '2023-10-17 10:35:59', '2023-10-17', 'P3699', '23-05183-10-17', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-171023-AJD9aoHSLsU01-124', 'b7e7c6af-d19d-4515-bb81-d073337e2452', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171023-AJD9aoHSLsU01-124&s=KOL2023&nf=P3699&i=379.34&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3937, 1, 706, 2, 0, NULL, 0, '2023-10-17 10:06:58', '2023-10-17 12:08:16', '2023-10-17', 'P3700', '23-05184-10-17', '', 0.00, 81.15, 21.21, 0.00, 0, 0.00, 24.00, 'Travessa do guarda joias, 14 Ap 1Direito', 'Travessa do guarda j', 'Lisboa', '1300297', 'Portugal', 123.03, 0, '2023-10-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171023-JAZnKrXPEPPKH-190', '8e0b1461-658d-45c7-b6d5-9452a24b8efc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171023-JAZnKrXPEPPKH-190&s=KOL2023&nf=P3700&i=123.03&cr=153', '[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
(3938, 1, 566, 2, 0, NULL, 0, '2023-10-17 13:57:22', '2023-10-18 09:07:54', '2023-10-17', 'P3704', '23-05185-10-17', '', 0.00, 370.50, 77.81, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 448.31, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-171023-QMZ9GpF05y0GM-083', '0d9ab49b-7563-440c-9d53-ffc7a969330a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171023-QMZ9GpF05y0GM-083&s=KOL2023&nf=P3704&i=448.31&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3939, 1, 306, 2, 0, NULL, 0, '2023-10-17 14:58:44', '2023-10-18 09:11:36', '2023-10-17', 'P3701', '23-05186-10-17', 'horario:de lunes a viernes de 9-18:30\r\nsabados de 8:30 a 13:30', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'c/puigmolto n9 (local comercial)', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 310.37, 0, '2023-10-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171023-R6Ayfs0laMbP5-196', '6859f96b-397b-4279-8b72-034e98073ce8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171023-R6Ayfs0laMbP5-196&s=KOL2023&nf=P3701&i=310.37&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3940, 1, 409, 2, 0, NULL, 0, '2023-10-17 15:39:35', '2023-10-18 09:13:28', '2023-10-17', 'P3702', '23-05187-10-17', 'Llamar antes de entrega', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Av. constitución 183 2.2', 'Castelldefels', 'Barcelona', '08860', 'España', 17.50, 0, '2023-10-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171023-leU5Nf1yxbX2p-126', 'f395dd29-d4a1-4f72-9128-664cef4995e3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171023-leU5Nf1yxbX2p-126&s=KOL2023&nf=P3702&i=17.50&cr=184', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3941, 1, 686, 2, 0, NULL, 0, '2023-10-18 05:59:07', '2023-10-18 09:16:00', '2023-10-18', 'P3703', '23-05188-10-18', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Sancho el sabio 11. Local 3. UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 172.43, 0, '2023-10-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181023-eAOFTcjLJZKsv-161', 'b48620df-46c2-4ec8-81d4-c9548297ab28', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181023-eAOFTcjLJZKsv-161&s=KOL2023&nf=P3703&i=172.43&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3942, 1, 106, 1, 0, NULL, 0, '2023-10-18 10:54:20', '2023-10-18 10:58:25', '2023-10-18', 'P3705', '2023-10-18', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Hipódromo 10 bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'ESPAÑA', 34.48, 0, '2023-10-18 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-181023-bzzEPhAMI5cKd-098', '8a3e9474-9e7e-40d6-ab5b-7da143802da4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181023-bzzEPhAMI5cKd-098&s=KOL2023&nf=P3705&i=34.47&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3943, 1, 221, 2, 0, NULL, 0, '2023-10-18 11:29:25', '2023-10-19 09:15:03', '2023-10-18', 'P3706', '23-05189-10-18', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 172.43, 0, '2023-10-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-181023-eBZkJTSY3c5vQ-001', '5a714105-2899-4f13-9705-0c6f4578ef80', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181023-eBZkJTSY3c5vQ-001&s=KOL2023&nf=P3706&i=172.43&cr=146', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
