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
(6576, 1, 1027, 2, 0, NULL, 0, '2025-01-25 00:05:56', '2025-01-27 10:01:09', '2025-01-27', 'P6177', '25-08028-01-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Plaza palacio Góngora 8 4b', 'Aranguren', 'Navarra', '31192', 'España', 30.61, 0, '2025-01-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-KhFZUMKtI2U8G-133', '80616a7f-85ae-4157-8332-6942c1e85867', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-KhFZUMKtI2U8G-133&s=KOL2025&nf=P6177&i=30.61&cr=029', '[BLOB]', 0, 'PKANHY071000273Z', '2025-01-27 10:01:16', '[BLOB]', 2, '', '2025-01-27', 'S0235', 20, 5, 10, 200, 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
(6577, 1, 10, 2, 0, NULL, 0, '2025-01-25 12:01:51', '2025-01-27 09:27:22', '2025-01-27', 'P6178', '25-08030-01-25', '', 0.00, 325.70, 68.40, 0.00, 0, 0.00, 0.00, 'Agirre auzunea 1 behea', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 394.10, 0, '2025-01-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-Myz+0eXnSbdLS-200', 'cf018cc6-a44f-41aa-bb22-701d19c826a5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-Myz%2B0eXnSbdLS-200&s=KOL2025&nf=P6178&i=394.10&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6578, 1, 1563, 2, 0, NULL, 0, '2025-01-25 14:31:01', '2025-01-27 09:29:08', '2025-01-27', 'P6179', '25-08039-01-25', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle del Corazón de María 13, 2-B', 'Madrid', 'Madrid', '28002', 'España', 28.39, 0, '2025-01-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-TBC7/U2ZqW7Kq-191', '2699893d-3639-4604-9475-c0fec3e09806', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-TBC7%2FU2ZqW7Kq-191&s=KOL2025&nf=P6179&i=28.39&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6579, 1, 1641, 2, 0, NULL, 0, '2025-01-25 17:22:41', '2025-01-27 09:32:12', '2025-01-27', 'P6180', '25-08040-01-25', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Urbanizacion Los Alisos 32', 'Ciudad Real', 'Ciudad Real', '13002', 'España', 43.71, 0, '2025-01-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270125-IAZOp7rgjvM08-158', '23ad6a09-16c0-4d0f-9fdc-86f1021896d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-IAZOp7rgjvM08-158&s=KOL2025&nf=P6180&i=43.71&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6580, 1, 406, 2, 0, NULL, 0, '2025-01-25 18:19:09', '2025-01-27 09:33:35', '2025-01-27', 'P6181', '25-08041-01-25', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ Blas de Otero 32 5A', 'Bilbao', 'Bizkaia', '48014', 'España', 28.39, 0, '2025-01-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-T0+d2snoP9lRG-209', '7fd14176-c7b3-49da-8c78-31407b8eed2d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-T0%2Bd2snoP9lRG-209&s=KOL2025&nf=P6181&i=28.39&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6581, 1, 1642, 2, 0, NULL, 0, '2025-01-26 09:53:17', '2025-01-27 09:37:13', '2025-01-27', 'P6182', '25-08042-01-26', 'Contactar al teléfono 650747536 para entrega.', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avenida de Galicia 8, 5° CENTRO', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 61.09, 0, '2025-01-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-HpgrsEx4S7DD/-208', 'aad4c8d4-ec23-445d-b99a-36261d20af50', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-HpgrsEx4S7DD%2F-208&s=KOL2025&nf=P6182&i=61.09&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6582, 1, 721, 2, 0, NULL, 0, '2025-01-26 12:42:01', '2025-01-27 09:38:20', '2025-01-27', 'P6183', '25-08043-01-26', 'Escalera derecha', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Aiotzategi 18 escalera derecha 4C, 4C escalera derecha', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 43.71, 0, '2025-01-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-JDFJ5Xw7tad3O-159', 'e75f0f5d-5861-40a3-b3e2-032119de8146', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-JDFJ5Xw7tad3O-159&s=KOL2025&nf=P6183&i=43.71&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6583, 1, 754, 2, 0, NULL, 0, '2025-01-26 14:48:59', '2025-01-27 09:40:08', '2025-01-27', 'P6184', '25-08044-01-26', '6+1 gratis\r\nREGALO COLOR CASTAÑO\r\nGRACIAS', 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, '2025-01-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-ghJPECmUdO0q0-071', '4561a37f-6a97-4796-9707-ca17305ea895', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-ghJPECmUdO0q0-071&s=KOL2025&nf=P6184&i=61.64&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6584, 1, 477, 2, 0, NULL, 0, '2025-01-26 15:20:21', '2025-01-27 09:45:22', '2025-01-27', 'P6186', '25-08045-01-26', '', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'Pedro Elejalde12,4 .ezk', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 95.98, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-270125-E2oRk8u3GR8cW-118', 'f680e28e-844a-45f2-94ea-a3d632a5cf15', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-E2oRk8u3GR8cW-118&s=KOL2025&nf=P6186&i=95.98&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6585, 1, 1604, 2, 0, NULL, 0, '2025-01-26 18:03:55', '2025-01-27 09:46:58', '2025-01-27', 'P6185', '25-08046-01-26', '', 0.00, 525.20, 110.29, 0.00, 0, 0.00, 0.00, 'urbieta kalea 57 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 635.49, 0, '2025-01-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270125-Il3EwWm+ICZjh-138', '2cf92848-8532-4a9d-8e29-ff4179daf4e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-Il3EwWm%2BICZjh-138&s=KOL2025&nf=P6185&i=635.49&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6586, 1, 1594, 2, 0, NULL, 0, '2025-01-27 09:01:43', '2025-01-27 10:16:34', '2025-01-27', 'P6187', '25-08047-01-27', 'Es una tienda. Abren de lunes a viernes mañana y tarde, menos los lunes por la tarde. ', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'C/ Sant Vicenç, 10, Bar Botiga Casal Maià', 'Maià de Montcal', 'Girona', '17851', 'España', 71.98, 0, '2025-01-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-I6y+tEw2pYo7y-254', '2a50241c-b757-4634-bbdb-88bbad1ac8c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-I6y%2BtEw2pYo7y-254&s=KOL2025&nf=P6187&i=71.98&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6587, 1, 108, 2, 0, NULL, 0, '2025-01-27 09:18:24', '2025-01-27 10:46:31', '2025-01-27', 'P6189', '25-08048-01-27', '', 0.00, 298.91, 62.77, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 361.68, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-270125-ZLOvqdbwVuS3s-004', '25cc144e-1aff-4bfc-b3ff-96b980b9b946', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-ZLOvqdbwVuS3s-004&s=KOL2025&nf=P6189&i=361.68&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6588, 1, 1643, 2, 0, NULL, 0, '2025-01-27 09:43:25', '2025-01-27 10:47:45', '2025-01-27', 'P6188', '25-08050-01-27', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Calle de Ponferrada, nº 3, 2º A', 'Santiago de Composte', 'A Coruña', '15707', 'España', 31.50, 0, '2025-01-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-BxyGFvF7KWmWN-095', 'ca1912ba-af06-425e-944d-8113f957eab0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-BxyGFvF7KWmWN-095&s=KOL2025&nf=P6188&i=31.50&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6589, 1, 1405, 2, 0, NULL, 0, '2025-01-27 11:24:05', '2025-01-27 12:26:52', '2025-01-27', 'P6190', '25-08053-01-27', '', 0.00, 61.50, 12.92, 0.00, 0, 0.00, 0.00, 'PASEO DEL COLORADO,40, 7º B1', 'Torremolinos', 'Málaga', '29620', 'España', 74.42, 0, '2025-01-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270125-IC/rvwkgZNXKT-245', 'bfdbcd2c-7e7c-46f6-b562-c00a63d9818e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270125-IC%2FrvwkgZNXKT-245&s=KOL2025&nf=P6190&i=74.42&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6590, 1, 1525, 2, 0, NULL, 0, '2025-01-27 12:52:54', '2025-01-28 09:08:18', '2025-01-28', 'P6191', '25-08054-01-27', '', 0.00, 41.00, 9.37, 0.00, 0, 0.00, 4.40, 'Avenida da Liberdade, 11, Escalera A, 5-A', 'Santiago de Composte', 'A Coruña', '15706', 'España', 54.01, 0, '2025-01-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280125-O8rZaM8lVApi1-172', 'a571a4c1-7a26-4167-93f8-94daba1ecd9a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-O8rZaM8lVApi1-172&s=KOL2025&nf=P6191&i=54.01&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6591, 1, 1644, 2, 0, NULL, 0, '2025-01-27 14:13:45', '2025-01-28 09:13:22', '2025-01-28', 'P6192', '25-08055-01-27', '', 0.00, 20.50, 5.07, 0.00, 0, 0.00, 4.40, 'Almirante Antonio Gaztañeta, 1-2D', 'Bilbao', 'Bizkaia', '48012', 'España', 29.21, 0, '2025-01-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280125-IQO7qzadyDZLz-071', '9ac201f8-4868-4f6e-a676-4e82af7a6d98', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-IQO7qzadyDZLz-071&s=KOL2025&nf=P6192&i=29.21&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6592, 1, 925, 2, 0, NULL, 0, '2025-01-27 19:14:36', '2025-01-28 09:16:48', '2025-01-28', 'P6193', '25-08056-01-27', '', 0.00, 117.88, 24.75, 0.00, 1, 6.13, 0.00, 'Perú número 16 Bloq 2 Bajo DCH', 'ALICANTE', 'ALICANTE', '03008', 'ESPAÑA', 148.76, 0, '2025-01-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280125-TTlJtwD7qye8Z-053', '450ff5d6-71ec-4e1f-8b98-ab9dc168114f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-TTlJtwD7qye8Z-053&s=KOL2025&nf=P6193&i=148.76&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6593, 1, 1551, 2, 0, NULL, 0, '2025-01-27 22:08:38', '2025-01-28 09:23:19', '2025-01-28', 'P6194', '25-08057-01-27', '', 0.00, 11.20, 3.12, 0.00, 0, 0.00, 4.40, 'Calle azabache 26', 'Pozuelo de Alarcón', 'Madrid', '28224', 'España', 17.95, 0, '2025-01-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280125-IxNqBNr5Gm9cc-240', '1681ad0f-32a6-4e41-83e1-07b028b481d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-IxNqBNr5Gm9cc-240&s=KOL2025&nf=P6194&i=17.95&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6594, 1, 1186, 2, 0, NULL, 0, '2025-01-28 06:37:45', '2025-01-28 09:26:34', '2025-01-28', 'P6195', '25-08059-01-28', 'dejar en el buzon  659040004', 0.00, 33.60, 7.82, 0.00, 0, 0.00, 4.40, 'fernandez alarcon 44', 'Málaga', 'Málaga', '29007', 'España', 45.06, 0, '2025-01-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280125-bv0u1ZawbyWXd-219', '8f0e792c-b8f3-42a9-9c67-52f2b9b4123b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-bv0u1ZawbyWXd-219&s=KOL2025&nf=P6195&i=45.06&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6595, 1, 7, 1, 0, NULL, 0, '2025-01-28 09:25:25', '2025-01-28 09:27:43', '2025-01-28', 'P6196', '', '', 0.00, 206.29, 43.32, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 249.61, 0, '2025-01-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280125-S/sbYh8jyZ+PS-160', '119ec6ce-a65f-40a8-9115-671b6cf978a1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-S%2FsbYh8jyZ%2BPS-160&s=KOL2025&nf=P6196&i=249.61&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6596, 1, 1312, 2, 0, NULL, 0, '2025-01-28 08:51:40', '2025-01-28 09:54:11', '2025-01-28', 'P6197', '25-08060-01-28', 'se puede dejar en conserjería', 0.00, 20.50, 5.07, 0.00, 0, 0.00, 4.40, 'MAGALLANES 1, APRT 605', 'Madrid', 'Madrid', '28015', 'España', 29.21, 0, '2025-01-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280125-T99W8CBEEmVV9-193', 'd86da732-2409-4d3b-99b7-45e80b164698', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-T99W8CBEEmVV9-193&s=KOL2025&nf=P6197&i=29.21&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6597, 1, 1158, 2, 0, NULL, 0, '2025-01-28 09:23:41', '2025-01-28 10:28:17', '2025-01-28', 'P6198', '25-08061-01-28', 'Peluquería Marai', 0.00, 58.94, 12.38, 0.00, 0, 0.00, 0.00, 'Republica Argentina 3, bajo 2', 'Irun', 'Gipuzkoa', '20302', 'España', 71.32, 0, '2025-01-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280125-KcP7RcEKupRl9-228', 'f49d2fd3-b518-48c5-87b7-d167f0d925da', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-KcP7RcEKupRl9-228&s=KOL2025&nf=P6198&i=71.31&cr=212', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6598, 1, 815, 2, 0, NULL, 0, '2025-01-28 12:19:17', '2025-01-28 13:20:25', '2025-01-28', 'P6199', '25-08062-01-28', '', 0.00, 44.80, 10.17, 0.00, 0, 0.00, 4.40, 'Jacinto Benavente, 8', 'Sevilla la Nueva', 'Madrid', '28609', 'España', 58.61, 0, '2025-01-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280125-HVm4cRaqQcy9s-109', 'd91e284e-fbda-444b-800f-432b10a58e40', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-HVm4cRaqQcy9s-109&s=KOL2025&nf=P6199&i=58.61&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6599, 1, 67, 1, 0, NULL, 0, '2025-01-28 15:34:14', '2025-01-28 15:34:14', '2025-01-28', 'P6200', '', '', 0.00, 206.29, 43.32, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 249.61, 0, '2025-01-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280125-OC6aqZolqEtmk-187', 'fd9f05e9-a052-46ed-84ca-844cfac1bb08', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280125-OC6aqZolqEtmk-187&s=KOL2025&nf=P6200&i=249.61&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6600, 1, 464, 2, 0, NULL, 0, '2025-01-28 14:57:50', '2025-01-29 09:14:49', '2025-01-29', 'P6201', '25-08063-01-28', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Avenida Santuario de Valverde 6, Portal H, 3B', 'Madrid', 'Madrid', '28049', 'España', 31.50, 0, '2025-01-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290125-eMbDIab8gCixj-154', '914d0e45-6ea0-4cde-8e40-cd632d8784db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290125-eMbDIab8gCixj-154&s=KOL2025&nf=P6201&i=31.50&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6601, 1, 1511, 2, 0, NULL, 0, '2025-01-29 09:33:21', '2025-01-29 10:55:56', '2025-01-29', 'P6203', '25-08064-01-29', 'Llamar antes de la entrega', 0.00, 20.50, 5.07, 0.00, 0, 0.00, 4.40, 'San Juan 9, 1, A', 'Badajoz', 'Badajoz', '06002', 'España', 29.21, 0, '2025-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290125-Kmhk/130mShlM-135', 'a9d5ea90-cbe1-4297-b1ba-478657c405f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290125-Kmhk%2F130mShlM-135&s=KOL2025&nf=P6203&i=29.21&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6602, 1, 932, 2, 0, NULL, 0, '2025-01-29 10:03:29', '2025-01-29 11:08:20', '2025-01-29', 'P6204', '25-08065-01-29', '', 0.00, 117.88, 25.19, 0.00, 0, 0.00, 2.50, 'Calle acera del pilar, edificio residencial casa fuerte local 2 peluquería ', 'Almuñécar', 'Granada', '18697', 'España', 145.13, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290125-dkxMSMFRpkDZ7-077', 'dc28e858-1fca-4bf8-9547-d12a2e96c633', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290125-dkxMSMFRpkDZ7-077&s=KOL2025&nf=P6204&i=145.13&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6603, 1, 1646, 2, 0, NULL, 0, '2025-01-29 11:29:11', '2025-01-29 15:47:02', '2025-01-29', 'P6205', '25-08066-01-29', '', 0.00, 442.05, 92.84, 0.00, 0, 0.00, 0.00, 'C/Aguadores, N 1', 'Cortes', 'Navarra', '31530', 'España', 534.88, 0, '2025-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290125-a43PSjDJdlq22-251', '36193276-44bc-4a15-9c86-cc8070f57240', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290125-a43PSjDJdlq22-251&s=KOL2025&nf=P6205&i=534.88&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6604, 1, 23, 2, 0, NULL, 0, '2025-01-29 11:59:23', '2025-01-29 15:50:53', '2025-01-29', 'P6206', '25-08067-01-29', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 106.98, 0, '2025-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290125-eDBrNZ6V2OFH2-109', '71467c39-2643-4e73-9557-adbf6ad56f5e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290125-eDBrNZ6V2OFH2-109&s=KOL2025&nf=P6206&i=106.98&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6605, 1, 1647, 2, 0, NULL, 0, '2025-01-29 12:15:38', '2025-01-29 12:15:38', '2025-01-29', '', '25-08068-01-29', NULL, 0.00, 168.00, 35.28, 0.00, 0, 0.00, 0.00, 'AVENIDA HERNAN CORTES 48', 'Villanueva de la Ser', 'Badajoz', '06700', 'España', 203.28, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6606, 1, 53, 2, 0, NULL, 0, '2025-01-29 15:19:41', '2025-01-30 09:10:51', '2025-01-30', 'P6211', '25-08069-01-29', '', 0.00, 147.35, 31.38, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 180.79, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-300125-CQB7Dt9B+rO6y-061', '05be786f-cb09-41c5-b2a7-b9bcf44a84d6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300125-CQB7Dt9B%2BrO6y-061&s=KOL2025&nf=P6211&i=180.79&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6607, 1, 384, 2, 0, NULL, 0, '2025-01-29 17:55:32', '2025-01-30 09:11:24', '2025-01-30', 'P6207', '25-08070-01-29', '', 0.00, 56.00, 11.76, 0.00, 0, 0.00, 0.00, 'C/ HORTALEZA 116 1º EXT DCHA', 'Madrid', 'Madrid', '28004', 'España', 67.76, 0, '2025-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300125-AmG+DeYL1O+Jf-131', 'c7fdde01-ac0d-4880-99bb-87ff33165845', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300125-AmG%2BDeYL1O%2BJf-131&s=KOL2025&nf=P6207&i=67.76&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
