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
(4351, 1, 87, 2, 0, NULL, 0, '2024-01-05 12:41:09', '2024-01-08 09:39:17', '2024-01-05', 'P4080', '24-05625-01-05', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Cc arcco local p 17', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 103.46, 0, '2024-01-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050124-ghqAhZXnMGf5H-170', '69b89203-c935-4bc5-b853-c237fee3630e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050124-ghqAhZXnMGf5H-170&s=KOL2024&nf=P4080&i=103.46&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4352, 1, 1113, 2, 0, NULL, 0, '2024-01-05 12:49:53', '2024-01-08 09:39:31', '2024-01-05', 'P4081', '24-05626-01-05', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Travesía Trauko6, 3b', 'Bilbao', 'Bizkaia', '48007', 'España', 30.61, 0, '2024-01-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050124-pCvM9TYvvR3ru-182', '0f3d757a-7ba0-4948-b51c-db1b13f3c8fd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050124-pCvM9TYvvR3ru-182&s=KOL2024&nf=P4081&i=30.61&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4353, 1, 994, 2, 0, NULL, 0, '2024-01-05 14:13:56', '2024-01-08 09:39:40', '2024-01-05', 'P4082', '24-05627-01-05', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Barrio La Iglesia S/N. Residencial Cubas 2. Chalet 1, Chalet 1', 'Ribamontán al Monte', 'Cantabria', '39793', 'España', 52.39, 0, '2024-01-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050124-RDA4or+4hxNRs-007', '86d03237-c707-4456-bc71-368744f79ed5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050124-RDA4or%2B4hxNRs-007&s=KOL2024&nf=P4082&i=52.39&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4354, 1, 1114, 2, 0, NULL, 0, '2024-01-05 16:45:43', '2024-01-08 09:39:53', '2024-01-05', 'P4083', '24-05628-01-05', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'calle gorriti 22 bajo', 'Pamplona/Iruña', 'Navarra', '31004', 'España', 65.52, 0, '2024-01-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050124-HHqAwrZPdwoKO-223', '9372b6bd-0b75-40a4-b363-a067f1a9d752', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050124-HHqAwrZPdwoKO-223&s=KOL2024&nf=P4083&i=65.52&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4355, 1, 1115, 2, 0, NULL, 0, '2024-01-05 18:12:32', '2024-01-08 09:40:01', '2024-01-05', 'P4084', '24-05629-01-05', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Sevilla,84', 'Guadalcanal', 'Sevilla', '41390', 'España', 17.50, 0, '2024-01-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050124-nXXbyc79GV9ZR-057', 'e2767a5a-4d63-434a-91ad-1768d4d629d7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050124-nXXbyc79GV9ZR-057&s=KOL2024&nf=P4084&i=17.50&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4356, 1, 812, 2, 0, NULL, 0, '2024-01-06 12:30:38', '2024-01-08 09:40:14', '2024-01-06', 'P4085', '24-05630-01-06', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Amezketarrak 10, Entresuelo Derecha Puerta 4', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 65.52, 0, '2024-01-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-060124-Q92DaK1+BQuk9-177', 'cd358966-ddbd-4c62-9c4e-8d52e61801cb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060124-Q92DaK1%2BBQuk9-177&s=KOL2024&nf=P4085&i=65.52&cr=091', '[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
(4357, 1, 53, 2, 0, NULL, 0, '2024-01-06 13:04:21', '2024-01-08 09:40:37', '2024-01-06', 'P4089', '24-05631-01-06', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-060124-BJpQv6bxKR1eG-024', '7b0c35e6-62aa-4a58-aa45-3cc01b9bbf63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060124-BJpQv6bxKR1eG-024&s=KOL2024&nf=P4089&i=209.41&cr=119', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4358, 1, 991, 2, 0, NULL, 0, '2024-01-07 17:10:21', '2024-01-08 09:40:52', '2024-01-07', 'P4086', '24-05632-01-07', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'C/ Doctor Marañón 12', 'Almonte', 'Huelva', '21730', 'España', 147.79, 0, '2024-01-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070124-Y0cKazMB0cMDA-235', 'b1ede876-9640-4a39-9fc1-adc914d05d19', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070124-Y0cKazMB0cMDA-235&s=KOL2024&nf=P4086&i=147.79&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4359, 1, 662, 2, 0, NULL, 0, '2024-01-07 20:41:04', '2024-01-08 09:41:02', '2024-01-07', 'P4087', '24-05633-01-07', 'Si no estamos se puede tirar por encima de la puerta', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle cadiz 45', 'Castelldefels', 'Barcelona', '08860', 'España', 56.82, 0, '2024-01-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070124-lP/IKI8YnUAWp-253', '9b7519c4-f170-4d0f-86c4-136f729f193d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070124-lP%2FIKI8YnUAWp-253&s=KOL2024&nf=P4087&i=56.82&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4360, 1, 664, 2, 0, NULL, 0, '2024-01-07 22:04:33', '2024-01-08 09:41:10', '2024-01-07', 'P4088', '24-05634-01-07', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Aranerreka 32, 3 izquierda', 'Bergara', 'Gipuzkoa', '20570', 'España', 17.50, 0, '2024-01-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070124-An2kcSeSWlw5D-250', 'eda44956-846a-40fe-805b-98a009d06a74', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070124-An2kcSeSWlw5D-250&s=KOL2024&nf=P4088&i=17.50&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4361, 1, 1116, 2, 0, NULL, 0, '2024-01-08 09:55:41', '2024-01-08 10:59:40', '2024-01-08', 'P4090', '24-05635-01-08', '', 0.00, 97.47, 20.90, 0.00, 0, 0.00, 2.50, 'C/ Blasco de Garay 74-2º-1ª', 'Madrid', 'Madrid', '28015', 'España', 120.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-080124-KNBC0K8KoBzvC-118', '127a4388-ea98-4b79-b878-15af68bc74a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080124-KNBC0K8KoBzvC-118&s=KOL2024&nf=P4090&i=120.44&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4362, 1, 754, 2, 0, NULL, 0, '2024-01-08 10:08:11', '2024-01-08 11:46:27', '2024-01-08', 'P4091', '24-05636-01-08', '', 0.00, 65.12, 13.67, 0.00, 1, 3.39, 0.00, 'josep ntarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 82.19, 0, '2024-01-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080124-Sg+M3TgrZ2WOM-000', '98090a78-3278-4fad-b9f6-8d06f1a11cdd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080124-Sg%2BM3TgrZ2WOM-000&s=KOL2024&nf=P4091&i=82.19&cr=142', '[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
(4363, 1, 65, 2, 0, NULL, 0, '2024-01-08 10:49:12', '2024-07-17 13:14:01', '2024-01-08', 'P4092', '24-05637-01-08', '', 0.00, 741.00, 155.61, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 896.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080124-MGiOf4ZsxNyYx-009', 'b11510eb-25e7-4ee7-ba82-186e460e6d92', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080124-MGiOf4ZsxNyYx-009&s=KOL2024&nf=P4092&i=896.61&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4364, 1, 1117, 2, 0, NULL, 0, '2024-01-08 17:18:12', '2024-01-09 09:21:28', '2024-01-08', 'P4093', '24-05638-01-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Cno. Badén, carril Torresalinas, 26 ', 'Murcia', 'Murcia', '30010', 'España', 17.50, 0, '2024-01-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080124-jSCOmb5+Gxa1i-221', 'b493f956-60b5-42ca-97e1-8e804715f008', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080124-jSCOmb5%2BGxa1i-221&s=KOL2024&nf=P4093&i=17.50&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4365, 1, 784, 2, 0, NULL, 0, '2024-01-08 17:42:44', '2024-01-09 09:29:56', '2024-01-08', 'P4094', '24-05639-01-08', '', 0.00, 52.92, 11.11, 0.00, 1, 2.75, 0.00, 'Calle san francisco 30 bis bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20002', 'España', 66.78, 0, '2024-01-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080124-OYwYjORoAPUlw-162', '26dae2b9-62bf-4036-a1e4-07167d05a7ec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080124-OYwYjORoAPUlw-162&s=KOL2024&nf=P4094&i=66.78&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4366, 1, 597, 2, 0, NULL, 0, '2024-01-08 19:13:25', '2024-01-09 09:30:09', '2024-01-08', 'P4095', '24-05640-01-08', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Avenida Judizmendi 48, 2°D', 'Vitoria-Gasteiz', 'Álava', '01003', 'España', 71.98, 0, '2024-01-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080124-hC9Ao3dvh8m8G-039', 'efe08305-58ab-4f05-ac4d-ef0335f5f764', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080124-hC9Ao3dvh8m8G-039&s=KOL2024&nf=P4095&i=71.98&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4367, 1, 1118, 2, 0, NULL, 0, '2024-01-09 08:57:06', '2024-01-09 10:00:20', '2024-01-09', 'P4096', '24-05641-01-09', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Ctra Valladolid 30 A 1-B', 'Lastrilla (La)', 'Segovia', '40196', 'España', 17.50, 0, '2024-01-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090124-G1/EO2XMvvuaA-127', 'bca487e6-8e3e-415f-a7ab-b41ecce55042', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090124-G1%2FEO2XMvvuaA-127&s=KOL2024&nf=P4096&i=17.50&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4368, 1, 956, 2, 0, NULL, 0, '2024-01-09 09:15:21', '2024-01-09 10:16:44', '2024-01-09', 'P4097', '24-05642-01-09', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1 bajo ', 'Vigo', 'Pontevedra', '36204', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090124-Ntuu8xORho81A-176', 'f92e0cbe-2a2a-4a9a-a61a-9a12b8f59da0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090124-Ntuu8xORho81A-176&s=KOL2024&nf=P4097&i=103.46&cr=135', '[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
(4369, 1, 67, 2, 0, NULL, 0, '2024-01-09 11:12:11', '2024-01-09 12:20:38', '2024-01-09', 'P4098', '24-05643-01-09', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 310.37, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090124-fNc93EXYJfj+1-157', '414ecd18-d01c-4a73-81b9-dfce61b6f4ee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090124-fNc93EXYJfj%2B1-157&s=KOL2024&nf=P4098&i=310.37&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4370, 1, 190, 3, 0, NULL, 0, '2024-01-09 12:19:49', '2024-10-15 16:05:30', '2024-01-09', '', 'Consumo interno', '', 0.00, 8.14, 1.71, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 9.85, 0, '2024-01-09 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4371, 1, 345, 2, 0, NULL, 0, '2024-01-09 11:45:23', '2024-01-09 12:47:36', '2024-01-09', 'P4099', '24-05644-01-09', '', 0.00, 73.26, 15.38, 0.00, 0, 0.00, 0.00, 'Espronceda 336', 'Barcelona', 'Barcelona', '08027', 'España', 88.64, 0, '2024-01-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090124-GvEDyACohWpid-026', 'b3da477c-1690-4137-8dc7-85c177942f8d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090124-GvEDyACohWpid-026&s=KOL2024&nf=P4099&i=88.64&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4372, 1, 522, 2, 0, NULL, 0, '2024-01-09 13:16:16', '2024-01-10 09:42:55', '2024-01-09', 'P4100', '24-05645-01-09', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 172.43, 0, '2024-01-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090124-ikrVpOqk0uDuM-203', '392c13cf-1816-480b-9591-65f6c177c510', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090124-ikrVpOqk0uDuM-203&s=KOL2024&nf=P4100&i=172.43&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4373, 1, 137, 2, 0, NULL, 0, '2024-01-09 17:26:31', '2024-01-10 09:43:10', '2024-01-09', 'P4101', '24-05646-01-09', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Pº ERMITA, 10', 'Madrid', 'Madrid', '28023', 'España', 172.43, 0, '2024-01-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090124-d8tp/YcJJgPFv-159', '6358a35c-232e-4f25-a16a-088c454296c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090124-d8tp%2FYcJJgPFv-159&s=KOL2024&nf=P4101&i=172.43&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4374, 1, 1119, 2, 0, NULL, 0, '2024-01-09 19:06:26', '2024-01-10 09:43:19', '2024-01-09', 'P4102', '24-05647-01-09', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Santa Lucía, 20, 1°D', 'Santander', 'Cantabria', '39003', 'España', 30.61, 0, '2024-01-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090124-RqBvE1+QcwNsZ-205', 'ce86be76-2662-43b1-ad19-8a220cac26d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090124-RqBvE1%2BQcwNsZ-205&s=KOL2024&nf=P4102&i=30.61&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4375, 1, 1120, 2, 0, NULL, 0, '2024-01-09 20:06:47', '2024-01-10 09:43:29', '2024-01-09', 'P4103', '24-05648-01-09', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle Jorge Guillén, 15, 6B', 'Zaragoza', 'Zaragoza', '50018', 'España', 43.71, 0, '2024-01-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090124-DN7oJ5Z7CPHMZ-186', 'cc06b6dc-4054-4e9b-81ac-0912a612df1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090124-DN7oJ5Z7CPHMZ-186&s=KOL2024&nf=P4103&i=43.71&cr=041', '[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
(4376, 1, 389, 2, 0, NULL, 0, '2024-01-09 20:31:59', '2024-01-10 09:43:43', '2024-01-09', 'P4104', '24-05649-01-09', '', 0.00, 52.32, 10.99, 0.00, 0, 0.00, 0.00, 'Padrón', 'Padrón', 'A Coruña', '15980', 'España', 63.31, 0, '2024-01-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090124-TtBS9vhAH1mcH-043', '646faee4-cc76-4197-88e1-7c63c418f0ad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090124-TtBS9vhAH1mcH-043&s=KOL2024&nf=P4104&i=63.31&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4377, 1, 967, 2, 0, NULL, 0, '2024-01-10 00:19:29', '2024-01-10 09:43:53', '2024-01-10', 'P4105', '24-05650-01-10', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Asua erletxe errepidea 15 ', 'Erandio', 'Bizkaia', '48950', 'España', 28.39, 0, '2024-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100124-VZEeueyfr4Vur-112', 'ba5a8925-ca89-4927-8b9a-d2826c032e9f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100124-VZEeueyfr4Vur-112&s=KOL2024&nf=P4105&i=28.39&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4378, 1, 190, 3, 0, NULL, 0, '2024-01-10 10:44:26', '2024-01-24 13:18:59', '2024-01-10', '', 'Consumo interno', '', 0.00, 8.14, 1.71, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 9.85, 0, '2024-01-10 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),
(4379, 1, 856, 2, 0, NULL, 0, '2024-01-10 10:11:45', '2024-01-10 11:36:24', '2024-01-10', 'P4106', '24-05651-01-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle de Aralar 28, 4ºDrcha, 4º Drcha', 'Pamplona/Iruña', 'Navarra', '31004', 'España', 30.61, 0, '2024-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100124-BleHo/DVvqPlr-039', 'c76c4b4b-04ba-4be1-b260-7b27815da0c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100124-BleHo%2FDVvqPlr-039&s=KOL2024&nf=P4106&i=30.61&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4380, 1, 492, 2, 0, NULL, 0, '2024-01-10 11:42:51', '2024-01-10 12:43:28', '2024-01-10', 'P4107', '24-05652-01-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle doctor Laureano Casquero 25 H7', 'Vélez-Málaga', 'Málaga', '29740', 'España', 30.61, 0, '2024-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100124-eh2DsJLxeQ1X+-017', '8ef4f908-eedb-438d-a030-bbdb8b7d2408', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100124-eh2DsJLxeQ1X%2B-017&s=KOL2024&nf=P4107&i=30.61&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4381, 1, 687, 1, 0, NULL, 0, '2024-01-10 14:03:56', '2024-01-10 14:04:08', '2024-01-10', 'P4108', '2024-01-10', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 123.15, 0, '2024-01-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100124-N+4ptuoWz0VCp-004', 'b7e486a9-28d6-4b7a-8bcd-5aa25b9237d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100124-N%2B4ptuoWz0VCp-004&s=KOL2024&nf=P4108&i=123.15&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4382, 1, 414, 2, 0, NULL, 0, '2024-01-10 19:58:23', '2024-01-11 09:29:24', '2024-01-10', 'P4109', '24-05653-01-10', 'Urbanización Canet de Fals', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Martí de l\'As, 1', 'Fonollosa', 'Barcelona', '08259', 'España', 30.61, 0, '2024-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100124-a8nOQ9b4nnXPh-146', 'e5b7d595-0757-44e3-b1f1-efe5b671ea5d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100124-a8nOQ9b4nnXPh-146&s=KOL2024&nf=P4109&i=30.61&cr=074', '[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
(4383, 1, 468, 2, 0, NULL, 0, '2024-01-11 09:24:41', '2024-01-11 10:42:36', '2024-01-11', 'P4111', '24-05654-01-11', '', 0.00, 16.28, 4.62, 0.00, 0, 0.00, 6.90, 'Rof Carballo 1', 'Lugo', 'Lugo', '27002', 'España', 26.60, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-110124-ZbdHxTCTTvUqx-246', '1d99d4e1-4116-4f29-bedb-1301b45be853', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110124-ZbdHxTCTTvUqx-246&s=KOL2024&nf=P4111&i=26.60&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4384, 1, 120, 2, 0, NULL, 0, '2024-01-11 09:33:45', '2024-01-11 10:53:56', '2024-01-11', 'P4110', '24-05655-01-11', '', 0.00, 122.12, 25.64, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 147.77, 0, '2024-01-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110124-SBgguEBoHl4s9-173', '51e108c6-6d61-46fb-b52a-27387c53f5b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110124-SBgguEBoHl4s9-173&s=KOL2024&nf=P4110&i=147.77&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4385, 1, 951, 2, 0, NULL, 0, '2024-01-11 11:36:03', '2024-01-11 12:40:02', '2024-01-11', 'P4112', '24-05656-01-11', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'calle pedro rico 27, escalera 1. 6A', 'Madrid', 'Madrid', '28029', 'España', 17.50, 0, '2024-01-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110124-efTvxoEAhHTgi-064', '261292fe-1fdd-413c-9af7-3bb1f13bdaf1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110124-efTvxoEAhHTgi-064&s=KOL2024&nf=P4112&i=17.50&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4386, 1, 248, 2, 0, NULL, 0, '2024-01-11 16:01:31', '2024-01-12 09:11:15', '2024-01-11', 'P4114', '24-05657-01-11', '', 0.00, 89.54, 19.24, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 110.84, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-110124-YgMB9qCOb0h24-005', '4fb69e9d-1a40-4df0-ac0e-48fe09730047', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110124-YgMB9qCOb0h24-005&s=KOL2024&nf=P4114&i=110.84&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4387, 1, 1121, 2, 0, NULL, 0, '2024-01-12 06:59:17', '2024-01-12 09:13:05', '2024-01-12', 'P4113', '24-05658-01-12', 'ES UNA OFICINA ( COSEVI) ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'CL. PORTAL DE FORONDA 27 BJ ', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 17.50, 0, '2024-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120124-IGvSDDoKOuZkY-177', '4b68eb41-dbe3-47a8-9341-1892edb85043', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120124-IGvSDDoKOuZkY-177&s=KOL2024&nf=P4113&i=17.50&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4388, 1, 1122, 2, 0, NULL, 0, '2024-01-12 08:53:24', '2024-01-12 10:16:25', '2024-01-12', 'P4116', '24-05659-01-12', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Plaza Cataluña, 2-1B', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 30.61, 0, '2024-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120124-dP8NAeoOryIrP-187', '5afffe23-f7b1-4b0b-8c2f-0d2b8f295c65', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120124-dP8NAeoOryIrP-187&s=KOL2024&nf=P4116&i=30.61&cr=170', '[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
(4389, 1, 57, 2, 0, NULL, 0, '2024-01-12 08:53:34', '2024-01-12 10:56:07', '2024-01-12', 'P4115', '24-05660-01-12', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 275.88, 0, '2024-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120124-eDtu3Er6Temt3-152', '67583627-6d4e-4cdd-b565-17f725dde68d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120124-eDtu3Er6Temt3-152&s=KOL2024&nf=P4115&i=275.88&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4390, 1, 1123, 2, 0, NULL, 0, '2024-01-12 10:11:51', '2024-01-12 12:21:15', '2024-01-12', 'P4117', '24-05661-01-12', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Carrer Amunt, 37', 'Vandellòs i l\'Hospit', 'Tarragona', '43891', 'España', 65.52, 0, '2024-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120124-PqyXfj8fKW0ac-036', 'a88c673f-b40b-4983-bcea-0a23f8297856', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120124-PqyXfj8fKW0ac-036&s=KOL2024&nf=P4117&i=65.52&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4391, 1, 4, 2, 0, NULL, 0, '2024-01-12 11:32:19', '2024-01-12 12:34:03', '2024-01-12', 'P4118', '24-05662-01-12', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 379.34, 0, '2024-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120124-KVO5i+oNUAB1Y-151', '888da488-135e-4b5a-9e3d-4150e150d329', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120124-KVO5i%2BoNUAB1Y-151&s=KOL2024&nf=P4118&i=379.34&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4392, 1, 672, 2, 0, NULL, 0, '2024-01-12 12:57:11', '2024-01-15 10:20:57', '2024-01-12', 'P4119', '24-05663-01-12', '', 0.00, 61.32, 12.88, 0.00, 0, 0.00, 0.00, 'ANDALUCIA KALEA 7, 7 B', 'Vitoria-Gasteiz', 'Álava', '01003', 'España', 74.20, 0, '2024-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120124-dSB6PaxASnJxX-125', '57dbba59-d945-4276-8b72-2e400c86077b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120124-dSB6PaxASnJxX-125&s=KOL2024&nf=P4119&i=74.20&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4393, 1, 1124, 2, 0, NULL, 0, '2024-01-12 16:33:12', '2024-01-15 10:21:16', '2024-01-12', 'P4123', '24-05664-01-12', '', 0.00, 39.66, 9.53, 0.00, 0, 0.00, 6.90, 'Paseo constitución 19', 'Zaragoza', 'Zaragoza', '50600', 'España', 54.89, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-120124-RUfdX8Mkx6FPg-154', '0756833d-586f-426a-a7e1-ace2f9cf8054', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120124-RUfdX8Mkx6FPg-154&s=KOL2024&nf=P4123&i=54.89&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4394, 1, 604, 2, 0, NULL, 0, '2024-01-12 17:02:34', '2024-01-15 10:21:34', '2024-01-12', 'P4120', '24-05665-01-12', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'c/ Julio caro baroja 6 bajo', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 65.52, 0, '2024-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120124-OtbKOltfZntPe-182', '7ac2ec76-ec51-46a7-bbdf-6eb94ac72191', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120124-OtbKOltfZntPe-182&s=KOL2024&nf=P4120&i=65.52&cr=064', '[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
(4395, 1, 157, 2, 0, NULL, 0, '2024-01-12 21:07:42', '2024-01-15 10:21:56', '2024-01-12', 'P4121', '24-05666-01-12', 'gracias de mandarme folletos ', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'CALLE APODACA,1 LOCAL', 'Madrid', 'Madrid', '28004', 'España', 275.88, 0, '2024-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120124-PDoaTSu147DhB-095', '83a9104e-1a1c-4f1f-87c7-5604057896e8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120124-PDoaTSu147DhB-095&s=KOL2024&nf=P4121&i=275.88&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4396, 1, 1125, 2, 0, NULL, 0, '2024-01-14 11:11:41', '2024-01-15 10:22:07', '2024-01-14', 'P4122', '24-05667-01-14', 'Llamar antes de la entrega ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo lormont 15 4 - 2', 'Castelldefels', 'Barcelona', '08860', 'España', 17.50, 0, '2024-01-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140124-g4IeprgFDs2Jf-170', 'db623923-00cb-4175-afc2-8ea196e4c220', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140124-g4IeprgFDs2Jf-170&s=KOL2024&nf=P4122&i=17.50&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4397, 1, 78, 2, 0, NULL, 0, '2024-01-15 11:22:43', '2024-01-15 12:28:54', '2024-01-15', 'P4124', '24-05668-01-15', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'AV. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 517.28, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150124-iFu1SyJKL/y6o-005', '131683b7-ebae-4ade-bca0-c1d56f6de9cc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150124-iFu1SyJKL%2Fy6o-005&s=KOL2024&nf=P4124&i=517.28&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4398, 1, 78, 2, 0, NULL, 0, '2024-01-15 11:22:47', '2024-01-15 11:22:47', '2024-01-15', '', '24-05669-01-15', NULL, 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'AV. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 517.28, 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),
(4399, 1, 78, 2, 0, NULL, 0, '2024-01-15 11:22:50', '2024-01-15 11:22:50', '2024-01-15', '', '24-05670-01-15', NULL, 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'AV. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 517.28, 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),
(4400, 1, 152, 1, 0, NULL, 0, '2024-01-15 13:38:06', '2024-01-15 13:38:06', '2024-01-15', 'P4125', '2024-01-15', '', 0.00, 68.64, 14.41, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 83.05, 0, '2024-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150124-Cf9Ua/hd8863N-174', '1a6e9f9e-b1e7-48ea-ba93-9b1cb2403e1f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150124-Cf9Ua%2Fhd8863N-174&s=KOL2024&nf=P4125&i=83.05&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4401, 1, 23, 2, 0, NULL, 0, '2024-01-15 12:55:43', '2024-01-16 09:41:41', '2024-01-15', 'P4126', '24-05671-01-15', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 172.43, 0, '2024-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150124-c99+aLSC6ueEk-154', 'c36bea6a-9e33-44e1-af5d-946b83af2ee2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150124-c99%2BaLSC6ueEk-154&s=KOL2024&nf=P4126&i=172.43&cr=095', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4402, 1, 686, 2, 0, NULL, 0, '2024-01-15 14:35:12', '2024-01-16 09:41:57', '2024-01-15', 'P4127', '24-05672-01-15', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Sancho el sabio 11. Local 3. UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 206.91, 0, '2024-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150124-Q6MchbjCEjSF4-138', '5d27e2fa-0137-4d98-b9c9-72df24035a5d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150124-Q6MchbjCEjSF4-138&s=KOL2024&nf=P4127&i=206.91&cr=144', '[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
(4403, 1, 1126, 2, 0, NULL, 0, '2024-01-15 16:14:07', '2024-01-16 09:42:07', '2024-01-15', 'P4128', '24-05673-01-15', 'Empresa SAS \r\nDejad en buzón Smart Point. \r\nCódigo usuario: MCVPAJ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Arroyo de Valdebebas, 4', 'Madrid', 'Madrid', '28040', 'España', 17.50, 0, '2024-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150124-eaNlBAOdJzlrl-050', '18768c43-bba1-4ab0-bc4c-c18c65822d43', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150124-eaNlBAOdJzlrl-050&s=KOL2024&nf=P4128&i=17.50&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4404, 1, 121, 2, 0, NULL, 0, '2024-01-15 18:19:15', '2024-01-16 09:42:39', '2024-01-15', 'P4129', '24-05674-01-15', '', 0.00, 207.64, 43.60, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 251.24, 0, '2024-01-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150124-gJ00gjZ1jPw3X-032', 'eb670335-f072-45da-b953-28352aa580c8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150124-gJ00gjZ1jPw3X-032&s=KOL2024&nf=P4129&i=251.24&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4405, 1, 174, 2, 0, NULL, 0, '2024-01-16 08:27:47', '2024-01-16 09:42:59', '2024-01-16', 'P4130', '24-05675-01-16', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 172.43, 0, '2024-01-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160124-L3y1PMh3gVZaQ-157', '02c9f1a0-f49d-424f-a4cb-bde61af258af', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160124-L3y1PMh3gVZaQ-157&s=KOL2024&nf=P4130&i=172.43&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4406, 1, 1127, 2, 0, NULL, 0, '2024-01-16 09:14:12', '2024-01-16 10:15:20', '2024-01-16', 'P4131', '24-05676-01-16', 'Si no hay nadie en casa se puede dejar en portería ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avda santuario de Valverde 20. d  4 B ', 'Madrid', 'Madrid', '28049', 'España', 28.39, 0, '2024-01-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160124-QsKnTsi4gvWpr-003', '10bf2308-e3d3-4e7c-bec9-cad223acfadc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160124-QsKnTsi4gvWpr-003&s=KOL2024&nf=P4131&i=28.39&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4407, 1, 556, 2, 0, NULL, 0, '2024-01-16 10:00:27', '2024-01-16 11:13:45', '2024-01-16', 'P4132', '24-05677-01-16', '', 0.00, 73.28, 15.82, 0.00, 0, 0.00, 2.50, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 91.17, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-160124-oQPI3D6krV4zj-208', 'aa894fef-a117-4e1d-b263-60ca13e1315a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160124-oQPI3D6krV4zj-208&s=KOL2024&nf=P4132&i=91.17&cr=252', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4408, 1, 135, 2, 0, NULL, 0, '2024-01-16 10:56:04', '2024-01-16 11:59:19', '2024-01-16', 'P4133', '24-05678-01-16', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'C/ Moraza N15', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 59.10, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-160124-CsT6IHxjQHSbj-017', '52befa03-adfe-49d3-a87e-634d240acd0b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160124-CsT6IHxjQHSbj-017&s=KOL2024&nf=P4133&i=59.10&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0);
