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
(5590, 1, 1386, 2, 0, NULL, 0, '2024-08-21 12:44:39', '2024-08-22 08:47:58', '2024-08-22', 'P5240', '24-06960-08-21', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'garaibide 5', 'Zuia', 'Álava', '01139', 'España', 56.82, 0, '2024-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220824-IKuE4sRHW3eqj-018', '67708322-36ff-4b30-97e9-bbd55f9b1480', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220824-IKuE4sRHW3eqj-018&s=KOL2024&nf=P5240&i=56.82&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5591, 1, 888, 2, 0, NULL, 0, '2024-08-21 16:09:14', '2024-08-22 08:52:51', '2024-08-22', 'P5241', '24-06961-08-21', 'LLAMEN AL 654259093 SI NO CONTESTA EL PRIMER NÚMERO', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'CALLE ARENAL 23', 'Yuncos', 'Toledo', '45210', 'España', 71.98, 0, '2024-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220824-dWk18qO829TPQ-082', '11df8091-534b-4140-863c-6768d71f40b5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220824-dWk18qO829TPQ-082&s=KOL2024&nf=P5241&i=71.98&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5592, 1, 1387, 2, 0, NULL, 0, '2024-08-21 18:21:57', '2024-08-22 09:28:45', '2024-08-22', 'P5242', '24-06962-08-21', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Monasterio de sigena 2 esc2 4D ', 'Huesca', 'Huesca', '22005', 'España', 196.56, 0, '2024-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220824-AzIM2NXY9h412-098', 'c956a56e-e777-4220-9336-e9e5d7c4f96f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220824-AzIM2NXY9h412-098&s=KOL2024&nf=P5242&i=196.56&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5593, 1, 7, 1, 0, NULL, 0, '2024-08-22 09:46:54', '2024-08-22 09:48:39', '2024-08-22', 'P5244', '2024-08-22', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 344.85, 0, '2024-08-22 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220824-bwKjInR9ZVEwz-137', '2db6426a-86ca-423e-809d-932d78d167dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220824-bwKjInR9ZVEwz-137&s=KOL2024&nf=P5244&i=344.85&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5594, 1, 1134, 1, 0, NULL, 0, '2024-08-22 10:11:55', '2024-08-22 10:11:55', '2024-08-22', 'P5245', '2024-08-22', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Aoiz 14, bajo.   ', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 103.46, 0, '2024-08-22 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220824-YJUkVqRB8KIcx-095', 'abfc744c-0346-4ec1-9fe6-7b78464cd608', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220824-YJUkVqRB8KIcx-095&s=KOL2024&nf=P5245&i=103.46&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5595, 1, 278, 2, 0, NULL, 0, '2024-08-22 08:26:15', '2024-08-22 11:18:11', '2024-08-22', 'P5246', '24-06964-08-22', 'ENTREGA EN HORARIO COMERCIAL DE 10.00 A 13,30 Y DE 17,30 A 20,30. MUCHAS GRACIAS', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'INNOVA . PSO SAN JUAN BOSCO 27 BJ', 'Monzón', 'Huesca', '22400', 'España', 30.61, 0, '2024-08-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220824-lb7VQ57MbeNYr-215', '30c99840-dd0c-4b83-9526-7cb47c358bc1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220824-lb7VQ57MbeNYr-215&s=KOL2024&nf=P5246&i=30.61&cr=027', '[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
(5596, 1, 154, 2, 0, NULL, 0, '2024-08-22 09:48:21', '2024-08-22 11:55:35', '2024-08-22', 'P5247', '24-06965-08-22', '', 0.00, 223.92, 47.02, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 270.94, 0, '2024-08-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220824-cLoWerDiVkyg8-247', '0abace23-3288-4aac-b9e4-6babae3e0153', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220824-cLoWerDiVkyg8-247&s=KOL2024&nf=P5247&i=270.94&cr=112', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5597, 1, 604, 2, 0, NULL, 0, '2024-08-22 10:17:35', '2024-08-22 12:18:36', '2024-08-22', 'P5248', '24-06967-08-22', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'c/ Julio caro baroja 6 bajo', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 65.52, 0, '2024-08-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220824-S3Gd8Fq28FdTm-219', '16fe93c3-69db-45ca-ac45-dfc808c8099c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220824-S3Gd8Fq28FdTm-219&s=KOL2024&nf=P5248&i=65.52&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5598, 1, 1388, 1, 0, NULL, 0, '2024-08-22 13:07:41', '2024-08-22 13:28:00', '2024-08-23', 'P5249', '2024-08-22', '', 0.00, 197.79, 41.54, 0.00, 0, 0.00, 0.00, 'C/ Hondarribi 26 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20005', 'España', 239.33, 0, '2024-08-22 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230824-kFyONEhZP/MkQ-022', '085db7f4-c5cf-4ea5-927d-1e698c64bfbc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230824-kFyONEhZP%2FMkQ-022&s=KOL2024&nf=P5249&i=239.33&cr=082', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5599, 1, 17, 2, 0, NULL, 0, '2024-08-22 13:01:33', '2024-08-23 09:14:15', '2024-08-23', 'P5250', '24-06968-08-22', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 172.43, 0, '2024-08-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230824-Lo98pF5h5uPZC-088', '7ec64da4-b507-4c53-9eb2-b70384fd3090', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230824-Lo98pF5h5uPZC-088&s=KOL2024&nf=P5250&i=172.43&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5600, 1, 236, 2, 0, NULL, 0, '2024-08-22 19:12:29', '2024-08-23 09:17:35', '2024-08-23', 'P5251', '24-06969-08-22', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'AVDA. DE LA POLICÍA NACIONAL, EDF. DONI IVES, 24', 'Antequera', 'Málaga', '29200', 'España', 241.40, 0, '2024-08-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230824-m9ns8riReUn3x-192', 'd552a4bd-14b3-46df-9a65-b946cd4b8bdc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230824-m9ns8riReUn3x-192&s=KOL2024&nf=P5251&i=241.40&cr=182', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5601, 1, 912, 2, 0, NULL, 0, '2024-08-22 19:13:26', '2024-08-23 09:21:00', '2024-08-23', 'P5252', '24-06970-08-22', '', 0.00, 63.15, 13.26, 0.00, 0, 0.00, 0.00, 'Vid2', 'Almagro', 'Ciudad Real', '13270', 'España', 76.41, 0, '2024-08-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230824-FXzInp3Q3qfaA-065', '5937a82f-ccf2-4a98-817c-c0f6e5f132aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230824-FXzInp3Q3qfaA-065&s=KOL2024&nf=P5252&i=76.41&cr=240', '[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
(5602, 1, 1014, 2, 0, NULL, 0, '2024-08-23 08:05:50', '2024-08-23 10:22:17', '2024-08-23', 'P5253', '24-06971-08-23', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Belorrieta 2, 2D', 'Aretxabaleta', 'Gipuzkoa', '20550', 'España', 61.09, 0, '2024-08-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230824-lTixczHN3hzAk-148', '1e83e2f0-d385-4582-a99a-da7270a0a1c8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230824-lTixczHN3hzAk-148&s=KOL2024&nf=P5253&i=61.09&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5603, 1, 239, 1, 0, NULL, 0, '2024-08-23 11:40:16', '2024-08-23 11:40:16', '2024-08-23', 'P5254', '2024-08-23', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'San Marcial 37', 'Donostia', 'Gipuzkoa', '20005', 'España', 137.94, 0, '2024-08-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230824-eKl+8OsVJ+wo/-248', '27f65cb1-7704-426d-9938-e369880efe01', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230824-eKl%2B8OsVJ%2Bwo%2F-248&s=KOL2024&nf=P5254&i=137.94&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5604, 1, 696, 1, 0, NULL, 0, '2024-08-23 12:13:10', '2024-08-23 12:13:10', '2024-08-23', 'P5255', '2024-08-23', '', 0.00, 42.90, 9.01, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 51.91, 0, '2024-08-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230824-hX9u7jmaeF6dl-178', 'ed5da360-df91-4e63-8a6f-6b88430a1e6b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230824-hX9u7jmaeF6dl-178&s=KOL2024&nf=P5255&i=51.91&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5605, 1, 522, 2, 0, NULL, 0, '2024-08-23 14:30:34', '2024-08-26 08:25:04', '2024-08-26', 'P5256', '24-06972-08-23', 'Abrimos de lunes a viernes de 10h a 18:30 ', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 172.43, 0, '2024-08-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260824-pVlPe4AV+se/2-124', '0061e3d1-be0e-48e7-b148-c7c4f17211a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-pVlPe4AV%2Bse%2F2-124&s=KOL2024&nf=P5256&i=172.43&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5606, 1, 53, 2, 0, NULL, 0, '2024-08-24 14:09:04', '2024-08-26 08:27:15', '2024-08-26', 'P5265', '24-06973-08-24', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-260824-lAImqwSVkjedt-195', '76ecae96-6d81-4742-a745-786a1fd7266d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-lAImqwSVkjedt-195&s=KOL2024&nf=P5265&i=209.41&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5607, 1, 701, 2, 0, NULL, 0, '2024-08-24 15:37:45', '2024-08-26 08:29:07', '2024-08-26', 'P5257', '24-06974-08-24', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Rua Palamios 21', 'Pontevedra', 'Pontevedra', '36001', 'España', 56.82, 0, '2024-08-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260824-SBNM0j0gldU37-171', 'ee3dffbc-6fb7-41ca-a2f0-9f78378056cb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-SBNM0j0gldU37-171&s=KOL2024&nf=P5257&i=56.82&cr=059', '[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
(5608, 1, 1332, 2, 0, NULL, 0, '2024-08-24 16:44:09', '2024-08-26 08:31:46', '2024-08-26', 'P5258', '24-06975-08-24', 'Si no estoy en casa, dejar en el felpudo, gracias ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Juan XXIII, 7,4A', 'Barakaldo', 'Bizkaia', '48903', 'España', 30.61, 0, '2024-08-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260824-mEA+4/R0QC7Kc-170', '9123b291-b1d3-4c33-8d73-57be23df76fb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-mEA%2B4%2FR0QC7Kc-170&s=KOL2024&nf=P5258&i=30.61&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5609, 1, 85, 2, 0, NULL, 0, '2024-08-24 21:40:48', '2024-08-24 21:40:48', '2024-08-24', '', '24-06976-08-24', NULL, 0.00, 203.56, 42.75, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 246.31, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(5610, 1, 85, 2, 0, NULL, 0, '2024-08-24 21:40:52', '2024-08-26 08:44:57', '2024-08-26', 'P5266', '24-06977-08-24', '', 0.00, 203.56, 42.75, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 246.31, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260824-jSofBlI6Gf83H-154', '094b880f-c22f-42bf-88fb-00e3bb99be04', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-jSofBlI6Gf83H-154&s=KOL2024&nf=P5266&i=246.31&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5611, 1, 798, 2, 0, NULL, 0, '2024-08-25 09:11:22', '2024-08-26 08:46:10', '2024-08-26', 'P5259', '24-06978-08-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Lepanto ,3. 1C', 'Arrigorriaga', 'Bizkaia', '48480', 'España', 30.61, 0, '2024-08-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260824-RPsnsAMGV7VJP-003', '430a24b9-02a5-47e8-88b1-c76a79e9fed4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-RPsnsAMGV7VJP-003&s=KOL2024&nf=P5259&i=30.61&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5612, 1, 1389, 2, 0, NULL, 0, '2024-08-25 11:57:39', '2024-08-26 08:48:38', '2024-08-26', 'P5260', '24-06979-08-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Zubimusu kalea, 5. 3D', 'Zestoa', 'Gipuzkoa', '20740', 'España', 30.61, 0, '2024-08-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260824-nZfwM+uybLy7i-251', 'd6ef335c-8c89-493c-8e99-3aff4c326124', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-nZfwM%2BuybLy7i-251&s=KOL2024&nf=P5260&i=30.61&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5613, 1, 405, 2, 0, NULL, 0, '2024-08-25 20:30:31', '2024-08-26 08:50:45', '2024-08-26', 'P5261', '24-06980-08-25', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Plaça Cots, 3, 5-2', 'Manresa', 'Barcelona', '08240', 'España', 65.52, 0, '2024-08-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260824-R4W7uNtdwcpx+-107', '8b83b52d-58a9-48ed-acaa-95faccf3f345', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-R4W7uNtdwcpx%2B-107&s=KOL2024&nf=P5261&i=65.52&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5614, 1, 262, 2, 0, NULL, 0, '2024-08-26 05:40:03', '2024-08-26 08:53:09', '2024-08-26', 'P5262', '24-06982-08-26', '', 0.00, 118.04, 24.79, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura, peluquería), Local', 'Girona', 'Girona', '17003', 'España', 142.83, 0, '2024-08-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260824-eqn2Ns3F158mB-253', '3ba0b2c2-5734-4397-aa76-e7c1779bc79e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-eqn2Ns3F158mB-253&s=KOL2024&nf=P5262&i=142.83&cr=186', '[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
(5615, 1, 121, 2, 0, NULL, 0, '2024-08-26 05:55:17', '2024-08-26 08:55:48', '2024-08-26', 'P5263', '24-06983-08-26', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 172.43, 0, '2024-08-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260824-PsOVgzxwPYwDC-181', '55e3752e-00f8-4aae-8171-a457ad810d54', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-PsOVgzxwPYwDC-181&s=KOL2024&nf=P5263&i=172.43&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5616, 1, 121, 2, 0, NULL, 0, '2024-08-26 05:58:43', '2024-08-26 08:59:21', '2024-08-26', 'P5264', '24-06984-08-26', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 172.42, 0, '2024-08-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260824-J3VrIDlX+psYJ-105', '3e311d94-60c8-4c58-9d38-2288ff6c7ea1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-J3VrIDlX%2BpsYJ-105&s=KOL2024&nf=P5264&i=172.42&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5617, 1, 131, 2, 0, NULL, 0, '2024-08-26 07:03:39', '2024-08-26 09:22:59', '2024-08-26', 'P5267', '24-06985-08-26', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260824-i1zn0MPw30Ry4-160', '2e817c87-78ac-4eb8-b273-f18658ecf1e2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-i1zn0MPw30Ry4-160&s=KOL2024&nf=P5267&i=413.82&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5618, 1, 152, 1, 0, NULL, 0, '2024-08-26 09:50:40', '2024-08-26 09:56:09', '2024-08-26', 'P5268', '2024-08-26', '', 0.00, 235.95, 49.55, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 285.50, 0, '2024-08-26 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260824-fev7UghR54KqQ-161', 'f5e91928-3f46-45be-a1a4-9c56514d0982', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-fev7UghR54KqQ-161&s=KOL2024&nf=P5268&i=285.50&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5619, 1, 246, 2, 0, NULL, 0, '2024-08-26 07:53:58', '2024-08-26 10:00:40', '2024-08-26', 'P5269', '24-06986-08-26', '', 0.00, 65.12, 13.67, 0.00, 0, 0.00, 0.00, 'iparraguirre 9 bis', 'Bilbao', 'Bizkaia', '48009', 'España', 78.80, 0, '2024-08-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260824-TR93AlNeVwE8R-168', '216c70e6-654d-4dda-a6f8-36cb40f52d8b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-TR93AlNeVwE8R-168&s=KOL2024&nf=P5269&i=78.80&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5620, 1, 28, 2, 0, NULL, 0, '2024-08-26 08:23:58', '2024-08-26 11:03:10', '2024-08-26', 'P5270', '24-06987-08-26', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 172.43, 0, '2024-08-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260824-LDUgaJ8fYqNss-168', 'c8519f63-920a-406b-9930-124a18026413', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-LDUgaJ8fYqNss-168&s=KOL2024&nf=P5270&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);
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
(5621, 1, 1390, 2, 0, NULL, 0, '2024-08-26 08:49:36', '2024-08-26 11:07:18', '2024-08-26', 'P5271', '24-06988-08-26', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Maquinilla 13 portal C piso 8 puerta 2', 'Madrid', 'Madrid', '28031', 'España', 30.61, 0, '2024-08-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260824-EKgRfjyCOrUT9-205', '382fa7c0-1bc9-4975-b5a1-2eb006ed4297', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-EKgRfjyCOrUT9-205&s=KOL2024&nf=P5271&i=30.61&cr=247', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5622, 1, 754, 2, 0, NULL, 0, '2024-08-26 08:54:53', '2024-08-26 11:12:37', '2024-08-26', 'P5272', '24-06989-08-26', '6+1 REGALO OTRO CASTAÑO', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas, 166 2n 1a', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-08-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260824-kQAbI46tZrXft-240', '9be2b13f-d645-4489-be0b-ca2abd1ceabf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-kQAbI46tZrXft-240&s=KOL2024&nf=P5272&i=61.64&cr=237', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5623, 1, 1391, 2, 0, NULL, 0, '2024-08-26 09:29:27', '2024-08-26 11:40:49', '2024-08-26', 'P5273', '24-06990-08-26', 'Dejar al conserje ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Juan Antonio Vallejo Najera Botas,25- portal i-6D', 'Madrid', 'Madrid', '28005', 'España', 17.50, 0, '2024-08-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260824-EJ3w51o/TzM+N-092', 'ed518c14-a5c0-4eed-9a17-86e6537da101', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-EJ3w51o%2FTzM%2BN-092&s=KOL2024&nf=P5273&i=17.50&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5624, 1, 77, 1, 0, NULL, 0, '2024-08-26 12:05:47', '2024-08-26 12:05:47', '2024-08-26', 'P5274', '', '', 0.00, 986.70, 207.21, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1193.91, 0, '2024-08-26 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260824-f5RdLhBI4dh/i-047', 'b82d88e1-987f-439e-9bc8-75ace934fde6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-f5RdLhBI4dh%2Fi-047&s=KOL2024&nf=P5274&i=1193.91&cr=092', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5625, 1, 365, 2, 0, NULL, 0, '2024-08-26 14:56:03', '2024-08-26 22:44:34', '2024-08-26', 'P5275', '24-06991-08-26', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Rúa Condesa Casa Bárcena, 12, 10A', 'Vigo', 'Pontevedra', '36204', 'España', 30.61, 0, '2024-08-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260824-JFdzipcecJfh0-107', 'a35bc204-5ef8-4b78-be7d-3a2576104d10', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260824-JFdzipcecJfh0-107&s=KOL2024&nf=P5275&i=30.61&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5626, 1, 23, 2, 0, NULL, 0, '2024-08-27 07:05:33', '2024-08-27 09:13:41', '2024-08-27', 'P5276', '24-06993-08-27', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 103.46, 0, '2024-08-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270824-L5/ERI96yX7sz-148', 'f16844f3-f5bb-40dd-b3f6-5bb7fa311ede', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270824-L5%2FERI96yX7sz-148&s=KOL2024&nf=P5276&i=103.46&cr=064', '[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
(5627, 1, 752, 2, 0, NULL, 0, '2024-08-27 07:46:38', '2024-08-27 07:46:38', '2024-08-27', 'P5277', '24-06994-08-27', 'Concesionario IMP SPORT BILBAO ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Poligono Iru bide 2-3. Pabellón 5, Concesionario imp sport bilbao', 'Galdakao', 'Bizkaia', '48960', 'España', 30.61, 0, '2024-08-27 07:46:37', '', '', 3, 5, 1, 'TBAI-B20930640-270824-Nh5jZTGOMTWhT-102', '34688386-bd79-4694-ac17-a2b18e4e6241', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270824-Nh5jZTGOMTWhT-102&s=KOL2024&nf=P5277&i=30.61&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(5628, 1, 1110, 2, 0, NULL, 0, '2024-08-27 09:53:39', '2024-08-27 11:57:48', '2024-08-27', 'P5278', '24-06995-08-27', '', 0.00, 81.40, 17.09, 0.00, 0, 0.00, 0.00, 'C/unió N015', 'Lleida', 'Lleida', '25002', 'España', 98.49, 0, '2024-08-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270824-cB7r9wTd3pcI8-042', 'd1297086-380f-47b9-bb57-efbd6edde3bf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270824-cB7r9wTd3pcI8-042&s=KOL2024&nf=P5278&i=98.49&cr=208', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5629, 1, 30, 2, 0, NULL, 0, '2024-08-27 14:58:41', '2024-08-28 09:18:59', '2024-08-28', 'P5279', '24-06996-08-27', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Calle González tablas, 3 bajo', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 344.85, 0, '2024-08-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280824-Ggg79v/wWVIav-099', 'f10930f4-38aa-4db0-a232-c2afab335b98', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280824-Ggg79v%2FwWVIav-099&s=KOL2024&nf=P5279&i=344.85&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5630, 1, 1392, 2, 0, NULL, 0, '2024-08-27 15:28:52', '2024-08-28 09:17:17', '2024-08-28', 'P5280', '24-06997-08-27', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ 9 de Octubre 18', 'Casinos', 'Valencia', '46171', 'España', 28.39, 0, '2024-08-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280824-XfaXg98KwKleN-040', '6a34cf76-5e8f-46be-bbee-30584d359572', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280824-XfaXg98KwKleN-040&s=KOL2024&nf=P5280&i=28.39&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5631, 1, 57, 1, 0, NULL, 0, '2024-08-28 09:24:41', '2024-08-28 09:27:08', '2024-08-28', 'P5281', '', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 241.40, 0, '2024-08-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280824-A/ta7/suLkS4Q-117', '57140cea-117e-4f15-96a6-1521989a73c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280824-A%2Fta7%2FsuLkS4Q-117&s=KOL2024&nf=P5281&i=241.40&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5632, 1, 166, 1, 0, NULL, 0, '2024-08-28 09:41:38', '2024-08-28 09:42:20', '2024-08-28', 'P5282', '', '', 0.00, 296.01, 62.16, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 358.17, 0, '2024-08-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280824-eMcav4fdY/aAg-029', '7aba23a1-be63-4f73-9863-f969eb23115a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280824-eMcav4fdY%2FaAg-029&s=KOL2024&nf=P5282&i=358.17&cr=003', '[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
(5633, 1, 1033, 2, 0, NULL, 0, '2024-08-28 08:09:13', '2024-08-28 10:14:24', '2024-08-28', 'P5283', '24-06998-08-28', '', 0.00, 48.84, 10.25, 0.00, 0, 0.00, 0.00, 'Lersundi 18 bajo peluqueria Ilea', 'Deba', 'Gipuzkoa', '20820', 'España', 59.10, 0, '2024-08-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280824-RicGpI4O7rJp4-116', '8dc84628-8664-4461-a5d4-fda96ab53a78', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280824-RicGpI4O7rJp4-116&s=KOL2024&nf=P5283&i=59.10&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5634, 1, 694, 2, 0, NULL, 0, '2024-08-28 09:07:49', '2024-08-28 11:22:55', '2024-08-28', 'P5284', '24-06999-08-28', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'DICES 33', 'Rois', 'A Coruña', '15911', 'España', 30.61, 0, '2024-08-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280824-bZSv/hcUEjpIO-014', 'b081f2f5-467f-4e0c-8288-7b89de9ecb75', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280824-bZSv%2FhcUEjpIO-014&s=KOL2024&nf=P5284&i=30.61&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5635, 1, 113, 1, 0, NULL, 0, '2024-08-28 12:59:18', '2024-08-29 09:03:08', '2024-08-29', 'P5285', '', '', 0.00, 48.84, 10.69, 0.00, 0, 0.00, 2.50, 'AVENIDA DE LOS LABRADORES 5 LOCAL3', 'Tres Cantos', 'Madrid', '28760', 'España', 61.60, 0, '2024-08-28 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290824-k04Kb7Tf7HLlg-238', '98f51f80-a6a6-4ad2-8cc1-080adade02f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290824-k04Kb7Tf7HLlg-238&s=KOL2024&nf=P5285&i=61.60&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5636, 1, 754, 2, 0, NULL, 0, '2024-08-28 12:01:55', '2024-08-29 09:00:55', '2024-08-29', 'P5286', '24-07000-08-28', '6+1 REGALO PREBASE DORADA', 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-08-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290824-dVTOG6p/m+GCg-108', '5d4d9d6d-6f9c-4373-93b0-a72f6a62012e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290824-dVTOG6p%2Fm%2BGCg-108&s=KOL2024&nf=P5286&i=61.64&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5637, 1, 460, 2, 0, NULL, 0, '2024-08-28 13:35:17', '2024-08-29 09:03:47', '2024-08-29', 'P5287', '24-07002-08-28', 'Es en Mutilva Alta', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Santxiki 13, 1C', 'Aranguren', 'Navarra', '31192', 'España', 65.52, 0, '2024-08-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-290824-bY5iDz24/nwp+-081', 'ac865f25-d7dd-4bc4-8030-ebd68b3ca89a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290824-bY5iDz24%2Fnwp%2B-081&s=KOL2024&nf=P5287&i=65.52&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5638, 1, 1393, 2, 0, NULL, 0, '2024-08-28 19:31:26', '2024-08-29 09:04:22', '2024-08-29', 'P5288', '24-07003-08-28', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Plaza Urbialde 1, bajo, Correos Ecomerce', 'Beasain', 'Gipuzkoa', '20200', 'España', 28.39, 0, '2024-08-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290824-jQi92xFDnk4fp-082', '50a1df51-40db-40b1-b3d4-94b6aec39a5d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290824-jQi92xFDnk4fp-082&s=KOL2024&nf=P5288&i=28.39&cr=041', '[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
(5639, 1, 1394, 2, 0, NULL, 0, '2024-08-28 19:59:01', '2024-08-29 09:05:09', '2024-08-29', 'P5289', '24-07004-08-28', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Valle de Oro 48 A', 'Madrid', 'Madrid', '28019', 'España', 30.61, 0, '2024-08-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-290824-MG8YzfC03EwVt-221', '76864036-443c-45ca-a24b-a938b5b72786', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290824-MG8YzfC03EwVt-221&s=KOL2024&nf=P5289&i=30.61&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5640, 1, 1395, 2, 0, NULL, 0, '2024-08-29 08:31:56', '2024-08-29 10:49:34', '2024-08-29', 'P5290', '24-07005-08-29', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Oyón 2, 1º A', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 30.61, 0, '2024-08-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290824-Hqta6T11COZjK-178', '342bdaf5-f388-4988-8d45-84cbc6a4042c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290824-Hqta6T11COZjK-178&s=KOL2024&nf=P5290&i=30.61&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5641, 1, 40, 2, 0, NULL, 0, '2024-08-29 10:15:43', '2024-08-29 12:29:16', '2024-08-29', 'P5291', '24-07007-08-29', 'martes cerrado y lunes tambien', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 137.94, 0, '2024-08-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290824-epU20ypPasdM0-041', 'eaeec54f-1d24-4d28-9652-ed809c7f1cfb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290824-epU20ypPasdM0-041&s=KOL2024&nf=P5291&i=137.94&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5642, 1, 1318, 2, 0, NULL, 0, '2024-08-29 11:56:01', '2024-08-30 08:23:35', '2024-08-30', 'P5292', '24-07008-08-29', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'carrer San Jaume 37', 'Sant Iscle de Vallal', 'Barcelona', '08359', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300824-QyeWei7yvt6gC-214', '7228e35f-8dc1-4268-85bd-71965d2e21a5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300824-QyeWei7yvt6gC-214&s=KOL2024&nf=P5292&i=17.50&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5643, 1, 75, 2, 0, NULL, 0, '2024-08-30 08:26:17', '2024-08-30 10:36:37', '2024-08-30', 'P5293', '24-07009-08-30', 'De martes a viernes de 10 a 19:00', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 206.91, 0, '2024-08-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300824-CSeh5eX1wLVNZ-029', '30f6e5c0-f20f-4325-b055-9b173d2f9c6d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300824-CSeh5eX1wLVNZ-029&s=KOL2024&nf=P5293&i=206.91&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5644, 1, 1050, 2, 0, NULL, 0, '2024-08-30 10:16:03', '2024-08-30 12:16:54', '2024-08-30', 'P5295', '24-07010-08-30', '', 0.00, 85.50, 18.39, 0.00, 1, 4.55, 2.50, 'Carlos caamaño,3', 'Madrid', 'Madrid', '28016', 'España', 110.51, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-300824-TgAaJ9Dv9HJOL-044', '4d427055-a567-4bbc-a5ba-05bc36fc198a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300824-TgAaJ9Dv9HJOL-044&s=KOL2024&nf=P5295&i=110.51&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
