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
(3206, 1, 34, 2, 0, NULL, 0, '2023-05-17 07:37:13', '2023-05-17 10:59:59', '2023-05-17', 'P3024', '23-04325-05-17', 'Entregar de martes a jueves de 9 a 12', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'peluqueria Marzo21 calle iparraguirre34 plaza trasera   Leioa Bizkaia', 'Leioa', 'Bizkaia', '48940', 'España', 620.73, 0, '2023-05-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170523-iHWF2PiBAc8aO-208', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-iHWF2PiBAc8aO-208&s=KOL2023&nf=P3024&i=620.73&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3207, 1, 633, 2, 0, NULL, 0, '2023-05-17 08:56:29', '2023-05-17 11:04:31', '2023-05-17', 'P3025', '23-04326-05-17', '', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Calle Abeto, 3 (Urbanización Los Robles)', 'Torrelodones', 'Madrid', '28250', 'España', 40.08, 0, '2023-05-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170523-X9lfYvVNah1SC-161', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-X9lfYvVNah1SC-161&s=KOL2023&nf=P3025&i=40.08&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3208, 1, 65, 2, 0, NULL, 0, '2023-05-17 10:31:46', '2023-06-14 13:59:05', '2023-05-17', 'P3026', '23-04327-05-17', '', 0.00, 712.50, 149.63, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 862.13, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170523-Gf0VJyknSgFs1-011', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-Gf0VJyknSgFs1-011&s=KOL2023&nf=P3026&i=862.13&cr=011', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3209, 1, 65, 2, 0, NULL, 0, '2023-05-17 10:31:49', '2023-06-14 13:57:58', '2023-05-17', 'P3027', '23-04328-05-17', '', 0.00, 712.50, 149.63, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 862.13, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170523-ATXAqVoVx6vCT-086', '4fe16271-627d-483f-8999-5df7b82a4070', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-ATXAqVoVx6vCT-086&s=KOL2023&nf=P3027&i=862.13&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3210, 1, 262, 2, 0, NULL, 0, '2023-05-17 11:18:03', '2023-05-18 10:33:05', '2023-05-17', 'P3028', '23-04329-05-17', 'Horario: de martes a viernes de 9h a 13h y de 16h a 19h', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 68.97, 0, '2023-05-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170523-CVspWgQGj2deh-020', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-CVspWgQGj2deh-020&s=KOL2023&nf=P3028&i=68.97&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3211, 1, 406, 2, 0, NULL, 0, '2023-05-17 11:31:57', '2023-05-18 10:37:19', '2023-05-17', 'P3029', '23-04330-05-17', '', 0.00, 28.01, 6.65, 0.00, 0, 0.00, 4.40, 'C/ Blas de Otero 32 5A', 'Bilbao', 'Bizkaia', '48014', 'España', 38.29, 0, '2023-05-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170523-j15gaj/zneVLj-231', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-j15gaj%2FzneVLj-231&s=KOL2023&nf=P3029&i=38.29&cr=248', '[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
(3212, 1, 23, 2, 0, NULL, 0, '2023-05-17 12:04:57', '2023-05-18 10:49:05', '2023-05-17', 'P3030', '23-04331-05-17', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 137.94, 0, '2023-05-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170523-o8Qzhh5KI3Syl-175', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-o8Qzhh5KI3Syl-175&s=KOL2023&nf=P3030&i=137.94&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3213, 1, 808, 2, 0, NULL, 0, '2023-05-17 18:55:45', '2023-05-18 10:51:35', '2023-05-17', 'P3031', '23-04332-05-17', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Fontanería Larrañaga-Eguren, Juan XXIII', 'Bergara', 'Gipuzkoa', '20570', 'España', 16.29, 0, '2023-05-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170523-CtwcNqDNzoDba-239', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-CtwcNqDNzoDba-239&s=KOL2023&nf=P3031&i=16.29&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3214, 1, 378, 2, 0, NULL, 0, '2023-05-17 19:19:28', '2023-05-18 10:52:29', '2023-05-17', 'P3032', '23-04333-05-17', 'Entregar entre las 9,00 y las 13,00 por la mañana y entre las 16,30 y las 19,30 por la tarde', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Elizgibela 1 -Bajo', 'Burlada/Burlata', 'Navarra', '31600', 'España', 40.08, 0, '2023-05-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170523-pVFKpzLOJ1yjk-133', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170523-pVFKpzLOJ1yjk-133&s=KOL2023&nf=P3032&i=40.08&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3215, 1, 686, 2, 0, NULL, 0, '2023-05-18 09:21:49', '2023-05-18 11:34:56', '2023-05-18', 'P3033', '23-04334-05-18', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Sancho el sabio 11. Local 3. UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 275.88, 0, '2023-05-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180523-iRB1UEz0sxsGU-133', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180523-iRB1UEz0sxsGU-133&s=KOL2023&nf=P3033&i=275.88&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3216, 1, 221, 2, 0, NULL, 0, '2023-05-18 10:08:08', '2023-05-18 12:18:12', '2023-05-18', 'P3034', '23-04335-05-18', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 68.97, 0, '2023-05-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180523-i8VzQqjGnMIJO-238', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180523-i8VzQqjGnMIJO-238&s=KOL2023&nf=P3034&i=68.97&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3217, 1, 108, 2, 0, NULL, 0, '2023-05-18 22:32:59', '2023-05-19 09:31:40', '2023-05-18', 'P3035', '23-04336-05-18', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180523-AjLyERS3BhIae-195', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180523-AjLyERS3BhIae-195&s=KOL2023&nf=P3035&i=241.40&cr=206', '[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
(3218, 1, 77, 1, 0, NULL, 0, '2023-05-19 09:40:09', '2023-05-19 09:43:58', '2023-05-19', 'P3036', '2023-05-19', '', 0.00, 390.00, 81.90, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 471.90, 0, '2023-05-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190523-NZp2CF2CSbZVP-218', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190523-NZp2CF2CSbZVP-218&s=KOL2023&nf=P3036&i=471.90&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3219, 1, 601, 2, 0, NULL, 0, '2023-05-19 09:29:40', '2023-05-19 12:07:57', '2023-05-19', 'P3037', '23-04337-05-19', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'KAMIÑAZPI, 61-3 DCHA', 'Ondarroa', 'Bizkaia', '48700', 'España', 59.47, 0, '2023-05-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190523-a6VkcAN4Mkhfq-097', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190523-a6VkcAN4Mkhfq-097&s=KOL2023&nf=P3037&i=59.47&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3220, 1, 601, 2, 0, NULL, 0, '2023-05-19 09:40:54', '2023-06-08 12:00:16', '2023-05-19', 'P3038', '23-04338-05-19', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'KAMIÑAZPI, 61-3 DCHA', 'Ondarroa', 'Bizkaia', '48700', 'España', 59.47, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190523-fCX6D1mhoyCTc-159', 'fee9c69c-994f-477f-850f-5faf7307f27f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190523-fCX6D1mhoyCTc-159&s=KOL2023&nf=P3038&i=59.47&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3221, 1, 632, 2, 0, NULL, 0, '2023-05-19 21:13:14', '2023-05-22 09:22:22', '2023-05-19', 'P3039', '23-04339-05-19', '', 0.00, 44.40, 10.08, 0.00, 0, 0.00, 4.40, 'Urbieta 57, bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 58.12, 0, '2023-05-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190523-cCwQ2u0JjGAlw-062', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190523-cCwQ2u0JjGAlw-062&s=KOL2023&nf=P3039&i=58.12&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3222, 1, 388, 2, 0, NULL, 0, '2023-05-20 19:10:09', '2023-05-22 09:25:35', '2023-05-20', 'P3040', '23-04342-05-20', 'Entrega a partir de las 17:30', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Leon Felipe, 27, 7ºE', 'Zaragoza', 'Zaragoza', '50018', 'España', 28.19, 0, '2023-05-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200523-JZ/GBVUrmKJDP-232', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200523-JZ%2FGBVUrmKJDP-232&s=KOL2023&nf=P3040&i=28.19&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3223, 1, 676, 2, 0, NULL, 0, '2023-05-21 14:57:02', '2023-05-22 09:31:38', '2023-05-21', 'P3041', '23-04343-05-21', 'Entrega en Beyond ', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Paseo de Gracia 98, piso 5 Beyond', 'Barcelona', 'Barcelona', '08008', 'España', 16.29, 0, '2023-05-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210523-mePRLVpesgiS2-065', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210523-mePRLVpesgiS2-065&s=KOL2023&nf=P3041&i=16.29&cr=063', '[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
(3224, 1, 569, 2, 0, NULL, 0, '2023-05-21 17:08:42', '2023-05-22 09:34:35', '2023-05-21', 'P3042', '23-04344-05-21', 'AUTAMA (ATT.UNAI BEITIA)', 0.00, 39.32, 9.02, 0.00, 0, 0.00, 4.40, 'Ctra.Ocaña 60B', 'Alicante/Alacant', 'Alicante', '03006', 'España', 51.98, 0, '2023-05-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210523-FE5HYpgc86oSu-168', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210523-FE5HYpgc86oSu-168&s=KOL2023&nf=P3042&i=51.98&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3225, 1, 809, 2, 0, NULL, 0, '2023-05-22 07:46:17', '2023-05-22 09:52:01', '2023-05-22', 'P3043', '23-04345-05-22', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'PASEO SAN JUAN BOSCO Nº 25 2º IZDA', 'Monzón', 'Huesca', '22400', 'España', 16.29, 0, '2023-05-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220523-d8iSueLVrGS7Q-055', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220523-d8iSueLVrGS7Q-055&s=KOL2023&nf=P3043&i=16.29&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3226, 1, 131, 2, 0, NULL, 0, '2023-05-22 08:37:20', '2023-05-23 09:04:07', '2023-05-22', 'P3044', '23-04346-05-22', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'C / general eguia frente al 31, Peluqueria bilbo', 'Bilbao', 'Bizkaia', '48920', 'España', 310.37, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220523-EdXsFNCxinDf8-049', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220523-EdXsFNCxinDf8-049&s=KOL2023&nf=P3044&i=310.37&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3227, 1, 810, 2, 0, NULL, 0, '2023-05-23 08:18:32', '2023-05-23 10:36:40', '2023-05-23', 'P3045', '23-04349-05-23', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Calle el sol 14 1°C', 'Tordesillas', 'Valladolid', '47100', 'España', 28.19, 0, '2023-05-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230523-Buuk1Ssigp9rZ-181', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230523-Buuk1Ssigp9rZ-181&s=KOL2023&nf=P3045&i=28.19&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3228, 1, 262, 2, 0, NULL, 0, '2023-05-23 08:26:33', '2023-05-23 10:39:26', '2023-05-23', 'P3046', '23-04350-05-23', '', 0.00, 50.70, 10.65, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 61.35, 0, '2023-05-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230523-gMw3j1RtZ6ehZ-159', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230523-gMw3j1RtZ6ehZ-159&s=KOL2023&nf=P3046&i=61.35&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3229, 1, 190, 3, 0, NULL, 0, '2023-05-23 11:25:11', '2023-05-23 11:28:47', '2023-05-23', '', 'consumo peluquería', '', 0.00, 221.70, 46.56, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 268.26, 0, '2023-05-23 00:00:00', '', '', 1, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3230, 1, 190, 3, 0, NULL, 0, '2023-05-23 12:37:42', '2023-05-23 12:38:18', '2023-05-23', '', 'consumo peluquería', '', 0.00, 7.40, 1.55, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 8.95, 0, '2023-05-23 00:00:00', '', '', 1, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3231, 1, 77, 1, 0, NULL, 0, '2023-05-23 13:32:13', '2023-06-14 13:59:56', '2023-05-23', 'P3047', '2023-05-23', '', 0.00, 156.00, 32.76, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 188.76, 0, '2023-05-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230523-ITOc9HP6X8YnD-238', '59ae9138-efc3-4fd5-ae7e-abb2dd6a468c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230523-ITOc9HP6X8YnD-238&s=KOL2023&nf=P3047&i=188.76&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0);
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
(3232, 1, 811, 2, 0, NULL, 0, '2023-05-23 13:59:53', '2023-05-24 09:07:40', '2023-05-23', 'P3048', '23-04351-05-23', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Paraje Rejuela MT 24', 'Monóvar/Monòver', 'Alicante', '03640', 'España', 28.19, 0, '2023-05-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230523-NH+1S+++zz4V+-142', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230523-NH%2B1S%2B%2B%2Bzz4V%2B-142&s=KOL2023&nf=P3048&i=28.19&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3233, 1, 812, 2, 0, NULL, 0, '2023-05-23 14:17:11', '2023-05-24 09:15:28', '2023-05-23', 'P3049', '23-04352-05-23', '', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Toribio Alzaga 15, 4C', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 40.08, 0, '2023-05-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230523-SOmD0+sbsJ3Aj-102', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230523-SOmD0%2BsbsJ3Aj-102&s=KOL2023&nf=P3049&i=40.08&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3234, 1, 220, 2, 0, NULL, 0, '2023-05-23 16:53:00', '2023-05-24 09:18:23', '2023-05-23', 'P3050', '23-04353-05-23', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 241.40, 0, '2023-05-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230523-PbcQPuO4jGw01-216', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230523-PbcQPuO4jGw01-216&s=KOL2023&nf=P3050&i=241.40&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3235, 1, 85, 2, 0, NULL, 0, '2023-05-23 20:16:07', '2023-05-24 11:44:41', '2023-05-23', 'P3051', '23-04354-05-23', '', 0.00, 100.30, 21.06, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 121.36, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230523-YcZl7xx3cG3/V-060', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230523-YcZl7xx3cG3%2FV-060&s=KOL2023&nf=P3051&i=121.36&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3236, 1, 813, 2, 0, NULL, 0, '2023-05-23 21:47:58', '2023-05-24 09:24:00', '2023-05-23', 'P3052', '23-04355-05-23', 'Si no estamos en casa, dejar el paquete en el porche, se puede dejar dentro desde la puerta de la calle.', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Antzalde, 12B', 'Lazkao', 'Gipuzkoa', '20210', 'España', 26.40, 0, '2023-05-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-230523-ObHk2LLqOm4y/-174', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230523-ObHk2LLqOm4y%2F-174&s=KOL2023&nf=P3052&i=26.40&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3237, 1, 263, 2, 0, NULL, 0, '2023-05-24 06:37:10', '2023-05-24 09:27:58', '2023-05-24', 'P3053', '23-04360-05-24', 'Urbanización Quintaleja \r\nEn el encinar de los reyes ', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Calle de san Enrique de osso 123', 'Madrid', 'Madrid', '28055', 'España', 59.47, 0, '2023-05-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240523-JF9zz3mmtshtz-068', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240523-JF9zz3mmtshtz-068&s=KOL2023&nf=P3053&i=59.47&cr=203', '[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
(3238, 1, 696, 1, 0, NULL, 0, '2023-05-24 09:18:56', '2023-05-24 09:19:07', '2023-05-24', 'P3054', '2023-05-24', '', 0.00, 327.60, 68.80, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 396.40, 0, '2023-05-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240523-eySBuwkQTbPU+-133', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240523-eySBuwkQTbPU%2B-133&s=KOL2023&nf=P3054&i=396.40&cr=210', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3239, 1, 77, 1, 0, NULL, 0, '2023-05-24 09:21:50', '2023-05-24 09:21:50', '2023-05-24', 'P3055', '2023-05-24', '', 0.00, 273.00, 57.33, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 330.33, 0, '2023-05-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240523-JCVREk+QemX/+-020', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240523-JCVREk%2BQemX%2F%2B-020&s=KOL2023&nf=P3055&i=330.33&cr=082', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3240, 1, 657, 2, 0, NULL, 0, '2023-05-24 10:43:10', '2023-05-24 13:07:42', '2023-05-24', 'P3056', '23-04361-05-24', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Calle Jose Miguel Barandiaran, número 8', 'Orkoien', 'Navarra', '31160', 'España', 28.19, 0, '2023-05-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240523-ga1d/FNNfDTXb-126', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240523-ga1d%2FFNNfDTXb-126&s=KOL2023&nf=P3056&i=28.19&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3241, 1, 783, 2, 0, NULL, 0, '2023-05-24 14:27:29', '2023-05-25 09:06:29', '2023-05-24', 'P3057', '23-04362-05-24', '', 0.00, 47.67, 10.01, 0.00, 0, 0.00, 0.00, 'Alvaro Cunqueiro, nº 15, 7º A', 'Vigo', 'Pontevedra', '36211', 'España', 57.68, 0, '2023-05-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240523-X6OT0zDcNc/H+-163', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240523-X6OT0zDcNc%2FH%2B-163&s=KOL2023&nf=P3057&i=57.68&cr=089', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3242, 1, 641, 2, 0, NULL, 0, '2023-05-25 10:24:41', '2023-05-25 12:40:43', '2023-05-25', 'P3058', '23-04363-05-25', '', 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-05-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250523-LcfcV6EB1fw6/-245', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250523-LcfcV6EB1fw6%2F-245&s=KOL2023&nf=P3058&i=68.97&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3243, 1, 7, 1, 0, NULL, 0, '2023-05-25 13:30:24', '2023-05-25 13:30:24', '2023-05-25', 'P3059', '2023-05-25', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 379.34, 0, '2023-05-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250523-epcFovsfyKhQc-188', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250523-epcFovsfyKhQc-188&s=KOL2023&nf=P3059&i=379.34&cr=046', '[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
(3244, 1, 4, 2, 0, NULL, 0, '2023-05-25 14:44:25', '2023-05-26 09:20:33', '2023-05-25', 'P3060', '23-04364-05-25', '', 0.00, 278.70, 58.53, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 337.23, 0, '2023-05-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250523-FQrk7wVyhJyYH-221', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250523-FQrk7wVyhJyYH-221&s=KOL2023&nf=P3060&i=337.23&cr=138', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3245, 1, 754, 2, 0, NULL, 0, '2023-05-25 16:50:07', '2023-05-26 09:34:41', '2023-05-25', 'P3061', '23-04365-05-25', '', 0.00, 51.80, 10.88, 0.00, 1, 2.69, 0.00, 'Josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 65.37, 0, '2023-05-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250523-irjlZZXQxPoFk-142', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250523-irjlZZXQxPoFk-142&s=KOL2023&nf=P3061&i=65.37&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3246, 1, 752, 2, 0, NULL, 0, '2023-05-26 05:31:19', '2023-05-26 09:40:31', '2023-05-26', 'P3062', '23-04366-05-26', 'Concesionario IMP SPORT BILBAO ', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Poligono Iru bide 2-3. Pabellón 5, Concesionario imp sport bilbao', 'Galdakao', 'Bizkaia', '48960', 'España', 28.19, 0, '2023-05-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260523-HMOKHQAkOoVvD-050', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260523-HMOKHQAkOoVvD-050&s=KOL2023&nf=P3062&i=28.19&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3247, 1, 814, 2, 0, NULL, 0, '2023-05-26 09:38:53', '2023-05-26 12:19:16', '2023-05-26', 'P3063', '23-04367-05-26', '', 0.00, 147.45, 30.96, 0.00, 0, 0.00, 0.00, 'C/ Txantrea 7 PUIU 31394', 'Pueyo', 'Navarra', '31394', 'España', 178.41, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260523-iUYplOMWC0ckA-121', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260523-iUYplOMWC0ckA-121&s=KOL2023&nf=P3063&i=178.41&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3248, 1, 80, 2, 0, NULL, 0, '2023-05-26 09:44:13', '2023-05-26 12:25:16', '2023-05-26', 'P3064', '23-04368-05-26', '', 0.00, 370.50, 77.81, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 448.31, 0, '2023-05-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260523-SNAOoPTJIffXW-197', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260523-SNAOoPTJIffXW-197&s=KOL2023&nf=P3064&i=448.31&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3249, 1, 815, 2, 0, NULL, 0, '2023-05-26 14:40:01', '2023-05-29 09:05:19', '2023-05-26', 'P3065', '23-04369-05-26', '', 0.00, 39.32, 9.02, 0.00, 0, 0.00, 4.40, 'Jacinto Benavente, 8', 'Sevilla la Nueva', 'Madrid', '28609', 'España', 51.98, 0, '2023-05-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260523-oGy2HSaDpC2dj-093', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260523-oGy2HSaDpC2dj-093&s=KOL2023&nf=P3065&i=51.98&cr=229', '[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
(3250, 1, 816, 2, 0, NULL, 0, '2023-05-26 18:49:12', '2023-05-29 09:09:15', '2023-05-26', 'P3066', '23-04370-05-26', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Calle Leo N 8', 'Cáceres', 'Cáceres', '10001', 'España', 26.40, 0, '2023-05-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260523-QiMCvFuOM/oQR-056', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260523-QiMCvFuOM%2FoQR-056&s=KOL2023&nf=P3066&i=26.40&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3251, 1, 167, 2, 0, NULL, 0, '2023-05-27 11:00:40', '2023-05-30 09:51:50', '2023-05-27', 'P3067', '23-04371-05-27', '', 0.00, 185.80, 39.02, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 224.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-270523-XBzpQu615zetu-082', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270523-XBzpQu615zetu-082&s=KOL2023&nf=P3067&i=224.82&cr=074', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3252, 1, 817, 2, 0, NULL, 0, '2023-05-27 15:51:20', '2023-05-29 09:20:45', '2023-05-27', 'P3068', '23-04372-05-27', '', 0.00, 39.32, 9.02, 0.00, 0, 0.00, 4.40, 'calle RafaelAlberti 37', 'Riogordo', 'Málaga', '29180', 'España', 51.98, 0, '2023-05-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270523-au3DcW5JqMuJn-075', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270523-au3DcW5JqMuJn-075&s=KOL2023&nf=P3068&i=51.98&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3253, 1, 818, 2, 0, NULL, 0, '2023-05-28 15:28:37', '2023-05-29 09:24:47', '2023-05-28', 'P3069', '23-04374-05-28', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'C/ Península Ibérica, 13', 'Ponferrada', 'León', '24411', 'España', 59.47, 0, '2023-05-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280523-AVHRLFSONFJtG-070', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280523-AVHRLFSONFJtG-070&s=KOL2023&nf=P3069&i=59.47&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3254, 1, 0, 4, 0, NULL, 0, '2023-05-29 10:54:30', '2023-05-29 10:54:30', '2023-05-29', '', '', '', 0.00, 113.52, 23.84, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 137.36, 0, '2023-05-29 00:00:00', '', '', 1, 1, 1, '', '', '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3255, 1, 819, 2, 0, NULL, 0, '2023-05-29 09:04:53', '2023-05-29 11:33:15', '2023-05-29', 'P3070', '23-04375-05-29', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'C/ juan de ortega 28', 'Málaga', 'Málaga', '29190', 'España', 16.29, 0, '2023-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290523-hM6kotkzyfn1i-217', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290523-hM6kotkzyfn1i-217&s=KOL2023&nf=P3070&i=16.29&cr=230', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3256, 1, 53, 2, 0, NULL, 0, '2023-05-29 09:24:03', '2023-05-29 11:35:00', '2023-05-29', 'P3071', '23-04376-05-29', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 140.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290523-JWEbxvdEE40fh-009', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290523-JWEbxvdEE40fh-009&s=KOL2023&nf=P3071&i=140.44&cr=197', '[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
(3257, 1, 310, 2, 0, NULL, 0, '2023-05-29 10:11:41', '2023-05-29 12:18:47', '2023-05-29', 'P3072', '23-04377-05-29', '', 0.00, 54.54, 11.45, 0.00, 0, 0.00, 0.00, 'Avd. 8 de marzo, 19 9ª-D', 'Vitoria-Gasteiz', 'Álava', '01002', 'España', 65.99, 0, '2023-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290523-dlgxZT3D3wa3m-073', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290523-dlgxZT3D3wa3m-073&s=KOL2023&nf=P3072&i=65.98&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3258, 1, 635, 2, 0, NULL, 0, '2023-05-29 14:43:43', '2023-05-30 09:29:39', '2023-05-29', 'P3073', '23-04380-05-29', 'SI ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703 (ESTOY AL LADO). GRACIAS.', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 206.91, 0, '2023-05-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290523-eR8aj9wVibll3-006', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290523-eR8aj9wVibll3-006&s=KOL2023&nf=P3073&i=206.91&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3259, 1, 393, 2, 0, NULL, 0, '2023-05-30 09:06:32', '2023-05-30 11:09:36', '2023-05-30', 'P3074', '23-04387-05-30', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'RÍO GUADIANA, 23, sol y luz', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 28.19, 0, '2023-05-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300523-CFzM7T0SHNJgp-061', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300523-CFzM7T0SHNJgp-061&s=KOL2023&nf=P3074&i=28.19&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3260, 1, 820, 2, 0, NULL, 0, '2023-05-30 12:32:36', '2023-05-31 08:59:07', '2023-05-30', 'P3075', '23-04388-05-30', '', 0.00, 58.98, 12.82, 0.00, 0, 0.00, 2.50, 'Calle Arcchiduque Otto de Habsburgo 24 (Salon asambleas Testigos de Jehová)', 'Benidorm', 'Alicante', '03503', 'España', 73.87, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-300523-RRsrnmHnv0eML-100', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300523-RRsrnmHnv0eML-100&s=KOL2023&nf=P3075&i=73.87&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3261, 1, 17, 2, 0, NULL, 0, '2023-05-30 13:59:38', '2023-05-31 09:02:25', '2023-05-30', 'P3076', '23-04389-05-30', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 137.94, 0, '2023-05-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300523-ersGtscvasV9v-115', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300523-ersGtscvasV9v-115&s=KOL2023&nf=P3076&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),
(3262, 1, 144, 2, 0, NULL, 0, '2023-05-30 17:19:44', '2023-05-31 09:08:12', '2023-05-30', 'P3077', '23-04390-05-30', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 103.46, 0, '2023-05-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300523-C+UpvEdOib3hw-073', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300523-C%2BUpvEdOib3hw-073&s=KOL2023&nf=P3077&i=103.46&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
