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
(4291, 1, 686, 2, 0, NULL, 0, '2023-12-19 11:14:16', '2023-12-19 12:17:48', '2023-12-19', 'P4026', '23-05546-12-19', '', 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-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191223-LBBM64YE/UoId-057', '544718a9-59b4-4b9d-98a7-7cc48627b29d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191223-LBBM64YE%2FUoId-057&s=KOL2023&nf=P4026&i=172.43&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4292, 1, 17, 2, 0, NULL, 0, '2023-12-19 12:19:51', '2023-12-19 13:23:20', '2023-12-19', 'P4027', '23-05547-12-19', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 103.46, 0, '2023-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191223-kkAL7CoHQe2cj-155', '6fda4263-8bc0-4e1d-9bd2-d96e33691760', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191223-kkAL7CoHQe2cj-155&s=KOL2023&nf=P4027&i=103.46&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4293, 1, 476, 2, 0, NULL, 0, '2023-12-19 17:33:06', '2023-12-20 09:29:55', '2023-12-19', 'P4028', '23-05548-12-19', 'Empresa LAGON Rubber SL', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Portal de Gamarra 9-A; Pab. 17', 'Vitoria-Gasteiz', 'Álava', '01013', 'España', 78.63, 0, '2023-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191223-NzGcuVIFOVDrN-112', '3da1668b-a23f-4a46-afae-30ed9ef8a9eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191223-NzGcuVIFOVDrN-112&s=KOL2023&nf=P4028&i=78.63&cr=112', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4294, 1, 895, 2, 0, NULL, 0, '2023-12-19 18:07:05', '2023-12-20 09:30:09', '2023-12-19', 'P4029', '23-05549-12-19', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Echebeste etxadia n°6bajo', 'Oiartzun', 'Gipuzkoa', '20180', 'España', 43.71, 0, '2023-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191223-a7l6bWIvrdYH9-021', '398d9a58-6845-4623-a03d-e09968577b1d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191223-a7l6bWIvrdYH9-021&s=KOL2023&nf=P4029&i=43.71&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4295, 1, 859, 2, 0, NULL, 0, '2023-12-20 19:27:24', '2023-12-21 09:29:07', '2023-12-20', 'P4030', '23-05550-12-20', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Ctra Ex208 kilómetro 95', 'Conquista de la Sier', 'Cáceres', '10240', 'España', 43.71, 0, '2023-12-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201223-Q9mYxyHRY2eqy-252', '1b54a481-d1bd-45bd-b921-43e9b5060388', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201223-Q9mYxyHRY2eqy-252&s=KOL2023&nf=P4030&i=43.71&cr=240', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4296, 1, 1098, 2, 0, NULL, 0, '2023-12-20 20:35:50', '2023-12-21 09:32:28', '2023-12-20', 'P4031', '23-05551-12-20', 'Por la mañanas graciad', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Mayor 12', 'Asteasu', 'Gipuzkoa', '20159', 'España', 30.61, 0, '2023-12-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-201223-l/EHCPfYSaNg8-215', '48577ee4-d937-4e96-873b-9638d91185d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201223-l%2FEHCPfYSaNg8-215&s=KOL2023&nf=P4031&i=30.61&cr=205', '[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
(4297, 1, 1099, 2, 0, NULL, 0, '2023-12-21 09:39:20', '2023-12-21 10:42:01', '2023-12-21', 'P4032', '23-05562-12-21', 'Casa', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Carretera de Sabadell, 72', 'Rubí', 'Barcelona', '08191', 'España', 71.98, 0, '2023-12-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211223-TVW0mOU5tyMad-006', 'd28b1538-cb7c-43e2-95b9-54bebbb6eb00', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211223-TVW0mOU5tyMad-006&s=KOL2023&nf=P4032&i=71.98&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4298, 1, 898, 2, 0, NULL, 0, '2023-12-21 12:33:01', '2023-12-21 13:39:53', '2023-12-21', 'P4033', '23-05563-12-21', 'entregar lunes o miercoles', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'beato tomas de zumarraga nº2 3C', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 30.61, 0, '2023-12-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211223-Ut6Y2BDCC2q6J-000', '97492fbf-2e8b-4386-8cdd-7e80b8bb17e5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211223-Ut6Y2BDCC2q6J-000&s=KOL2023&nf=P4033&i=30.61&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4299, 1, 145, 2, 0, NULL, 0, '2023-12-21 14:15:32', '2023-12-22 10:12:30', '2023-12-21', 'P4034', '23-05564-12-21', '', 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-211223-jP0GuJhISg6vG-076', 'de61516a-08e0-4dad-9070-299e89d4d099', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211223-jP0GuJhISg6vG-076&s=KOL2023&nf=P4034&i=243.90&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4300, 1, 1100, 2, 0, NULL, 0, '2023-12-21 16:56:13', '2023-12-22 10:15:20', '2023-12-21', 'P4035', '23-05567-12-21', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'SANTA VIRGILIA 14 IZQ 7C', 'Madrid', 'Madrid', '28033', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-211223-CToLTiGRObdwr-253', '5b215556-337d-4a49-ada0-f72959c7c4da', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211223-CToLTiGRObdwr-253&s=KOL2023&nf=P4035&i=30.61&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4301, 1, 190, 3, 0, NULL, 0, '2023-12-22 10:31:05', '2023-12-22 10:31:05', '2023-12-22', '', 'consumo peluquería', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Pendiente de abonar', '20011', 'España', 68.97, 0, '2023-12-22 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),
(4302, 1, 845, 2, 0, NULL, 0, '2023-12-22 12:20:51', '2023-12-22 13:23:33', '2023-12-22', 'P4036', '23-05568-12-22', 'Hay principal. Es como un segundo ', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Panaderos 68 1 izquierda', 'Valladolid', 'Valladolid', '47004', 'España', 61.09, 0, '2023-12-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221223-N/CI+PJB22gmR-009', '70653c31-38de-448f-a950-76923e7c1317', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221223-N%2FCI%2BPJB22gmR-009&s=KOL2023&nf=P4036&i=61.09&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4303, 1, 962, 2, 0, NULL, 0, '2023-12-23 12:29:24', '2023-12-26 09:16:09', '2023-12-23', 'P4037', '23-05569-12-23', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Muiña - Quión 20, 1º', 'Touro', 'A Coruña', '15824', 'España', 65.52, 0, '2023-12-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231223-ADjtrZXn3GhLY-222', 'b8a76753-c2a9-4e39-b5f3-6e458c2a8a8f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231223-ADjtrZXn3GhLY-222&s=KOL2023&nf=P4037&i=65.52&cr=180', '[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
(4304, 1, 11, 2, 0, NULL, 0, '2023-12-25 11:30:53', '2023-12-26 09:27:39', '2023-12-25', 'P4039', '23-05570-12-25', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'calle Colomeres 36 local 2', 'Gavà', 'Barcelona', '08840', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-251223-RhUlN+rpQEa0y-128', '8b245fd7-aa8b-43f0-9f2e-1ec6235b2e90', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251223-RhUlN%2BrpQEa0y-128&s=KOL2023&nf=P4039&i=103.46&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4305, 1, 862, 2, 0, NULL, 0, '2023-12-25 18:52:06', '2023-12-26 09:29:40', '2023-12-25', 'P4040', '23-05571-12-25', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Finca san Anton, s/n', 'Mirabel', 'Cáceres', '10540', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-251223-TJLrypOksWUB3-128', '897cc073-64e4-4541-870b-66aed10f3482', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251223-TJLrypOksWUB3-128&s=KOL2023&nf=P4040&i=20.00&cr=082', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4306, 1, 731, 2, 0, NULL, 0, '2023-12-26 07:21:42', '2023-12-26 09:32:24', '2023-12-26', 'P4038', '23-05572-12-26', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'CALLE NAGUSIA 3 (CITYPAQ CORREOS)', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 17.50, 0, '2023-12-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261223-dXCNsBCQcsrpL-091', 'de55aff4-92f6-46f8-b352-c99ba8baf736', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261223-dXCNsBCQcsrpL-091&s=KOL2023&nf=P4038&i=17.50&cr=009', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4307, 1, 1075, 2, 0, NULL, 0, '2023-12-26 11:11:01', '2023-12-27 09:18:31', '2023-12-26', 'P4042', '23-05573-12-26', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'General  Eguia 40', 'Bilbao', 'Bizkaia', '48013', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-261223-A2eb+o10ApSgl-042', '693611bb-103a-4275-9935-842332ad93b5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261223-A2eb%2Bo10ApSgl-042&s=KOL2023&nf=P4042&i=413.82&cr=010', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4308, 1, 1075, 2, 0, NULL, 0, '2023-12-26 11:11:04', '2023-12-26 11:11:04', '2023-12-26', '', '23-05574-12-26', NULL, 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'General  Eguia 40', 'Bilbao', 'Bizkaia', '48013', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4309, 1, 1101, 2, 0, NULL, 0, '2023-12-26 17:04:28', '2023-12-27 09:20:09', '2023-12-26', 'P4043', '23-05575-12-26', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Escuela artes Y Oficios , 7, 6A', 'Barakaldo', 'Bizkaia', '48901', 'España', 43.71, 0, '2023-12-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-261223-F1LI39nO456fE-183', '593e2a54-6ad0-44d3-bec0-9d01e80bc807', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261223-F1LI39nO456fE-183&s=KOL2023&nf=P4043&i=43.71&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4310, 1, 659, 2, 0, NULL, 0, '2023-12-26 18:06:03', '2023-12-27 10:14:06', '2023-12-26', 'P4044', '23-05576-12-26', '', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'San   Lázaro,11', 'Medina del Campo', 'Valladolid', '47400', 'España', 54.60, 0, '2023-12-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261223-bxwpzff+wXbQr-099', '2dd6e8fb-915e-42cd-9745-1bce322a98e8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261223-bxwpzff%2BwXbQr-099&s=KOL2023&nf=P4044&i=54.60&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4311, 1, 1102, 2, 0, NULL, 0, '2023-12-26 18:25:09', '2023-12-27 09:29:53', '2023-12-26', '', '23-05577-12-26', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Calle Vinatea,12 Urb. Montealegre', 'Eliana (l\')', 'Valencia', '46183', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 1, 4, 0, '', NULL, '', '', 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
(4312, 1, 1103, 2, 0, NULL, 0, '2023-12-26 20:40:29', '2023-12-27 09:30:39', '2023-12-26', 'P4041', '23-05579-12-26', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, '10B, 5B Basadi Auzategia ', 'Zumaia', 'Gipuzkoa', '20750', 'España', 28.39, 0, '2023-12-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261223-DxySM/UVqMHsD-094', '49fa3836-4fa3-4832-8c7d-85ca3db68648', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261223-DxySM%2FUVqMHsD-094&s=KOL2023&nf=P4041&i=28.39&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4313, 1, 1102, 2, 0, NULL, 0, '2023-12-27 09:30:23', '2023-12-27 10:16:28', '2023-12-26', 'P4045', '23-05577-12-26', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Calle Vinatea,12 Urb. Montealegre', 'Eliana (l\')', 'Valencia', '46183', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-261223-XBkrCRQCK1Z3v-125', '381e528e-f892-4267-a634-5402179bd6ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261223-XBkrCRQCK1Z3v-125&s=KOL2023&nf=P4045&i=33.11&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4314, 1, 40, 2, 0, NULL, 0, '2023-12-27 09:07:52', '2023-12-27 10:17:44', '2023-12-27', 'P4046', '23-05580-12-27', 'martes cerrado y lunes por la mañana tb, si no estoy dejar en ogi koskorra  panaderia  al lado', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 103.46, 0, '2023-12-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271223-aN4j/7tCj4L26-157', 'bb078704-774b-4920-bc70-48036b2e3f4c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271223-aN4j%2F7tCj4L26-157&s=KOL2023&nf=P4046&i=103.46&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4315, 1, 262, 2, 0, NULL, 0, '2023-12-27 14:01:36', '2023-12-28 09:27:59', '2023-12-27', 'P4047', '23-05581-12-27', 'lunes cerrado', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 133.00, 0, '2023-12-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271223-eoyQh91GkUMmH-217', 'd1ca9838-d9c8-4089-8b30-4ec31cced047', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271223-eoyQh91GkUMmH-217&s=KOL2023&nf=P4047&i=133.00&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4316, 1, 204, 2, 0, NULL, 0, '2023-12-27 15:19:51', '2023-12-28 09:28:42', '2023-12-27', 'P4048', '23-05583-12-27', '', 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-12-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271223-o9rSHNdzTJsAU-225', '55e89dfd-38c9-4438-a453-d46a31fde6d4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271223-o9rSHNdzTJsAU-225&s=KOL2023&nf=P4048&i=137.94&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4317, 1, 1104, 2, 0, NULL, 0, '2023-12-27 15:37:23', '2023-12-28 09:28:59', '2023-12-27', 'P4049', '23-05584-12-27', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Urbanización Mirador de Entrambasaguas, 63', 'Valle de Mena', 'Burgos', '09585', 'España', 30.61, 0, '2023-12-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271223-LP2+S4hZu05CW-243', '131cab30-33ec-488e-a1a6-3561f0981a67', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271223-LP2%2BS4hZu05CW-243&s=KOL2023&nf=P4049&i=30.61&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4318, 1, 221, 2, 0, NULL, 0, '2023-12-27 16:51:59', '2023-12-28 09:29:26', '2023-12-27', 'P4050', '23-05585-12-27', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 137.94, 0, '2023-12-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271223-AGgSrN/NsIpFk-053', '4b79cc47-6e49-47e6-afc3-dd270fa51a56', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271223-AGgSrN%2FNsIpFk-053&s=KOL2023&nf=P4050&i=137.94&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4319, 1, 582, 2, 0, NULL, 0, '2023-12-27 22:30:49', '2023-12-28 09:29:41', '2023-12-27', 'P4051', '23-05586-12-27', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Calle Mar Mediterráneo 40', 'San Fernando de Hena', 'Madrid', '28830', 'España', 52.39, 0, '2023-12-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271223-Nl+oTxA6TR29e-022', '23e10d94-c57c-47a9-9b0a-2595b7cbb15a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271223-Nl%2BoTxA6TR29e-022&s=KOL2023&nf=P4051&i=52.39&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4320, 1, 121, 2, 0, NULL, 0, '2023-12-28 07:03:57', '2023-12-28 09:30:16', '2023-12-28', 'P4052', '23-05587-12-28', '', 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-12-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-281223-FbiE6JJegY6SW-207', '28d73ce3-b8c3-463a-9690-1f272f26a8df', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281223-FbiE6JJegY6SW-207&s=KOL2023&nf=P4052&i=241.40&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4321, 1, 4, 2, 0, NULL, 0, '2023-12-28 09:28:58', '2023-12-28 10:41:58', '2023-12-28', 'P4053', '23-05588-12-28', '', 0.00, 232.06, 48.73, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 280.79, 0, '2023-12-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281223-J3iLswKdMNkde-021', '694a7ec1-656e-4d2d-b3d3-2e2e13a0064a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281223-J3iLswKdMNkde-021&s=KOL2023&nf=P4053&i=280.79&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4322, 1, 174, 2, 0, NULL, 0, '2023-12-28 10:50:18', '2023-12-28 11:55:21', '2023-12-28', 'P4054', '23-05589-12-28', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 206.91, 0, '2023-12-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281223-R6Y07mWfYJ2T4-151', 'd39e6c5f-140d-42f5-b4f2-c0b525a439a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281223-R6Y07mWfYJ2T4-151&s=KOL2023&nf=P4054&i=206.91&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4323, 1, 77, 1, 0, NULL, 0, '2023-12-28 12:02:17', '2023-12-28 12:02:17', '2023-12-28', 'P4055', '2023-12-28', '', 0.00, 622.05, 130.63, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 752.68, 0, '2023-12-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-281223-eUr5eM1YzUV5H-004', 'ea2da8a7-8a7b-405c-80c5-a06ff50d89bf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281223-eUr5eM1YzUV5H-004&s=KOL2023&nf=P4055&i=752.68&cr=092', '[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
(4324, 1, 172, 2, 0, NULL, 0, '2023-12-28 13:29:38', '2023-12-29 09:20:44', '2023-12-28', 'P4056', '23-05590-12-28', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Soldevila, 6 baixos', 'Tremp', 'Lleida', '25620', 'España', 123.15, 0, '2023-12-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281223-GgboPBjjFCEWB-194', '44e0616b-5143-483f-ad38-02ac3e5fb0ae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281223-GgboPBjjFCEWB-194&s=KOL2023&nf=P4056&i=123.15&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4325, 1, 923, 2, 0, NULL, 0, '2023-12-28 15:52:41', '2023-12-29 09:20:59', '2023-12-28', 'P4057', '23-05591-12-28', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Mintegi Kalea 1A, 3A', 'Zarautz', 'Gipuzkoa', '20800', 'España', 17.50, 0, '2023-12-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281223-KMQ82s/JDsWL4-118', '64bb3de9-89e9-41e0-a842-7622f762a31f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281223-KMQ82s%2FJDsWL4-118&s=KOL2023&nf=P4057&i=17.50&cr=023', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4326, 1, 1050, 2, 0, NULL, 0, '2023-12-28 21:58:20', '2023-12-29 09:21:38', '2023-12-28', '', '23-05592-12-28', '', 0.00, 211.68, 44.89, 0.00, 1, 11.12, 2.50, 'Carlos caamaño,3', 'Madrid', 'Madrid', '28016', 'España', 269.75, 0, '0000-00-00 00:00:00', '', '', 1, 4, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(4327, 1, 190, 3, 0, NULL, 0, '2023-12-29 09:21:06', '2023-12-29 09:21:06', '2023-12-29', '', 'consumo peluquería', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 241.40, 0, '2023-12-29 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),
(4328, 1, 1050, 2, 0, NULL, 0, '2023-12-29 09:21:57', '2023-12-29 09:21:57', '2023-12-28', 'P4058', '23-05592-12-28', '', 0.00, 211.68, 44.89, 0.00, 1, 11.12, 2.50, 'Carlos caamaño,3', 'Madrid', 'Madrid', '28016', 'España', 269.75, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-281223-Mj+iE4WyHi/AN-135', '919659ed-469f-4807-a589-1e123bbe638c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281223-Mj%2BiE4WyHi%2FAN-135&s=KOL2023&nf=P4058&i=269.75&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4329, 1, 617, 2, 0, NULL, 0, '2023-12-29 18:59:48', '2024-01-02 09:39:43', '2023-12-29', 'P4059', '23-05593-12-29', 'Factura ', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Riestra, 14', 'Pontevedra', 'Pontevedra', '36001', 'España', 344.85, 0, '2023-12-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291223-JPQSI9fyOBtNo-134', '786fa937-3532-4da2-ad39-1db36ae36d4b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291223-JPQSI9fyOBtNo-134&s=KOL2023&nf=P4059&i=344.85&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4330, 1, 1105, 2, 0, NULL, 0, '2023-12-30 18:20:23', '2024-01-02 09:39:57', '2023-12-30', 'P4060', '23-05594-12-30', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Gabriela mistral, 40. Portal 3. 3D', 'Valdemoro', 'Madrid', '28342', 'España', 30.61, 0, '2023-12-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301223-BnFtWbfseF7qp-131', '083741a4-d657-45b6-a188-77aa5ea4541b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301223-BnFtWbfseF7qp-131&s=KOL2023&nf=P4060&i=30.61&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4331, 1, 722, 2, 0, NULL, 0, '2023-12-30 21:43:54', '2024-01-02 09:40:11', '2023-12-30', 'P4061', '23-05595-12-30', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Gregal 4, Edificio Alcotán II, Planta 9, Apartamento 76', 'Villajoyosa/Vila Joi', 'Alicante', '03570', 'España', 28.39, 0, '2023-12-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301223-l7p6LU6Z1SMBu-018', 'deded0b6-1ddb-4a8e-8c81-503759b4ce73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301223-l7p6LU6Z1SMBu-018&s=KOL2023&nf=P4061&i=28.39&cr=043', '[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
(4332, 1, 721, 2, 0, NULL, 0, '2024-01-01 12:25:19', '2024-01-02 09:40:33', '2024-01-01', 'P4062', '24-05596-01-01', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Aiotzategi 18 escalera derecha 4C', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 43.71, 0, '2024-01-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010124-eWCvS0i+Ms3ek-179', '4073f9a1-50bf-4c8b-95e5-46dd4e2c7cea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010124-eWCvS0i%2BMs3ek-179&s=KOL2024&nf=P4062&i=43.71&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4333, 1, 1106, 2, 0, NULL, 0, '2024-01-02 03:04:23', '2024-01-02 09:40:45', '2024-01-02', 'P4063', '24-05597-01-02', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Mari 21', 'Donostia-San Sebasti', 'Gipuzkoa', '20003', 'España', 17.50, 0, '2024-01-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020124-i1EJF5cZrqZ+9-095', '16a237f3-130a-4bfc-a323-86ca767161fa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020124-i1EJF5cZrqZ%2B9-095&s=KOL2024&nf=P4063&i=17.50&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4334, 1, 160, 2, 0, NULL, 0, '2024-01-02 08:49:05', '2024-01-02 09:58:38', '2024-01-02', 'P4064', '24-05598-01-02', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 123.15, 0, '2024-01-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020124-iXawHu3AeWBV1-098', 'e34a5cb3-54e2-4d1a-a658-a33d79bc414f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020124-iXawHu3AeWBV1-098&s=KOL2024&nf=P4064&i=123.15&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4335, 1, 1107, 2, 0, NULL, 0, '2024-01-02 10:54:29', '2024-01-02 12:28:16', '2024-01-02', 'P4065', '24-05599-01-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ Tarragona, 3 -3A', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 28.39, 0, '2024-01-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020124-dYJM7u6LIfOVH-064', '7bda072d-6525-4650-a1ba-cb0bb8da4d2d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020124-dYJM7u6LIfOVH-064&s=KOL2024&nf=P4065&i=28.39&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4336, 1, 1044, 2, 0, NULL, 0, '2024-01-02 12:48:10', '2024-01-03 09:11:15', '2024-01-02', 'P4066', '24-05603-01-02', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ MARINES S/N C.V Eliavet', 'Eliana (l\')', 'Valencia', '46183', 'España', 30.61, 0, '2024-01-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020124-nbHQQGOZ6+ftk-149', 'd0228916-1ebf-46e0-9e38-b93ce104012e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020124-nbHQQGOZ6%2Bftk-149&s=KOL2024&nf=P4066&i=30.61&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4337, 1, 370, 2, 0, NULL, 0, '2024-01-02 13:34:25', '2024-01-03 09:11:27', '2024-01-02', 'P4067', '24-05604-01-02', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Arturo Soria 330, 3C', 'Madrid', 'Madrid', '28033', 'España', 30.61, 0, '2024-01-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020124-X2qkmutAUb6+g-158', '23c4fd17-e11e-4458-b103-240015000677', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020124-X2qkmutAUb6%2Bg-158&s=KOL2024&nf=P4067&i=30.61&cr=038', '[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
(4338, 1, 391, 2, 0, NULL, 0, '2024-01-02 14:25:08', '2024-01-03 09:11:42', '2024-01-02', 'P4068', '24-05605-01-02', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle divina pastora 13 bajo', 'Ansoáin', 'Navarra', '31013', 'España', 103.46, 0, '2024-01-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020124-SdI/4HLUoZczO-038', '1dda29fa-1153-449d-beca-056d9642758a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020124-SdI%2F4HLUoZczO-038&s=KOL2024&nf=P4068&i=103.46&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4339, 1, 1108, 2, 0, NULL, 0, '2024-01-02 17:14:44', '2024-01-03 09:11:53', '2024-01-02', 'P4069', '24-05606-01-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Novena, 24, Vivienda unifamiliar', 'Madrid', 'Madrid', '28016', 'España', 28.39, 0, '2024-01-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020124-S/QyJa3o/0Qmm-028', 'ec2b3fa8-0ff8-4c24-a089-29b888f592d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020124-S%2FQyJa3o%2F0Qmm-028&s=KOL2024&nf=P4069&i=28.39&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4340, 1, 329, 2, 0, NULL, 0, '2024-01-02 19:17:50', '2024-01-03 09:12:08', '2024-01-02', 'P4070', '24-05607-01-02', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'JUAN BAUTISTA ZABALA nº9 GAURKO', 'Getxo', 'Bizkaia', '48991', 'España', 30.61, 0, '2024-01-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020124-A3jhpyzpriJpS-206', '46e19e70-d37e-4ba5-b592-a541e67980f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020124-A3jhpyzpriJpS-206&s=KOL2024&nf=P4070&i=30.61&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4341, 1, 696, 1, 0, NULL, 0, '2024-01-03 10:23:09', '2024-01-03 10:23:09', '2024-01-03', 'P4071', '2024-01-03', '', 0.00, 351.78, 73.87, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 425.65, 0, '2024-01-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030124-bSkAZKPRPKN91-146', '78a0d660-0bcf-488f-93bf-8272bcc00552', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030124-bSkAZKPRPKN91-146&s=KOL2024&nf=P4071&i=425.65&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4342, 1, 80, 2, 0, NULL, 0, '2024-01-03 10:46:59', '2024-01-03 12:06:46', '2024-01-03', 'P4072', '24-05608-01-03', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 620.73, 0, '2024-01-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030124-aSBvGtJ8oSIon-050', '7c6d0bd7-2712-49be-938c-0149fad3d38d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030124-aSBvGtJ8oSIon-050&s=KOL2024&nf=P4072&i=620.73&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4343, 1, 568, 2, 0, NULL, 0, '2024-01-03 13:51:42', '2024-01-04 09:24:26', '2024-01-03', 'P4073', '24-05609-01-03', 'PELUQUERIA EL MARCO BLANCO', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'LARRAMENDI 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 103.46, 0, '2024-01-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030124-VjWBdImtLThVb-052', '09fe3913-64b1-4846-b2e7-3854e18f15ad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030124-VjWBdImtLThVb-052&s=KOL2024&nf=P4073&i=103.46&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4344, 1, 1109, 2, 0, NULL, 0, '2024-01-04 09:03:24', '2024-01-04 09:03:24', '2024-01-04', '', '24-05619-01-04', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'C/unió 15 Bajos Lleida', 'Lleida', 'Lleida', '25002 ', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 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
(4345, 1, 532, 2, 0, NULL, 0, '2024-01-04 09:21:54', '2024-01-04 10:32:27', '2024-01-04', 'P4074', '24-05620-01-04', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Ayuntamiento de Baztan. Plaza Fueros s.n. Elizondo', 'Baztan', 'Navarra', '31700', 'España', 56.82, 0, '2024-01-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040124-V5xUQqZoqagE4-079', '98d09f1c-0d58-4074-b994-0292bf453488', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040124-V5xUQqZoqagE4-079&s=KOL2024&nf=P4074&i=56.82&cr=187', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4346, 1, 1110, 2, 0, NULL, 0, '2024-01-04 10:04:15', '2024-01-04 11:04:47', '2024-01-04', 'P4075', '24-05621-01-04', '', 0.00, 32.56, 7.60, 0.00, 0, 0.00, 4.40, 'C/unió 15 Bajos.  Lleida', 'Lleida', 'Lleida', ' 25002', 'España', 43.80, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040124-Nh2Nx6+jPBcIt-200', '074b5009-a672-4bb9-8d2e-72de95e8c09b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040124-Nh2Nx6%2BjPBcIt-200&s=KOL2024&nf=P4075&i=43.80&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4347, 1, 76, 1, 0, NULL, 0, '2024-01-04 13:06:16', '2024-01-04 13:06:16', '2024-01-04', 'P4076', '2024-01-04', '', 0.00, 270.27, 56.76, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 327.03, 0, '2024-01-04 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040124-AQVii036nbi+V-164', '779b18a3-5c70-45f1-a8be-3d2206694479', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040124-AQVii036nbi%2BV-164&s=KOL2024&nf=P4076&i=327.02&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4348, 1, 379, 2, 0, NULL, 0, '2024-01-04 12:49:27', '2024-01-04 13:55:06', '2024-01-04', 'P4077', '24-05622-01-04', 'Les ruego que me llamen por teléfono antes de la entrega del paquete para que haya alguien en el domicilio para recogerlo.\r\nSaludos cordiales.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Mazarredo 81, 5º izda., izda.', 'Bilbao', 'Bizkaia', '48009', 'España', 28.39, 0, '2024-01-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040124-jt2WxLG4tCjtz-166', 'c076f6ed-9c4f-469c-b889-445cb48c4c1f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040124-jt2WxLG4tCjtz-166&s=KOL2024&nf=P4077&i=28.39&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4349, 1, 1111, 2, 0, NULL, 0, '2024-01-04 22:58:06', '2024-01-05 09:01:10', '2024-01-04', 'P4078', '24-05623-01-04', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'zabala 13 lUZURIAGA', 'San Millán/Donemilia', 'Álava', '01208', 'España', 17.50, 0, '2024-01-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040124-EE5oCyqOMcUWN-232', 'b94f2009-eb3b-4ed8-9ba5-53d37894b053', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040124-EE5oCyqOMcUWN-232&s=KOL2024&nf=P4078&i=17.50&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4350, 1, 1112, 2, 0, NULL, 0, '2024-01-05 10:52:04', '2024-01-05 12:02:15', '2024-01-05', 'P4079', '24-05624-01-05', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Paseo Bertsolari Txirrita 4 esc derecha 2A', 'Donostia-San Sebasti', 'Gipuzkoa', '20017', 'España', 28.39, 0, '2024-01-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-050124-D7psF9AaSNA1J-099', '70b9abcd-5835-47eb-857d-70788a17dd2e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050124-D7psF9AaSNA1J-099&s=KOL2024&nf=P4079&i=28.39&cr=158', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
