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
(6795, 1, 174, 2, 0, NULL, 0, '2025-02-27 20:47:33', '2025-02-28 09:16:30', '2025-02-28', 'P6386', '25-08284-02-27', 'Hola , si me las podéis enviar lo antes posible , porque me he descuidado un poco y de algún tono casi no tengo.\r\nMuchas gracias Oihana', 0.00, 265.23, 55.70, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 320.93, 0, '2025-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280225-gPMxX1sbuZNe8-205', 'e75c5966-feea-4177-8088-93b7b357e9f1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-gPMxX1sbuZNe8-205&s=KOL2025&nf=P6386&i=320.93&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6796, 1, 248, 2, 0, NULL, 0, '2025-02-28 06:56:58', '2025-02-28 09:17:04', '2025-02-28', 'P6387', '25-08285-02-28', '', 0.00, 67.36, 14.58, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 84.01, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-280225-akWw4KWIV9YWq-146', '75f1a5b2-cb11-47cd-81e3-c79709c47a50', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-akWw4KWIV9YWq-146&s=KOL2025&nf=P6387&i=84.01&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6797, 1, 152, 1, 0, NULL, 0, '2025-02-28 09:57:58', '2025-02-28 09:57:58', '2025-02-28', 'P6388', '', '', 0.00, 155.35, 32.62, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 187.97, 0, '2025-02-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280225-K38XdjO6Z+rrU-197', '9ee4980e-6af4-4acd-8124-fd5bc07b3341', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-K38XdjO6Z%2BrrU-197&s=KOL2025&nf=P6388&i=187.97&cr=150', '[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
(6798, 1, 1698, 2, 0, NULL, 0, '2025-02-28 09:44:58', '2025-02-28 10:59:14', '2025-02-28', 'P6389', '25-08286-02-28', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'ELBARREN KALEA 37, 2B', 'Leitza', 'Navarra', '31880', 'España', 17.72, 0, '2025-02-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280225-CupWb0wAUzdM7-072', 'c0b519c0-38f4-4aeb-a401-d2f603088ce4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-CupWb0wAUzdM7-072&s=KOL2025&nf=P6389&i=17.72&cr=050', '[BLOB]', 0, 'PKANHY071000497E', '2025-02-28 10:59:17', '[BLOB]', 2, '', '2025-02-28', 'S0235', 20, 5, 10, 100, 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
(6799, 1, 292, 2, 0, NULL, 0, '2025-02-28 14:19:53', '2025-03-03 08:31:46', '2025-03-03', 'P6390', '25-08287-02-28', 'Confirmar horario al 655848478', 0.00, 52.20, 10.96, 0.00, 0, 0.00, 0.00, 'Passeig de la terracuita 1-5 Esc. A piso 4 puerta 1, Riera de les prats 7', 'Gavà', 'Barcelona', '08850', 'España', 63.16, 0, '2025-02-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030325-HGwnvT/3dAGHG-231', 'da3a9ba1-5ce3-4fae-bc6e-25e8bc7b4126', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-HGwnvT%2F3dAGHG-231&s=KOL2025&nf=P6390&i=63.16&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6800, 1, 1699, 2, 0, NULL, 0, '2025-02-28 15:25:38', '2025-03-03 08:32:33', '2025-03-03', 'P6391', '25-08288-02-28', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'santiago rusiñol 5-9. bajos 2, bajos 2', 'Pineda de Mar', 'Barcelona', '08397', 'España', 17.72, 0, '2025-02-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030325-GZ5djEZZLWZ/P-207', '3508681f-1e59-409a-8d2b-f34aa0161ad6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-GZ5djEZZLWZ%2FP-207&s=KOL2025&nf=P6391&i=17.72&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6801, 1, 1093, 2, 0, NULL, 0, '2025-02-28 22:06:38', '2025-03-03 08:33:16', '2025-03-03', 'P6392', '25-08289-02-28', '', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'AGUSTINA DE ARAGÓN NUMERO 39 ', 'Valdemoro', 'Madrid', '28342', 'España', 28.98, 0, '2025-02-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030325-P+LHeHKEyWxRN-249', '58181567-8f72-413b-a2a0-bdbbc7538f91', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-P%2BLHeHKEyWxRN-249&s=KOL2025&nf=P6392&i=28.98&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6802, 1, 167, 2, 0, NULL, 0, '2025-03-01 08:33:52', '2025-03-03 08:34:09', '2025-03-03', 'P6401', '25-08290-03-01', '', 0.00, 218.92, 45.97, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 264.89, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030325-BY42iN7NdnW/A-245', '7da4c526-c3ef-4586-8429-e5b4d98dd9f8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-BY42iN7NdnW%2FA-245&s=KOL2025&nf=P6401&i=264.89&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6803, 1, 145, 2, 0, NULL, 0, '2025-03-01 08:58:55', '2025-03-03 08:42:01', '2025-03-03', 'P6402', '25-08291-03-01', '', 0.00, 176.82, 37.57, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 216.45, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-030325-gBj48ZRQnd2/W-109', 'ce8ba52e-2695-4736-828b-837d18bfee2c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-gBj48ZRQnd2%2FW-109&s=KOL2025&nf=P6402&i=216.45&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6804, 1, 1700, 2, 0, NULL, 0, '2025-03-01 09:39:09', '2025-03-03 08:43:43', '2025-03-03', 'P6393', '25-08292-03-01', '', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'Calle Coaña 10, 8ºA', 'Oviedo', 'Asturias', '33012', 'España', 28.98, 0, '2025-03-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030325-Ny0w4EXu6qOG5-214', 'e8fc9024-e031-4ec8-b2da-178f921c6894', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-Ny0w4EXu6qOG5-214&s=KOL2025&nf=P6393&i=28.98&cr=140', '[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
(6805, 1, 1151, 2, 0, NULL, 0, '2025-03-01 10:38:02', '2025-03-03 08:45:24', '2025-03-03', 'P6394', '25-08297-03-01', '', 0.00, 82.00, 17.22, 0.00, 0, 0.00, 0.00, 'C/ Pedro Martin N 2, 2 E', 'Don Benito', 'Badajoz', '06400', 'España', 99.22, 0, '2025-03-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030325-M9qVwIPIuqvde-210', '96af0538-4545-4ab2-a5df-f3ff2996153f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-M9qVwIPIuqvde-210&s=KOL2025&nf=P6394&i=99.22&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6806, 1, 1701, 2, 0, NULL, 0, '2025-03-01 10:38:51', '2025-03-03 08:45:59', '2025-03-03', 'P6395', '25-08296-03-01', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'C/Pilones, 15', 'Hornachos', 'Badajoz', '06228', 'España', 17.72, 0, '2025-03-01 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030325-L7B3srxZ0PphV-139', 'd176ad89-f95f-4ecd-bf4f-12706d0ebd74', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-L7B3srxZ0PphV-139&s=KOL2025&nf=P6395&i=17.72&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6807, 1, 1702, 2, 0, NULL, 0, '2025-03-01 18:52:50', '2025-03-03 08:47:08', '2025-03-03', 'P6396', '25-08299-03-01', '', 0.00, 22.40, 5.34, 0.00, 0, 0.00, 3.67, 'Iturrizar 13 6A', 'Aretxabaleta', 'Gipuzkoa', '20550', 'España', 30.77, 0, '2025-03-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030325-JE+bCDSfmMGaH-038', '88a475ce-def2-424f-9abc-d8eab83801d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-JE%2BbCDSfmMGaH-038&s=KOL2025&nf=P6396&i=30.77&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6808, 1, 1703, 2, 0, NULL, 0, '2025-03-01 22:26:42', '2025-03-03 08:48:41', '2025-03-03', 'P6397', '25-08300-03-01', '', 0.00, 20.50, 4.94, 0.00, 0, 0.00, 3.67, 'Travesía Olaondo 3, 2A', 'Legazpi', 'Gipuzkoa', '20230', 'España', 28.48, 0, '2025-03-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030325-gKD4fXkXX10uF-141', '98def942-558b-47bf-bbf2-93b120ae80f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-gKD4fXkXX10uF-141&s=KOL2025&nf=P6397&i=28.48&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6809, 1, 1704, 2, 0, NULL, 0, '2025-03-02 08:44:26', '2025-03-03 08:49:23', '2025-03-03', 'P6398', '25-08302-03-02', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'Roma Piera i Arcal, 10, 4B', 'Premià de Mar', 'Barcelona', '08330', 'España', 17.72, 0, '2025-03-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030325-HvwKtjGuAPowZ-211', '16a52994-a218-4351-b775-30e034b8eacd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-HvwKtjGuAPowZ-211&s=KOL2025&nf=P6398&i=17.72&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6810, 1, 793, 2, 0, NULL, 0, '2025-03-02 08:45:00', '2025-03-03 08:50:19', '2025-03-03', 'P6399', '25-08303-03-02', '', 0.00, 61.50, 12.92, 0.00, 0, 0.00, 0.00, 'C/ Igualdad, 54', 'Alcorcón', 'Madrid', '28922', 'España', 74.42, 0, '2025-03-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030325-XgG5ILz5zo+ZF-212', '45f598e4-1374-4883-a2e1-e8ec12972858', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-XgG5ILz5zo%2BZF-212&s=KOL2025&nf=P6399&i=74.42&cr=174', '[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
(6811, 1, 1074, 2, 0, NULL, 0, '2025-03-02 16:11:18', '2025-03-03 08:51:02', '2025-03-03', 'P6400', '25-08304-03-02', 'No funciona el interfono. Porfavor, llamar por telefono O dejar en la cafeteria Syngland de la calle santa Marta, en la esquina. Gràcies ', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Plaça Dels Vents 13, Esc 2, 2-1', 'Calonge', 'Girona', '17252', 'España', 31.27, 0, '2025-03-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030325-ElGi8hVnEM9Kl-160', '29993dbf-c578-48b2-afe7-d2d6a0df7be3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-ElGi8hVnEM9Kl-160&s=KOL2025&nf=P6400&i=31.27&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6812, 1, 113, 1, 0, NULL, 0, '2025-03-03 10:46:02', '2025-03-03 10:51:01', '2025-03-03', 'P6403', '2025-03-03', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'AVENIDA DE LOS LABRADORES 5 LOCAL3', 'Tres Cantos', 'Madrid', '28760', 'España', 106.98, 0, '2025-03-03 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-030325-U6DNItgw+W9zR-180', 'd1ce0bb6-e0d1-445c-99dd-dca312905dc2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-U6DNItgw%2BW9zR-180&s=KOL2025&nf=P6403&i=106.98&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '2025-03-03', 'S0133', 15, 5, 10, 1200, 0, '', 1, 1),
(6813, 1, 1326, 2, 0, NULL, 0, '2025-03-03 09:55:09', '2025-03-03 10:56:22', '2025-03-03', 'P6404', '25-08307-03-03', '', 0.00, 20.50, 4.94, 0.00, 0, 0.00, 3.67, 'IRIARTE MARGOLARIA 17/5A', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 28.48, 0, '2025-03-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030325-FLlP3fjPkABse-070', '56978370-c637-4787-b316-0480421beb63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-FLlP3fjPkABse-070&s=KOL2025&nf=P6404&i=28.48&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6814, 1, 1404, 2, 0, NULL, 0, '2025-03-03 10:09:32', '2025-03-03 11:20:03', '2025-03-03', 'P6405', '25-08308-03-03', '', 0.00, 56.00, 12.92, 0.00, 0, 0.00, 6.67, 'Avenida de Marín Nº 5   3º G', 'Pontevedra', 'Pontevedra', '36003', 'España', 74.43, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-030325-GhEt71ZZkXUZk-005', '2cdc6d4f-4edf-47ff-8757-ba197cbc3a97', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-GhEt71ZZkXUZk-005&s=KOL2025&nf=P6405&i=74.43&cr=252', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6815, 1, 1404, 2, 0, NULL, 0, '2025-03-03 10:13:53', '2025-03-03 10:13:53', '2025-03-03', '', '25-08309-03-03', NULL, 0.00, 11.20, 3.51, 0.00, 0, 0.00, 6.67, 'Avenida de Marín Nº 5   3º G', 'Pontevedra', 'Pontevedra', '36003', 'España', 20.22, 0, '0000-00-00 00:00:00', '', '', 1, 4, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6816, 1, 166, 1, 0, NULL, 0, '2025-03-03 11:28:01', '2025-03-03 11:30:01', '2025-03-03', 'P6406', '2025-03-03', '', 0.00, 168.72, 35.43, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 204.15, 0, '2025-03-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030325-Ut5DVCZlGWq8P-150', '6cff5da5-cd82-4998-8f13-c9694006c188', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030325-Ut5DVCZlGWq8P-150&s=KOL2025&nf=P6406&i=204.15&cr=070', '[BLOB]', 0, 'PKANHY071000513B', '2025-03-03 11:30:05', '[BLOB]', 2, '', '2025-03-03', 'S0235', 30, 20, 35, 3800, 0, '', 1, 1);
