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
(6710, 1, 1673, 2, 0, NULL, 0, '2025-02-13 07:56:59', '2025-02-13 07:56:59', '2025-02-13', '', '25-08191-02-13', NULL, 0.00, 168.00, 35.28, 0.00, 0, 0.00, 0.00, 'Calle Serrano 164 Local peluquería ', 'Madrid', 'Madrid', '28002', 'España', 203.28, 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),
(6711, 1, 40, 1, 0, NULL, 0, '2025-02-13 09:02:59', '2025-02-13 09:02:59', '2025-02-13', 'P6304', '', '', 0.00, 88.41, 19.00, 0.00, 0, 0.00, 2.50, 'Plaza valencia 7 intxaurrondo ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 109.48, 0, '2025-02-13 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130225-aZkhqwIfZDkn3-082', '4f57118b-a377-4b03-8a5c-d6472dae7128', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-aZkhqwIfZDkn3-082&s=KOL2025&nf=P6304&i=109.48&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6712, 1, 1674, 2, 0, NULL, 0, '2025-02-13 08:54:19', '2025-02-13 10:04:09', '2025-02-13', 'P6305', '25-08192-02-13', 'Urb Malladeta', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'C/Eslinga 2', 'Pobla de Vallbona (l', 'Valencia', '46185', 'España', 28.98, 0, '2025-02-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130225-ev2yJfb5CxUNw-248', 'ea58d1cb-e34c-4207-b1a2-8545c250fc4d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-ev2yJfb5CxUNw-248&s=KOL2025&nf=P6305&i=28.98&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6713, 1, 1390, 2, 0, NULL, 0, '2025-02-13 08:55:15', '2025-02-13 10:05:02', '2025-02-13', 'P6306', '25-08193-02-13', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'Maquinilla 13 portal C piso 8 puerta 2', 'Madrid', 'Madrid', '28031', 'España', 17.72, 0, '2025-02-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130225-e2LJoO3VgGGfp-218', '9a3f1a98-6c53-49d6-92d3-05aac88be680', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-e2LJoO3VgGGfp-218&s=KOL2025&nf=P6306&i=17.72&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6714, 1, 754, 2, 0, NULL, 0, '2025-02-13 10:00:05', '2025-02-13 11:15:27', '2025-02-13', 'P6307', '25-08194-02-13', '6+1 GRATIS\r\nREGALO COLOR NEUTRAL\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-02-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130225-DidqelbI3uJvl-028', 'f5ec1883-7d4e-4557-90c7-1e70a05cc48b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-DidqelbI3uJvl-028&s=KOL2025&nf=P6307&i=63.76&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6715, 1, 1673, 1, 0, NULL, 0, '2025-02-13 11:20:53', '2025-02-13 11:26:11', '2025-02-13', 'P6308', '2025-02-13', '', 0.00, 294.70, 61.89, 0.00, 0, 0.00, 0.00, 'Calle Serrano 164 Local peluquería ', 'Madrid', 'Madrid', '28002', 'España', 356.59, 0, '2025-02-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130225-Qvyw4dLsELANh-223', '8ce0282e-189d-4e15-acb7-6d8535f91223', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-Qvyw4dLsELANh-223&s=KOL2025&nf=P6308&i=356.59&cr=210', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6716, 1, 1675, 2, 0, NULL, 0, '2025-02-13 10:35:24', '2025-02-13 11:52:17', '2025-02-13', 'P6309', '25-08196-02-13', 'Si estoy ausente en mi domicilio por favor dejar el envío en el buzón de citibox de la urbanización ', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'AVDA. PABLO IGLESIAS 80 BL 3 TERCERO C', 'Rivas-Vaciamadrid', 'Madrid', '28521', 'España', 28.98, 0, '2025-02-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130225-KgAdtMTRAFOvO-062', '4fa148b4-e8cf-49de-9833-0b619e67694e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-KgAdtMTRAFOvO-062&s=KOL2025&nf=P6309&i=28.98&cr=162', '[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
(6717, 1, 1676, 2, 0, NULL, 0, '2025-02-13 13:07:29', '2025-02-17 09:49:37', '2025-02-13', 'P6310', '25-08200-02-13', 'Si es posible depositen el paquete en un punto de recogida cercano (en Gros) e indíquenme dónde recogerlo. Gracias!', 0.00, 11.20, 2.99, 0.00, 0, 0.00, 3.67, 'Calle José María Soroa 13 - 5 izq', 'Donostia-San Sebastián', 'Gipuzkoa', '20013', 'España', 17.22, 0, '2025-02-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130225-TmkDwnUKiTEfb-075', '6de030e7-5e0a-4ee6-bb92-e1f6d50e47bd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-TmkDwnUKiTEfb-075&s=KOL2025&nf=P6310&i=17.22&cr=149', '[BLOB]', 0, 'PRANHY071000007Q', '2025-02-17 09:49:42', '[BLOB]', 2, '', '2025-02-14', 'S0133', 15, 20, 5, 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
(6718, 1, 1677, 2, 0, NULL, 0, '2025-02-13 13:16:11', '2025-02-13 17:16:47', '2025-02-13', 'P6311', '25-08201-02-13', 'Si no estoy en casa, dejadlo en el felpudo por favor :)', 0.00, 11.20, 2.99, 0.00, 0, 0.00, 3.67, 'Loiolako Erriberako Pasealekua 12, 2A', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 17.22, 0, '2025-02-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130225-S/tb2D2SM0cK/-027', 'c11b3b36-3c6e-44e1-955d-930105c66628', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130225-S%2Ftb2D2SM0cK%2F-027&s=KOL2025&nf=P6311&i=17.22&cr=183', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6719, 1, 1316, 2, 0, NULL, 0, '2025-02-14 08:56:09', '2025-02-14 10:07:22', '2025-02-14', 'P6312', '25-08202-02-14', 'cerrado los lunes', 0.00, 147.35, 30.94, 0.00, 0, 0.00, 0.00, 'avenida de Santiago 18', 'Pino (O)', 'A Coruña', '15821', 'España', 178.29, 0, '2025-02-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140225-cL15Wss2SQbqF-244', '4b52ef7f-05e9-434c-bd8e-5ea9dca63d97', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140225-cL15Wss2SQbqF-244&s=KOL2025&nf=P6312&i=178.29&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6720, 1, 350, 2, 0, NULL, 0, '2025-02-14 14:39:18', '2025-02-17 09:16:39', '2025-02-17', 'P6313', '25-08203-02-14', 'Peluquería Begoña Iturrioz', 0.00, 147.35, 30.94, 0.00, 0, 0.00, 0.00, 'Calle Balleneros 19 Bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 178.29, 0, '2025-02-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170225-A5pzz8nvERV+2-188', 'cba9fa04-c61c-4790-81f4-1c9168607476', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-A5pzz8nvERV%2B2-188&s=KOL2025&nf=P6313&i=178.29&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6721, 1, 4, 2, 0, NULL, 0, '2025-02-14 18:44:05', '2025-02-17 09:17:24', '2025-02-17', 'P6314', '25-08204-02-14', '', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 142.63, 0, '2025-02-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170225-a3FS2ORBiy8u5-034', '92c44ee0-31cf-49fc-8cd0-47359bca690c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-a3FS2ORBiy8u5-034&s=KOL2025&nf=P6314&i=142.63&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6722, 1, 520, 2, 0, NULL, 0, '2025-02-15 08:40:50', '2025-02-17 09:17:56', '2025-02-17', 'P6315', '25-08205-02-15', '', 0.00, 58.94, 12.38, 0.00, 0, 0.00, 0.00, 'Calle Andreszar, 34, ZAR Peluqueria', 'Villava/Atarrabia', 'Navarra', '31610', 'España', 71.32, 0, '2025-02-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170225-N8RZU2GfHBgv/-180', '2623ad33-2ed3-4332-9fd4-827f0e6be4c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-N8RZU2GfHBgv%2F-180&s=KOL2025&nf=P6315&i=71.31&cr=119', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6723, 1, 80, 2, 0, NULL, 0, '2025-02-15 08:44:36', '2025-02-17 09:19:13', '2025-02-17', 'P6316', '25-08206-02-15', '', 0.00, 677.81, 142.34, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 820.15, 0, '2025-02-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170225-QH0rXtHFtfG/u-021', '1ac40645-ac99-4ec1-8957-9640d8ca7e24', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-QH0rXtHFtfG%2Fu-021&s=KOL2025&nf=P6316&i=820.15&cr=084', '[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
(6724, 1, 754, 2, 0, NULL, 0, '2025-02-15 17:30:22', '2025-02-17 09:20:48', '2025-02-17', 'P6317', '25-08207-02-15', '6+1 GRATIS\r\nREGALO TRATAMIENTO NEUTRAL\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-02-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170225-bcsfSBMXvawpD-156', '07106164-fcc0-4b9b-9893-572cfb538dc7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-bcsfSBMXvawpD-156&s=KOL2025&nf=P6317&i=63.76&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6725, 1, 289, 2, 0, NULL, 0, '2025-02-15 20:13:40', '2025-02-17 09:21:31', '2025-02-17', 'P6318', '25-08208-02-15', 'Avisar dos horas antes de entregar. Gracias', 0.00, 44.80, 10.13, 0.00, 0, 0.00, 4.17, 'Ramón y Cajal, 28, ático dcha.', 'Biescas', 'Huesca', '22630', 'España', 58.38, 0, '2025-02-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170225-fCArR/WhavST7-242', '9dc33940-7fce-47b4-81b8-e40a7d6f0388', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-fCArR%2FWhavST7-242&s=KOL2025&nf=P6318&i=58.38&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6726, 1, 1678, 2, 0, NULL, 0, '2025-02-16 08:45:58', '2025-02-17 09:22:15', '2025-02-17', 'P6319', '25-08209-02-16', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'Calle veneranda manzano , n° 4 2°C', 'Gijón', 'Asturias', '33210', 'España', 17.72, 0, '2025-02-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170225-Haf4nUd86LQFF-127', 'c5861cec-bd61-41db-98d9-bf24919d1cac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-Haf4nUd86LQFF-127&s=KOL2025&nf=P6319&i=17.72&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6727, 1, 1679, 2, 0, NULL, 0, '2025-02-17 08:44:25', '2025-02-17 10:01:01', '2025-02-17', 'P6320', '25-08210-02-17', 'Llamar antes de entregar ', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Valdehondillo 3 -64 Urbanización caraquiz ', 'Uceda', 'Guadalajara', '19188', 'España', 31.27, 0, '2025-02-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170225-DU//ZOjZjHhT0-148', '134c0469-9296-4522-a296-4ef7f02957c5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-DU%2F%2FZOjZjHhT0-148&s=KOL2025&nf=P6320&i=31.27&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6728, 1, 241, 2, 0, NULL, 0, '2025-02-17 09:30:53', '2025-02-17 11:02:40', '2025-02-17', 'P6321', '25-08211-02-17', '', 0.00, 193.56, 40.64, 0.00, 1, 10.07, 0.00, 'morales hidalgo,4 tienda arume nature', 'Ponteareas', 'Pontevedra', '36860', 'España', 244.28, 0, '2025-02-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170225-B3Wo2OE72gw9G-032', '2f7077d2-d02a-4dff-9ded-10adcac7147b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-B3Wo2OE72gw9G-032&s=KOL2025&nf=P6321&i=244.28&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6729, 1, 1680, 2, 0, NULL, 0, '2025-02-17 10:37:43', '2025-02-17 12:16:08', '2025-02-17', 'P6322', '25-08213-02-17', 'Entregar en peluquería Nadia Guijarro. Horario de martes a viernes de 9.30 a 18.30 y sábados de 9 a 14', 0.00, 442.05, 92.84, 0.00, 0, 0.00, 0.00, 'Calle Benlliure, 35 Bajo B 1', 'San Vicente del Raspeig/Sant Vicent del Raspeig', 'Alicante', '03690', 'España', 534.88, 0, '2025-02-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170225-SJDPvCQ0KDvfJ-058', '39dd769f-c693-4516-88e9-1eef8ee89d36', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-SJDPvCQ0KDvfJ-058&s=KOL2025&nf=P6322&i=534.88&cr=237', '[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
(6730, 1, 1681, 1, 0, NULL, 0, '2025-02-17 12:22:21', '2025-02-17 12:24:05', '2025-02-17', 'P6323', '', '', 0.00, 134.68, 28.28, 0.00, 0, 0.00, 0.00, ' Ihurrita bidea 14,  ', 'Oiartzun ', 'Guipúzcoa', '20180', 'España', 162.96, 0, '2025-02-17 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170225-KcwJipMWj4tiI-044', 'f0454989-9d95-46f8-9a68-e459774ea55e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170225-KcwJipMWj4tiI-044&s=KOL2025&nf=P6323&i=162.96&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6731, 1, 1050, 2, 0, NULL, 0, '2025-02-17 12:16:13', '2025-02-18 08:45:24', '2025-02-18', 'P6328', '25-08215-02-17', '', 0.00, 46.31, 10.16, 0.00, 1, 2.52, 2.50, 'Carlos Caamaño,3, Peluquería ', 'Madrid', 'Madrid', '28016', 'España', 61.06, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-180225-gCApGUuRh3600-066', 'df706a3b-d839-4c8c-a66b-98cfc8e05288', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180225-gCApGUuRh3600-066&s=KOL2025&nf=P6328&i=61.06&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6732, 1, 252, 2, 0, NULL, 0, '2025-02-17 12:45:18', '2025-02-18 08:46:43', '2025-02-18', 'P6324', '25-08216-02-17', '', 0.00, 56.00, 11.76, 0.00, 0, 0.00, 0.00, 'C/ Ategorri Txakolindegi, N°4 BJA', 'Bilbao', 'Bizkaia', '48004', 'España', 67.76, 0, '2025-02-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180225-CKlEcitVC1vCx-130', '187abdb1-c907-40f7-8ba7-b9dd91058ac2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180225-CKlEcitVC1vCx-130&s=KOL2025&nf=P6324&i=67.76&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6733, 1, 88, 2, 0, NULL, 0, '2025-02-17 14:17:48', '2025-02-18 08:47:36', '2025-02-18', 'P6325', '25-08217-02-17', '', 0.00, 206.29, 43.32, 0.00, 0, 0.00, 0.00, 'Turina 2bj  peluqueria ecologica valderros ', 'Valladolid', 'Valladolid', '47006', 'España', 249.61, 0, '2025-02-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180225-cgu92U73FyYgC-034', '6dc3d74a-a546-49b3-8f71-5bf54b8cabeb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180225-cgu92U73FyYgC-034&s=KOL2025&nf=P6325&i=249.61&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6734, 1, 1682, 2, 0, NULL, 0, '2025-02-17 14:29:36', '2025-02-18 08:48:27', '2025-02-18', 'P6326', '25-08218-02-17', '', 0.00, 20.50, 4.97, 0.00, 0, 0.00, 3.84, 'Algortako Etorbidea, 53-2°izda', 'Getxo', 'Bizkaia', '48991', 'España', 28.65, 0, '2025-02-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180225-Kh9ImpsnCOMhm-010', 'c2695c3d-916b-4057-8ad4-cf1cd761c316', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180225-Kh9ImpsnCOMhm-010&s=KOL2025&nf=P6326&i=28.65&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6735, 1, 1683, 2, 0, NULL, 0, '2025-02-17 16:43:38', '2025-02-18 08:49:09', '2025-02-18', 'P6327', '25-08220-02-17', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Calle Libertad 18', 'Álamo (El)', 'Madrid', '28607', 'España', 31.27, 0, '2025-02-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180225-cVmVbrMW3sbBi-151', 'c1d15b50-7538-4f5c-959e-22e7472c16ee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180225-cVmVbrMW3sbBi-151&s=KOL2025&nf=P6327&i=31.27&cr=068', '[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
(6736, 1, 1684, 2, 0, NULL, 0, '2025-02-17 18:50:16', '2025-02-18 08:51:47', '2025-02-18', 'P6329', '25-08221-02-17', '', 0.00, 22.40, 5.34, 0.00, 0, 0.00, 3.67, 'Agustin Leitza Atzekaldea 12/ 3 izda', 'Andoain', 'Gipuzkoa', '20140', 'España', 30.77, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180225-DHFhYNxa0DWGx-099', '648f8422-0fad-486d-9b14-d4303eb7facb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180225-DHFhYNxa0DWGx-099&s=KOL2025&nf=P6329&i=30.77&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6737, 1, 154, 2, 0, NULL, 0, '2025-02-18 10:53:35', '2025-02-18 12:20:43', '2025-02-18', 'P6330', '25-08222-02-18', 'entregar a partir de las 12:00p.m.', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 142.63, 0, '2025-02-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180225-LHSEHBXugeoGT-163', 'be33da2d-c817-4072-867f-9edb4f4ba562', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180225-LHSEHBXugeoGT-163&s=KOL2025&nf=P6330&i=142.63&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6738, 1, 67, 1, 0, NULL, 0, '2025-02-18 14:30:18', '2025-02-18 14:30:18', '2025-02-18', 'P6331', '', '', 0.00, 235.76, 49.51, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 285.27, 0, '2025-02-18 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180225-QEt5sCxxNj2A3-191', '26117e14-62e9-4942-9cf2-6a9fb523eef9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180225-QEt5sCxxNj2A3-191&s=KOL2025&nf=P6331&i=285.27&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6739, 1, 166, 1, 0, NULL, 0, '2025-02-18 14:34:35', '2025-02-18 14:34:35', '2025-02-18', 'P6332', '', '', 0.00, 115.44, 24.24, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 139.68, 0, '2025-02-18 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180225-enizwkXYAmBIX-229', 'f0c2293a-07c6-48e8-8717-03142da3a8fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180225-enizwkXYAmBIX-229&s=KOL2025&nf=P6332&i=139.68&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6740, 1, 973, 2, 0, NULL, 0, '2025-02-18 19:16:04', '2025-02-19 09:02:48', '2025-02-19', 'P6333', '25-08224-02-18', 'Horario de entrega de 9:00 a 15:00', 0.00, 61.50, 12.92, 0.00, 0, 0.00, 0.00, 'Calle Alejandro Dumas, 4', 'Madrid', 'Madrid', '28005', 'España', 74.42, 0, '2025-02-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190225-XW1fChybhYDA5-115', 'f27fa0dd-c1af-4798-ba4d-7e4ed4dbd15b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190225-XW1fChybhYDA5-115&s=KOL2025&nf=P6333&i=74.42&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6741, 1, 1430, 1, 0, NULL, 0, '2025-02-19 09:04:47', '2025-02-19 09:04:47', '2025-02-19', 'P6334', '', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'Carrer Rei en Jaume 90, bajo', 'Vila-real', 'Castellón', '12540', 'España', 106.98, 0, '2025-02-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190225-dIdsViOJ5OHwT-032', 'b863ab2f-b485-4120-9092-85fbf00dcae7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190225-dIdsViOJ5OHwT-032&s=KOL2025&nf=P6334&i=106.98&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
