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
(4865, 1, 662, 2, 0, NULL, 0, '2024-04-10 08:17:20', '2024-04-10 11:53:48', '2024-04-10', 'P4551', '24-06177-04-10', 'Si no contesto al timbre llamar al telefono', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle general josep moragues, 5 bjo1', 'Gavà', 'Barcelona', '08850', 'España', 65.52, 0, '2024-04-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100424-pVSPIO8PIZyq8-218', 'f3624ea3-ff68-4235-b48d-9d8e7e48a08b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100424-pVSPIO8PIZyq8-218&s=KOL2024&nf=P4551&i=65.52&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4866, 1, 1227, 2, 0, NULL, 0, '2024-04-10 11:56:30', '2024-04-10 13:57:19', '2024-04-10', 'P4552', '24-06178-04-10', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle los cantos 24 2° B', 'Alcorcón', 'Madrid', '28922', 'España', 28.39, 0, '2024-04-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100424-Bqlaet/0nnte5-045', 'ef4bd46e-2fa9-40ad-99da-8df2bc8b2d59', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100424-Bqlaet%2F0nnte5-045&s=KOL2024&nf=P4552&i=28.39&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4867, 1, 1075, 2, 0, NULL, 0, '2024-04-10 12:50:20', '2024-04-11 08:47:05', '2024-04-11', 'P4555', '24-06179-04-10', '', 0.00, 472.28, 99.18, 0.00, 0, 0.00, 0.00, 'Avenida Ferrocarril 2b,  entrada por General Eguia frente al n 31,BORGANICA', 'Bilbao', 'Bizkaia', '48013', 'España', 571.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110424-WJb/61QGW4gYH-147', '98309101-f6f3-4068-b941-2b134870a02e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110424-WJb%2F61QGW4gYH-147&s=KOL2024&nf=P4555&i=571.46&cr=045', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4868, 1, 1228, 2, 0, NULL, 0, '2024-04-10 13:21:30', '2024-04-11 08:53:04', '2024-04-11', 'P4553', '24-06180-04-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Koskontako Bidea,1,5°C', 'Lesaka', 'Navarra', '31770', 'España', 30.61, 0, '2024-04-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110424-GXx3DoTk9vnsr-181', 'b741af76-96bb-44b3-9075-d8e82c9d9379', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110424-GXx3DoTk9vnsr-181&s=KOL2024&nf=P4553&i=30.61&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4869, 1, 1229, 2, 0, NULL, 0, '2024-04-10 18:45:58', '2024-04-11 08:56:53', '2024-04-11', 'P4554', '24-06181-04-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Santa Eulalia, 18 B', 'Berrioplano', 'Navarra', '31195', 'España', 30.61, 0, '2024-04-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110424-gpgItHK+eHLgl-157', 'a565a3bc-c6d1-4651-879e-0fc1b3d9a922', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110424-gpgItHK%2BeHLgl-157&s=KOL2024&nf=P4554&i=30.61&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4870, 1, 687, 1, 0, NULL, 0, '2024-04-11 09:03:50', '2024-04-11 09:04:23', '2024-04-11', 'P4556', '', '', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 88.67, 0, '2024-04-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110424-f4RCNWQk+OBYB-048', '30738d5b-a3da-4d03-b43f-1abd43199e11', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110424-f4RCNWQk%2BOBYB-048&s=KOL2024&nf=P4556&i=88.67&cr=233', '[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
(4871, 1, 239, 1, 0, NULL, 0, '2024-04-11 10:31:23', '2024-04-11 10:31:23', '2024-04-11', 'P4557', '', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'San Marcial 37', 'Donostia', 'Gipuzkoa', '20005', 'España', 68.97, 0, '2024-04-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110424-Rb2ardO7paPDO-094', 'ec677c83-382e-40bd-959e-bc0e920ed713', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110424-Rb2ardO7paPDO-094&s=KOL2024&nf=P4557&i=68.97&cr=220', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4872, 1, 152, 1, 0, NULL, 0, '2024-04-11 10:50:17', '2024-04-11 10:50:17', '2024-04-11', 'P4558', '', '', 0.00, 145.86, 30.63, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 176.49, 0, '2024-04-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110424-MMPDLNrKTLQif-208', '019ff1a0-eb1a-4885-bd5d-f3fae5597557', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110424-MMPDLNrKTLQif-208&s=KOL2024&nf=P4558&i=176.49&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4873, 1, 121, 2, 0, NULL, 0, '2024-04-11 08:53:34', '2024-04-11 11:36:29', '2024-04-11', 'P4559', '24-06182-04-11', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 206.91, 0, '2024-04-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-110424-oLz4YPM85evpS-109', '1828c44d-4d32-4321-a77c-bc5c46ec33c3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110424-oLz4YPM85evpS-109&s=KOL2024&nf=P4559&i=206.91&cr=123', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4874, 1, 1230, 2, 0, NULL, 0, '2024-04-11 15:20:21', '2024-04-12 09:42:15', '2024-04-12', 'P4560', '24-06183-04-11', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle Domingo Artes 23 P02 A', 'Almería', 'Almería', '04009', 'España', 65.52, 0, '2024-04-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120424-TevrgnoLGIoHT-226', 'd6e9a1c4-81d4-4896-9496-2df44c49f033', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120424-TevrgnoLGIoHT-226&s=KOL2024&nf=P4560&i=65.52&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4875, 1, 938, 2, 0, NULL, 0, '2024-04-11 20:04:08', '2024-04-12 09:43:22', '2024-04-12', 'P4561', '24-06184-04-11', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Comandante Fortea, 60', 'Madrid', 'Madrid', '28008', 'España', 28.39, 0, '2024-04-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120424-f+x2L4YL7N1bj-009', 'c421e343-65e5-4286-891b-76aa62fb0ae2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120424-f%2Bx2L4YL7N1bj-009&s=KOL2024&nf=P4561&i=28.39&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4876, 1, 522, 2, 0, NULL, 0, '2024-04-12 08:23:40', '2024-04-12 11:24:30', '2024-04-12', 'P4562', '24-06185-04-12', '', 0.00, 179.14, 37.62, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 216.76, 0, '2024-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120424-lw2d7qqrr/7Zq-147', '6dad6bbd-49fc-4f35-b43b-2eb050cbf57a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120424-lw2d7qqrr%2F7Zq-147&s=KOL2024&nf=P4562&i=216.76&cr=151', '[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
(4877, 1, 244, 2, 0, NULL, 0, '2024-04-12 08:43:17', '2024-04-12 11:25:17', '2024-04-12', 'P4563', '24-06186-04-12', 'Si no estoy, entregar en la barbería de al lado.', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'C/ Balmes, 79 Local 3 Peluquería Maimar', 'Calella', 'Barcelona', '08370', 'España', 68.97, 0, '2024-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120424-h7mWb+ZbGx/31-121', '5d2d97d3-e85f-47b1-8704-8ff3f7e80c6d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120424-h7mWb%2BZbGx%2F31-121&s=KOL2024&nf=P4563&i=68.97&cr=190', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4878, 1, 815, 2, 0, NULL, 0, '2024-04-12 11:24:38', '2024-04-15 09:25:20', '2024-04-15', 'P4564', '24-06187-04-12', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Jacinto Benavente, 8', 'Sevilla la Nueva', 'Madrid', '28609', 'España', 56.82, 0, '2024-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150424-RI4nVlimdeNDG-065', 'd3648b28-53b2-4952-80cf-1b4d8031de0f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150424-RI4nVlimdeNDG-065&s=KOL2024&nf=P4564&i=56.82&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4879, 1, 157, 2, 0, NULL, 0, '2024-04-12 19:47:26', '2024-04-15 09:25:42', '2024-04-15', 'P4565', '24-06188-04-12', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'CALLE APODACA,1 LOCAL', 'Madrid', 'Madrid', '28004', 'España', 275.88, 0, '2024-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150424-EJQIdXhyC/OfU-171', '0385a541-5598-4706-af72-4a51f8558b49', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150424-EJQIdXhyC%2FOfU-171&s=KOL2024&nf=P4565&i=275.88&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4880, 1, 157, 2, 0, NULL, 0, '2024-04-12 20:08:54', '2024-04-15 09:26:02', '2024-04-15', 'P4566', '24-06194-04-12', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'CALLE APODACA,1 LOCAL', 'Madrid', 'Madrid', '28004', 'España', 241.40, 0, '2024-04-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150424-VgDgySDGGhDqq-246', 'a99338d6-de0e-4b49-9b15-ecf9b668139d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150424-VgDgySDGGhDqq-246&s=KOL2024&nf=P4566&i=241.40&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4881, 1, 838, 2, 0, NULL, 0, '2024-04-13 05:55:27', '2024-04-15 09:26:29', '2024-04-15', 'P4567', '24-06195-04-13', 'En caso de ausencia entregar en porteria', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Almirante Antonio Gaztañeta 1, 2d', 'Bilbao', 'Bizkaia', '48012', 'España', 61.09, 0, '2024-04-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150424-i/ob9VEaus27Y-039', '960cb5e3-783e-4896-a78d-3c9dd4858575', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150424-i%2Fob9VEaus27Y-039&s=KOL2024&nf=P4567&i=61.09&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4882, 1, 1147, 2, 0, NULL, 0, '2024-04-15 08:32:19', '2024-04-15 08:32:19', '2024-04-15', '', '24-06198-04-15', NULL, 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avenida Aragón 14, Primero C', 'Teruel', 'Teruel', '44001', 'España', 61.09, 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),
(4883, 1, 1147, 2, 0, NULL, 0, '2024-04-15 08:32:22', '2024-04-15 10:59:25', '2024-04-15', 'P4569', '24-06199-04-15', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avenida Aragón 14, Primero C', 'Teruel', 'Teruel', '44001', 'España', 61.09, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150424-asCVxXHYZRhTv-099', '4f56fbc2-2a87-4e42-8050-b9e830d42e9a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150424-asCVxXHYZRhTv-099&s=KOL2024&nf=P4569&i=61.09&cr=131', '[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
(4884, 1, 784, 2, 0, NULL, 0, '2024-04-15 08:48:32', '2024-04-15 10:55:57', '2024-04-15', 'P4568', '24-06200-04-15', '', 0.00, 77.34, 16.24, 0.00, 1, 4.02, 0.00, 'Calle san francisco 30 bis bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20002', 'España', 97.60, 0, '2024-04-15 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-150424-lCWwxUifL3nlk-152', 'f5af6661-8549-4a94-a362-23db1c9e5885', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150424-lCWwxUifL3nlk-152&s=KOL2024&nf=P4568&i=97.60&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4885, 1, 4, 2, 0, NULL, 0, '2024-04-15 10:05:04', '2024-04-15 12:06:49', '2024-04-15', 'P4570', '24-06201-04-15', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 275.88, 0, '2024-04-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150424-npTj6IbpxIY/F-124', '390bacb5-0489-4783-ba0e-2759e7172444', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150424-npTj6IbpxIY%2FF-124&s=KOL2024&nf=P4570&i=275.88&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4886, 1, 474, 1, 0, NULL, 0, '2024-04-15 12:57:31', '2024-04-15 12:57:58', '2024-04-15', 'P4571', '', '', 0.00, 61.06, 13.25, 0.00, 0, 0.00, 2.50, 'C Ntra Sra de los clarines 56', 'Beas', 'Huelva', '21630', 'España', 76.38, 0, '2024-04-15 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-150424-ke3ydFuPNmbya-002', '61815af9-2dfc-47cd-aa96-8ae7fbc076ec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150424-ke3ydFuPNmbya-002&s=KOL2024&nf=P4571&i=76.38&cr=187', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4887, 1, 1075, 2, 0, NULL, 0, '2024-04-15 11:30:55', '2024-04-15 11:30:55', '2024-04-15', '', '24-06179-04-10', 'Peluquería Borganica ', 0.00, 472.28, 99.18, 0.00, 0, 0.00, 0.00, 'Avenida Ferrocarril 2b,  entrada por General Eguia frente al n 31,BORGANICA', 'Bilbao', 'Bizkaia', '48013', 'España', 571.46, 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),
(4888, 1, 1075, 2, 0, NULL, 0, '2024-04-15 11:30:56', '2024-04-15 11:30:56', '2024-04-15', '', '24-06179-04-10', 'Peluquería Borganica ', 0.00, 472.28, 99.18, 0.00, 0, 0.00, 0.00, 'Avenida Ferrocarril 2b,  entrada por General Eguia frente al n 31,BORGANICA', 'Bilbao', 'Bizkaia', '48013', 'España', 571.46, 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),
(4889, 1, 391, 2, 0, NULL, 0, '2024-04-16 07:04:18', '2024-04-16 09:10:55', '2024-04-16', 'P4572', '24-06202-04-16', 'Peluquería mi cabello &Moi', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Paseo Santxiki num14', 'Pamplona/Iruña', 'Navarra', '31192', 'España', 68.97, 0, '2024-04-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160424-b8Y/MoYYG6z28-195', 'd6bf1f65-dbe7-4465-bd9c-43f138a4fc25', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160424-b8Y%2FMoYYG6z28-195&s=KOL2024&nf=P4572&i=68.97&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4890, 1, 23, 2, 0, NULL, 0, '2024-04-16 07:12:47', '2024-04-16 09:14:13', '2024-04-16', 'P4573', '24-06203-04-16', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 137.94, 0, '2024-04-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160424-oFuBiba90UIAe-194', '8da65189-7850-46ce-ba44-b2a2e611239b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160424-oFuBiba90UIAe-194&s=KOL2024&nf=P4573&i=137.94&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4891, 1, 145, 2, 0, NULL, 0, '2024-04-16 11:07:11', '2024-04-16 13:17:52', '2024-04-16', 'P4574', '24-06204-04-16', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-160424-mEMptKnWWrqm2-178', 'f69865fe-690c-4529-ad02-71484b06001a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160424-mEMptKnWWrqm2-178&s=KOL2024&nf=P4574&i=209.41&cr=030', '[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
(4892, 1, 1025, 2, 0, NULL, 0, '2024-04-16 11:40:44', '2024-04-17 10:11:20', '2024-04-17', 'P4575', '24-06205-04-16', 'lunes cerrado', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Artekale  12  bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 275.88, 0, '2024-04-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170424-AVEwHi+Erre8d-227', '95d2959c-515e-43e7-ac2f-c463a981344f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170424-AVEwHi%2BErre8d-227&s=KOL2024&nf=P4575&i=275.88&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4893, 1, 1231, 2, 0, NULL, 0, '2024-04-16 14:21:53', '2024-04-17 10:11:37', '2024-04-17', 'P4576', '24-06206-04-16', 'Planta baja\r\nMasterd Girona', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Emili Grahit 5', 'Girona', 'Girona', '17002', 'España', 17.50, 0, '2024-04-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170424-Mb0ej0uIoQXu2-250', 'b69a4230-dcba-454b-9a7c-a7075c028f24', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170424-Mb0ej0uIoQXu2-250&s=KOL2024&nf=P4576&i=17.50&cr=184', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4894, 1, 28, 2, 0, NULL, 0, '2024-04-16 15:32:35', '2024-04-17 10:12:03', '2024-04-17', 'P4578', '24-06207-04-16', '', 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, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170424-RpQnIe5clMFmq-051', '5ae1e526-8e7c-41d5-bd90-7e52f63f25b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170424-RpQnIe5clMFmq-051&s=KOL2024&nf=P4578&i=172.43&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4895, 1, 28, 2, 0, NULL, 0, '2024-04-16 15:32:38', '2024-04-16 15:32:38', '2024-04-16', '', '24-06208-04-16', NULL, 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, '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),
(4896, 1, 28, 2, 0, NULL, 0, '2024-04-16 15:32:41', '2024-04-16 15:32:41', '2024-04-16', '', '24-06209-04-16', NULL, 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, '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),
(4897, 1, 28, 2, 0, NULL, 0, '2024-04-16 15:32:43', '2024-04-16 15:32:43', '2024-04-16', '', '24-06210-04-16', NULL, 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, '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),
(4898, 1, 696, 1, 0, NULL, 0, '2024-04-17 10:00:19', '2024-04-17 10:12:35', '2024-04-17', 'P4577', '', '', 0.00, 514.80, 108.11, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 622.91, 0, '2024-04-17 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170424-e+eB4Tyh7nKrX-221', 'fa4616b8-a88b-4949-b154-380c71489b17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170424-e%2BeB4Tyh7nKrX-221&s=KOL2024&nf=P4577&i=622.91&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4899, 1, 223, 2, 0, NULL, 0, '2024-04-17 09:56:58', '2024-04-17 12:08:19', '2024-04-17', 'P4579', '24-06211-04-17', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'c/damas apostolicas,8 -bajo D.  A Ramallosa', 'Nigrán', 'Pontevedra', '36370', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-170424-kuhPaWFum0d0o-192', 'b86705d3-e755-4b88-ac9b-2b05be3085bb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170424-kuhPaWFum0d0o-192&s=KOL2024&nf=P4579&i=137.94&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4900, 1, 802, 2, 0, NULL, 0, '2024-04-17 10:30:04', '2024-04-17 12:42:41', '2024-04-17', 'P4580', '24-06212-04-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle/ Poeta Blas de Otero, nº 14.  Piso3ºB', 'Madrid', 'Madrid', '28017', 'España', 17.50, 0, '2024-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170424-M046Ur4Wux5UW-212', 'e429d7f0-f67f-479d-a79b-0c57ccd2b933', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170424-M046Ur4Wux5UW-212&s=KOL2024&nf=P4580&i=17.50&cr=005', '[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
(4901, 1, 581, 2, 0, NULL, 0, '2024-04-17 10:35:27', '2024-04-17 12:43:08', '2024-04-17', 'P4581', '24-06213-04-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'P. Arcillero 3, 6 D', 'Santander', 'Cantabria', '39001', 'España', 17.50, 0, '2024-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170424-S4vokodpk/efn-223', 'b0c01294-2444-4dab-bb22-e0238ccd0c1a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170424-S4vokodpk%2Fefn-223&s=KOL2024&nf=P4581&i=17.50&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4902, 1, 87, 2, 0, NULL, 0, '2024-04-17 10:54:01', '2024-04-17 12:55:32', '2024-04-17', 'P4582', '24-06214-04-17', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Cc arcco local p 17', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 68.97, 0, '2024-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170424-h91MsXi/peXvQ-183', '2c90036f-729f-43cc-9f45-d0cfcd824823', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170424-h91MsXi%2FpeXvQ-183&s=KOL2024&nf=P4582&i=68.97&cr=225', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4903, 1, 17, 2, 0, NULL, 0, '2024-04-17 13:31:25', '2024-04-18 10:03:19', '2024-04-18', 'P4583', '24-06215-04-17', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 103.46, 0, '2024-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180424-AWYvVYy9rG11G-096', '5f792433-f668-4d01-a07a-f36dfb96a267', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180424-AWYvVYy9rG11G-096&s=KOL2024&nf=P4583&i=103.46&cr=103', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4904, 1, 1033, 2, 0, NULL, 0, '2024-04-17 13:43:03', '2024-04-18 10:19:44', '2024-04-18', 'P4587', '24-06216-04-17', '', 0.00, 40.70, 9.74, 0.00, 0, 0.00, 6.90, 'Lersundi 18baji', 'Deba', 'Gipuzkoa', '20820', 'España', 56.15, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-180424-Vt14ujSOU5alM-149', 'bb987d91-0a86-4b17-905a-edf106539602', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180424-Vt14ujSOU5alM-149&s=KOL2024&nf=P4587&i=56.15&cr=110', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4905, 1, 137, 2, 0, NULL, 0, '2024-04-17 14:03:13', '2024-04-18 10:21:33', '2024-04-18', 'P4584', '24-06217-04-17', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Pº ERMITA, 10', 'Madrid', 'Madrid', '28023', 'España', 241.40, 0, '2024-04-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180424-nrJGwYZQZn0up-217', '0c306e96-88a3-43e9-b2b3-77207dd448f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180424-nrJGwYZQZn0up-217&s=KOL2024&nf=P4584&i=241.40&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4906, 1, 1232, 2, 0, NULL, 0, '2024-04-17 21:31:42', '2024-04-17 21:31:42', '2024-04-17', '', '24-06219-04-17', NULL, 0.00, 162.45, 34.11, 0.00, 0, 8.45, 0.00, 'Peluquería  rosarosae c/juan de olazabal  20100 errenteria', 'Errenteria', 'Gipuzkoa', '20100', 'España', 205.01, 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),
(4907, 1, 1036, 2, 0, NULL, 0, '2024-04-17 21:34:10', '2024-04-18 10:59:28', '2024-04-18', 'P4585', '24-06220-04-17', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Gurmendi kalea 10. 1A', 'Zarautz', 'Gipuzkoa', '20800', 'España', 78.63, 0, '2024-04-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180424-ChTvtLNH4y8sT-131', 'a0ae5416-0262-4bec-ae5f-60865a735fb0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180424-ChTvtLNH4y8sT-131&s=KOL2024&nf=P4585&i=78.63&cr=183', '[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
(4908, 1, 1233, 2, 0, NULL, 0, '2024-04-18 07:50:31', '2024-04-18 11:00:45', '2024-04-18', 'P4586', '24-06221-04-18', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Calle fuego, 10, 2A, ', 'Tres Cantos', 'Madrid', '28760', 'España', 61.09, 0, '2024-04-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180424-MIzlCG0QzLOYi-142', '7628e97f-ea76-4e24-8501-16e5c1b3ba6e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180424-MIzlCG0QzLOYi-142&s=KOL2024&nf=P4586&i=61.09&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4909, 1, 1232, 2, 0, NULL, 0, '2024-04-18 08:17:05', '2024-04-18 11:02:12', '2024-04-18', 'P4588', '24-06222-04-18', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'c/juan de olazabal s/n', 'Errenteria', 'Gipuzkoa', '20100', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180424-Xqv36v6wEP9gT-103', '6b79b8e3-4392-46c9-9c74-7add6ab704a9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180424-Xqv36v6wEP9gT-103&s=KOL2024&nf=P4588&i=196.56&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4910, 1, 34, 2, 0, NULL, 0, '2024-04-18 08:26:39', '2024-04-18 11:07:30', '2024-04-18', 'P4589', '24-06223-04-18', 'Factura en papel.\r\nEntregar de martes a viernes antes de las 12.00', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'peluqueria Marzo21 calle iparraguirre34 plaza trasera   Leioa Bizkaia', 'Leioa', 'Bizkaia', '48940', 'España', 551.76, 0, '2024-04-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180424-PoHHeFdIuLou/-058', '618a3444-0f95-4b2a-9a94-c838e108146f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180424-PoHHeFdIuLou%2F-058&s=KOL2024&nf=P4589&i=551.76&cr=198', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4911, 1, 903, 1, 0, NULL, 0, '2024-04-19 09:35:40', '2024-04-19 09:35:40', '2024-04-19', 'P4590', '', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Calle Miño 20 ', 'Estepona', 'Málaga', '29680', 'España', 71.47, 0, '2024-04-19 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-190424-ItQIZmfZVt6Au-001', 'f0983199-c4b8-449b-a840-04a2d6df2a5c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190424-ItQIZmfZVt6Au-001&s=KOL2024&nf=P4590&i=71.47&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4912, 1, 1234, 2, 0, NULL, 0, '2024-04-19 07:48:08', '2024-04-19 10:15:43', '2024-04-19', 'P4591', '24-06225-04-19', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'TECNALIA. Paseo Mikeletegi, 7', 'Donostia-San Sebasti', 'Gipuzkoa', '20009', 'España', 30.61, 0, '2024-04-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190424-j8cBntzvcZXVx-217', 'e879e537-2542-4e86-b445-509f97e020e3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190424-j8cBntzvcZXVx-217&s=KOL2024&nf=P4591&i=30.61&cr=092', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4913, 1, 222, 2, 0, NULL, 0, '2024-04-19 10:50:29', '2024-04-19 13:08:23', '2024-04-19', 'P4592', '24-06226-04-19', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'Cartagena 296 ', 'Barcelona', 'Barcelona', '08025', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190424-b0KOTTO1NVZoA-029', '8ffd7e0e-32ac-4a64-9590-13c6668c63ec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190424-b0KOTTO1NVZoA-029&s=KOL2024&nf=P4592&i=413.82&cr=120', '[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
(4914, 1, 1235, 2, 0, NULL, 0, '2024-04-20 11:02:26', '2024-04-22 09:53:44', '2024-04-22', 'P4593', '24-06230-04-20', 'CENTRO DE TRANSFUSION COMUNIDAD DE MADRID', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'AV DEMOCRACIA, S/N ', 'Madrid', 'Madrid', '28032', 'España', 30.61, 0, '2024-04-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220424-GzEqbZuY8PoYk-236', 'a67da0c3-ed54-4659-a77e-aff8dc35c589', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220424-GzEqbZuY8PoYk-236&s=KOL2024&nf=P4593&i=30.61&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4915, 1, 340, 2, 0, NULL, 0, '2024-04-21 08:52:00', '2024-04-22 09:54:07', '2024-04-22', 'P4594', '24-06231-04-21', 'no enviar paara que llegue el miercoles.esta cerrado', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'juan carlos 1 17, 17', 'Sesma', 'Navarra', '31293', 'España', 123.15, 0, '2024-04-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220424-JEFxIyoI2VeiQ-047', '6dbdfc61-3f6f-49e4-8a92-f7d2936379bd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220424-JEFxIyoI2VeiQ-047&s=KOL2024&nf=P4594&i=123.15&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4916, 1, 826, 2, 0, NULL, 0, '2024-04-21 13:33:44', '2024-04-22 09:54:24', '2024-04-22', 'P4596', '24-06240-04-21', '', 0.00, 32.49, 8.02, 0.00, 0, 0.00, 6.90, 'C/Gelasio Aramburu 3 4 C', 'Pasaia', 'Gipuzkoa', '20110', 'España', 46.21, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-220424-h7m4cLvs+gZn2-220', '9df1fd8b-9dc9-427c-8278-8913655ba689', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220424-h7m4cLvs%2BgZn2-220&s=KOL2024&nf=P4596&i=46.21&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4917, 1, 1055, 2, 0, NULL, 0, '2024-04-21 13:54:55', '2024-04-22 09:54:34', '2024-04-22', 'P4595', '24-06242-04-21', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida de la Ribera 44, 2°', 'Lodosa', 'Navarra', '31580', 'España', 30.61, 0, '2024-04-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220424-MvZ+c40MtO8fa-012', '0da51b06-2748-4b6e-b1a8-624f52ef31d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220424-MvZ%2Bc40MtO8fa-012&s=KOL2024&nf=P4595&i=30.61&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4918, 1, 337, 2, 0, NULL, 0, '2024-04-21 20:22:58', '2024-04-22 09:55:53', '2024-04-22', 'P4597', '24-06243-04-21', '', 0.00, 130.24, 27.35, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 157.59, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220424-F0mMaOB5UJLdH-005', '87d71fb8-5d5f-4c13-bdd3-9abffd492562', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220424-F0mMaOB5UJLdH-005&s=KOL2024&nf=P4597&i=157.59&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4919, 1, 4, 2, 0, NULL, 0, '2024-04-22 08:21:40', '2024-04-22 10:28:48', '2024-04-22', 'P4598', '24-06244-04-22', '', 0.00, 252.42, 53.01, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 305.43, 0, '2024-04-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220424-Ehl31CDW6Thz2-150', '0a7dfb8e-d43f-4bdc-a30d-b24657edf1dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220424-Ehl31CDW6Thz2-150&s=KOL2024&nf=P4598&i=305.43&cr=087', '[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
(4920, 1, 67, 1, 0, NULL, 0, '2024-04-22 10:35:01', '2024-04-22 10:40:32', '2024-04-22', 'P4599', '', '', 0.00, 256.50, 54.29, 0.00, 0, 0.00, 2.50, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 312.86, 0, '2024-04-22 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-220424-jUoeytHINlk25-001', '9b33c83b-c347-4323-b4ca-e1b97027454e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220424-jUoeytHINlk25-001&s=KOL2024&nf=P4599&i=312.86&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4921, 1, 126, 2, 0, NULL, 0, '2024-04-22 09:25:51', '2024-04-22 12:11:47', '2024-04-22', 'P4600', '24-06245-04-22', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'C/ Santa Lucía Nº 8 ocal', 'Valladolid', 'Valladolid', '47005', 'España', 172.43, 0, '2024-04-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220424-Ejqo5znZp9JVT-019', '05af3705-9578-4778-8349-fc4e05fddbb8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220424-Ejqo5znZp9JVT-019&s=KOL2024&nf=P4600&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),
(4922, 1, 1130, 2, 0, NULL, 0, '2024-04-22 09:40:55', '2024-04-22 12:12:02', '2024-04-22', 'P4601', '24-06246-04-22', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ Ulises, 4', 'Mairena del Aljarafe', 'Sevilla', '41927', 'España', 30.61, 0, '2024-04-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220424-Mpp56xT9Q2PJk-096', '9b1d83be-63dc-461b-baed-c22acc8da71a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220424-Mpp56xT9Q2PJk-096&s=KOL2024&nf=P4601&i=30.61&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4923, 1, 1236, 2, 0, NULL, 0, '2024-04-22 15:29:06', '2024-04-23 09:48:57', '2024-04-23', 'P4602', '24-06247-04-22', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Almazara 6, 4ºA ', 'Getafe', 'Madrid', '28903 ', 'España', 17.50, 0, '2024-04-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230424-U+hCAaDW1S/dV-016', '5f14a0bd-5f0b-415f-ad3b-a1b91e1b06b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-U%2BhCAaDW1S%2FdV-016&s=KOL2024&nf=P4602&i=17.50&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4924, 1, 394, 2, 0, NULL, 0, '2024-04-22 18:43:31', '2024-04-23 09:49:10', '2024-04-23', 'P4603', '24-06248-04-22', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'PASAJE DE COLON, 1. ESC 3. 5B', 'Valdemoro', 'Madrid', '28341', 'España', 30.61, 0, '2024-04-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230424-FUsIxCLBzFe0g-142', '78755986-8973-4cdb-9f78-a89953e8b332', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-FUsIxCLBzFe0g-142&s=KOL2024&nf=P4603&i=30.61&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4925, 1, 1237, 2, 0, NULL, 0, '2024-04-22 20:10:59', '2024-04-23 09:49:26', '2024-04-23', 'P4606', '24-06249-04-22', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Goieta kalea  28 - 3. Izq.', 'Elorrio', 'Bizkaia', '48230', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-230424-L339XT7zi8Lgy-104', 'd516ea33-ec65-4ab1-b624-f54ab0d7c05b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230424-L339XT7zi8Lgy-104&s=KOL2024&nf=P4606&i=30.61&cr=225', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
