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
(6859, 1, 1713, 2, 0, NULL, 0, '2025-03-07 16:39:35', '2025-03-10 08:38:53', '2025-03-10', 'P6448', '25-08350-03-07', '', 0.00, 44.80, 10.05, 0.00, 0, 0.00, 3.67, 'Calle Txofre 2, 1º B', 'Donostia-San Sebastián', 'Gipuzkoa', '20001', 'España', 57.88, 0, '2025-03-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-XpMQWX1Mqoq5Y-198', 'ea171692-a73c-4d8c-aa0e-9ee5d60f481c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-XpMQWX1Mqoq5Y-198&s=KOL2025&nf=P6448&i=57.88&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6860, 1, 1110, 2, 0, NULL, 0, '2025-03-08 09:32:59', '2025-03-10 08:40:01', '2025-03-10', 'P6449', '25-08352-03-08', '', 0.00, 58.94, 12.38, 0.00, 0, 0.00, 0.00, 'C/unió N015', 'Lleida', 'Lleida', '25002', 'España', 71.32, 0, '2025-03-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-Iqe0bp3Lykwmh-255', '31a34494-90c7-445c-820c-76c3ca678c02', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-Iqe0bp3Lykwmh-255&s=KOL2025&nf=P6449&i=71.31&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6861, 1, 1714, 2, 0, NULL, 0, '2025-03-08 10:19:59', '2025-03-10 08:40:49', '2025-03-10', 'P6450', '25-08353-03-08', '', 0.00, 78.40, 16.46, 0.00, 0, 0.00, 0.00, 'Bernardo Ezenarro. 15. Esc.2-2A', 'Elgoibar', 'Gipuzkoa', '20870', 'España', 94.86, 0, '2025-03-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-UlIeTcV53OQgR-136', '2c629d74-38bd-40b9-a6c1-d581532f52aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-UlIeTcV53OQgR-136&s=KOL2025&nf=P6450&i=94.86&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6862, 1, 291, 2, 0, NULL, 0, '2025-03-08 11:39:12', '2025-03-10 08:41:28', '2025-03-10', 'P6451', '25-08354-03-08', '', 0.00, 33.60, 7.78, 0.00, 0, 0.00, 4.17, 'Calle de la Begonia 66', 'Alcobendas', 'Madrid', '28109', 'España', 44.83, 0, '2025-03-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-DZgvGrBdzPJNC-175', 'a66d58c6-6764-4970-99f2-8ceb13b0c2c3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-DZgvGrBdzPJNC-175&s=KOL2025&nf=P6451&i=44.83&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6863, 1, 451, 2, 0, NULL, 0, '2025-03-08 11:59:01', '2025-03-10 08:42:11', '2025-03-10', 'P6452', '25-08355-03-08', '', 0.00, 33.60, 7.78, 0.00, 0, 0.00, 4.17, 'Av. Barcelona N°2,  pta.19', 'San Vicente del Raspeig/Sant Vicent del Raspeig', 'Alicante', '03690', 'España', 44.83, 0, '2025-03-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-d5vzVULmrU00d-207', 'ac967f2a-b549-45bd-8723-98aeaab63784', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-d5vzVULmrU00d-207&s=KOL2025&nf=P6452&i=44.83&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6864, 1, 1715, 2, 0, NULL, 0, '2025-03-08 15:17:00', '2025-03-10 08:42:51', '2025-03-10', 'P6453', '25-08356-03-08', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Calle Porto Colón 14, derecha 7 C', 'Alcorcón', 'Madrid', '28924', 'España', 31.27, 0, '2025-03-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-BNjuLadRs483e-015', 'a43977d1-627c-4569-8d62-0f195dea711d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-BNjuLadRs483e-015&s=KOL2025&nf=P6453&i=31.27&cr=073', '[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
(6865, 1, 1568, 2, 0, NULL, 0, '2025-03-08 21:33:24', '2025-03-10 08:43:29', '2025-03-10', 'P6454', '25-08358-03-08', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'C/ Ángel postigo mejias, 6, 5-B', 'Pamplona/Iruña', 'Navarra', '31016', 'España', 17.72, 0, '2025-03-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100325-G59R5lZtjatvQ-139', '6ff7a566-1efa-4c21-bc54-414d01dd7e32', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-G59R5lZtjatvQ-139&s=KOL2025&nf=P6454&i=17.72&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6866, 1, 1407, 2, 0, NULL, 0, '2025-03-09 15:49:17', '2025-03-10 08:44:14', '2025-03-10', 'P6455', '25-08360-03-09', 'Si no están llevar al nº 3. Gracias.', 0.00, 56.00, 11.76, 0.00, 0, 0.00, 0.00, 'Carrer de Castelló, 8', 'Gavà', 'Barcelona', '08850', 'España', 67.76, 0, '2025-03-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-fI4DKTIx9Rnm8-252', 'a4136042-a498-4e37-95a2-631d9a1116d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-fI4DKTIx9Rnm8-252&s=KOL2025&nf=P6455&i=67.76&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6867, 1, 754, 2, 0, NULL, 0, '2025-03-09 18:53:20', '2025-03-10 08:45:09', '2025-03-10', 'P6456', '25-08362-03-09', '6+1 gratis\r\nregalo tratamiento incoloro\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-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-Xx3vZrHnmKdzw-225', '50cc42cc-1a08-4589-8ceb-020549494dd9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-Xx3vZrHnmKdzw-225&s=KOL2025&nf=P6456&i=63.76&cr=225', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6868, 1, 314, 2, 0, NULL, 0, '2025-03-09 22:38:35', '2025-03-10 08:45:54', '2025-03-10', 'P6457', '25-08363-03-09', '', 0.00, 54.10, 11.36, 0.00, 0, 0.00, 0.00, 'calle mateo miguel ayllon, 2, 3C, 16002', 'Cuenca', 'Cuenca', '16002', 'España', 65.46, 0, '2025-03-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-LSoAT3sKuoOhe-018', '5f88f64c-0915-40a8-9ff8-bc2605c7bd2d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-LSoAT3sKuoOhe-018&s=KOL2025&nf=P6457&i=65.45&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6869, 1, 696, 1, 0, NULL, 0, '2025-03-10 11:57:42', '2025-03-10 12:07:07', '2025-03-11', 'P6458', '', '', 0.00, 1601.91, 336.40, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 1938.31, 0, '2025-03-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110325-L+WBG5FCa3D9E-143', '2fca5e78-4061-4c35-8b49-e395085ec384', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-L%2BWBG5FCa3D9E-143&s=KOL2025&nf=P6458&i=1938.31&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0),
(6870, 1, 87, 2, 0, NULL, 0, '2025-03-10 11:30:10', '2025-03-10 15:20:55', '2025-03-10', 'P6459', '25-08364-03-10', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'Cc arcco local p 17', 'Donostia-San Sebastián', 'Gipuzkoa', '20011', 'España', 106.98, 0, '2025-03-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100325-LMHj8QjvlTNPl-127', 'b3c4658b-7ea0-4786-80a8-e1d472cc493c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-LMHj8QjvlTNPl-127&s=KOL2025&nf=P6459&i=106.98&cr=131', '[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
(6871, 1, 78, 2, 0, NULL, 0, '2025-03-10 13:15:03', '2025-03-10 15:21:32', '2025-03-10', 'P6460', '25-08365-03-10', '', 0.00, 353.64, 74.26, 0.00, 0, 0.00, 0.00, 'AVD. SATRUSTEGUI 1', 'Donostia-San Sebastián', 'Gipuzkoa', '20008', 'España', 427.90, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100325-GAjrCJ7i8nD4Q-070', '6e5ee573-6954-4db1-99b0-64c392660235', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100325-GAjrCJ7i8nD4Q-070&s=KOL2025&nf=P6460&i=427.90&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0),
(6872, 1, 75, 2, 0, NULL, 0, '2025-03-10 17:25:02', '2025-03-11 09:25:09', '2025-03-11', 'P6461', '25-08366-03-10', 'De martes a viernes de 10 a 19:00', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 106.98, 0, '2025-03-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-110325-P/O92nBh9KaT5-238', 'fa3e3921-3c1a-4ed7-a7da-fafdd8587991', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-P%2FO92nBh9KaT5-238&s=KOL2025&nf=P6461&i=106.98&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6873, 1, 522, 2, 0, NULL, 0, '2025-03-10 22:25:05', '2025-03-11 09:26:35', '2025-03-11', 'P6462', '25-08368-03-10', '', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 142.63, 0, '2025-03-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110325-ONitSnB9D7X0o-041', '76fb1a1b-652e-4c49-825a-aa7783a79bed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-ONitSnB9D7X0o-041&s=KOL2025&nf=P6462&i=142.63&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6874, 1, 167, 1, 0, NULL, 0, '2025-03-11 09:38:34', '2025-03-11 09:38:34', '2025-03-11', 'P6463', '', '', 0.00, 218.92, 45.97, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 264.89, 0, '2025-03-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110325-FxqDrSn6PqfrS-104', '500c8566-dcea-4f1e-9b9c-800c154868bd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-FxqDrSn6PqfrS-104&s=KOL2025&nf=P6463&i=264.89&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6875, 1, 1577, 2, 0, NULL, 0, '2025-03-11 09:22:27', '2025-03-11 10:45:55', '2025-03-11', 'P6464', '25-08369-03-11', '', 0.00, 31.70, 7.38, 0.00, 0, 0.00, 4.17, 'Rio Tambre,30', 'Oleiros', 'A Coruña', '15173', 'España', 42.53, 0, '2025-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110325-EY4KWJLandXDX-061', 'ac81b580-52b0-4cd3-8e73-68f20c85bb09', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-EY4KWJLandXDX-061&s=KOL2025&nf=P6464&i=42.53&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6876, 1, 23, 2, 0, NULL, 0, '2025-03-11 09:31:36', '2025-03-11 10:46:32', '2025-03-11', 'P6465', '25-08370-03-11', '', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 213.95, 0, '2025-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110325-FvsyByNwcpJkz-240', '742ae34f-e3f9-4c6d-9083-6ca1c4b49f88', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-FvsyByNwcpJkz-240&s=KOL2025&nf=P6465&i=213.95&cr=133', '[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
(6877, 1, 78, 2, 1, 'Faltan productos', 6871, '2025-03-11 11:01:52', '2025-03-11 11:01:52', '2025-03-11', 'R104', 'P6460 RECT.', '', 0.00, 353.64, 74.26, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 427.90, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-110325-Z5/lWh2KDDj+Y-124', '25725e2a-7dd0-4bec-ae9d-8af122038dad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-Z5%2FlWh2KDDj%2BY-124&s=KOL2025&nf=R104&i=-427.90&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(6878, 1, 78, 1, 0, NULL, 0, '2025-03-11 11:04:47', '2025-03-11 11:04:47', '2025-03-11', 'P6466', '', '', 0.00, 353.64, 74.26, 0.00, 0, 0.00, 0.00, 'AVND. DE SATRUSTEGUI 1', 'Donostia-San Sebastián', 'Gipuzkoa', '20008', 'España', 427.90, 0, '2025-03-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110325-ZhmYqKTw3E6XX-062', '97a8372e-5361-45b7-bb64-465cdcec1881', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-ZhmYqKTw3E6XX-062&s=KOL2025&nf=P6466&i=427.90&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6879, 1, 696, 1, 1, 'Faltan productos', 6869, '2025-03-11 11:09:39', '2025-03-11 11:09:39', '2025-03-11', 'R105', 'P6458 RECT.', '', 0.00, 1601.91, 336.40, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 1938.31, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-110325-XpzNvT5xL5bQ6-206', '225ad106-39ea-4e7c-aa2c-18c63378c6f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-XpzNvT5xL5bQ6-206&s=KOL2025&nf=R105&i=-1938.31&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(6880, 1, 696, 1, 0, NULL, 0, '2025-03-11 11:25:55', '2025-03-11 11:34:49', '2025-03-11', 'P6467', '', '', 0.00, 2415.27, 507.21, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 2922.48, 0, '2025-03-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110325-KCl2KW+TjXIC9-202', '48a69690-8ada-4c3f-a632-3b48f1744451', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-KCl2KW%2BTjXIC9-202&s=KOL2025&nf=P6467&i=2922.48&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0),
(6881, 1, 456, 2, 0, NULL, 0, '2025-03-11 12:06:49', '2025-03-11 13:15:59', '2025-03-11', 'P6468', '25-08371-03-11', 'Por favor, llamen al teléfono indicado antes de entregar el pedido Telf. 653665960', 0.00, 56.00, 11.76, 0.00, 0, 0.00, 0.00, 'CALLE ELDA, Nº 3, ESCALERA 2, 3º C IZQUIERDA', 'San Vicente del Raspeig/Sant Vicent del Raspeig', 'Alicante', '03690', 'España', 67.76, 0, '2025-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110325-TGRGyjcGSnTLn-159', '4af1c984-f2b8-466c-b57d-fdcc80b0f82f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-TGRGyjcGSnTLn-159&s=KOL2025&nf=P6468&i=67.76&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6882, 1, 1716, 2, 0, NULL, 0, '2025-03-11 12:09:17', '2025-03-11 13:16:34', '2025-03-11', 'P6469', '25-08373-03-11', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Calle ibo Alfaro 62', 'Cervera del Río Alhama', 'La Rioja', '26520', 'España', 31.27, 0, '2025-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110325-MFkzveGYbLOuH-047', 'aeb1e9b2-e004-4254-8aeb-8a68185283d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110325-MFkzveGYbLOuH-047&s=KOL2025&nf=P6469&i=31.27&cr=205', '[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
(6883, 1, 111, 2, 0, NULL, 0, '2025-03-11 13:49:27', '2025-03-12 09:12:33', '2025-03-12', 'P6470', '25-08374-03-11', '', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'c/ Juan de Tarazona portal 1 piso 2B', 'Pamplona/Iruña', 'Navarra', '31015', 'España', 213.95, 0, '2025-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120325-AqFev7wQyDLp1-028', '17a96592-4c1c-41ad-8998-8f4212f7c111', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120325-AqFev7wQyDLp1-028&s=KOL2025&nf=P6470&i=213.95&cr=002', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6884, 1, 1601, 2, 0, NULL, 0, '2025-03-11 15:25:09', '2025-03-12 09:13:09', '2025-03-12', 'P6471', '25-08376-03-11', 'Edificio de oficinas. Horario de 8:00 a 18:00', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Entregar en Recepción de CEIN, Polígono Mocholi, 5', 'Noáin (Valle de Elorz)/Noain (Elortzibar)', 'Navarra', '31110', 'España', 31.27, 0, '2025-03-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120325-QNRkGzRcXCg0J-018', 'ae821254-153d-40b2-898f-d24cb60b2cb0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120325-QNRkGzRcXCg0J-018&s=KOL2025&nf=P6471&i=31.27&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6885, 1, 1717, 2, 0, NULL, 0, '2025-03-11 19:29:47', '2025-03-12 09:13:45', '2025-03-12', 'P6472', '25-08377-03-11', '', 0.00, 33.60, 7.78, 0.00, 0, 0.00, 4.17, 'Calle ITALIA 63', 'Valdemoro', 'Madrid', '28341', 'España', 44.83, 0, '2025-03-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120325-COcVVA9/rPQNs-046', '94bcfac4-2feb-468f-a4c7-213830623abe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120325-COcVVA9%2FrPQNs-046&s=KOL2025&nf=P6472&i=44.83&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6886, 1, 1718, 2, 0, NULL, 0, '2025-03-12 07:10:58', '2025-03-12 09:14:23', '2025-03-12', 'P6473', '25-08378-03-12', '', 0.00, 41.00, 9.25, 0.00, 0, 0.00, 3.67, 'Calle Rabal 1B, 4A', 'Soraluze/Placencia de las Armas', 'Gipuzkoa', '20590', 'España', 53.28, 0, '2025-03-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120325-G1VPLwEmHATk8-228', '92a6d521-0f61-4b00-a2f0-785b820c6097', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120325-G1VPLwEmHATk8-228&s=KOL2025&nf=P6473&i=53.28&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6887, 1, 1691, 2, 0, NULL, 0, '2025-03-12 10:39:55', '2025-03-12 11:58:15', '2025-03-12', 'P6474', '25-08379-03-12', 'Lunes cerrado.\r\nMartes a jueves de 9:00h-13:00h/15:30-19:00h\r\nViernes de 9:00h-19:00h\r\nSábado de 8:00-13:00h', 0.00, 58.94, 12.38, 0.00, 0, 0.00, 0.00, 'Plaza las agustinas. 6 bajo', 'Hernani', 'Gipuzkoa', '20120', 'España', 71.32, 0, '2025-03-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120325-e6ZK5Ae4dDVc7-130', 'b8ef33bf-7bed-41fd-ad4d-1610e0d77f30', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120325-e6ZK5Ae4dDVc7-130&s=KOL2025&nf=P6474&i=71.31&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6888, 1, 38, 1, 0, NULL, 0, '2025-03-12 12:00:57', '2025-03-12 12:00:57', '2025-03-12', 'P6475', '', '', 0.00, 265.23, 55.70, 0.00, 0, 0.00, 0.00, 'SARRICOBASO Nº 20 B,  BAJO', ' GETXO', 'BIZKAIA', '48991', '', 320.93, 0, '2025-03-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120325-J/kBPkLGAfu/J-188', '9e049aed-a2c1-403d-93bc-88fca1aed3ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120325-J%2FkBPkLGAfu%2FJ-188&s=KOL2025&nf=P6475&i=320.93&cr=091', '[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
(6889, 1, 1427, 2, 0, NULL, 0, '2025-03-12 14:28:01', '2025-03-12 15:43:02', '2025-03-12', 'P6476', '25-08380-03-12', 'Guadalsegur', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'C/ victoria 1', 'Coín', 'Málaga', '29100', 'España', 31.27, 0, '2025-03-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120325-cUH2AUkSbV26X-221', 'f5565975-0341-4d62-8b61-f53efcaa9531', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120325-cUH2AUkSbV26X-221&s=KOL2025&nf=P6476&i=31.27&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6890, 1, 1719, 2, 0, NULL, 0, '2025-03-12 15:58:02', '2025-03-13 09:20:20', '2025-03-13', 'P6480', '25-08381-03-12', '', 0.00, 20.50, 5.46, 0.00, 0, 0.00, 6.67, 'Virgen delm Lluc 87 2do izq.', 'Madrid', 'Madrid', '28027', 'España', 31.48, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130325-Zq2rVMj0KaHmx-067', '7f7aefc0-f05b-4d68-9f0e-05610ddb9703', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130325-Zq2rVMj0KaHmx-067&s=KOL2025&nf=P6480&i=31.48&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6891, 1, 155, 2, 0, NULL, 0, '2025-03-12 18:07:37', '2025-03-12 18:07:37', '2025-03-12', '', '25-08383-03-12', NULL, 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 213.95, 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),
(6892, 1, 155, 2, 0, NULL, 0, '2025-03-12 18:12:22', '2025-03-13 09:24:18', '2025-03-13', 'P6481', '25-08384-03-12', '', 0.00, 176.82, 37.57, 0.00, 0, 0.00, 2.50, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 216.45, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130325-YzwrMbZTl77iT-036', '843a953b-069d-470e-8521-08a4f2f0aa8e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130325-YzwrMbZTl77iT-036&s=KOL2025&nf=P6481&i=216.45&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6893, 1, 53, 2, 0, NULL, 0, '2025-03-12 18:24:15', '2025-03-13 09:25:22', '2025-03-13', 'P6482', '25-08385-03-12', '', 0.00, 147.35, 31.38, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Compostela', 'A Coruña', '15702', 'España', 180.79, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130325-TM9oklufFti6i-160', '7f7dbaa3-f604-4add-a6ba-1c3a521595e9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130325-TM9oklufFti6i-160&s=KOL2025&nf=P6482&i=180.79&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6894, 1, 1627, 2, 0, NULL, 0, '2025-03-12 18:33:51', '2025-03-13 09:25:51', '2025-03-13', 'P6477', '25-08386-03-12', '', 0.00, 41.00, 9.33, 0.00, 0, 0.00, 4.17, 'C/ MATEO NUÑEZ, 1', 'Vera', 'Almería', '04620', 'España', 53.78, 0, '2025-03-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130325-Jeg9giPKyU17v-112', 'be86a25c-73af-4cb8-9f90-8e5770911e58', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130325-Jeg9giPKyU17v-112&s=KOL2025&nf=P6477&i=53.78&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6895, 1, 373, 2, 0, NULL, 0, '2025-03-12 18:43:20', '2025-03-13 09:26:27', '2025-03-13', 'P6478', '25-08387-03-12', '', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'MANZANEDO 55 1C', 'Don Benito', 'Badajoz', '06400', 'España', 28.98, 0, '2025-03-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130325-WM33i9+62XgpV-168', '147db06d-5e24-4478-843f-29988d9a1514', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130325-WM33i9%2B62XgpV-168&s=KOL2025&nf=P6478&i=28.98&cr=044', '[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
(6896, 1, 770, 2, 0, NULL, 0, '2025-03-12 20:31:06', '2025-03-13 09:27:02', '2025-03-13', 'P6479', '25-08388-03-12', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'Emilio Arrieta 11 bis 4º oficina 7-8', 'Pamplona/Iruña', 'Navarra', '31002', 'España', 17.72, 0, '2025-03-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130325-f5jM/+CIAzBXi-035', 'c1376374-d5b9-4c89-adc4-8267e0181891', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130325-f5jM%2F%2BCIAzBXi-035&s=KOL2025&nf=P6479&i=17.72&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6897, 1, 932, 2, 0, NULL, 0, '2025-03-12 21:27:28', '2025-03-13 09:28:23', '2025-03-13', 'P6483', '25-08389-03-12', '', 0.00, 88.41, 19.00, 0.00, 0, 0.00, 2.50, 'Calle acera del pilar,Edf. Residencial casa fuerte local 2 peluquería 2', 'Almuñécar', 'Granada', '18697', 'España', 109.48, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130325-DI4miIfiPjfiW-088', 'd39c83d8-8b6e-44e6-8f66-587dc570f062', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130325-DI4miIfiPjfiW-088&s=KOL2025&nf=P6483&i=109.48&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6898, 1, 1650, 2, 0, NULL, 0, '2025-03-12 21:37:50', '2025-03-13 09:30:41', '2025-03-13', 'P6484', '25-08391-03-12', '', 0.00, 88.41, 18.57, 0.00, 0, 0.00, 0.00, 'Avenida Balaidos 70, Vigo', 'Vigo', 'Pontevedra', '36210', 'España', 106.98, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130325-QC/Ojdh9pgY/C-018', 'a5142018-c763-4158-8d75-9c8ef0e625a1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130325-QC%2FOjdh9pgY%2FC-018&s=KOL2025&nf=P6484&i=106.98&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6899, 1, 1721, 2, 0, NULL, 0, '2025-03-13 09:39:43', '2025-03-13 11:11:40', '2025-03-13', 'P6485', '25-08393-03-13', 'Si ausente llamar 680364124', 0.00, 52.20, 10.96, 0.00, 0, 0.00, 0.00, 'Calle Eras N11 3D', 'Ausejo', 'La Rioja', '26513', 'España', 63.16, 0, '2025-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130325-Wabl2PGwvduCx-139', 'bb7b6b35-b555-413f-89a8-d18428d2d33d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130325-Wabl2PGwvduCx-139&s=KOL2025&nf=P6485&i=63.16&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6900, 1, 11, 2, 0, NULL, 0, '2025-03-14 09:32:25', '2025-03-14 10:40:50', '2025-03-14', 'P6486', '25-08394-03-14', '', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'calle Colomeres 36 local 2', 'Gavà', 'Barcelona', '08840', 'España', 142.63, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140325-SI78tnBCWDHLF-118', 'a1cd0708-42ab-450d-8050-254316c082df', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140325-SI78tnBCWDHLF-118&s=KOL2025&nf=P6486&i=142.63&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6901, 1, 696, 1, 1, 'faltan productos', 6880, '2025-03-14 11:33:39', '2025-03-14 11:33:39', '2025-03-14', 'R106', 'P6467 RECT.', '', 0.00, 2415.27, 507.21, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 2922.48, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-140325-WnaTZ0sre5HoO-146', 'e8839fdf-8d37-4086-b5e6-35c8d2c2a8fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140325-WnaTZ0sre5HoO-146&s=KOL2025&nf=R106&i=-2922.48&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 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
(6902, 1, 696, 1, 0, NULL, 0, '2025-03-14 11:50:42', '2025-03-14 12:06:13', '2025-03-14', 'P6487', '', '', 0.00, 2466.75, 518.02, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 2984.77, 0, '2025-03-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140325-Yhg73vhPV1Ljg-088', 'f90e131d-aed7-40c5-b895-1f56e9eee862', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140325-Yhg73vhPV1Ljg-088&s=KOL2025&nf=P6487&i=2984.77&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6903, 1, 1722, 2, 0, NULL, 0, '2025-03-14 16:25:19', '2025-03-17 09:20:56', '2025-03-17', 'P6502', '25-08395-03-14', '', 0.00, 11.20, 2.99, 0.00, 0, 0.00, 3.67, 'Martin Deuna kalea 3, 4.', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 17.22, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170325-VclLEwdE0rZzt-232', '965d36d7-b1a9-4681-9f6e-06f09137af0a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-VclLEwdE0rZzt-232&s=KOL2025&nf=P6502&i=17.22&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6904, 1, 4, 2, 0, NULL, 0, '2025-03-14 19:36:39', '2025-03-17 09:23:34', '2025-03-17', 'P6488', '25-08396-03-14', '', 0.00, 307.33, 64.54, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 371.87, 0, '2025-03-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170325-QWBN/W6R1ml75-081', '216c704e-25c8-44e5-b927-dd2ddde13ffb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-QWBN%2FW6R1ml75-081&s=KOL2025&nf=P6488&i=371.87&cr=197', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6905, 1, 755, 2, 0, NULL, 0, '2025-03-14 19:49:52', '2025-03-17 09:27:10', '2025-03-17', 'P6489', '25-08397-03-14', '', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Estrada pola Vía,21', 'Nigrán', 'Pontevedra', '36350', 'España', 31.27, 0, '2025-03-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170325-CEgtRJq+SLgZW-193', 'cff1bb45-0448-4093-9cfa-8acc7954e98a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-CEgtRJq%2BSLgZW-193&s=KOL2025&nf=P6489&i=31.27&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6906, 1, 1723, 2, 0, NULL, 0, '2025-03-14 22:02:06', '2025-03-17 09:28:15', '2025-03-17', 'P6490', '25-08398-03-14', '', 0.00, 31.70, 7.38, 0.00, 0, 0.00, 4.17, 'Calle Sagüesgaña 5, 3B', 'Zizur Mayor/Zizur Nagusia', 'Navarra', '31180', 'España', 42.53, 0, '2025-03-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170325-b32nzDtSMQI1J-110', '77e78540-c44e-4458-83ec-888188d7161d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-b32nzDtSMQI1J-110&s=KOL2025&nf=P6490&i=42.53&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6907, 1, 248, 2, 0, NULL, 0, '2025-03-15 08:52:00', '2025-03-17 09:36:28', '2025-03-17', 'P6503', '25-08399-03-15', '', 0.00, 92.62, 19.89, 0.00, 0, 0.00, 2.50, 'Rua otero pedraio bajo 1 peluquería peina-t', 'Cambre', 'A Coruña', '15679', 'España', 114.57, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-170325-F2eN4xNrTlbqM-184', '40a348ad-0b91-43ab-9d36-502a9b8c64e4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-F2eN4xNrTlbqM-184&s=KOL2025&nf=P6503&i=114.57&cr=042', '[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
(6908, 1, 442, 2, 0, NULL, 0, '2025-03-15 09:49:16', '2025-03-17 09:38:21', '2025-03-17', 'P6491', '25-08400-03-15', '', 0.00, 44.80, 10.13, 0.00, 0, 0.00, 4.17, 'Travesía del Tornado 7, piso 4N', 'Tres Cantos', 'Madrid', '28760', 'España', 58.38, 0, '2025-03-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170325-GHo2kcoE6HIME-245', 'fb49045d-19c0-4ffe-8e9b-ea86c49445a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-GHo2kcoE6HIME-245&s=KOL2025&nf=P6491&i=58.38&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6909, 1, 1724, 2, 0, NULL, 0, '2025-03-15 12:55:19', '2025-03-17 09:42:17', '2025-03-17', 'P6492', '25-08401-03-15', '', 0.00, 63.40, 13.31, 0.00, 0, 0.00, 0.00, 'Nube de Magallanes, 61, Chalet', 'Valladolid', 'Valladolid', '47011', 'España', 76.71, 0, '2025-03-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170325-LuCdX6tkjXk51-113', '80c010f8-bfbc-4026-9ad8-a223a061829a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-LuCdX6tkjXk51-113&s=KOL2025&nf=P6492&i=76.70&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6910, 1, 589, 2, 0, NULL, 0, '2025-03-15 19:49:38', '2025-03-17 09:42:49', '2025-03-17', 'P6493', '25-08402-03-15', 'Entregar por las tardes a partir de las 15:15 gracias ', 0.00, 44.80, 10.13, 0.00, 0, 0.00, 4.17, 'Avenida Constitución 184, portal 3 esc 5 , 1 E', 'Torrejón de Ardoz', 'Madrid', '28850', 'España', 58.38, 0, '2025-03-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170325-Ig6cAVtQoDJf6-211', '120227ef-a6d4-4980-b7f2-06f6f890adef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-Ig6cAVtQoDJf6-211&s=KOL2025&nf=P6493&i=58.38&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6911, 1, 1725, 2, 0, NULL, 0, '2025-03-16 09:20:21', '2025-03-17 09:43:41', '2025-03-17', 'P6494', '25-08403-03-16', 'Es en la asociación contra el cáncer ', 0.00, 22.40, 5.37, 0.00, 0, 0.00, 3.84, 'Plaza Porticada 1, bajo, Asociación contra el cáncer', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 30.94, 0, '2025-03-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170325-HUhjPMlECtqqw-221', '9e9e1032-6d93-4f85-be63-c24baa881150', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-HUhjPMlECtqqw-221&s=KOL2025&nf=P6494&i=30.94&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6912, 1, 1726, 2, 0, NULL, 0, '2025-03-16 11:39:06', '2025-03-17 09:44:07', '2025-03-17', 'P6495', '25-08404-03-16', '', 0.00, 22.40, 5.37, 0.00, 0, 0.00, 3.84, 'Calle Estartetxe 12 3A', 'Leioa', 'Bizkaia', '48940', 'España', 30.94, 0, '2025-03-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170325-Sj1PTZtg3OGee-137', 'd2ce6f94-9b79-4b45-a403-9a33df1c1086', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-Sj1PTZtg3OGee-137&s=KOL2025&nf=P6495&i=30.94&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6913, 1, 1245, 2, 0, NULL, 0, '2025-03-16 11:47:13', '2025-03-17 09:44:41', '2025-03-17', 'P6496', '25-08405-03-16', 'Tienda Telfy', 0.00, 20.50, 5.03, 0.00, 0, 0.00, 4.17, 'Avenida Constitución 9', 'Catral', 'Alicante', '03158', 'España', 28.98, 0, '2025-03-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170325-E57enzQ2j96pI-173', 'e3d460e1-15da-435c-8d81-a0a23cc16595', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170325-E57enzQ2j96pI-173&s=KOL2025&nf=P6496&i=28.98&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
