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
(3042, 1, 275, 2, 0, NULL, 0, '2023-04-16 08:40:29', '2023-04-17 09:19:33', '2023-04-16', 'P2864', '23-04113-04-16', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Beata Margarita López De Maturana, 5', 'Bilbao', 'Bizkaia', '48003', 'España', 59.47, 0, '2023-04-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160423-kPo1IGUEh6fDG-222', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160423-kPo1IGUEh6fDG-222&s=KOL2023&nf=P2864&i=59.47&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3043, 1, 761, 2, 0, NULL, 0, '2023-04-16 10:05:03', '2023-04-17 09:24:35', '2023-04-16', 'P2865', '23-04114-04-16', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Forn,4', 'Terrassa', 'Barcelona', '08221', 'España', 16.29, 0, '2023-04-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160423-Ymb6HRLf8SQ0f-230', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160423-Ymb6HRLf8SQ0f-230&s=KOL2023&nf=P2865&i=16.29&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3044, 1, 635, 2, 0, NULL, 0, '2023-04-16 18:22:46', '2023-04-17 09:30:49', '2023-04-16', 'P2866', '23-04122-04-16', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-160423-mu4D2pS9pCmWD-209', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160423-mu4D2pS9pCmWD-209&s=KOL2023&nf=P2866&i=275.88&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3045, 1, 762, 2, 0, NULL, 0, '2023-04-16 19:15:44', '2023-04-17 09:37:45', '2023-04-16', 'P2867', '23-04124-04-16', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'TEILERIA KALEA  Nº 6 - D', 'Irun', 'Gipuzkoa', '20305', 'España', 55.89, 0, '2023-04-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160423-R0N24a/Zx80sn-188', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160423-R0N24a%2FZx80sn-188&s=KOL2023&nf=P2867&i=55.89&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3046, 1, 763, 2, 0, NULL, 0, '2023-04-17 06:32:34', '2023-04-17 09:40:54', '2023-04-17', 'P2868', '23-04126-04-17', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Bekuri Kalea 21', 'Legutiano', 'Álava', '01170', 'España', 28.19, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-gUy7O+QcM5I1/-077', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-gUy7O%2BQcM5I1%2F-077&s=KOL2023&nf=P2868&i=28.19&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3047, 1, 754, 2, 0, NULL, 0, '2023-04-17 07:12:22', '2023-04-18 10:45:27', '2023-04-17', 'P2869', '23-04127-04-17', 'Acuerdate de ponerme la prebase dorada.\r\ngracias\r\nsi puedes ponerme folletos paras las clientas....\r\n', 0.00, 66.60, 13.99, 0.00, 1, 3.46, 0.00, 'josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 84.05, 0, '2023-04-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170423-BsrqlsnHdrctt-187', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-BsrqlsnHdrctt-187&s=KOL2023&nf=P2869&i=84.05&cr=097', '[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
(3048, 1, 764, 2, 0, NULL, 0, '2023-04-17 10:00:04', '2023-04-18 10:24:59', '2023-04-17', 'P2870', '23-04128-04-17', '', 0.00, 74.20, 15.58, 0.00, 0, 0.00, 0.00, 'Calle Badalona, 102, 4A', 'Madrid', 'Madrid', '28034', 'España', 89.78, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170423-JugqN4P8bpFRt-131', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-JugqN4P8bpFRt-131&s=KOL2023&nf=P2870&i=89.78&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3049, 1, 157, 2, 0, NULL, 0, '2023-04-17 10:09:19', '2023-04-17 12:21:03', '2023-04-17', 'P2871', '23-04129-04-17', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'calle apodaca,1', 'Madrid', 'Madrid', '28004', 'España', 172.43, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-YyyKdrskIRL00-058', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-YyyKdrskIRL00-058&s=KOL2023&nf=P2871&i=172.43&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3050, 1, 157, 2, 0, NULL, 0, '2023-04-17 10:13:35', '2023-04-17 12:21:58', '2023-04-17', 'P2872', '23-04130-04-17', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'calle apodaca,1', 'Madrid', 'Madrid', '28004', 'España', 275.88, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-eY4RthUqhBr9O-161', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-eY4RthUqhBr9O-161&s=KOL2023&nf=P2872&i=275.88&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3051, 1, 765, 2, 0, NULL, 0, '2023-04-17 13:29:43', '2023-04-18 11:02:51', '2023-04-17', 'P2873', '23-04131-04-17', '', 0.00, 230.20, 48.78, 0.00, 0, 0.00, 2.50, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 281.04, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-170423-QwqUSxg3Ohfnc-239', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-QwqUSxg3Ohfnc-239&s=KOL2023&nf=P2873&i=281.04&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3052, 1, 416, 2, 0, NULL, 0, '2023-04-17 14:35:27', '2023-04-18 09:30:18', '2023-04-17', 'P2874', '23-04134-04-17', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'C/ Damas Apostolicas, 8, ático M ', 'Nigrán', 'Pontevedra', '36370', 'España', 26.40, 0, '2023-04-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170423-am48ZX5eQFkmp-160', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-am48ZX5eQFkmp-160&s=KOL2023&nf=P2874&i=26.40&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3053, 1, 248, 2, 0, NULL, 0, '2023-04-17 14:59:53', '2023-04-18 09:36:18', '2023-04-17', 'P2875', '23-04135-04-17', 'Miércoles cerrado', 0.00, 74.00, 15.54, 0.00, 0, 0.00, 0.00, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 89.54, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-EpOHlEKz4mE5e-066', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-EpOHlEKz4mE5e-066&s=KOL2023&nf=P2875&i=89.54&cr=185', '[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
(3054, 1, 382, 2, 0, NULL, 0, '2023-04-17 15:10:56', '2023-04-18 09:48:17', '2023-04-17', 'P2876', '23-04136-04-17', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'C/ Boulevard de Mariturri 60 - 2B', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 28.19, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-nEobxVTgYssu6-175', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-nEobxVTgYssu6-175&s=KOL2023&nf=P2876&i=28.19&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3055, 1, 766, 2, 0, NULL, 0, '2023-04-17 15:23:32', '2023-04-18 09:50:24', '2023-04-17', 'P2877', '23-04137-04-17', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Rambla nova 84', 'Tarragona', 'Tarragona', '43003', 'España', 26.40, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-bxD9f6c7zUbze-244', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-bxD9f6c7zUbze-244&s=KOL2023&nf=P2877&i=26.40&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3056, 1, 568, 2, 0, NULL, 0, '2023-04-17 16:35:47', '2023-04-18 09:57:33', '2023-04-17', 'P2878', '23-04138-04-17', 'peluquería el marco blanco', 0.00, 185.80, 39.02, 0.00, 0, 0.00, 0.00, 'larramendi 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 224.82, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-f6Q//CfPFu5Md-158', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-f6Q%2F%2FCfPFu5Md-158&s=KOL2023&nf=P2878&i=224.82&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3057, 1, 767, 2, 0, NULL, 0, '2023-04-17 17:16:13', '2023-04-18 10:04:38', '2023-04-17', 'P2879', '23-04139-04-17', 'De lunes a viernes por las mañanas', 0.00, 39.32, 9.02, 0.00, 0, 0.00, 4.40, 'Calle Pablo Ruiz Picasso, n° 9', 'Utebo', 'Zaragoza', '50180', 'España', 51.98, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-attoiou0tX0mR-128', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-attoiou0tX0mR-128&s=KOL2023&nf=P2879&i=51.98&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3058, 1, 768, 2, 0, NULL, 0, '2023-04-17 18:11:56', '2023-04-18 10:07:46', '2023-04-17', 'P2880', '23-04140-04-17', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Paseo Lazkano 18, Bajo derecha', 'Donostia-San Sebasti', 'Gipuzkoa', '2009', 'España', 16.29, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-bOxcmR56CIL4A-221', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-bOxcmR56CIL4A-221&s=KOL2023&nf=P2880&i=16.29&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3059, 1, 71, 2, 0, NULL, 0, '2023-04-17 21:46:43', '2023-04-18 10:14:29', '2023-04-17', 'P2881', '23-04142-04-17', '', 0.00, 116.20, 24.40, 0.00, 0, 0.00, 0.00, 'Casiano martinez 40 4I', 'Vigo', 'Pontevedra', '36208', 'España', 140.60, 0, '2023-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170423-GcGT7PcQPG7Xn-178', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-GcGT7PcQPG7Xn-178&s=KOL2023&nf=P2881&i=140.60&cr=158', '[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
(3060, 1, 765, 2, 0, NULL, 0, '2023-04-18 09:25:04', '2023-04-18 09:25:12', '2023-04-17', 'P2882', '23-04131-04-17', '', 0.00, 230.20, 48.78, 0.00, 0, 0.00, 2.50, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 281.04, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-170423-Zp3cY90CXP+/x-197', 'e0aad5c2-d3d5-4269-8ac1-7d7de62db70d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-Zp3cY90CXP%2B%2Fx-197&s=KOL2023&nf=P2882&i=281.04&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3061, 1, 765, 2, 0, NULL, 0, '2023-04-18 09:25:31', '2023-06-14 13:37:10', '2023-04-17', 'P2883', '23-04131-04-17', '', 0.00, 14.80, 3.54, 0.00, 0, 0.00, 2.50, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 20.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-170423-jc/iusQxUAaKE-071', '87ba1863-bffd-49a3-bdd1-56c506ce4044', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170423-jc%2FiusQxUAaKE-071&s=KOL2023&nf=P2883&i=20.41&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3062, 1, 269, 2, 0, NULL, 0, '2023-04-18 07:53:43', '2023-04-18 10:19:47', '2023-04-18', 'P2884', '23-04144-04-18', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Atxutegi 2 1°E', 'Erandio', 'Bizkaia', '48950', 'España', 16.29, 0, '2023-04-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180423-fAL/ceXmyvGlM-058', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-fAL%2FceXmyvGlM-058&s=KOL2023&nf=P2884&i=16.29&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3063, 1, 306, 2, 0, NULL, 0, '2023-04-18 09:18:35', '2023-04-18 11:38:56', '2023-04-18', 'P2885', '23-04145-04-18', 'horario:9:00-18:30 de martes a viernes\r\nsabados de 8:30-13:30', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'c/puigmolto n9 bajos', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 344.85, 0, '2023-04-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180423-P4Xs9Hjw1fyHp-048', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-P4Xs9Hjw1fyHp-048&s=KOL2023&nf=P2885&i=344.85&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3064, 1, 769, 2, 0, NULL, 0, '2023-04-18 10:42:17', '2023-04-18 12:49:09', '2023-04-18', 'P2886', '23-04146-04-18', '', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Calle Villavieja, 15 - Piso 10 Puerta 40', 'Castellón de la Plan', 'Castellón', '12003', 'España', 40.08, 0, '2023-04-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180423-Mfy0kdKld0K6m-049', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-Mfy0kdKld0K6m-049&s=KOL2023&nf=P2886&i=40.08&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3065, 1, 272, 2, 0, NULL, 0, '2023-04-18 12:24:01', '2023-04-19 09:06:46', '2023-04-18', 'P2887', '23-04147-04-18', '', 0.00, 78.64, 16.51, 0.00, 0, 0.00, 0.00, 'Los Cerros 27C', 'Palazuelos de Eresma', 'Segovia', '40194', 'España', 95.15, 0, '2023-04-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180423-Yq1Z2SONg+H/j-011', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-Yq1Z2SONg%2BH%2Fj-011&s=KOL2023&nf=P2887&i=95.15&cr=139', '[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
(3066, 1, 631, 2, 0, NULL, 0, '2023-04-18 12:42:08', '2023-04-19 09:09:16', '2023-04-18', 'P2888', '23-04148-04-18', 'ABIERTO DE LUNES A VIERNES DE 10 A 18 HORAS', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'CALLE LA HACIENDA DE PAVONES 15', 'Madrid', 'Madrid', '28030', 'España', 16.29, 0, '2023-04-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180423-Rkkx1LrkwJOeG-226', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-Rkkx1LrkwJOeG-226&s=KOL2023&nf=P2888&i=16.29&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3067, 1, 91, 2, 0, NULL, 0, '2023-04-18 13:57:50', '2023-04-19 09:14:35', '2023-04-18', 'P2889', '23-04149-04-18', '', 0.00, 185.80, 39.02, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 224.82, 0, '2023-04-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180423-BDLg3nBmFmEdT-140', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-BDLg3nBmFmEdT-140&s=KOL2023&nf=P2889&i=224.82&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3068, 1, 145, 2, 0, NULL, 0, '2023-04-18 14:49:49', '2023-04-19 09:20:20', '2023-04-18', 'P2890', '23-04150-04-18', '', 0.00, 199.50, 42.33, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 243.90, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-180423-lzqbAKbFaWjzI-024', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-lzqbAKbFaWjzI-024&s=KOL2023&nf=P2890&i=243.90&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3069, 1, 770, 2, 0, NULL, 0, '2023-04-18 15:51:14', '2023-04-19 09:24:09', '2023-04-18', 'P2891', '23-04151-04-18', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'c/ Berroa 4 2º planta oficina 210 Tajonar', 'Aranguren', 'Navarra', '31192', 'España', 16.29, 0, '2023-04-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180423-EEgqa3ScrF0gr-129', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-EEgqa3ScrF0gr-129&s=KOL2023&nf=P2891&i=16.29&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3070, 1, 323, 2, 0, NULL, 0, '2023-04-18 18:48:28', '2023-04-19 09:27:27', '2023-04-18', 'P2892', '23-04152-04-18', 'Entregar a partir de las 16 h', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Calle Las Camelias N10 1B', 'Alcorcón', 'Madrid', '28925', 'España', 26.40, 0, '2023-04-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180423-Tx2JxDHiqpI8C-019', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-Tx2JxDHiqpI8C-019&s=KOL2023&nf=P2892&i=26.40&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3071, 1, 108, 2, 0, NULL, 0, '2023-04-18 21:42:53', '2023-04-19 10:41:24', '2023-04-18', 'P2893', '23-04153-04-18', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180423-j4682ZX9TsgQj-178', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180423-j4682ZX9TsgQj-178&s=KOL2023&nf=P2893&i=137.94&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
(3072, 1, 77, 1, 0, NULL, 0, '2023-04-19 09:39:19', '2023-04-19 11:53:50', '2023-04-19', 'P2894', 'P2894', '', 0.00, 370.50, 77.80, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 448.30, 0, '2023-04-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190423-l0Uqz649S0s0g-100', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190423-l0Uqz649S0s0g-100&s=KOL2023&nf=P2894&i=448.30&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3073, 1, 342, 2, 0, NULL, 0, '2023-04-19 14:02:30', '2023-04-20 08:58:29', '2023-04-19', 'P2895', '23-04154-04-19', '', 0.00, 49.15, 10.32, 0.00, 0, 0.00, 0.00, 'Renaixement, 115 bajos 1a', 'Cerdanyola del Vallè', 'Barcelona', '08290', 'España', 59.47, 0, '2023-04-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190423-A64ftPNJcmp1z-241', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190423-A64ftPNJcmp1z-241&s=KOL2023&nf=P2895&i=59.47&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3074, 1, 17, 2, 0, NULL, 0, '2023-04-19 14:03:54', '2023-04-20 09:02:32', '2023-04-19', 'P2896', '23-04155-04-19', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 172.43, 0, '2023-04-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190423-LlbeHbkwnmTIu-034', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190423-LlbeHbkwnmTIu-034&s=KOL2023&nf=P2896&i=172.43&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3075, 1, 582, 2, 0, NULL, 0, '2023-04-19 15:41:02', '2023-04-20 09:05:12', '2023-04-19', 'P2897', '23-04156-04-19', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Calle Mar Mediterráneo 40', 'San Fernando de Hena', 'Madrid', '28830', 'España', 26.40, 0, '2023-04-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190423-lRczhcO5osvV4-017', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190423-lRczhcO5osvV4-017&s=KOL2023&nf=P2897&i=26.40&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3076, 1, 222, 2, 0, NULL, 0, '2023-04-19 19:39:36', '2023-04-20 09:12:39', '2023-04-19', 'P2898', '23-04157-04-19', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Cartagena 296 tenda 1 ', 'Barcelona', 'Barcelona', '08025', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190423-YLbB6Q4QZ2xgV-212', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190423-YLbB6Q4QZ2xgV-212&s=KOL2023&nf=P2898&i=137.94&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3077, 1, 566, 2, 0, NULL, 0, '2023-04-19 21:00:50', '2023-04-20 09:29:11', '2023-04-19', 'P2899', '23-04158-04-19', 'Peluquería ', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'C/sant cugat 29 ', 'Mataró', 'Barcelona', '08302', 'España', 275.88, 0, '2023-04-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190423-ZNShNAb0T3xpQ-126', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190423-ZNShNAb0T3xpQ-126&s=KOL2023&nf=P2899&i=275.88&cr=009', '[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
(3078, 1, 87, 2, 0, NULL, 0, '2023-04-20 08:48:08', '2023-04-25 09:16:18', '2023-04-20', 'P2900', '23-04159-04-20', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Centro comercial Arcco local P-17', 'Donostia', 'Gipuzkoa', '20011', 'ESPAÑA', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200423-VdneB+5taZeDL-064', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200423-VdneB%2B5taZeDL-064&s=KOL2023&nf=P2900&i=103.46&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3079, 1, 772, 2, 0, NULL, 0, '2023-04-20 10:54:56', '2023-04-20 13:05:48', '2023-04-20', 'P2901', '23-04160-04-20', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Erletxe errepidea 15 Asua', 'Erandio', 'Bizkaia', '48950', 'España', 26.40, 0, '2023-04-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200423-Pxn55I8oSVuBR-192', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200423-Pxn55I8oSVuBR-192&s=KOL2023&nf=P2901&i=26.40&cr=237', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3080, 1, 754, 2, 0, NULL, 0, '2023-04-20 11:02:27', '2023-04-20 13:08:58', '2023-04-20', 'P2902', '23-04161-04-20', '', 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-04-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-200423-ExhpHUKg5YKTB-095', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200423-ExhpHUKg5YKTB-095&s=KOL2023&nf=P2902&i=65.37&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3081, 1, 350, 2, 0, NULL, 0, '2023-04-20 14:05:50', '2023-04-21 08:58:36', '2023-04-20', 'P2903', '23-04163-04-20', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'c/ Balleneros, 19 Bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200423-XbWjGLYQu3p2p-030', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200423-XbWjGLYQu3p2p-030&s=KOL2023&nf=P2903&i=68.97&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3082, 1, 773, 2, 0, NULL, 0, '2023-04-20 14:38:59', '2023-04-21 09:03:22', '2023-04-20', 'P2904', '23-04164-04-20', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Uribarrena 28', 'Otxandio', 'Bizkaia', '48210', 'España', 16.29, 0, '2023-04-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-200423-f1IqbIBQxc/wz-054', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200423-f1IqbIBQxc%2Fwz-054&s=KOL2023&nf=P2904&i=16.29&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3083, 1, 533, 2, 0, NULL, 0, '2023-04-20 15:21:06', '2023-04-21 09:04:50', '2023-04-20', 'P2905', '23-04165-04-20', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Clara campoamor, num 2 esc. C  1-4', 'Gavà', 'Barcelona', '08850', 'España', 16.29, 0, '2023-04-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200423-naBBcsz5Ma8go-111', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200423-naBBcsz5Ma8go-111&s=KOL2023&nf=P2905&i=16.29&cr=018', '[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
(3084, 1, 80, 2, 0, NULL, 0, '2023-04-21 08:58:07', '2023-04-21 11:54:01', '2023-04-21', 'P2906', '23-04166-04-21', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 551.76, 0, '2023-04-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210423-CiuOsS67p8yRo-127', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210423-CiuOsS67p8yRo-127&s=KOL2023&nf=P2906&i=551.76&cr=013', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3085, 1, 774, 2, 0, NULL, 0, '2023-04-21 09:41:29', '2023-04-21 12:00:13', '2023-04-21', 'P2907', '23-04167-04-21', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Bonviatge n° 48 escalera 10 2°1°', 'Sant Joan Despí', 'Barcelona', '08970', 'España', 16.29, 0, '2023-04-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210423-S+05aj2IgPkoA-079', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210423-S%2B05aj2IgPkoA-079&s=KOL2023&nf=P2907&i=16.29&cr=255', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3086, 1, 775, 2, 0, NULL, 0, '2023-04-21 13:38:30', '2023-04-24 08:54:19', '2023-04-21', 'P2908', '23-04168-04-21', 'Horario La V 9:30 13:30 16:30 a 20', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'FARMACIA ARTABE ARRIZAR N10', 'Donostia-San Sebasti', 'Gipuzkoa', '20017', 'España', 16.29, 0, '2023-04-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210423-jvJNxTViAjL/q-251', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210423-jvJNxTViAjL%2Fq-251&s=KOL2023&nf=P2908&i=16.29&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3087, 1, 542, 2, 0, NULL, 0, '2023-04-21 15:01:06', '2023-04-24 08:55:37', '2023-04-21', 'P2909', '23-04169-04-21', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'Avda Niceto Alcala Zamora 11; portal E piso 1-D', 'Madrid', 'Madrid', '28050', 'España', 55.89, 0, '2023-04-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210423-XIFnCzJknxc39-049', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210423-XIFnCzJknxc39-049&s=KOL2023&nf=P2909&i=55.89&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3088, 1, 337, 2, 0, NULL, 0, '2023-04-21 16:13:21', '2023-04-24 08:56:50', '2023-04-21', 'P2910', '23-04170-04-21', '', 0.00, 44.40, 10.09, 0.00, 0, 0.00, 4.40, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 58.12, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210423-exapsr5aadbDf-124', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210423-exapsr5aadbDf-124&s=KOL2023&nf=P2910&i=58.12&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3089, 1, 497, 2, 0, NULL, 0, '2023-04-22 07:29:39', '2023-04-24 09:07:26', '2023-04-22', 'P2911', '23-04171-04-22', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Avda Madariaga nº11 2ºC', 'Bilbao', 'Bizkaia', '48014', 'España', 26.40, 0, '2023-04-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220423-olrzht7YRr3F3-041', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220423-olrzht7YRr3F3-041&s=KOL2023&nf=P2911&i=26.40&cr=089', '[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
(3090, 1, 471, 2, 0, NULL, 0, '2023-04-22 17:36:18', '2023-04-24 09:00:19', '2023-04-22', 'P2912', '23-04172-04-22', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Siervas de Jesús nº 4, 2º D', 'Logroño', 'La Rioja', '26001', 'España', 16.29, 0, '2023-04-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220423-XITEaWnDx+sCO-051', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220423-XITEaWnDx%2BsCO-051&s=KOL2023&nf=P2912&i=16.29&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3091, 1, 142, 2, 0, NULL, 0, '2023-04-23 11:31:25', '2023-04-24 09:01:38', '2023-04-23', 'P2913', '23-04173-04-23', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'C/ Manzanedo 12', 'Santoña', 'Cantabria', '39740', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-230423-OOhYmVJ3Pdrmz-193', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230423-OOhYmVJ3Pdrmz-193&s=KOL2023&nf=P2913&i=105.96&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3092, 1, 776, 2, 0, NULL, 0, '2023-04-23 13:17:37', '2023-04-24 09:03:33', '2023-04-23', 'P2914', '23-04174-04-23', 'Por favor, no dejar en el ascensor. Traerlo a casa.', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle María Domínguez 3, 6°B (Nuevo Artica)', 'Berrioplano', 'Navarra', '31013', 'España', 16.29, 0, '2023-04-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230423-QNpJ4Ai5v71l0-180', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230423-QNpJ4Ai5v71l0-180&s=KOL2023&nf=P2914&i=16.29&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3093, 1, 777, 2, 0, NULL, 0, '2023-04-24 09:25:29', '2023-04-24 12:02:34', '2023-04-24', 'P2915', '23-04175-04-24', '', 0.00, 39.32, 9.02, 0.00, 0, 0.00, 4.40, 'Artibai N26 bajo', 'Markina-Xemein', 'Bizkaia', '48270', 'España', 51.98, 0, '2023-04-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-240423-kdI51rUywfjmM-144', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240423-kdI51rUywfjmM-144&s=KOL2023&nf=P2915&i=51.98&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3094, 1, 97, 2, 0, NULL, 0, '2023-04-24 14:40:01', '2023-04-24 16:50:59', '2023-04-24', 'P2916', '23-04176-04-24', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Bidasoa 8, Bajo Bera', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 137.94, 0, '2023-04-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240423-ZlHAUAAec9xOy-216', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240423-ZlHAUAAec9xOy-216&s=KOL2023&nf=P2916&i=137.94&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3095, 1, 285, 2, 0, NULL, 0, '2023-04-24 21:32:41', '2023-04-25 09:22:01', '2023-04-24', 'P2917', '23-04177-04-24', '', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'PASAJE PUIGVERT, 8, 3C', 'Santa Coloma de Cerv', 'Barcelona', '08690', 'España', 40.08, 0, '2023-04-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240423-jGs7LSbcCRsF0-080', '', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240423-jGs7LSbcCRsF0-080&s=KOL2023&nf=P2917&i=40.08&cr=023', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
