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
(5645, 1, 79, 1, 0, NULL, 0, '2024-08-30 12:16:08', '2024-08-30 12:16:08', '2024-08-30', 'P5294', '', '', 0.00, 285.00, 60.28, 0.00, 0, 0.00, 2.50, 'Calle María Paya 8, planta baja', 'Biar', 'Alicante', '03410', 'España', 347.35, 0, '2024-08-30 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-300824-W5AnrBS7kGO9i-207', 'ab1d246c-d757-4fab-81b3-57c1511d1bbc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300824-W5AnrBS7kGO9i-207&s=KOL2024&nf=P5294&i=347.35&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5646, 1, 270, 2, 0, NULL, 0, '2024-08-30 14:07:18', '2024-09-02 09:03:08', '2024-09-02', 'P5303', '24-07011-08-30', 'Horario comercial', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Juan Bautista Zabala 9 (Comercio Gaurko)', 'Getxo', 'Bizkaia', '48991', 'España', 41.50, 0, '2024-08-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020924-mehI0+874sT/a-143', '706ff98d-cdf8-4023-bc1b-b5ee71e2c44e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-mehI0%2B874sT%2Fa-143&s=KOL2024&nf=P5303&i=41.50&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5647, 1, 110, 2, 0, NULL, 0, '2024-08-30 15:49:39', '2024-09-02 09:05:46', '2024-09-02', 'P5296', '24-07012-08-30', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 241.40, 0, '2024-08-30 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020924-jyaV/x3h6miBV-255', '9685df7a-4828-4bec-8be2-2e0f777b0069', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-jyaV%2Fx3h6miBV-255&s=KOL2024&nf=P5296&i=241.40&cr=234', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5648, 1, 1074, 2, 0, NULL, 0, '2024-08-30 19:33:30', '2024-09-02 09:09:17', '2024-09-02', 'P5297', '24-07013-08-30', 'No funciona el interfono.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Plaça Dels Vents 13, Esc 2, 2-1', 'Calonge', 'Girona', '17252', 'España', 17.50, 0, '2024-08-30 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020924-ZftUseCjOaXXP-140', '16f3b026-de60-40ae-bb63-54d98d6f7e2a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-ZftUseCjOaXXP-140&s=KOL2024&nf=P5297&i=17.50&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5649, 1, 1390, 2, 0, NULL, 0, '2024-08-30 19:49:40', '2024-09-02 09:17:58', '2024-09-02', 'P5298', '24-07014-08-30', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Maquinilla 13 portal C piso 8 puerta 2', 'Madrid', 'Madrid', '28031', 'España', 17.50, 0, '2024-08-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020924-pMQBMm+v/DZnq-131', 'b832f4c7-cf26-4467-86e3-936bd8683166', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-pMQBMm%2Bv%2FDZnq-131&s=KOL2024&nf=P5298&i=17.50&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5650, 1, 1396, 2, 0, NULL, 0, '2024-08-31 12:25:07', '2024-09-02 09:20:42', '2024-09-02', 'P5299', '24-07015-08-31', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Cabo San Vicente 14 5A', 'Alcorcón', 'Madrid', '28924', 'España', 30.61, 0, '2024-08-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020924-UwRZfoezzWlcN-227', 'f8903d61-0059-426e-8502-d264bfaf8b04', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-UwRZfoezzWlcN-227&s=KOL2024&nf=P5299&i=30.61&cr=016', '[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
(5651, 1, 987, 2, 0, NULL, 0, '2024-08-31 15:27:02', '2024-09-02 09:25:11', '2024-09-02', 'P5300', '24-07016-08-31', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'San Joaquín 25', 'Aoiz/Agoitz', 'Navarra', '31430', 'España', 65.52, 0, '2024-08-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020924-GjaqUPPFTbfO1-110', 'cbb21c69-4307-4d7e-be54-142c19dce18b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-GjaqUPPFTbfO1-110&s=KOL2024&nf=P5300&i=65.52&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5652, 1, 994, 2, 0, NULL, 0, '2024-08-31 17:04:58', '2024-09-02 09:27:29', '2024-09-02', 'P5301', '24-07017-08-31', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avda. Joaquín Fernández Vallejo 20, 2° A', 'Torrelavega', 'Cantabria', '39300', 'España', 52.39, 0, '2024-08-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020924-WiI+gzYV4mXrb-104', 'c405e0ed-a302-4485-b45b-a26d5449f003', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-WiI%2BgzYV4mXrb-104&s=KOL2024&nf=P5301&i=52.39&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5653, 1, 601, 2, 0, NULL, 0, '2024-08-31 18:48:04', '2024-09-03 09:14:20', '2024-09-03', 'P5309', '24-07019-08-31', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Iturribarri, 11,-1 (puerta granate)', 'Ondarroa', 'Bizkaia', '48700', 'España', 78.63, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030924-EROp1DQ3B+z8Z-126', 'e88689ef-8d40-4e27-884e-72ce32b10bce', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030924-EROp1DQ3B%2Bz8Z-126&s=KOL2024&nf=P5309&i=78.63&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5654, 1, 993, 2, 0, NULL, 0, '2024-09-02 06:50:30', '2024-09-02 09:30:39', '2024-09-02', 'P5302', '24-07020-09-02', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'c/ Sorolla 40 1A', 'Rincón de la Victori', 'Málaga', '29720', 'España', 65.52, 0, '2024-09-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020924-U69LKLjCjl6Rb-198', 'db91b484-6677-4c21-ab28-d590e21ee8ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-U69LKLjCjl6Rb-198&s=KOL2024&nf=P5302&i=65.52&cr=084', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5655, 1, 78, 2, 0, NULL, 0, '2024-09-02 08:19:05', '2024-09-02 10:37:22', '2024-09-02', '', '24-07021-09-02', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'AV. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 551.76, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(5656, 1, 78, 2, 0, NULL, 0, '2024-09-02 10:37:35', '2024-09-02 10:38:03', '2024-09-02', 'P5304', '24-07021-09-02', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'AV. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 551.76, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020924-KcVEBrOjEnjST-245', '2d3eaca5-fa33-4baf-a94f-408e05e60a3f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-KcVEBrOjEnjST-245&s=KOL2024&nf=P5304&i=551.76&cr=184', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5657, 1, 754, 2, 0, NULL, 0, '2024-09-02 09:40:01', '2024-09-02 11:42:24', '2024-09-02', 'P5305', '24-07022-09-02', '6+1 REGALO COLOR COBRE', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-09-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020924-AOp1F9++bGhGY-082', '9c9de8e9-6cd4-4c0d-908e-f73ac678114f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-AOp1F9%2B%2BbGhGY-082&s=KOL2024&nf=P5305&i=61.64&cr=053', '[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
(5658, 1, 4, 2, 0, NULL, 0, '2024-09-02 09:51:06', '2024-09-02 11:56:48', '2024-09-02', 'P5306', '24-07023-09-02', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 206.91, 0, '2024-09-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020924-jiCzYvWuPb82F-170', '227f5aa8-ae33-450e-823a-786b434a6fa0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020924-jiCzYvWuPb82F-170&s=KOL2024&nf=P5306&i=206.91&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5659, 1, 1397, 2, 0, NULL, 0, '2024-09-02 15:41:19', '2024-09-03 09:03:42', '2024-09-03', 'P5307', '24-07024-09-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Camiño Tras da Vila 24, 1B', 'Cabanas', 'A Coruña', '15621', 'España', 28.39, 0, '2024-09-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030924-TT4IaAE7deT36-239', '074dbcd0-cee0-4980-a5f5-ecab38b19919', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030924-TT4IaAE7deT36-239&s=KOL2024&nf=P5307&i=28.39&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5660, 1, 1158, 2, 0, NULL, 0, '2024-09-03 07:01:25', '2024-09-03 09:06:39', '2024-09-03', 'P5308', '24-07026-09-03', 'Peluqueria Marai', 0.00, 154.66, 32.48, 0.00, 0, 0.00, 0.00, 'Republica argentina, bajo 2', 'Irun', 'Gipuzkoa', '20302', 'España', 187.14, 0, '2024-09-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030924-bp1Fb3rKB/H9i-085', '30c5024e-fcb6-408d-ad23-271bf607fe0b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030924-bp1Fb3rKB%2FH9i-085&s=KOL2024&nf=P5308&i=187.14&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5661, 1, 784, 2, 0, NULL, 0, '2024-09-03 07:28:43', '2024-09-03 09:40:20', '2024-09-03', 'P5310', '24-07027-09-03', '', 0.00, 57.00, 11.97, 0.00, 1, 2.96, 0.00, 'Calle san francisco 30 bis bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20002', 'España', 71.93, 0, '2024-09-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030924-Bb/BDrrzH+u+s-151', '6e730c81-e5fe-4939-8713-c3bb91f41b78', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030924-Bb%2FBDrrzH%2Bu%2Bs-151&s=KOL2024&nf=P5310&i=71.93&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5662, 1, 167, 1, 0, NULL, 0, '2024-09-03 10:19:20', '2024-09-03 10:19:20', '2024-09-03', 'P5311', '', '', 0.00, 289.06, 60.70, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 349.76, 0, '2024-09-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030924-IdRTA0QvqUf9N-036', '8c708622-2bfd-404a-96c4-0baf0aa433a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030924-IdRTA0QvqUf9N-036&s=KOL2024&nf=P5311&i=349.76&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5663, 1, 566, 2, 0, NULL, 0, '2024-09-03 08:51:31', '2024-09-03 10:56:15', '2024-09-03', 'P5312', '24-07028-09-03', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 551.76, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030924-AP/DRcqej8SUU-137', 'f6d866af-5e90-4ad1-a2ed-a51a6b6e17ad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030924-AP%2FDRcqej8SUU-137&s=KOL2024&nf=P5312&i=551.76&cr=252', '[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
(5664, 1, 164, 2, 0, NULL, 0, '2024-09-03 09:14:01', '2024-09-03 11:48:57', '2024-09-03', 'P5313', '24-07029-09-03', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 482.79, 0, '2024-09-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030924-aLj7rVUxhQiIY-149', '285fc40f-9e3f-492e-b23c-11ac5866ab78', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030924-aLj7rVUxhQiIY-149&s=KOL2024&nf=P5313&i=482.79&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5665, 1, 306, 2, 0, NULL, 0, '2024-09-03 10:31:45', '2024-09-03 12:34:14', '2024-09-03', 'P5314', '24-07030-09-03', 'perruqueria beQhairstyle horario de lunes a viernes de 9:00 a 18:30 y sabados de 8:30 a 13:30 .', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'calle puigmolto n9 ', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 517.28, 0, '2024-09-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030924-KWcpw+LaZLdNk-140', 'a736380b-5dc6-4ea2-88f0-e82261c1786d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030924-KWcpw%2BLaZLdNk-140&s=KOL2024&nf=P5314&i=517.28&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5666, 1, 166, 1, 0, NULL, 0, '2024-09-03 13:02:41', '2024-09-03 13:03:13', '2024-09-03', 'P5315', '2024-09-03', '', 0.00, 210.21, 44.14, 0.00, 1, 10.93, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 265.28, 0, '2024-09-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030924-TN2othCHAjuZa-235', '5442fdcd-ed0d-4b42-96d5-751a1962c2bc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030924-TN2othCHAjuZa-235&s=KOL2024&nf=P5315&i=265.27&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5667, 1, 1398, 2, 0, NULL, 0, '2024-09-03 13:28:32', '2024-09-04 09:09:10', '2024-09-04', 'P5316', '24-07031-09-03', '', 0.00, 104.64, 28.57, 0.00, 0, 0.00, 38.00, '15 Rue Pontcottier \"Le Quadrille\"', 'Bourgoin - Jallieu', 'Isére', '38300', 'Francia', 164.96, 0, '2024-09-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040924-mA+xfvV2uQp5o-019', 'b4d85399-c65d-4a02-9a7b-1dc110ca6d49', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040924-mA%2BxfvV2uQp5o-019&s=KOL2024&nf=P5316&i=164.96&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5668, 1, 1399, 2, 0, NULL, 0, '2024-09-03 14:02:24', '2024-09-04 09:14:13', '2024-09-04', 'P5317', '24-07032-09-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Hermanos Álvarez Quintero , 1 - 1ºB', 'Molina de Segura', 'Murcia', '30500', 'España', 17.50, 0, '2024-09-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040924-jGX8jAlPE7E8x-038', '9e183885-50a9-4f30-9d04-2423e19a4603', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040924-jGX8jAlPE7E8x-038&s=KOL2024&nf=P5317&i=17.50&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5669, 1, 67, 2, 0, NULL, 0, '2024-09-03 14:12:57', '2024-09-04 09:16:29', '2024-09-04', 'P5319', '24-07033-09-03', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040924-RBwUnul2mKjRW-197', 'f980dc14-d3c7-49f1-be4e-414fe752ab78', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040924-RBwUnul2mKjRW-197&s=KOL2024&nf=P5319&i=379.34&cr=219', '[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
(5670, 1, 98, 2, 0, NULL, 0, '2024-09-03 16:13:13', '2024-09-04 09:18:13', '2024-09-04', 'P5318', '24-07034-09-03', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 59.10, 0, '2024-09-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040924-a1cwVq151747g-038', '3d338bdc-7882-4a96-9554-fbc52f81e7d6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040924-a1cwVq151747g-038&s=KOL2024&nf=P5318&i=59.10&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5671, 1, 23, 2, 0, NULL, 0, '2024-09-04 09:30:27', '2024-09-04 11:55:21', '2024-09-04', 'P5320', '24-07035-09-04', '', 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-09-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040924-YINT9zd25eB4P-239', 'c3255405-ad5b-41e9-97b1-88c00b016079', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040924-YINT9zd25eB4P-239&s=KOL2024&nf=P5320&i=172.43&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5672, 1, 979, 2, 0, NULL, 0, '2024-09-04 09:41:12', '2024-09-04 11:57:05', '2024-09-04', 'P5321', '24-07036-09-04', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'calle palma 58 local 1', 'Madrid', 'Madrid', '28015', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040924-WofT1uEz2DJXx-024', 'fc8ed3ef-f10a-44df-9410-8a0c41f7382a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040924-WofT1uEz2DJXx-024&s=KOL2024&nf=P5321&i=413.82&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5673, 1, 190, 3, 0, NULL, 0, '2024-09-04 12:20:45', '2024-09-04 12:20:45', '2024-09-04', '', 'Consumo interno', '', 0.00, 2931.00, 615.51, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 3546.51, 0, '2024-09-04 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),
(5674, 1, 560, 2, 0, NULL, 0, '2024-09-04 11:04:48', '2024-09-04 13:08:19', '2024-09-04', 'P5322', '24-07037-09-04', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'calle balmes 133', 'Barcelona', 'Barcelona', '08008', 'España', 517.28, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040924-iZs216OaaAplO-200', '2b0ae596-1110-4543-96d1-b012cb4252c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040924-iZs216OaaAplO-200&s=KOL2024&nf=P5322&i=517.28&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5675, 1, 468, 2, 0, NULL, 0, '2024-09-04 12:35:13', '2024-09-05 08:59:20', '2024-09-05', 'P5323', '24-07039-09-04', '', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'Avda. Andurique 47', 'Poio', 'Pontevedra', '36163', 'España', 88.67, 0, '2024-09-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-050924-RVn3OLmJ/lfNU-128', '89ea8b45-2244-49fd-94f1-afda4d581d53', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050924-RVn3OLmJ%2FlfNU-128&s=KOL2024&nf=P5323&i=88.67&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5676, 1, 272, 2, 0, NULL, 0, '2024-09-04 16:03:50', '2024-09-05 09:01:02', '2024-09-05', 'P5324', '24-07040-09-04', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Los Cerros 27C', 'Palazuelos de Eresma', 'Segovia', '40194', 'España', 65.52, 0, '2024-09-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050924-EE61dc4bmWSRf-084', 'da8d51fb-fdc8-4f56-8220-8396e8a25658', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050924-EE61dc4bmWSRf-084&s=KOL2024&nf=P5324&i=65.52&cr=134', '[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
(5677, 1, 754, 2, 0, NULL, 0, '2024-09-04 16:13:29', '2024-09-05 09:06:03', '2024-09-05', 'P5325', '24-07041-09-04', '6+1 REGALO ', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'JOSEP TARRADELLAS 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-09-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050924-Quy6rLcmvRry2-122', 'd8989552-851d-401b-906b-67426ea13733', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050924-Quy6rLcmvRry2-122&s=KOL2024&nf=P5325&i=61.64&cr=198', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5678, 1, 677, 2, 0, NULL, 0, '2024-09-04 17:00:17', '2024-09-05 09:07:31', '2024-09-05', 'P5326', '24-07042-09-04', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Volvo Arregui(Oscar Aragunde)C/ Portal de Betoño, 13.', 'Vitoria-Gasteiz', 'Álava', '01013', 'España', 30.61, 0, '2024-09-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050924-U4HBd03vtvm89-175', 'aa354686-8825-4961-92ae-7787f1e22e03', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050924-U4HBd03vtvm89-175&s=KOL2024&nf=P5326&i=30.61&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5679, 1, 687, 1, 0, NULL, 0, '2024-09-05 09:14:10', '2024-09-05 09:16:15', '2024-09-05', 'P5327', '', '', 0.00, 166.92, 35.05, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 201.97, 0, '2024-09-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050924-fOPeBlnp2wPJt-082', '75d73e04-5b2c-4f8a-84c1-dc8f563471fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050924-fOPeBlnp2wPJt-082&s=KOL2024&nf=P5327&i=201.97&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5680, 1, 108, 2, 0, NULL, 0, '2024-09-05 07:31:11', '2024-09-05 09:36:47', '2024-09-05', 'P5328', '24-07043-09-05', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050924-pXqtrVh77FcmI-159', 'f35c227b-f252-4caa-b20b-f9e7caa887e9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050924-pXqtrVh77FcmI-159&s=KOL2024&nf=P5328&i=103.46&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5681, 1, 145, 2, 0, NULL, 0, '2024-09-05 12:57:16', '2024-09-06 09:01:45', '2024-09-06', 'P5333', '24-07044-09-05', '', 0.00, 256.50, 54.30, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 312.87, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-060924-Nk9TuSJn/PVKk-131', 'ee3f3643-4193-406a-b124-b78fef20b077', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060924-Nk9TuSJn%2FPVKk-131&s=KOL2024&nf=P5333&i=312.87&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5682, 1, 951, 2, 0, NULL, 0, '2024-09-05 14:27:04', '2024-09-06 09:03:31', '2024-09-06', 'P5329', '24-07045-09-05', '', 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-09-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060924-W8XyUHvjL+0Pl-130', '4e3dd885-841d-43fe-a570-42e750201b97', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060924-W8XyUHvjL%2B0Pl-130&s=KOL2024&nf=P5329&i=17.50&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
(5683, 1, 1400, 2, 0, NULL, 0, '2024-09-05 15:08:48', '2024-09-06 09:05:13', '2024-09-06', 'P5330', '24-07046-09-05', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Pujada de cal rei 34', 'Porqueres', 'Girona', '17834', 'España', 65.52, 0, '2024-09-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060924-k+yCmWk9OkhaQ-205', '3359229e-b41d-435a-b2be-c103b0b0254c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060924-k%2ByCmWk9OkhaQ-205&s=KOL2024&nf=P5330&i=65.52&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5684, 1, 157, 2, 0, NULL, 0, '2024-09-05 15:15:34', '2024-09-06 09:06:28', '2024-09-06', 'P5331', '24-07047-09-05', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'CALLE APODACA,1 LOCAL', 'Madrid', 'Madrid', '28004', 'España', 379.34, 0, '2024-09-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060924-bGLe453ZqYUMt-067', 'de98dfde-03b9-4308-b738-77571b7596fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060924-bGLe453ZqYUMt-067&s=KOL2024&nf=P5331&i=379.34&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5685, 1, 1280, 2, 0, NULL, 0, '2024-09-05 15:23:05', '2024-09-06 09:08:14', '2024-09-06', 'P5332', '24-07048-09-05', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Carrer de Joan Alsina, 27 bxs 2a', 'Girona', 'Girona', '17003', 'España', 52.39, 0, '2024-09-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-060924-jSdqbROOxtQhr-004', 'f5ad14b4-2397-45b4-98f8-f5f7b453c8b3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060924-jSdqbROOxtQhr-004&s=KOL2024&nf=P5332&i=52.39&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5686, 1, 242, 1, 0, NULL, 0, '2024-09-06 09:12:24', '2024-09-06 09:13:14', '2024-09-06', 'P5334', '', '', 0.00, 146.52, 30.77, 0.00, 1, 7.62, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 184.91, 0, '2024-09-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060924-PhSgW/rEz+uUs-150', '042b04b3-5732-4043-8004-7f3b2c037570', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060924-PhSgW%2FrEz%2BuUs-150&s=KOL2024&nf=P5334&i=184.91&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5687, 1, 127, 2, 0, NULL, 0, '2024-09-06 12:11:41', '2024-09-09 09:03:17', '2024-09-09', 'P5335', '24-07049-09-06', '', 0.00, 179.14, 37.62, 0.00, 0, 0.00, 0.00, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 216.76, 0, '2024-09-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-d4LzKzWeEIrfb-093', '81b035bf-ab9e-411a-a00f-db1fb78ec3f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-d4LzKzWeEIrfb-093&s=KOL2024&nf=P5335&i=216.76&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5688, 1, 449, 2, 0, NULL, 0, '2024-09-06 19:41:44', '2024-09-09 09:04:03', '2024-09-09', 'P5336', '24-07050-09-06', 'Nombre local ( Engimek)', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Tiburtzio Anitua 32, 1 planta', 'Eibar', 'Gipuzkoa', '20600', 'España', 41.50, 0, '2024-09-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-L2ls7VLUJdpAH-024', '697f30a6-dbc1-4391-8cf9-9b56653105c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-L2ls7VLUJdpAH-024&s=KOL2024&nf=P5336&i=41.50&cr=049', '[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
(5689, 1, 1401, 2, 0, NULL, 0, '2024-09-07 05:41:22', '2024-09-09 09:06:40', '2024-09-09', 'P5337', '24-07051-09-07', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Ocaña 145, 7D', 'Madrid', 'Madrid', '28047', 'España', 17.50, 0, '2024-09-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-jS82YgQD1TKMU-250', '2190f297-0df7-414b-95c3-73cc6a5c4216', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-jS82YgQD1TKMU-250&s=KOL2024&nf=P5337&i=17.50&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5690, 1, 1402, 2, 0, NULL, 0, '2024-09-08 10:06:18', '2024-09-09 09:08:40', '2024-09-09', 'P5338', '24-07053-09-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Río Boeza, 10 . SUPERMERCADO ALCAMPO, 10, Bajo', 'Bembibre', 'León', '24300', 'España', 17.50, 0, '2024-09-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-d2J6yatqxT4KX-000', '8bcb9c90-6d82-4e9b-987d-da8a477fe454', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-d2J6yatqxT4KX-000&s=KOL2024&nf=P5338&i=17.50&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5691, 1, 1037, 2, 0, NULL, 0, '2024-09-08 11:45:40', '2024-09-09 09:11:19', '2024-09-09', 'P5339', '24-07054-09-08', 'Si es posible entregar antes de las 13:00h. ', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Av/ Nuestra Señora de la Asunción,  Número 4. 1-1ª', 'Bellvei', 'Tarragona', '43719', 'España', 43.71, 0, '2024-09-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-iI9wxR6N4czPu-196', 'aa903bc8-c69d-40ea-998f-9e79237fb9d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-iI9wxR6N4czPu-196&s=KOL2024&nf=P5339&i=43.71&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5692, 1, 1177, 2, 0, NULL, 0, '2024-09-08 15:18:11', '2024-09-09 09:13:07', '2024-09-09', 'P5340', '24-07056-09-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'rua S.D.Compostela n 24° 4°A', 'Santiago de Composte', 'A Coruña', '15707', 'España', 17.50, 0, '2024-09-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090924-U6fMD/R+joEA1-209', '4e3bd7ae-f413-4fff-b9c1-502314449623', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-U6fMD%2FR%2BjoEA1-209&s=KOL2024&nf=P5340&i=17.50&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5693, 1, 627, 2, 0, NULL, 0, '2024-09-08 15:46:04', '2024-09-09 09:14:30', '2024-09-09', 'P5341', '24-07057-09-08', 'Se puede dejar el paquete en Goldra nº5 si no contesta nadie al timbre. Gracias', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Goldra 12, Mañufe, CASA', 'Gondomar', 'Pontevedra', '36388', 'España', 30.61, 0, '2024-09-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-N/iElQCpLRzip-061', 'a1b1b563-732a-43f3-a164-4816640041cd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-N%2FiElQCpLRzip-061&s=KOL2024&nf=P5341&i=30.61&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5694, 1, 571, 2, 0, NULL, 0, '2024-09-08 20:51:17', '2024-09-09 09:20:32', '2024-09-09', 'P5342', '24-07058-09-08', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'AMAROZ  30, 1B', 'Tolosa', 'Gipuzkoa', '20400', 'España', 71.98, 0, '2024-09-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-JLViUx8xN3bGI-220', '48630020-3ab6-4742-9909-731f8b74a9c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-JLViUx8xN3bGI-220&s=KOL2024&nf=P5342&i=71.98&cr=133', '[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
(5695, 1, 522, 2, 0, NULL, 0, '2024-09-09 07:15:54', '2024-09-09 09:23:00', '2024-09-09', 'P5343', '24-07059-09-09', '', 0.00, 264.64, 55.57, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 320.21, 0, '2024-09-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-m/bxfE/W8En+o-217', '584f822d-f104-4800-82e2-dca0c0ae1436', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-m%2FbxfE%2FW8En%2Bo-217&s=KOL2024&nf=P5343&i=320.20&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5696, 1, 754, 2, 0, NULL, 0, '2024-09-09 07:19:39', '2024-09-09 09:25:08', '2024-09-09', 'P5344', '24-07060-09-09', '6+1 REGALO CASTAÑO\r\nDE FORMA PUNTUAL, ENVIAR EL PEDIDO A \" CALLE MALLORCA, NÚMERO 5, LOCAL. EN EL MISMO MUNICIPIO. GRACIAS', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradelals 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-09-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-IUY43QmqiZy8n-117', 'c287bd28-0292-4792-a88c-e65bf92d9438', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-IUY43QmqiZy8n-117&s=KOL2024&nf=P5344&i=61.64&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5697, 1, 4, 2, 0, NULL, 0, '2024-09-09 07:50:13', '2024-09-09 09:57:00', '2024-09-09', 'P5345', '24-07061-09-09', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 206.91, 0, '2024-09-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090924-Wq4US/Bcs3A48-154', '1b097226-2e29-4ce4-b7f9-5ac3f26586d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-Wq4US%2FBcs3A48-154&s=KOL2024&nf=P5345&i=206.91&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5698, 1, 1270, 2, 0, NULL, 0, '2024-09-09 09:41:33', '2024-09-09 11:42:17', '2024-09-09', 'P5346', '24-07062-09-09', '', 0.00, 30.66, 7.64, 0.00, 0, 0.00, 6.90, 'Principe Felipe 18', 'Daganzo de Arriba', 'Madrid', '28814', 'España', 44.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-090924-nVYz2nYQsRY2q-090', '692b5dd0-768d-4722-84dd-ef7799578258', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090924-nVYz2nYQsRY2q-090&s=KOL2024&nf=P5346&i=44.00&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5699, 1, 258, 2, 0, NULL, 0, '2024-09-09 15:22:54', '2024-09-10 09:46:45', '2024-09-10', 'P5347', '24-07063-09-09', 'Casa', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'carrer Maria Zambrano, 14', 'Viladecans', 'Barcelona', '08840', 'España', 95.98, 0, '2024-09-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100924-UwPoBGXrtsPUn-165', '02b7e79f-0dfc-44cd-818f-59035df2a3db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100924-UwPoBGXrtsPUn-165&s=KOL2024&nf=P5347&i=95.98&cr=208', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5700, 1, 258, 2, 0, NULL, 0, '2024-09-09 15:35:04', '2024-09-10 09:47:32', '2024-09-10', 'P5348', '24-07064-09-09', 'casa', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Carrer Maria Zambrano, 14', 'Viladecans', 'Barcelona', '08840', 'España', 43.71, 0, '2024-09-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100924-OHLFbFegSvhzt-219', '77d9cba1-9a00-4990-9048-936abb1743d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100924-OHLFbFegSvhzt-219&s=KOL2024&nf=P5348&i=43.71&cr=184', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
