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
(6989, 1, 1750, 2, 0, NULL, 0, '2025-03-25 14:06:36', '2025-03-25 15:24:31', '2025-03-25', 'P6569', '25-08487-03-25', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Rua Sol, nº76, bajo izda', 'Carballo', 'A Coruña', '15100', 'España', 31.27, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250325-QK/PFhHhfPTxC-076', 'aaeb2a1a-4919-4cc2-9f6c-4e185e3663d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250325-QK%2FPFhHhfPTxC-076&s=KOL2025&nf=P6569&i=31.27&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6990, 1, 190, 3, 0, NULL, 0, '2025-03-25 15:19:56', '2025-03-25 15:19:56', '2025-03-25', '', 'Consumo interno', '', 0.00, 589.40, 123.77, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebastián', 'Gipuzkoa', '20011', 'España', 713.17, 0, '2025-03-25 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6991, 1, 174, 2, 0, NULL, 0, '2025-03-25 17:22:49', '2025-03-26 09:00:23', '2025-03-26', 'P6570', '25-08493-03-25', 'Hola Oihana ,esta vez si no es molestia prefiero que me envíes la factura por mail y no la pongas en el envío .\r\nMuchas gracias \r\nun saludo\r\nMarga\r\n', 0.00, 147.35, 30.95, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 178.29, 0, '2025-03-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260325-K0et/G6W+UbAx-014', 'a249d88c-78e5-4e29-a4aa-f3e2ddef05f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260325-K0et%2FG6W%2BUbAx-014&s=KOL2025&nf=P6570&i=178.29&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6992, 1, 1351, 2, 0, NULL, 0, '2025-03-25 23:00:06', '2025-03-26 09:00:52', '2025-03-26', 'P6571', '25-08495-03-25', 'Llamar al telefonillo 524.\r\nAvisar con antelación de seis horas, por favor.', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Jose Manuel Valles 9, 5, 6D', 'Marbella', 'Málaga', '29603', 'España', 31.27, 0, '2025-03-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260325-JsBGrMigU4xzI-054', 'f235cdb2-aaf7-4eeb-b500-e7e9e237fca0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260325-JsBGrMigU4xzI-054&s=KOL2025&nf=P6571&i=31.27&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6993, 1, 1316, 2, 0, NULL, 0, '2025-03-26 09:46:47', '2025-03-26 11:11:01', '2025-03-26', 'P6572', '25-08496-03-26', 'lunes cerrado', 0.00, 147.35, 30.95, 0.00, 0, 0.00, 0.00, 'AVENIDA DE SANTIAGO 18 BAJO PEDROUZO', 'Pino (O)', 'A Coruña', '15821', 'España', 178.29, 0, '2025-03-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260325-f+EMD9ef3Nm/g-249', '10494023-1070-4b8f-8bd1-e8fad88336c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260325-f%2BEMD9ef3Nm%2Fg-249&s=KOL2025&nf=P6572&i=178.29&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6994, 1, 397, 2, 0, NULL, 0, '2025-03-26 10:13:49', '2025-03-26 11:20:59', '2025-03-26', 'P6573', '25-08498-03-26', '', 0.00, 61.50, 12.92, 0.00, 0, 0.00, 0.00, 'Alaberga 69. 1 izda.', 'Errenteria', 'Gipuzkoa', '20100', 'España', 74.42, 0, '2025-03-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260325-eehknO6WpEBZE-210', '2572477e-46da-45c9-b50c-40fc6b79f904', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260325-eehknO6WpEBZE-210&s=KOL2025&nf=P6573&i=74.42&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6995, 1, 65, 2, 0, NULL, 0, '2025-03-26 10:17:25', '2025-03-26 11:22:07', '2025-03-26', 'P6574', '25-08499-03-26', '', 0.00, 324.17, 68.08, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 392.25, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260325-LWW/sMx9TMSHC-038', '5cff225a-d262-4402-a296-083c02995574', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260325-LWW%2FsMx9TMSHC-038&s=KOL2025&nf=P6574&i=392.25&cr=160', '[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
(6996, 1, 576, 2, 0, NULL, 0, '2025-03-26 11:08:00', '2025-03-26 12:09:00', '2025-03-26', 'P6575', '25-08484-03-24', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'Calle silicio n° 32 , 1° D escalera derecha ', 'Torrejón de Ardoz', 'Madrid', '28850', 'España', 17.72, 0, '0000-00-00 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260325-U85L2b20+ztZ1-122', 'd2540cd2-0a39-421f-b0a8-e4797f181c52', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260325-U85L2b20%2BztZ1-122&s=KOL2025&nf=P6575&i=17.72&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6997, 1, 1388, 2, 0, NULL, 0, '2025-03-26 12:43:13', '2025-03-27 08:37:43', '2025-03-27', 'P6581', '25-08501-03-26', '', 0.00, 33.68, 7.71, 0.00, 0, 0.00, 3.67, 'Hondarribia 26', 'Donostia-San Sebastián', 'Gipuzkoa', '20005', 'España', 44.42, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-270325-V2324ZJEGqNpK-035', 'af7cc587-3377-4b25-a0f1-61e8718d2308', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270325-V2324ZJEGqNpK-035&s=KOL2025&nf=P6581&i=44.42&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6998, 1, 505, 2, 0, NULL, 0, '2025-03-26 13:07:09', '2025-03-26 16:00:10', '2025-03-26', 'P6576', '25-08502-03-26', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Av. Labradores 16, piso 4 puerta 2', 'Tres Cantos', 'Madrid', '28760', 'España', 31.27, 0, '2025-03-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260325-HxudPYk3XXnfc-053', '58b74b9e-1250-4936-a50c-0355cfdb84aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260325-HxudPYk3XXnfc-053&s=KOL2025&nf=P6576&i=31.27&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6999, 1, 145, 2, 0, NULL, 0, '2025-03-26 15:09:50', '2025-03-27 08:38:53', '2025-03-27', 'P6582', '25-08503-03-26', '', 0.00, 117.88, 25.19, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 145.13, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-270325-CHzQOPglCJwJ9-239', '42026b8e-5cec-4586-9580-083566062dd4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270325-CHzQOPglCJwJ9-239&s=KOL2025&nf=P6582&i=145.13&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7000, 1, 686, 2, 0, NULL, 0, '2025-03-26 15:12:49', '2025-03-27 08:39:31', '2025-03-27', 'P6577', '25-08504-03-26', '', 0.00, 214.71, 45.09, 0.00, 0, 0.00, 0.00, 'calle del parque 3. UDARA', 'Donostia-San Sebastián', 'Gipuzkoa', '20010', 'España', 259.80, 0, '2025-03-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270325-dgvvZbaRKfGgA-253', 'c612bc3d-0761-4e61-98ec-b0b8a6b329e5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270325-dgvvZbaRKfGgA-253&s=KOL2025&nf=P6577&i=259.80&cr=009', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7001, 1, 1751, 2, 0, NULL, 0, '2025-03-26 20:10:21', '2025-03-27 08:40:04', '2025-03-27', 'P6578', '25-08505-03-26', '', 0.00, 41.00, 9.33, 0.00, 0, 0.00, 4.17, 'c.triops sn', 'Fontcoberta', 'Girona', '17833', 'España', 53.78, 0, '2025-03-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270325-VH3cd2kfIJBwI-203', '4c5d8b1b-4c98-4e72-aba7-cf9e43f1cea2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270325-VH3cd2kfIJBwI-203&s=KOL2025&nf=P6578&i=53.78&cr=177', '[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
(7002, 1, 1752, 2, 0, NULL, 0, '2025-03-26 22:32:56', '2025-03-27 08:40:32', '2025-03-27', 'P6579', '25-08506-03-26', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'C/CORTADORES 5', 'Ejido (El)', 'Almería', '04710', 'España', 17.72, 0, '2025-03-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-270325-EqaEEh+h21aP1-191', '611b990a-d547-48b1-a38f-2e4cf9169886', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270325-EqaEEh%2Bh21aP1-191&s=KOL2025&nf=P6579&i=17.72&cr=198', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7003, 1, 1753, 2, 0, NULL, 0, '2025-03-27 07:32:03', '2025-03-27 08:40:54', '2025-03-27', 'P6580', '25-08507-03-27', 'entrega oficina Saretik', 0.00, 11.20, 2.99, 0.00, 0, 0.00, 3.67, 'Iurre auzoa 4 bajo', 'Tolosa', 'Gipuzkoa', '20400', 'España', 17.22, 0, '2025-03-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270325-HAvZY8lcWTRH1-093', 'b6e5e6e0-9e4e-425e-ab8d-29e51d70f492', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270325-HAvZY8lcWTRH1-093&s=KOL2025&nf=P6580&i=17.22&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7004, 1, 747, 2, 0, NULL, 0, '2025-03-27 09:47:25', '2025-03-27 10:49:46', '2025-03-27', 'P6583', '25-08508-03-27', '', 0.00, 44.80, 10.13, 0.00, 0, 0.00, 4.17, 'C/Estena 6 -Jardines de Sierra Blanca -Bloque 6-Bajo.L', 'Marbella', 'Málaga', '29602', 'España', 58.38, 0, '2025-03-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270325-WrHA3kcF9tdN4-189', '6c8b6be4-91e8-43c1-9e80-d01275eee713', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270325-WrHA3kcF9tdN4-189&s=KOL2025&nf=P6583&i=58.38&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7005, 1, 1754, 2, 0, NULL, 0, '2025-03-27 10:06:51', '2025-03-27 11:14:26', '2025-03-27', 'P6584', '25-08509-03-27', 'Citibox Portal 1', 0.00, 56.00, 11.76, 0.00, 0, 0.00, 0.00, 'Av. Pablo Iglesias , 91 Portal 4 - 3A', 'Rivas-Vaciamadrid', 'Madrid', '28521', 'España', 67.76, 0, '2025-03-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270325-J6s472/G/+9L0-161', '5e587ee4-33ce-46d2-877c-64824fb5c79c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270325-J6s472%2FG%2F%2B9L0-161&s=KOL2025&nf=P6584&i=67.76&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7006, 1, 1137, 2, 0, NULL, 0, '2025-03-27 15:14:07', '2025-03-28 08:58:13', '2025-03-28', 'P6585', '25-08510-03-27', '', 0.00, 78.40, 16.46, 0.00, 0, 0.00, 0.00, 'PUJADA DE CAL REI 34', 'Porqueres', 'Girona', '17834', 'España', 94.86, 0, '2025-03-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280325-RdwjrJvi75wtS-172', '1c5813cb-5762-4fdd-b718-b3cd037d2a9b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280325-RdwjrJvi75wtS-172&s=KOL2025&nf=P6585&i=94.86&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7007, 1, 1755, 2, 0, NULL, 0, '2025-03-27 21:02:11', '2025-03-28 08:58:54', '2025-03-28', 'P6586', '25-08511-03-27', 'Horario oficina 09:30 a 17:40', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'C/. Mercedes formica 8 local 5', 'Málaga', 'Málaga', '29140', 'España', 28.98, 0, '2025-03-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280325-OM/vsnjqlACHy-105', '52a23de5-a729-44c9-9861-7fd588e06bf1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280325-OM%2FvsnjqlACHy-105&s=KOL2025&nf=P6586&i=28.98&cr=208', '[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
(7008, 1, 441, 2, 0, NULL, 0, '2025-03-28 06:37:15', '2025-03-28 08:59:30', '2025-03-28', 'P6587', '25-08512-03-28', 'Hay dos n 24, es el que tiene una placa que indica Cal Sellarès.', 0.00, 44.80, 10.13, 0.00, 0, 0.00, 4.17, 'C/Raval n24', 'Olesa de Bonesvalls', 'Barcelona', '08795', 'España', 58.38, 0, '2025-03-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280325-QXugNzlAkFWir-174', '43b01b69-5b13-400e-9b93-ab7ed15d1cab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280325-QXugNzlAkFWir-174&s=KOL2025&nf=P6587&i=58.38&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7009, 1, 754, 2, 0, NULL, 0, '2025-03-28 09:16:47', '2025-03-28 10:46:54', '2025-03-28', 'P6588', '25-08513-03-28', '6+1 gratis\r\nregalo precolor dorado\r\ngracias', 0.00, 50.52, 10.61, 0.00, 1, 2.63, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 63.76, 0, '2025-03-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280325-am60QCsFiwjtU-032', '5b7ba8dd-8a42-4c90-b587-6fa05a7726b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280325-am60QCsFiwjtU-032&s=KOL2025&nf=P6588&i=63.76&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7010, 1, 1388, 2, 0, NULL, 0, '2025-03-28 10:12:58', '2025-03-28 10:12:58', '2025-03-28', '', '25-08501-03-26', '', 0.00, 33.68, 7.71, 0.00, 0, 0.00, 3.67, 'Hondarribia 26', 'Donostia-San Sebastián', 'Gipuzkoa', '20005', 'España', 44.42, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(7011, 1, 993, 2, 0, NULL, 0, '2025-03-28 11:29:31', '2025-03-31 09:16:33', '2025-03-31', 'P6589', '25-08514-03-28', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Calle Sorolla 40 1A', 'Rincón de la Victoria', 'Málaga', '29720', 'España', 31.27, 0, '2025-03-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310325-Px8d5GkJIUOrk-088', '3d58b222-d1ae-4d50-ac83-f7e2372b3706', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-Px8d5GkJIUOrk-088&s=KOL2025&nf=P6589&i=31.27&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7012, 1, 1565, 2, 0, NULL, 0, '2025-03-28 16:48:56', '2025-03-31 09:09:01', '2025-03-31', 'P6590', '25-08515-03-28', 'AVISAR ANTES DE IR', 0.00, 31.70, 7.38, 0.00, 0, 0.00, 4.17, 'PLAZA PABLO IGLESIAS 7 2ºF', 'Torrelavega', 'Cantabria', '39300', 'España', 42.53, 0, '2025-03-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310325-PKMQ5gHQNh7na-098', '17fc727c-7252-45e9-9236-3c8729d5ac18', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-PKMQ5gHQNh7na-098&s=KOL2025&nf=P6590&i=42.53&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7013, 1, 1756, 2, 0, NULL, 0, '2025-03-29 05:33:57', '2025-03-31 09:17:23', '2025-03-31', 'P6591', '25-08518-03-29', '', 0.00, 11.20, 3.02, 0.00, 0, 0.00, 3.84, 'San pelaio bide nagusia 52 Bajo 6', 'Bakio', 'Bizkaia', '48130', 'España', 17.39, 0, '2025-03-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-310325-U6ULCLM9D6+g9-101', '53ec021c-7185-483e-9b63-bd8f8669e666', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-U6ULCLM9D6%2Bg9-101&s=KOL2025&nf=P6591&i=17.39&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7014, 1, 1757, 2, 0, NULL, 0, '2025-03-29 16:11:26', '2025-03-31 09:19:48', '2025-03-31', 'P6594', '25-08520-03-29', '', 0.00, 11.20, 7.14, 0.00, 0, 0.00, 27.57, 'Breestraat 1', 'Delft', '', '2611 CB', 'Países Bajos', 41.12, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-310325-WJ7peS+0HO0ei-008', '3e8453a2-145a-4101-a3d2-b68f13b6e249', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-WJ7peS%2B0HO0ei-008&s=KOL2025&nf=P6594&i=41.12&cr=007', '[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
(7015, 1, 327, 2, 0, NULL, 0, '2025-03-30 19:59:04', '2025-03-31 09:20:27', '2025-03-31', 'P6592', '25-08522-03-30', '', 0.00, 104.40, 21.92, 0.00, 0, 0.00, 0.00, 'elizagaina 20 Egillor', 'Ollo', 'Navarra', '31172', 'España', 126.32, 0, '2025-03-30 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-310325-EY0mhGYQLg4Bo-081', '3b816c85-9e34-4d23-97ae-c740f1ea5616', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-EY0mhGYQLg4Bo-081&s=KOL2025&nf=P6592&i=126.32&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7016, 1, 573, 2, 0, NULL, 0, '2025-03-30 21:32:07', '2025-03-31 09:21:49', '2025-03-31', 'P6595', '25-08523-03-30', '', 0.00, 41.00, 9.77, 0.00, 0, 0.00, 6.67, 'Paseo margallo 22', 'Sitges', 'Barcelona', '08870', 'España', 56.28, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-310325-cXxTHx0bvMvbr-063', 'cf5e6658-d5b3-4240-84fb-8ef0839eaf34', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-cXxTHx0bvMvbr-063&s=KOL2025&nf=P6595&i=56.28&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7017, 1, 1758, 2, 0, NULL, 0, '2025-03-31 06:17:32', '2025-03-31 09:22:22', '2025-03-31', 'P6593', '25-08526-03-31', '', 0.00, 11.20, 3.02, 0.00, 0, 0.00, 3.84, 'Aldai Azpi Nº39 - Bajo C', 'Gorliz', 'Bizkaia', '48630', 'España', 17.39, 0, '2025-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310325-bPyObvs0wyLyO-034', '59528230-1e58-41ec-885f-d04489e97c3b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-bPyObvs0wyLyO-034&s=KOL2025&nf=P6593&i=17.39&cr=182', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7018, 1, 166, 1, 0, NULL, 0, '2025-03-31 09:27:44', '2025-03-31 09:29:40', '2025-03-31', 'P6596', '', '', 0.00, 142.08, 29.84, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 171.92, 0, '2025-03-31 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-310325-KHJKDTb7AQCzL-238', 'bed95f2e-08ec-4fa4-b96b-588cfdf75c12', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-KHJKDTb7AQCzL-238&s=KOL2025&nf=P6596&i=171.92&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7019, 1, 1588, 1, 0, NULL, 0, '2025-03-31 09:35:03', '2025-03-31 09:35:03', '2025-03-31', 'P6597', '', '', 0.00, 44.80, 9.84, 0.00, 0, 0.00, 2.50, 'Vitoria 23 primero ', 'Miranda de Ebro', 'Burgos', '09200', 'España', 56.71, 0, '2025-03-31 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-310325-gXTUpHZdwI1b2-013', 'd71cb5c8-ed6e-462c-9cdb-d427da78909f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-gXTUpHZdwI1b2-013&s=KOL2025&nf=P6597&i=56.71&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7020, 1, 7, 1, 0, NULL, 0, '2025-03-31 13:19:16', '2025-03-31 13:19:16', '2025-03-31', 'P6598', '', '', 0.00, 294.70, 61.89, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 356.59, 0, '2025-03-31 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-310325-djrqjRYWhgDm+-051', '7860353b-3031-49ab-84d2-14938312fe2d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310325-djrqjRYWhgDm%2B-051&s=KOL2025&nf=P6598&i=356.59&cr=165', '[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
(7021, 1, 463, 2, 0, NULL, 0, '2025-03-31 13:55:56', '2025-04-01 09:13:28', '2025-04-01', 'P6599', '25-08527-03-31', '', 0.00, 82.00, 17.22, 0.00, 0, 0.00, 0.00, 'C/ Viento 32 1 izqda majadahonda', 'Madrid', 'Madrid', '28220', 'España', 99.22, 0, '2025-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010425-RhB32hOa09eeo-162', '1521cab5-26d7-4d78-945a-f648cf442a98', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-RhB32hOa09eeo-162&s=KOL2025&nf=P6599&i=99.22&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7022, 1, 1759, 2, 0, NULL, 0, '2025-03-31 15:55:22', '2025-04-01 09:14:42', '2025-04-01', 'P6600', '25-08528-03-31', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Paseo san txiki nº4 1B', 'Aranguren', 'Navarra', '31192', 'España', 31.27, 0, '2025-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010425-bPUyzTpZLHqGX-066', 'f602508c-64e0-4e26-9837-ff0d563eabf7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-bPUyzTpZLHqGX-066&s=KOL2025&nf=P6600&i=31.27&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7023, 1, 1760, 2, 0, NULL, 0, '2025-03-31 16:15:45', '2025-04-01 09:15:23', '2025-04-01', 'P6601', '25-08531-03-31', 'LLAMAR ANTES DE ENTREGAR.', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'CALLE EUROPA, Nº 89, 8º 1ª', 'Badalona', 'Barcelona', '08913', 'España', 31.27, 0, '2025-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010425-MBAp+35CdcPnE-039', 'ba997f94-2f4f-427f-a564-b4aeac909d83', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-MBAp%2B35CdcPnE-039&s=KOL2025&nf=P6601&i=31.27&cr=212', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7024, 1, 1761, 2, 0, NULL, 0, '2025-03-31 16:40:39', '2025-04-01 09:16:11', '2025-04-01', 'P6602', '25-08532-03-31', '', 0.00, 22.40, 5.37, 0.00, 0, 0.00, 3.84, 'Puente de Deusto 7, 4º, dpt.3', 'Bilbao', 'Bizkaia', '48014', 'España', 30.94, 0, '2025-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010425-c4CZxSoJWTsI5-153', '52de5dbd-d8af-456e-81bb-1b41e8fde8ff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-c4CZxSoJWTsI5-153&s=KOL2025&nf=P6602&i=30.94&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7025, 1, 1599, 2, 0, NULL, 0, '2025-03-31 16:46:17', '2025-04-01 09:19:10', '2025-04-01', 'P6603', '25-08534-03-31', 'Entrega de tardes, también podría entregar en un punto de recogida cercano si es posible , la vez anterior la enviasteis a la oficina de correos de Tomás Alonso ', 0.00, 61.50, 12.92, 0.00, 0, 0.00, 0.00, 'Teixugueiras 19, portal 1, 8A', 'Vigo', 'Pontevedra', '36212', 'España', 74.42, 0, '2025-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010425-QzgP11lQ2hd/k-071', '63707072-e1f0-4063-a581-d2a6e8a8d8ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-QzgP11lQ2hd%2Fk-071&s=KOL2025&nf=P6603&i=74.42&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7026, 1, 1544, 2, 0, NULL, 0, '2025-03-31 17:10:10', '2025-04-01 09:20:22', '2025-04-01', 'P6604', '25-08535-03-31', '', 0.00, 22.40, 5.37, 0.00, 0, 0.00, 3.84, 'Espoz y mina n11 2b', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 30.94, 0, '2025-03-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010425-f1H7OyX6/63WZ-066', 'c6f22d11-22b3-4325-8a65-ffe4bd49bf45', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-f1H7OyX6%2F63WZ-066&s=KOL2025&nf=P6604&i=30.94&cr=183', '[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
(7027, 1, 337, 2, 0, NULL, 0, '2025-03-31 17:18:49', '2025-04-01 09:22:02', '2025-04-01', 'P6606', '25-08536-03-31', '', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaragoza', 'Zaragoza', '50014', 'España', 213.95, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010425-gmnSs2UEhLI0d-248', 'f0f24c0a-ff6f-4fd5-9520-40d69bc58d19', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-gmnSs2UEhLI0d-248&s=KOL2025&nf=P6606&i=213.95&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7028, 1, 698, 2, 0, NULL, 0, '2025-04-01 05:55:59', '2025-04-01 09:23:53', '2025-04-01', 'P6605', '25-08538-04-01', 'Dejar en jardín (mirando al portal, la puerta de metal de la derecha), se puede lanzar por encima del muro', 0.00, 67.20, 14.11, 0.00, 0, 0.00, 0.00, '(la quadra) Calle eskauriatza 25 Pb-B', 'Güeñes', 'Bizkaia', '48820', 'España', 81.31, 0, '2025-04-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010425-cauVa0JG0qV2Y-135', '549dc05c-599e-4083-8e93-3f8678a10210', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-cauVa0JG0qV2Y-135&s=KOL2025&nf=P6605&i=81.31&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7029, 1, 152, 1, 0, NULL, 0, '2025-04-01 10:27:53', '2025-04-01 11:35:26', '2025-04-01', 'P6608', '', '', 0.00, 62.09, 13.04, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 75.13, 0, '2025-04-01 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010425-V70XxDX0VEobr-178', 'd2ed2cd6-efff-4b82-be1f-7be88f85d130', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-V70XxDX0VEobr-178&s=KOL2025&nf=P6608&i=75.13&cr=154', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7030, 1, 106, 1, 0, NULL, 0, '2025-04-01 10:40:08', '2025-04-01 10:40:08', '2025-04-01', 'P6607', '', '', 0.00, 92.62, 19.45, 0.00, 0, 0.00, 0.00, 'Hipódromo 10 bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'ESPAÑA', 112.07, 0, '2025-04-01 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010425-IkqDoyFQFKD9w-140', '0d998170-72e7-43fd-9cc2-0232e06c5b45', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-IkqDoyFQFKD9w-140&s=KOL2025&nf=P6607&i=112.07&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0),
(7031, 1, 106, 1, 1, 'cambio de productos', 7030, '2025-04-01 11:54:17', '2025-04-01 11:54:17', '2025-04-01', 'R110', 'P6607 RECT.', '', 0.00, 92.62, 19.45, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 112.07, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-010425-Z2HkZNC8nGvkE-137', 'ba71e5f1-ef0e-4012-95e7-1388ba0e3760', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-Z2HkZNC8nGvkE-137&s=KOL2025&nf=R110&i=-112.07&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(7032, 1, 106, 1, 0, NULL, 0, '2025-04-01 11:56:18', '2025-04-01 11:57:21', '2025-04-01', 'P6609', '', '', 0.00, 92.62, 19.45, 0.00, 0, 0.00, 0.00, 'Hipódromo 10 bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'ESPAÑA', 112.07, 0, '2025-04-01 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010425-f/nOQYEjz6r8+-030', 'b58dcec3-e0f1-4fd0-8d84-99fa4864cf88', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-f%2FnOQYEjz6r8%2B-030&s=KOL2025&nf=P6609&i=112.07&cr=005', '[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
(7033, 1, 28, 2, 0, NULL, 0, '2025-04-01 10:10:44', '2025-04-01 12:39:56', '2025-04-01', 'P6611', '25-08539-04-01', '', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 142.63, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010425-Cv4ohOWbqy9Ta-161', '0f4b6f43-c688-485f-88a2-bdd0fe856637', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-Cv4ohOWbqy9Ta-161&s=KOL2025&nf=P6611&i=142.63&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7034, 1, 25, 2, 0, NULL, 0, '2025-04-01 10:15:22', '2025-04-01 12:40:39', '2025-04-01', 'P6610', '25-08540-04-01', '', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'araba kalea 1 bajo 20240 ordizia', 'Ordizia', 'Gipuzkoa', '20240', 'España', 142.63, 0, '2025-04-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010425-X0MxL2056Y7Kd-132', '73ea16cd-2244-4a33-912b-63ce99ddfede', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010425-X0MxL2056Y7Kd-132&s=KOL2025&nf=P6610&i=142.63&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7035, 1, 1158, 2, 0, NULL, 0, '2025-04-01 11:45:52', '2025-04-02 09:02:33', '2025-04-02', 'P6616', '25-08541-04-01', 'Peluquería Marai', 0.00, 92.62, 19.45, 0.00, 0, 0.00, 0.00, 'Republica Argentina  3, bajo2', 'Irun', 'Gipuzkoa', '20302', 'España', 112.07, 0, '2025-04-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020425-OnuoB4czpwnqM-180', 'c5449da4-694a-45b8-b7d1-072a9d1ea76a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020425-OnuoB4czpwnqM-180&s=KOL2025&nf=P6616&i=112.07&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7036, 1, 1762, 2, 0, NULL, 0, '2025-04-01 14:29:17', '2025-04-02 09:03:54', '2025-04-02', 'P6612', '25-08542-04-01', 'Asesoría Jurídica Comisiones Obreras (att. Arantza Aza)', 0.00, 11.20, 2.99, 0.00, 0, 0.00, 3.67, 'Carlos I, n. 5, bajo', 'Donostia-San Sebastián', 'Gipuzkoa', '20011', 'España', 17.22, 0, '2025-04-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020425-CEqUL2WnGKdkv-183', '80dea980-1258-4d59-8e8f-8f5146b3f264', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020425-CEqUL2WnGKdkv-183&s=KOL2025&nf=P6612&i=17.22&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7037, 1, 1183, 2, 0, NULL, 0, '2025-04-01 14:37:00', '2025-04-02 09:04:40', '2025-04-02', 'P6613', '25-08543-04-01', 'Panaderia Herminia ', 0.00, 31.70, 7.38, 0.00, 0, 0.00, 4.17, 'Silverio Moreda Alvariño 1', 'Laracha (A)', 'A Coruña', '15145', 'España', 42.53, 0, '2025-04-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020425-DERn4d4GNDPRR-022', 'fb47a181-1e5f-43eb-bc07-60b786377d27', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020425-DERn4d4GNDPRR-022&s=KOL2025&nf=P6613&i=42.53&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7038, 1, 979, 2, 0, NULL, 0, '2025-04-01 16:10:48', '2025-04-02 09:05:15', '2025-04-02', 'P6614', '25-08544-04-01', 'Lunes cerrado \r\nDe martes a viernes de 11 a 20', 0.00, 235.76, 49.51, 0.00, 0, 0.00, 0.00, 'calle palma 58 local 1', 'Madrid', 'Madrid', '28015', 'España', 285.27, 0, '2025-04-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020425-fpDCM8c2sseTh-137', '5d0d2130-b143-4aac-bfd9-a1c2292f00c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020425-fpDCM8c2sseTh-137&s=KOL2025&nf=P6614&i=285.27&cr=199', '[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
(7039, 1, 522, 2, 0, NULL, 0, '2025-04-01 18:36:52', '2025-04-02 09:05:56', '2025-04-02', 'P6615', '25-08545-04-01', '', 0.00, 235.76, 49.51, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 285.27, 0, '2025-04-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020425-V71T2JZgB0a03-130', 'a37b6f0c-aa1b-4cd6-90fb-79734d450c23', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020425-V71T2JZgB0a03-130&s=KOL2025&nf=P6615&i=285.27&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7040, 1, 110, 2, 0, NULL, 0, '2025-04-02 08:57:25', '2025-04-02 11:13:43', '2025-04-02', 'P6618', '25-08546-04-02', 'HORARIO MARTES A VIERNES 10H A 18H', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 213.95, 0, '2025-04-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020425-E4xkM9YaszaOM-194', 'bdbcb054-e11b-4097-92f7-1c934dc0b5a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020425-E4xkM9YaszaOM-194&s=KOL2025&nf=P6618&i=213.95&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7041, 1, 43, 2, 0, NULL, 0, '2025-04-02 09:01:50', '2025-04-02 11:14:07', '2025-04-02', 'P6617', '25-08547-04-02', '', 0.00, 117.88, 24.75, 0.00, 0, 0.00, 0.00, 'Nagusia 5', 'Tolosa', 'Gipuzkoa', '20400', 'España', 142.63, 0, '2025-04-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020425-Acn93YsehmLXf-087', '427bbbc8-48f4-4523-a4bd-0d056c830758', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020425-Acn93YsehmLXf-087&s=KOL2025&nf=P6617&i=142.63&cr=054', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7042, 1, 492, 2, 0, NULL, 0, '2025-04-02 09:40:19', '2025-04-02 11:47:55', '2025-04-02', 'P6620', '25-08548-04-02', 'Por favor, avísenme al tfno de que me van a entregar el paquete. Gracias.', 0.00, 33.60, 7.78, 0.00, 0, 0.00, 4.17, 'Calle dr Laureano Casquero 25 H7', 'Vélez-Málaga', 'Málaga', '29740', 'España', 44.83, 0, '2025-04-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020425-QXiSVEJMCVXsq-027', 'dd951a2b-c16c-46ad-9c4c-700fdf655945', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020425-QXiSVEJMCVXsq-027&s=KOL2025&nf=P6620&i=44.83&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7043, 1, 173, 1, 0, NULL, 0, '2025-04-02 11:41:57', '2025-04-02 11:44:34', '2025-04-02', 'P6619', '', '', 0.00, 88.41, 19.00, 0.00, 0, 0.00, 2.50, 'Latsunbe Berri nº1 bajo', 'Hernani', 'Gipuzkoa', '20120', 'España', 109.48, 0, '2025-04-02 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-020425-ehGOJaGGluLFS-177', 'bb6f09a4-3958-4702-98e6-a9729e5b9e6a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020425-ehGOJaGGluLFS-177&s=KOL2025&nf=P6619&i=109.48&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(7044, 1, 173, 2, 0, NULL, 0, '2025-04-02 10:20:12', '2025-04-02 10:20:12', '2025-04-02', '', '25-08549-04-02', NULL, 0.00, 156.80, 32.93, 0.00, 0, 0.00, 0.00, 'Latxunbe Berri nº1 bajo 3', 'Hernani', 'Gipuzkoa', '20120', 'España', 189.73, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(7045, 1, 98, 2, 0, NULL, 0, '2025-04-02 17:05:24', '2025-04-03 07:40:14', '2025-04-03', 'P6623', '25-08550-04-02', '', 0.00, 75.78, 15.91, 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', 91.69, 0, '2025-04-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030425-Y7B003QAOXo4A-084', '60811b70-89cc-4b72-9a5e-a33b8a89db61', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030425-Y7B003QAOXo4A-084&s=KOL2025&nf=P6623&i=91.69&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
