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
(6039, 1, 1423, 2, 0, NULL, 0, '2024-11-05 14:24:45', '2024-11-05 15:45:45', '2024-11-05', 'P5671', '24-07451-11-05', '', 0.00, 370.50, 77.81, 0.00, 0, 0.00, 0.00, 'General Eguia frente al 31 PELUQUERÍA  BORGANICA', 'Bilbao', 'Bizkaia', '48013', 'España', 448.31, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-051124-KVYXWfT1DWOlO-188', 'bd970820-ad76-4bee-8ecc-47675789aaba', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-KVYXWfT1DWOlO-188&s=KOL2024&nf=P5671&i=448.31&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6040, 1, 714, 2, 0, NULL, 0, '2024-11-05 15:10:32', '2024-11-05 16:25:34', '2024-11-05', 'P5672', '24-07452-11-05', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer Cantallops 19', 'Avinyonet del Penedè', 'Barcelona', '08793', 'España', 30.61, 0, '2024-11-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051124-KeLztxCeUaOY8-149', '3665c1d6-6dc8-4bac-bb64-19aa4913bfe0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-KeLztxCeUaOY8-149&s=KOL2024&nf=P5672&i=30.61&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6041, 1, 222, 2, 0, NULL, 0, '2024-11-05 15:20:14', '2024-11-05 16:35:33', '2024-11-05', 'P5673', '24-07453-11-05', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Cartagena 296 ', 'Barcelona', 'Barcelona', '08025', 'España', 206.91, 0, '2024-11-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051124-Lry75yJ65wUJt-219', '79078284-e7d3-4d16-ac58-34e3931ade35', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-Lry75yJ65wUJt-219&s=KOL2024&nf=P5673&i=206.91&cr=255', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6042, 1, 1292, 2, 0, NULL, 0, '2024-11-05 15:38:32', '2024-11-05 16:40:33', '2024-11-05', 'P5674', '24-07454-11-05', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Luces de la ciudad 27. 5 b', 'Zaragoza', 'Zaragoza', '50019', 'España', 78.63, 0, '2024-11-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051124-aNlDORDIBXZ9T-237', 'a0a08451-30f8-40b7-8732-700b2f505a5a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051124-aNlDORDIBXZ9T-237&s=KOL2024&nf=P5674&i=78.63&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6043, 1, 712, 2, 0, NULL, 0, '2024-11-05 17:32:49', '2024-11-06 08:53:10', '2024-11-06', 'P5675', '24-07455-11-05', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle Río Cubas 7 5°izda 5°dcha', 'Santander', 'Cantabria', '39004', 'España', 56.82, 0, '2024-11-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061124-FRJ36MQN2RsRE-007', '0a68cf99-1322-4a7e-8f8a-7ef1febf0367', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-FRJ36MQN2RsRE-007&s=KOL2024&nf=P5675&i=56.82&cr=237', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6044, 1, 765, 2, 0, NULL, 0, '2024-11-05 20:04:10', '2024-11-06 08:54:32', '2024-11-06', 'P5676', '24-07456-11-05', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061124-du82eiV4W6Uo9-023', 'af8cbd6e-fef9-45a5-ad34-8f8fbcbc7412', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-du82eiV4W6Uo9-023&s=KOL2024&nf=P5676&i=379.34&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(6045, 1, 580, 2, 0, NULL, 0, '2024-11-06 07:55:02', '2024-11-06 08:59:56', '2024-11-06', 'P5677', '24-07458-11-06', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'san martin 4, 4º izd', 'Urretxu', 'Gipuzkoa', '20700', 'España', 30.61, 0, '2024-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061124-fZP2v+n7s+6iz-101', '5314d9c0-d896-42c9-bccb-60ebdd864e50', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-fZP2v%2Bn7s%2B6iz-101&s=KOL2024&nf=P5677&i=30.61&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6046, 1, 76, 1, 0, NULL, 0, '2024-11-06 09:32:30', '2024-11-06 09:32:30', '2024-11-06', 'P5678', '', '', 0.00, 77.22, 16.22, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 93.44, 0, '2024-11-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061124-ZL9jtxS0nd1GL-247', '036cff0c-3dd9-4750-9dfe-6325b05ad309', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-ZL9jtxS0nd1GL-247&s=KOL2024&nf=P5678&i=93.44&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6047, 1, 1508, 2, 0, NULL, 0, '2024-11-06 08:48:43', '2024-11-06 10:00:46', '2024-11-06', 'P5679', '24-07459-11-06', 'NO HAY TIMBRE LLAMAR', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'JOSEP MARIA DE SAGARRA N.9', 'Santa Eulàlia de Ron', 'Barcelona', '08187', 'España', 30.61, 0, '2024-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061124-R+OpQWSCu7rX/-204', 'a9a7ea0b-a157-4409-be7c-ac4b12885ffb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-R%2BOpQWSCu7rX%2F-204&s=KOL2024&nf=P5679&i=30.61&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6048, 1, 3, 1, 0, NULL, 0, '2024-11-06 10:30:19', '2024-11-06 10:30:19', '2024-11-06', 'P5680', '', '', 0.00, 350.14, 73.53, 0.00, 0, 0.00, 0.00, 'C/ PINTOR AURELIO VIRAFAJARDO Nº2 B', 'VITORIA', 'ÁLAVA', '01008', 'España', 423.67, 0, '2024-11-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061124-YX6UcZXTHPUei-026', '374a36c1-a6ce-47cb-8f22-aac11ef1c181', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-YX6UcZXTHPUei-026&s=KOL2024&nf=P5680&i=423.67&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(6049, 1, 3, 1, 1, 'confusión en 1 producto', 6048, '2024-11-06 10:31:40', '2024-11-06 10:31:40', '2024-11-06', 'R93', 'P5680 RECT.', '', 0.00, 350.14, 73.53, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 423.67, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-061124-ONWF0AEwlypzW-095', '2d1f93b8-75f7-4a0e-88c0-0b029a8ccfa0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-ONWF0AEwlypzW-095&s=KOL2024&nf=R93&i=-423.67&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(6050, 1, 3, 1, 0, NULL, 0, '2024-11-06 10:35:55', '2024-11-06 10:35:55', '2024-11-06', 'P5681', '', '', 0.00, 370.50, 77.80, 0.00, 0, 0.00, 0.00, 'C/ PINTOR AURELIO VIRAFAJARDO Nº2 B', 'VITORIA', 'ÁLAVA', '01008', 'España', 448.30, 0, '2024-11-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061124-BWnhepM61gX9g-225', 'a5f19715-9c7c-41d8-807c-bcd26cf5000b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-BWnhepM61gX9g-225&s=KOL2024&nf=P5681&i=448.30&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(6051, 1, 155, 2, 0, NULL, 0, '2024-11-06 10:02:57', '2024-11-06 11:03:28', '2024-11-06', 'P5682', '24-07457-11-06', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061124-Urpwbj4pqK53Z-058', '87f79339-28a4-4796-8cb0-b1904181747f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-Urpwbj4pqK53Z-058&s=KOL2024&nf=P5682&i=275.88&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6052, 1, 687, 1, 0, NULL, 0, '2024-11-06 11:14:15', '2024-11-06 11:14:15', '2024-11-06', 'P5683', '', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 123.15, 0, '2024-11-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061124-OImg2+S+9+KN2-108', '1574b465-cd21-49fa-83dd-7b9c072d9646', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-OImg2%2BS%2B9%2BKN2-108&s=KOL2024&nf=P5683&i=123.15&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6053, 1, 1311, 1, 0, NULL, 0, '2024-11-06 11:22:27', '2024-11-06 11:22:27', '2024-11-06', 'P5684', '', '', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'Emilio Arrieta 25', 'Pamplona', 'Navarra', '31002', 'España', 133.00, 0, '2024-11-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-061124-K1Atpw1s6vhBJ-188', '6c3412b5-e34b-4c45-92eb-754e5c003003', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-K1Atpw1s6vhBJ-188&s=KOL2024&nf=P5684&i=133.00&cr=197', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6054, 1, 244, 2, 0, NULL, 0, '2024-11-06 10:33:28', '2024-11-06 11:34:16', '2024-11-06', 'P5685', '24-07460-11-06', 'Peluquería Maimar', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'C/ Balmes, 79 Local 3', 'Calella', 'Barcelona', '08370', 'España', 78.82, 0, '2024-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061124-CzcGInhU76V9o-033', '5a70afe3-8b1a-40d1-b982-9546a66136ac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-CzcGInhU76V9o-033&s=KOL2024&nf=P5685&i=78.81&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6055, 1, 1011, 2, 0, NULL, 0, '2024-11-06 10:36:57', '2024-11-06 11:55:42', '2024-11-06', 'P5686', '24-07461-11-06', 'Local 7 Peluquería Arte&Cabello', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Avenida Goleta 23-25', 'Alicante/Alacant', 'Alicante', '03550', 'España', 275.88, 0, '2024-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061124-V7qdFvjHhLpsF-035', 'e4e6f0d7-9847-4c4e-b5c1-db328c0d5761', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061124-V7qdFvjHhLpsF-035&s=KOL2024&nf=P5686&i=275.88&cr=011', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6056, 1, 1509, 2, 0, NULL, 0, '2024-11-06 13:54:19', '2024-11-07 07:48:24', '2024-11-07', 'P5687', '24-07462-11-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Victoria Kent, 4, 1°F', 'Salobreña', 'Granada', '18010', 'España', 17.50, 0, '2024-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071124-KwFXpDMHQoVVB-088', '9ab0db97-1c8b-4efc-be53-620f20d47208', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071124-KwFXpDMHQoVVB-088&s=KOL2024&nf=P5687&i=17.50&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(6057, 1, 1253, 2, 0, NULL, 0, '2024-11-06 14:12:14', '2024-11-07 08:18:53', '2024-11-07', 'P5688', '24-07463-11-06', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle La Paz nº 37 bajo derecha', 'Barakaldo', 'Bizkaia', '48903', 'España', 30.61, 0, '2024-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071124-IXFxOQ5gQPbdM-005', '5bc945f0-457d-4d88-a1ba-c6215f854a62', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071124-IXFxOQ5gQPbdM-005&s=KOL2024&nf=P5688&i=30.61&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6058, 1, 362, 2, 0, NULL, 0, '2024-11-06 15:36:10', '2024-11-07 08:21:01', '2024-11-07', 'P5689', '24-07464-11-06', 'Horario mediodía , llamar al 653802342', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Doctor Jose zaldua n 10; 3 B', 'Portugalete', 'Bizkaia', '48920', 'España', 43.71, 0, '2024-11-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-071124-ClUPZNpbm+Wsj-182', '4bf67197-a8e8-484a-9a91-c084402fb7f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071124-ClUPZNpbm%2BWsj-182&s=KOL2024&nf=P5689&i=43.71&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6059, 1, 17, 2, 0, NULL, 0, '2024-11-06 18:00:00', '2024-11-07 08:24:30', '2024-11-07', 'P5690', '24-07465-11-06', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 137.94, 0, '2024-11-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071124-eq88Ej5JbfN3P-209', 'f75c7d9a-eb4f-479c-8066-6d2f314697a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071124-eq88Ej5JbfN3P-209&s=KOL2024&nf=P5690&i=137.94&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6060, 1, 166, 1, 0, NULL, 0, '2024-11-07 10:44:27', '2024-11-07 11:51:24', '2024-11-07', 'P5691', '', '', 0.00, 154.44, 32.43, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 186.87, 0, '2024-11-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-071124-F917mSXDrhffj-112', '059e233e-bf64-4821-87dc-bc9fbc4be16b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071124-F917mSXDrhffj-112&s=KOL2024&nf=P5691&i=186.87&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6061, 1, 152, 1, 0, NULL, 0, '2024-11-07 12:09:41', '2024-11-07 12:16:08', '2024-11-07', 'P5692', '', '', 0.00, 660.66, 138.74, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 799.40, 0, '2024-11-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-071124-WsETuZGWv9OUM-091', '231e98bf-e449-472c-ba8b-1e022bb84958', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071124-WsETuZGWv9OUM-091&s=KOL2024&nf=P5692&i=799.40&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6062, 1, 696, 1, 0, NULL, 0, '2024-11-07 13:03:44', '2024-11-07 13:17:47', '2024-11-07', 'P5693', '', '', 0.00, 1145.43, 240.54, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 1385.97, 0, '2024-11-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-071124-avHXjDv5k6rf/-061', '1e75f55c-940c-4620-bd69-8bbb99432e79', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071124-avHXjDv5k6rf%2F-061&s=KOL2024&nf=P5693&i=1385.97&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(6063, 1, 1377, 2, 0, NULL, 0, '2024-11-07 12:04:18', '2024-11-07 13:04:39', '2024-11-07', 'P5694', '24-07467-11-07', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Plaza Ezkurdi 4, 6 derecha', 'Durango', 'Bizkaia', '48200', 'España', 43.71, 0, '2024-11-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-071124-Wk8TcmMLORHrJ-071', '39a90b5b-bcde-4800-9bd0-e389b99b56fd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071124-Wk8TcmMLORHrJ-071&s=KOL2024&nf=P5694&i=43.71&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6064, 1, 1510, 2, 0, NULL, 0, '2024-11-07 19:54:56', '2024-11-08 09:44:33', '2024-11-08', 'P5695', '24-07468-11-07', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Crta. Matama-Pazo, 74. San Andrés de Comesaña.', 'Vigo', 'Pontevedra', '36213', 'España', 30.61, 0, '2024-11-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-081124-X1ajnjBlTAupM-240', '8670c102-ccf9-4a9f-aa4f-ae09ceee34a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081124-X1ajnjBlTAupM-240&s=KOL2024&nf=P5695&i=30.61&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6065, 1, 157, 2, 0, NULL, 0, '2024-11-07 20:31:02', '2024-11-08 09:47:29', '2024-11-08', 'P5696', '24-07469-11-07', 'ESTARÉ CERRADO HASTA EL MARTES POR LA TARDE. ENTREGAR DESPUES POR FAVOR. MUCHAS GRACIAS', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'CALLE APODACA,1 LOCAL', 'Madrid', 'Madrid', '28004', 'España', 68.97, 0, '2024-11-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-081124-KQ2EeCuLhUwXm-068', 'b69ab467-d2fa-4387-a549-eb076d9e4df1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081124-KQ2EeCuLhUwXm-068&s=KOL2024&nf=P5696&i=68.97&cr=187', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6066, 1, 80, 2, 0, NULL, 0, '2024-11-08 09:13:01', '2024-11-08 11:50:08', '2024-11-08', 'P5697', '24-07471-11-08', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 482.79, 0, '2024-11-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-081124-bJ99L8QeCHpGh-061', '65e6c142-e0f8-457b-8a68-926474b7141e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081124-bJ99L8QeCHpGh-061&s=KOL2024&nf=P5697&i=482.79&cr=154', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6067, 1, 623, 2, 0, NULL, 0, '2024-11-08 09:40:18', '2024-11-08 11:58:42', '2024-11-08', 'P5698', '24-07472-11-08', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Gaiteira 66, Bajo', 'Coruña (A)', 'A Coruña', '15006', 'España', 275.88, 0, '2024-11-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-081124-OXvZE7pqUHVfg-252', '68e11b89-2a23-4892-93b6-42adca6efb83', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081124-OXvZE7pqUHVfg-252&s=KOL2024&nf=P5698&i=275.88&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6068, 1, 634, 2, 0, NULL, 0, '2024-11-08 12:24:36', '2024-11-08 14:05:52', '2024-11-08', 'P5699', '24-07473-11-08', 'Por la tarde a partir de las 3', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Río Duero52', 'Aldeamayor de San Ma', 'Valladolid', '47164', 'España', 30.61, 0, '2024-11-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-081124-UnG+ZgMLjJuxH-068', '7528f7da-96bc-45ee-ac89-afddf43c4a5e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081124-UnG%2BZgMLjJuxH-068&s=KOL2024&nf=P5699&i=30.61&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(6069, 1, 162, 2, 0, NULL, 0, '2024-11-08 13:26:30', '2024-11-10 07:57:36', '2024-11-10', 'P5700', '24-07474-11-08', 'Entregar en horario de mañana', 0.00, 162.84, 34.20, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 197.04, 0, '2024-11-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101124-Uru5S7p5UXyQm-072', '1fcf46b9-5f26-479a-a238-a95bd67d2b57', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101124-Uru5S7p5UXyQm-072&s=KOL2024&nf=P5700&i=197.04&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6070, 1, 144, 2, 0, NULL, 0, '2024-11-08 15:01:57', '2024-11-10 07:58:46', '2024-11-10', 'P5701', '24-07475-11-08', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 172.43, 0, '2024-11-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101124-QpeRPSgVsUxKn-229', '99b534db-015d-4d36-bd43-b88b77d20822', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101124-QpeRPSgVsUxKn-229&s=KOL2024&nf=P5701&i=172.43&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6071, 1, 40, 2, 0, NULL, 0, '2024-11-08 16:01:35', '2024-11-10 08:02:29', '2024-11-10', 'P5702', '24-07477-11-08', '', 0.00, 89.56, 18.81, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 108.37, 0, '2024-11-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101124-Xqh6e65HOkcaF-143', '55a63078-1594-4a39-9c8e-d40512f9ae7c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101124-Xqh6e65HOkcaF-143&s=KOL2024&nf=P5702&i=108.37&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6072, 1, 1511, 2, 0, NULL, 0, '2024-11-08 17:58:19', '2024-11-11 09:36:57', '2024-11-11', 'P5703', '24-07478-11-08', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'San Juan 9, 1, A', 'Badajoz', 'Badajoz', '06002', 'España', 28.39, 0, '2024-11-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111124-IW9JYVrVhUhzl-095', '87cdb52c-fa88-4f45-8390-f2c72e3863f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111124-IW9JYVrVhUhzl-095&s=KOL2024&nf=P5703&i=28.39&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6073, 1, 337, 2, 0, NULL, 0, '2024-11-08 18:25:36', '2024-11-10 08:04:34', '2024-11-10', 'P5708', '24-07479-11-08', '', 0.00, 122.10, 25.64, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 147.74, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-101124-E69IhFEmNN044-227', 'b9d6307b-1363-4629-ae90-3b8394489d63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101124-E69IhFEmNN044-227&s=KOL2024&nf=P5708&i=147.74&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6074, 1, 1512, 2, 0, NULL, 0, '2024-11-08 22:50:35', '2024-11-10 08:06:07', '2024-11-10', 'P5704', '24-07480-11-08', 'Hospital Veterinario Tapia ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Polígono industrial El Cortaficio, Parcela I-20, Hospital Veterinario Tapia', 'Tapia de Casariego', 'Asturias', '33747', 'España', 28.39, 0, '2024-11-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101124-LgH8FB/Y9Bvkc-089', '9164f8db-d1f1-4c2b-b276-789819441a3f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101124-LgH8FB%2FY9Bvkc-089&s=KOL2024&nf=P5704&i=28.39&cr=225', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(6075, 1, 215, 2, 0, NULL, 0, '2024-11-09 04:39:21', '2024-11-10 08:07:26', '2024-11-10', 'P5705', '24-07481-11-09', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 206.91, 0, '2024-11-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101124-NmJ3nZTwKTh/O-193', '2f890d65-1bc7-4bf9-bc73-1e92a6edd0a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101124-NmJ3nZTwKTh%2FO-193&s=KOL2024&nf=P5705&i=206.91&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6076, 1, 1513, 2, 0, NULL, 0, '2024-11-09 11:08:23', '2024-11-10 08:08:30', '2024-11-10', 'P5706', '24-07483-11-09', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'amanecer 14, A', 'Adra', 'Almería', '04770', 'España', 30.61, 0, '2024-11-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101124-AOlRipw7d2nsQ-187', '8179e0ef-ffcd-411e-8a83-6b0163fe1438', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101124-AOlRipw7d2nsQ-187&s=KOL2024&nf=P5706&i=30.61&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6077, 1, 694, 2, 0, NULL, 0, '2024-11-09 18:35:39', '2024-11-10 08:09:17', '2024-11-10', 'P5707', '24-07484-11-09', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'DICES 33', 'Rois', 'A Coruña', '15911', 'España', 43.71, 0, '2024-11-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101124-Emr7/9pSEHr0l-194', '1edb9624-7ead-43ed-b4df-73ab45ece11e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101124-Emr7%2F9pSEHr0l-194&s=KOL2024&nf=P5707&i=43.71&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6078, 1, 1514, 2, 0, NULL, 0, '2024-11-09 23:34:38', '2024-11-09 23:34:38', '2024-11-09', '', '24-07485-11-09', NULL, 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Urbanización Casquero Calle N 4 C ', 'Dos Hermanas', 'Sevilla', '41703', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6079, 1, 174, 2, 0, NULL, 0, '2024-11-10 08:29:49', '2024-11-11 09:40:35', '2024-11-11', 'P5711', '24-07486-11-10', 'Hola Ouhana , te hago el pedido ahora pero estaremos cerradas por vacaciones del 11 al 17 de noviembre. ¿ me lo puedes enviar para que lo entreguen el lunes 18 ?\r\nLa factura esta vez me la envías por whassap porque yo no estaré hasta final de mes .\r\nMuchas gracias , un saludo', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 275.88, 0, '2024-11-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111124-e1kHAwZ8eKSSK-179', 'd098d2c3-8be4-4f51-b218-342c088101e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111124-e1kHAwZ8eKSSK-179&s=KOL2024&nf=P5711&i=275.88&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6080, 1, 754, 2, 0, NULL, 0, '2024-11-10 20:11:53', '2024-11-11 09:48:09', '2024-11-11', 'P5709', '24-07487-11-10', '6+1 regalo PRECOLOR DORADO\r\nGRACIAS', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-11-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111124-dd0Kk4lKPm6d+-129', '8b8dc384-c8ef-4221-b047-1fbbe932158a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111124-dd0Kk4lKPm6d%2B-129&s=KOL2024&nf=P5709&i=61.64&cr=119', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6081, 1, 1045, 2, 0, NULL, 0, '2024-11-10 21:18:18', '2024-11-11 09:46:14', '2024-11-11', 'P5710', '24-07488-11-10', 'Si no estoy en casa me lo podéis dejar en el buzón o en el felpudo', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Monasterio del paular 16 bajo F', 'Valladolid', 'Valladolid', '47015', 'España', 30.61, 0, '2024-11-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111124-fqzrKPxTjlepV-161', '4780d73e-5056-422f-a204-c4e24f521c41', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111124-fqzrKPxTjlepV-161&s=KOL2024&nf=P5710&i=30.61&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(6082, 1, 1515, 2, 0, NULL, 0, '2024-11-11 11:31:04', '2024-11-11 12:47:12', '2024-11-11', 'P5712', '24-07489-11-11', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Arretxea 2', 'Lesaka', 'Navarra', '31770', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111124-EeO+xvArRa+I7-061', '2ca6dba7-4d52-43c3-89e0-d708293c54cc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111124-EeO%2BxvArRa%2BI7-061&s=KOL2024&nf=P5712&i=103.46&cr=190', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6083, 1, 65, 2, 0, NULL, 0, '2024-11-11 12:07:23', '2024-11-11 13:14:27', '2024-11-11', 'P5713', '24-07490-11-11', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 482.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111124-eMfeyQDOxrf9s-017', 'a095eaab-eba8-4c2f-a3e7-96f21418f1f1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111124-eMfeyQDOxrf9s-017&s=KOL2024&nf=P5713&i=482.79&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6084, 1, 1516, 2, 0, NULL, 0, '2024-11-11 18:21:50', '2024-11-12 09:33:48', '2024-11-12', 'P5714', '24-07491-11-11', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Señora Sergia, 4A piso 2B', 'Torrelodones', 'Madrid', '28250', 'España', 28.39, 0, '2024-11-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-121124-ZCdrUUjb9Nq+q-041', 'bb3f11bd-393d-4f9f-bc67-9dbf82181d0a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121124-ZCdrUUjb9Nq%2Bq-041&s=KOL2024&nf=P5714&i=28.39&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6085, 1, 932, 2, 0, NULL, 0, '2024-11-11 19:59:00', '2024-11-12 09:36:02', '2024-11-12', 'P5715', '24-07492-11-11', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Av.Fco.Prieto Moreno,ED.Las Palmeras 1-2e', 'Almuñécar', 'Granada', '18697', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-121124-DsM7erRb1dp79-125', '6d4decca-13c9-42e8-94ea-416230f7475b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121124-DsM7erRb1dp79-125&s=KOL2024&nf=P5715&i=71.47&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6086, 1, 925, 2, 0, NULL, 0, '2024-11-12 09:46:15', '2024-11-12 11:00:56', '2024-11-12', 'P5716', '24-07493-11-12', '', 0.00, 228.00, 47.88, 0.00, 1, 11.86, 0.00, 'Perú número 16 Bloq 2 Bajo DCH', 'ALICANTE', 'ALICANTE', '03008', 'ESPAÑA', 287.74, 0, '2024-11-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-121124-Grj5+e7QGjJtz-139', 'e04ce5fc-ea39-4bdb-a7af-2339fcf45e26', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121124-Grj5%2Be7QGjJtz-139&s=KOL2024&nf=P5716&i=287.74&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6087, 1, 1449, 2, 0, NULL, 0, '2024-11-12 11:55:43', '2024-11-12 13:02:36', '2024-11-12', 'P5717', '24-07494-11-12', '', 0.00, 65.14, 14.11, 0.00, 0, 0.00, 2.50, 'Calle olimpiadas 13', 'Ejido (El)', 'Almería', '04700', 'España', 81.32, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-121124-MZb6kXxTwebQo-130', '7de405be-2fe6-4a09-bdbc-bb78beb835e5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-121124-MZb6kXxTwebQo-130&s=KOL2024&nf=P5717&i=81.31&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(6088, 1, 4, 2, 0, NULL, 0, '2024-11-12 15:34:29', '2024-11-13 09:09:57', '2024-11-13', 'P5718', '24-07495-11-12', '', 0.00, 179.14, 37.62, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 216.76, 0, '2024-11-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131124-QF5+uf3LnViwR-239', 'b435be25-aa38-478b-b9ca-fc4eea383cff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-QF5%2Buf3LnViwR-239&s=KOL2024&nf=P5718&i=216.76&cr=026', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6089, 1, 1518, 2, 0, NULL, 0, '2024-11-12 18:40:08', '2024-11-13 09:12:14', '2024-11-13', 'P5719', '24-07497-11-12', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Passatge Gaudi, 4', 'Vic', 'Barcelona', '08500', 'España', 17.50, 0, '2024-11-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131124-c+gjaxx57oLY5-128', '0e5a7ea9-ff9f-433d-a0dc-6a8bf0fc3d71', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-c%2Bgjaxx57oLY5-128&s=KOL2024&nf=P5719&i=17.50&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6090, 1, 1519, 2, 0, NULL, 0, '2024-11-13 06:48:43', '2024-11-13 09:13:58', '2024-11-13', 'P5720', '24-07498-11-13', 'Tienda La Despensa Canina', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle del Comercio 10B', 'Gandia', 'Valencia', '46701', 'España', 30.61, 0, '2024-11-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131124-f+3bCwy6GwE8a-026', '56c94929-ed06-474c-90cc-3b1f1c3a2602', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-f%2B3bCwy6GwE8a-026&s=KOL2024&nf=P5720&i=30.61&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6091, 1, 262, 2, 0, NULL, 0, '2024-11-13 06:58:14', '2024-11-13 09:19:19', '2024-11-13', 'P5721', '24-07499-11-13', 'Cerrado: jueves tarde, sabado tarde y lunes.', 0.00, 93.62, 19.66, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 113.28, 0, '2024-11-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131124-LTQGr9HDkEXKi-199', '948f91bb-3b15-429c-8d58-1db27f94ed54', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-LTQGr9HDkEXKi-199&s=KOL2024&nf=P5721&i=113.28&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6092, 1, 220, 2, 0, NULL, 0, '2024-11-13 11:26:54', '2024-11-13 17:01:21', '2024-11-13', 'P5725', '24-07500-11-13', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-131124-Wj/G1ZWcmhz6y-151', 'c1c7663b-170e-45ee-841a-2c6dd8fb3e7e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-Wj%2FG1ZWcmhz6y-151&s=KOL2024&nf=P5725&i=206.91&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(6093, 1, 538, 2, 0, NULL, 0, '2024-11-13 12:16:58', '2024-11-13 17:04:55', '2024-11-13', 'P5722', '24-07501-11-13', 'Hay dos n24, es el que tiene una placa que pone Cal Sellarès.', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/Raval n24', 'Olesa de Bonesvalls', 'Barcelona', '08795', 'España', 43.71, 0, '2024-11-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131124-Xt1f930cpfDdb-195', '84239043-91c9-4664-a0e5-429659f75475', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131124-Xt1f930cpfDdb-195&s=KOL2024&nf=P5722&i=43.71&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
