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
(3778, 1, 155, 2, 0, NULL, 0, '2023-09-13 09:23:05', '2023-09-13 11:35:00', '2023-09-13', 'P3548', '23-05017-09-13', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130923-FgfYa8avTuSrM-180', '85472c61-c2e0-4e78-b6f1-6ca499be3b08', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-FgfYa8avTuSrM-180&s=KOL2023&nf=P3548&i=379.34&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3779, 1, 965, 2, 0, NULL, 0, '2023-09-13 09:29:41', '2023-09-13 11:31:19', '2023-09-13', 'P3547', '23-05018-09-13', '', 0.00, 19.83, 5.36, 0.00, 0, 0.00, 6.90, 'CALLE CALERUEGA Nº2-13A', 'Madrid', 'Madrid', '28033', 'España', 30.89, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130923-GX71AD9f6Shtw-216', 'c406a76a-cc34-4f12-b252-c6f3598d0c61', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-GX71AD9f6Shtw-216&s=KOL2023&nf=P3547&i=30.89&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3780, 1, 662, 2, 0, NULL, 0, '2023-09-13 11:38:59', '2023-09-14 09:02:52', '2023-09-13', 'P3553', '23-05019-09-13', 'Se puede tirar en el jardin', 0.00, 72.15, 15.15, 0.00, 0, 0.00, 0.00, 'Calle cadiz 45', 'Castelldefels', 'Barcelona', '08860', 'España', 87.30, 0, '2023-09-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130923-WiQMy1g5/eujZ-041', '14ab4326-4d15-4926-a69e-2505331be4c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-WiQMy1g5%2FeujZ-041&s=KOL2023&nf=P3553&i=87.30&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3781, 1, 391, 2, 0, NULL, 0, '2023-09-13 12:10:18', '2023-09-14 09:09:34', '2023-09-13', 'P3554', '23-05023-09-13', '', 0.00, 118.06, 24.79, 0.00, 0, 0.00, 0.00, 'Calle divina pastora 13 bajo', 'Ansoáin', 'Navarra', '31013', 'España', 142.85, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130923-l9pTPbgzvg4zf-032', '46d2f4f3-d126-4558-a769-c83af192b555', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-l9pTPbgzvg4zf-032&s=KOL2023&nf=P3554&i=142.85&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3782, 1, 405, 2, 0, NULL, 0, '2023-09-13 15:15:41', '2023-09-14 09:11:10', '2023-09-13', 'P3549', '23-05024-09-13', '', 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, '2023-09-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130923-VtPn8a3KJ2I6N-216', '02dd7649-545d-4109-adaa-2a8f4d1165dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-VtPn8a3KJ2I6N-216&s=KOL2023&nf=P3549&i=65.52&cr=187', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3783, 1, 162, 2, 0, NULL, 0, '2023-09-13 16:24:12', '2023-09-14 09:19:15', '2023-09-13', 'P3550', '23-05027-09-13', 'Entregar por la mañan', 0.00, 154.70, 32.49, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 187.19, 0, '2023-09-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130923-fybQ3IxAsY1Dm-022', '57b08612-513e-4890-bb9f-148d6e730de6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-fybQ3IxAsY1Dm-022&s=KOL2023&nf=P3550&i=187.19&cr=031', '[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
(3784, 1, 568, 2, 0, NULL, 0, '2023-09-13 18:39:17', '2023-09-14 09:28:45', '2023-09-13', 'P3551', '23-05028-09-13', 'peluquería el marco blanco', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'larramendi 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 137.94, 0, '2023-09-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130923-evs/tLScHNdvP-135', 'f56c20fc-3216-46b8-86d7-900fa69794ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-evs%2FtLScHNdvP-135&s=KOL2023&nf=P3551&i=137.94&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3785, 1, 966, 2, 0, NULL, 0, '2023-09-13 19:12:50', '2023-09-14 09:34:02', '2023-09-13', 'P3552', '23-05029-09-13', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Azpeitia 9,  8. C', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 17.50, 0, '2023-09-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130923-NZsqoU9g95TGE-043', '100a7d7a-17ce-4787-bfe6-36cd7133cf04', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-NZsqoU9g95TGE-043&s=KOL2023&nf=P3552&i=17.50&cr=231', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3786, 1, 967, 2, 0, NULL, 0, '2023-09-14 07:58:02', '2023-09-14 10:24:26', '2023-09-14', 'P3555', '23-05030-09-14', 'Llamar por teléfono en la entrega.\r\n', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Erletxe errepidea 15 ', 'Erandio', 'Bizkaia', '48950', 'España', 17.50, 0, '2023-09-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140923-Iy5rxmgqS0A/a-234', 'c8a76c48-c538-4676-8d3d-4a98a6e93bd6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140923-Iy5rxmgqS0A%2Fa-234&s=KOL2023&nf=P3555&i=17.50&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3787, 1, 714, 2, 0, NULL, 0, '2023-09-14 10:43:37', '2023-09-14 13:04:53', '2023-09-14', 'P3556', '23-05031-09-14', '', 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, '2023-09-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140923-B2g+L3oKaoA3E-237', '00defff4-8c9e-4149-8e3a-06a7b5e02f01', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140923-B2g%2BL3oKaoA3E-237&s=KOL2023&nf=P3556&i=30.61&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3788, 1, 968, 2, 0, NULL, 0, '2023-09-14 12:31:58', '2023-09-15 10:37:04', '2023-09-14', 'P3557', '23-05032-09-14', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Felix Rodriguez de la Fuente, bloque 3, 3º b Izq', 'Estepona', 'Málaga', '29680', 'España', 28.39, 0, '2023-09-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140923-C65i02lGZdEwY-211', 'f4b4dfea-ec12-412f-814b-012230c1d7a9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140923-C65i02lGZdEwY-211&s=KOL2023&nf=P3557&i=28.39&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3789, 1, 337, 2, 0, NULL, 0, '2023-09-14 14:44:19', '2023-09-15 10:42:28', '2023-09-14', 'P3558', '23-05034-09-14', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaragoza', 'Zaragoza', '50014 ', 'España', 59.10, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140923-Z2pCv2UOKkU7l-220', '69f25637-c745-490b-9023-cc8387b8ab4f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140923-Z2pCv2UOKkU7l-220&s=KOL2023&nf=P3558&i=59.10&cr=103', '[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
(3790, 1, 522, 2, 0, NULL, 0, '2023-09-15 11:55:06', '2023-09-18 08:49:51', '2023-09-15', 'P3559', '23-05036-09-15', '', 0.00, 207.64, 43.60, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 251.24, 0, '2023-09-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150923-YkOSG21NQSdVm-155', 'ba6e263e-29cb-42dd-ba33-1055c81c5064', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150923-YkOSG21NQSdVm-155&s=KOL2023&nf=P3559&i=251.24&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3791, 1, 468, 2, 0, NULL, 0, '2023-09-15 17:05:47', '2023-09-18 08:53:21', '2023-09-15', 'P3569', '23-05038-09-15', '', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'Rof carballo 1 peluqueria', 'Lugo', 'Lugo', '27002', 'España', 113.30, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150923-S8UHbGMng6gVU-128', 'd2420574-462b-4930-b665-4c3b53a5043c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150923-S8UHbGMng6gVU-128&s=KOL2023&nf=P3569&i=113.30&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3792, 1, 88, 2, 0, NULL, 0, '2023-09-16 07:54:15', '2023-09-18 08:55:30', '2023-09-16', 'P3560', '23-05040-09-16', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Turina 2bj  peluqueria ecologica valderros ', 'Valladolid', 'Valladolid', '47006', 'España', 379.34, 0, '2023-09-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160923-SNtqdzHL+C78B-238', '288f3fbe-01ed-414f-93dd-83c7513c6e31', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160923-SNtqdzHL%2BC78B-238&s=KOL2023&nf=P3560&i=379.34&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3793, 1, 145, 2, 0, NULL, 0, '2023-09-16 08:51:34', '2023-09-18 09:00:13', '2023-09-16', 'P3570', '23-05041-09-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-160923-VgqjH5OIbzPKj-059', 'b16bb57c-d4e2-4a8d-b639-e04a46fb05ab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160923-VgqjH5OIbzPKj-059&s=KOL2023&nf=P3570&i=209.41&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3794, 1, 547, 2, 0, NULL, 0, '2023-09-16 14:35:29', '2023-09-18 09:02:53', '2023-09-16', 'P3561', '23-05042-09-16', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Montevixán 25, Carreira', 'Ribeira', 'A Coruña', '15967', 'España', 43.71, 0, '2023-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160923-et+ootkhtsW1U-032', 'dc1d6841-4c92-42df-8d39-3f7083ea77f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160923-et%2BootkhtsW1U-032&s=KOL2023&nf=P3561&i=43.71&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3795, 1, 630, 2, 0, NULL, 0, '2023-09-16 14:44:30', '2023-09-18 09:04:35', '2023-09-16', 'P3562', '23-05043-09-16', 'Entregar en Viajes Eroski', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avenida de Navarra 9 Bajo', 'Beasain', 'Gipuzkoa', '20200', 'España', 52.39, 0, '2023-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160923-ocofVfxBnDWEv-077', 'cf60a20e-5b12-4828-80f7-6b1ce127c640', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160923-ocofVfxBnDWEv-077&s=KOL2023&nf=P3562&i=52.39&cr=222', '[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
(3796, 1, 449, 2, 0, NULL, 0, '2023-09-16 19:31:02', '2023-09-18 09:07:04', '2023-09-16', 'P3563', '23-05044-09-16', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'TIBURCIO ANITUA 32-1ª PL.', 'Eibar', 'Gipuzkoa', '20600', 'España', 43.71, 0, '2023-09-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160923-aHZBZaLmsCmRY-106', 'aac121f5-ce00-430a-a45a-c14d0aa2f44f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160923-aHZBZaLmsCmRY-106&s=KOL2023&nf=P3563&i=43.71&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3797, 1, 351, 2, 0, NULL, 0, '2023-09-17 07:01:39', '2023-09-18 09:08:28', '2023-09-17', 'P3564', '23-05045-09-17', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Puenteareas 16', 'Soto del Real', 'Madrid', '28791', 'España', 30.61, 0, '2023-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170923-Eg+c5zBfYVt0S-119', 'f57d0231-36a5-4a8c-a3ed-99632e95d945', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170923-Eg%2Bc5zBfYVt0S-119&s=KOL2023&nf=P3564&i=30.61&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3798, 1, 754, 2, 0, NULL, 0, '2023-09-17 17:38:16', '2023-09-18 09:13:13', '2023-09-17', 'P3565', '23-05046-09-17', 'DE FORMA PUNTUAL ENVIAR EL PEDIDO AL MISMO MUNICIPIO PERO A: LA CALLE MALLORCA Nº5 LOCAL', 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, '2023-09-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170923-cO//a5CdofkoS-010', '3cbf6624-c725-44e6-90ef-83c04ab8c4e6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170923-cO%2F%2Fa5CdofkoS-010&s=KOL2023&nf=P3565&i=61.64&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3799, 1, 969, 2, 0, NULL, 0, '2023-09-17 19:46:07', '2023-09-18 09:16:29', '2023-09-17', 'P3566', '23-05047-09-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C / particular de Coste, n5 , 5A', 'Getxo', 'Bizkaia', '48930', 'España', 17.50, 0, '2023-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170923-CKfHEj3YEwUDJ-004', 'bf8527bb-3348-463e-b487-9d38197baf65', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170923-CKfHEj3YEwUDJ-004&s=KOL2023&nf=P3566&i=17.50&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3800, 1, 970, 2, 0, NULL, 0, '2023-09-17 20:13:01', '2023-09-17 20:13:01', '2023-09-17', '', '23-05048-09-17', NULL, 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'calle santaisabel 9 local', 'Zaragoza', 'Zaragoza', '50003', 'España', 65.52, 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),
(3801, 1, 970, 2, 0, NULL, 0, '2023-09-17 20:39:53', '2023-09-18 09:21:24', '2023-09-17', 'P3567', '23-05049-09-17', 'Con calma peluqueria,  entregar con factura\r\nen el caso de no encontrarme en el local,entregar en floristeria de enfrente,gracias', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'calle santaisabel 9 local', 'Zaragoza', 'Zaragoza', '5003', 'España', 65.52, 0, '2023-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170923-PEjxJc0ahbDRJ-219', '1d65dde3-965a-4770-b4ae-9cf77dcf994b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170923-PEjxJc0ahbDRJ-219&s=KOL2023&nf=P3567&i=65.52&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3802, 1, 971, 2, 0, NULL, 0, '2023-09-17 21:57:05', '2023-09-18 09:24:39', '2023-09-17', 'P3568', '23-05051-09-17', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Tomas Romero de Castilla 3 3C', 'Mérida', 'Badajoz', '06800', 'España', 28.39, 0, '2023-09-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170923-QZNeLgTfYvSU7-134', '5026aa85-1e08-416e-b149-8647b1e3e79a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170923-QZNeLgTfYvSU7-134&s=KOL2023&nf=P3568&i=28.39&cr=166', '[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
(3803, 1, 972, 2, 0, NULL, 0, '2023-09-18 11:03:38', '2023-09-18 13:14:49', '2023-09-18', 'P3571', '23-05053-09-18', 'PONER AMBOS NOMBRE, EMPRESA Y PERSONA', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'AERNNOVA AEROSPACE, Parque Tecnologico de Alava, C/Leonardo da Vinci 13', 'Vitoria-Gasteiz', 'Álava', '01510', 'España', 41.50, 0, '2023-09-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180923-dPkr/m2/W07uY-068', 'c26f5414-e964-46fd-b60f-cfba23faf06a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180923-dPkr%2Fm2%2FW07uY-068&s=KOL2023&nf=P3571&i=41.50&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3804, 1, 471, 2, 0, NULL, 0, '2023-09-18 15:58:14', '2023-09-19 08:54:54', '2023-09-18', 'P3572', '23-05055-09-18', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Siervas de Jesús nº 4, 2º D', 'Logroño', 'La Rioja', '26001', 'España', 30.61, 0, '2023-09-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180923-lv70qhgWlFTUo-144', '4001e651-d89d-4aec-b82d-528ff31d235c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180923-lv70qhgWlFTUo-144&s=KOL2023&nf=P3572&i=30.61&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3805, 1, 973, 2, 0, NULL, 0, '2023-09-18 17:17:41', '2023-09-19 08:56:59', '2023-09-18', 'P3573', '23-05056-09-18', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sitio del Marillejo, 29', 'Torrelodones', 'Madrid', '28250', 'España', 28.39, 0, '2023-09-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180923-G1FRKzkC2Hd4k-050', 'dd427037-e548-4f71-902b-800bed8a617c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180923-G1FRKzkC2Hd4k-050&s=KOL2023&nf=P3573&i=28.39&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3806, 1, 157, 2, 0, NULL, 0, '2023-09-18 17:34:27', '2023-09-19 08:59:42', '2023-09-18', 'P3574', '23-05057-09-18', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'CALLE APODACA,1 LOCAL', 'Madrid', 'Madrid', '28004', 'España', 482.79, 0, '2023-09-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180923-ogd0NMg+aR90m-121', '6d5aa502-ea0d-4b32-b63f-9f21ba312786', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180923-ogd0NMg%2BaR90m-121&s=KOL2023&nf=P3574&i=482.79&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3807, 1, 974, 2, 0, NULL, 0, '2023-09-18 22:14:07', '2023-09-19 09:05:01', '2023-09-18', 'P3575', '23-05058-09-18', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Avinguda Estudi General,, num 7, 6e  4a', 'Lleida', 'Lleida', '25001', 'España', 41.50, 0, '2023-09-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180923-fW49kvVe7zV/Q-042', '270c500f-765c-459a-88b5-1fa44935b0a2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180923-fW49kvVe7zV%2FQ-042&s=KOL2023&nf=P3575&i=41.50&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3808, 1, 106, 1, 0, NULL, 0, '2023-09-19 09:11:20', '2023-09-19 09:11:20', '2023-09-19', 'P3576', '', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Hipódromo 10 bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'ESPAÑA', 137.94, 0, '2023-09-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190923-DX6MlEJjwhN+w-065', 'cd7e45d0-31a9-439f-91f6-35b7775eab64', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190923-DX6MlEJjwhN%2Bw-065&s=KOL2023&nf=P3576&i=137.94&cr=092', '[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
(3809, 1, 644, 2, 0, NULL, 0, '2023-09-19 10:09:41', '2023-09-19 12:14:19', '2023-09-19', 'P3577', '23-05059-09-19', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle Caldera de Taburiente 7, 2B', 'Ciempozuelos', 'Madrid', '28350', 'España', 65.52, 0, '2023-09-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190923-iEsitkHLDZaai-250', 'f34f1e7a-cda8-4bab-ae95-c8240f55f031', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190923-iEsitkHLDZaai-250&s=KOL2023&nf=P3577&i=65.52&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3810, 1, 223, 2, 0, NULL, 0, '2023-09-19 11:00:17', '2023-09-20 09:21:20', '2023-09-19', 'P3580', '23-05060-09-19', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'c/damas apostolicas,8 -bajo D.  A Ramallosa', 'Nigrán', 'Pontevedra', '36370', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190923-aoBV98czC655A-119', 'b9e9d067-4ac6-4c5a-ba4d-faa07d392421', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190923-aoBV98czC655A-119&s=KOL2023&nf=P3580&i=206.91&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3811, 1, 280, 2, 0, NULL, 0, '2023-09-19 11:25:33', '2023-09-20 09:26:33', '2023-09-19', 'P3578', '23-05061-09-19', 'LOS LUNES ESTA CERRADO', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'RUA CODESAL Nº2', 'Pino (O)', 'A Coruña', '15821', 'España', 310.37, 0, '2023-09-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190923-C/qnVRjt0w3Qw-203', '54085db1-28fb-4621-a30d-a0d39be43b12', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190923-C%2FqnVRjt0w3Qw-203&s=KOL2023&nf=P3578&i=310.37&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3812, 1, 595, 2, 0, NULL, 0, '2023-09-19 11:28:11', '2023-09-20 09:30:20', '2023-09-19', 'P3581', '23-05062-09-19', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'Zurbaranbarri 16 Peluqueria', 'Bilbao', 'Bizkaia', '48007', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-190923-ZuOV5BDBZn5qV-002', 'a3c438d3-34f8-4651-921f-fff0c0ad2ed6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190923-ZuOV5BDBZn5qV-002&s=KOL2023&nf=P3581&i=105.96&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3813, 1, 65, 2, 0, NULL, 0, '2023-09-19 15:48:01', '2024-07-17 13:07:41', '2023-09-19', 'P3582', '23-05063-09-19', '', 0.00, 684.00, 143.64, 0.00, 0, 0.00, 0.00, 'balmes 133', 'Barcelona', 'Barcelona', '08008', 'España', 827.64, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190923-iIG6kPF0W4e5h-051', '597e7370-538d-454b-898d-73a6332a22dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190923-iIG6kPF0W4e5h-051&s=KOL2023&nf=P3582&i=827.64&cr=230', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3814, 1, 55, 2, 0, NULL, 0, '2023-09-19 16:48:47', '2023-09-20 09:48:06', '2023-09-19', 'P3579', '23-05064-09-19', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'San Pedro De Mezonzo 17 bajo derch', 'Santiago de Composte', 'A Coruña', '15701', 'España', 103.46, 0, '2023-09-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190923-da/UeP0EInS5b-104', '9df6c27c-781d-4b09-a069-d1ec402eb17c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190923-da%2FUeP0EInS5b-104&s=KOL2023&nf=P3579&i=103.46&cr=017', '[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
(3815, 1, 595, 2, 1, 'factura incompleta', 3812, '2023-09-20 09:32:56', '2023-09-20 09:32:56', '2023-09-20', 'R55', 'P3581 RECT.', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, '', '', '', '', '', 105.96, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-200923-jB4RcpR4oL9/F-170', 'b90233a2-11c8-46dc-9764-6b73e770365a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200923-jB4RcpR4oL9%2FF-170&s=KOL2023&nf=R55&i=-105.96&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3816, 1, 595, 2, 0, NULL, 0, '2023-09-20 09:34:28', '2023-09-20 10:51:04', '2023-09-20', 'P3584', '2023-09-20', '', 0.00, 85.50, 18.38, 0.00, 0, 0.00, 2.50, 'Zurbaranbarri 16', 'Bilbao', 'Bizkaia', '48007', 'España', 105.95, 0, '2023-09-20 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-200923-NO/G9QkLrrNZF-114', 'fad5c285-420d-4d6c-890f-f644aacb9db8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200923-NO%2FG9QkLrrNZF-114&s=KOL2023&nf=P3584&i=105.95&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3817, 1, 215, 1, 0, NULL, 0, '2023-09-20 10:00:16', '2023-09-20 10:07:26', '2023-09-20', 'P3583', '2023-09-20', '', 0.00, 268.70, 56.43, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 325.13, 0, '2023-09-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200923-TZH3bqxLReMwI-251', 'fd71ff83-0299-4d9e-8063-b45cbefe1afe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200923-TZH3bqxLReMwI-251&s=KOL2023&nf=P3583&i=325.13&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3818, 1, 160, 2, 0, NULL, 0, '2023-09-20 08:38:02', '2023-09-20 11:10:25', '2023-09-20', 'P3585', '23-05065-09-20', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Felisa Martin Bravo 13 Peluquería Urrezko Orrazia', 'Donostia-San Sebasti', 'Gipuzkoa', '20014', 'España', 123.15, 0, '2023-09-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200923-o8FkCIVf0wbln-173', 'f0bd0844-5350-4ac0-9122-01e8c417f1e5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200923-o8FkCIVf0wbln-173&s=KOL2023&nf=P3585&i=123.15&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3819, 1, 3, 1, 0, NULL, 0, '2023-09-20 11:20:32', '2023-09-20 11:20:32', '2023-09-20', 'P3586', '2023-09-20', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'C/ PINTOR AURELIO VIRAFAJARDO Nº2 B', 'VITORIA', 'ÁLAVA', '01008', 'España', 379.34, 0, '2023-09-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-200923-C9x5MRZEZuoeI-247', 'adc55f59-2e5e-4066-99f0-db0ed8fe13e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200923-C9x5MRZEZuoeI-247&s=KOL2023&nf=P3586&i=379.34&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3820, 1, 190, 3, 0, NULL, 0, '2023-09-20 12:09:36', '2023-09-20 12:30:10', '2023-09-20', '', '2023-09-20', '', 0.00, 1172.56, 246.24, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 1418.80, 0, '2023-09-20 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3821, 1, 975, 2, 0, NULL, 0, '2023-09-20 17:15:04', '2023-09-21 09:15:42', '2023-09-20', 'P3587', '23-05066-09-20', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'MATXIN ARZU 6, LOCAL 2A', 'Hondarribia', 'Gipuzkoa', '20280', 'España', 17.50, 0, '2023-09-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200923-eGqAm5OtljD58-247', 'b5c59793-375a-4288-b8f4-023a52217481', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200923-eGqAm5OtljD58-247&s=KOL2023&nf=P3587&i=17.50&cr=095', '[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
(3822, 1, 976, 2, 0, NULL, 0, '2023-09-20 19:14:30', '2023-09-21 09:20:41', '2023-09-20', 'P3588', '23-05067-09-20', 'llamarme antes de la entrega ', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'calle bolivia n 1 bajo puerta 3', 'Coruña (A)', 'A Coruña', '15004', 'España', 517.28, 0, '2023-09-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200923-MHw0aMRhf7Hu+-110', '5fce3b40-bf95-44ed-84a9-0846c5213907', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200923-MHw0aMRhf7Hu%2B-110&s=KOL2023&nf=P3588&i=517.28&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3823, 1, 571, 2, 0, NULL, 0, '2023-09-20 21:46:39', '2023-09-21 09:30:28', '2023-09-20', 'P3589', '23-05068-09-20', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'AMAROZ, 30, 1B', 'Tolosa', 'Gipuzkoa', '20400', 'España', 41.50, 0, '2023-09-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200923-OXaiaJAw4PXT8-067', '360f53ab-c260-44c0-8eab-26933bcf360f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200923-OXaiaJAw4PXT8-067&s=KOL2023&nf=P3589&i=41.50&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3824, 1, 242, 1, 0, NULL, 0, '2023-09-21 08:53:53', '2023-09-21 09:34:27', '2023-09-21', 'P3590', '2023-09-21', '', 0.00, 113.96, 23.93, 0.00, 1, 5.93, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 143.82, 0, '2023-09-21 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210923-AEzxZdiQ3SkMS-063', 'fe33ae11-3fb3-4f66-97ed-aaeffe7fba38', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210923-AEzxZdiQ3SkMS-063&s=KOL2023&nf=P3590&i=143.82&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3825, 1, 977, 2, 0, NULL, 0, '2023-09-21 09:27:15', '2023-09-21 12:09:19', '2023-09-21', 'P3591', '23-05069-09-21', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'julio urquijo 14 - 6 der', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 30.61, 0, '2023-09-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210923-BWKdTraesh5L7-107', 'c80f940b-67ab-472d-9baa-c1d41e3dccbf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210923-BWKdTraesh5L7-107&s=KOL2023&nf=P3591&i=30.61&cr=082', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3826, 1, 23, 2, 0, NULL, 0, '2023-09-21 11:37:06', '2023-09-22 09:10:49', '2023-09-21', 'P3592', '23-05070-09-21', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 241.40, 0, '2023-09-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210923-S7+Iga5qm8hoQ-155', 'd63ec929-c5d6-4641-b14c-3fee3c73c0c3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210923-S7%2BIga5qm8hoQ-155&s=KOL2023&nf=P3592&i=241.40&cr=110', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3827, 1, 978, 2, 0, NULL, 0, '2023-09-21 14:22:31', '2023-09-22 09:12:33', '2023-09-21', 'P3595', '23-05071-09-21', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Antonio Gaudi 9, bajo B', 'Sant Boi de Llobrega', 'Barcelona', '08830', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-210923-Yd4WpW7sHMYXm-163', '330bfa86-5ef4-40df-89d2-3755d355894a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210923-Yd4WpW7sHMYXm-163&s=KOL2023&nf=P3595&i=20.00&cr=184', '[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
(3828, 1, 703, 2, 0, NULL, 0, '2023-09-21 14:33:12', '2023-09-22 09:16:04', '2023-09-21', 'P3593', '23-05072-09-21', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Mayor 37 2', 'Entrena', 'La Rioja', '26375', 'España', 17.50, 0, '2023-09-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210923-K3Jjlnc8m5FMN-245', '6a842f38-5954-49ab-8f6c-04dd5de226b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210923-K3Jjlnc8m5FMN-245&s=KOL2023&nf=P3593&i=17.50&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3829, 1, 350, 2, 0, NULL, 0, '2023-09-21 14:44:49', '2023-09-22 09:23:04', '2023-09-21', 'P3596', '23-05074-09-21', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Balleneros 19 Bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210923-BhUA1iojHYQeq-071', 'df10b4b2-ac95-4b21-b1cc-65f6fc64db93', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210923-BhUA1iojHYQeq-071&s=KOL2023&nf=P3596&i=172.43&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3830, 1, 979, 2, 0, NULL, 0, '2023-09-21 15:06:01', '2023-09-22 09:30:41', '2023-09-21', 'P3597', '23-05075-09-21', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'Calle Palma 58, Local 1. 28015 Madrid', 'Madrid', 'Madrid', '28015', 'España', 517.28, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210923-WJXbC09B8SA/W-230', '7c14d47f-f1f0-47ba-b7be-d77a58efbc80', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210923-WJXbC09B8SA%2FW-230&s=KOL2023&nf=P3597&i=517.28&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3831, 1, 816, 2, 0, NULL, 0, '2023-09-22 06:57:06', '2023-09-22 09:32:45', '2023-09-22', 'P3594', '23-05076-09-22', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Calle Leo Número 8', 'Cáceres', 'Cáceres', '10001', 'España', 71.98, 0, '2023-09-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220923-oH2A2vJq2O/sE-149', '6b2a7f29-7576-4c1f-aa84-fa95d2740a14', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220923-oH2A2vJq2O%2FsE-149&s=KOL2023&nf=P3594&i=71.98&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3832, 1, 4, 2, 0, NULL, 0, '2023-09-22 09:23:24', '2023-09-22 12:06:41', '2023-09-22', 'P3599', '23-05077-09-22', '', 0.00, 305.34, 64.12, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 369.46, 0, '2023-09-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220923-J3ldzzuPvul9q-144', '05cafbaf-b17a-406c-b554-c2cb91f0b0cf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220923-J3ldzzuPvul9q-144&s=KOL2023&nf=P3599&i=369.46&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3833, 1, 980, 2, 0, NULL, 0, '2023-09-22 09:59:42', '2023-09-22 12:06:21', '2023-09-22', 'P3598', '23-05078-09-22', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Príncipe de Vergara 255,2E ', 'Madrid', 'Madrid', '28016', 'España', 17.50, 0, '2023-09-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220923-Cjf3Px1T2pbJA-178', 'b4d1dcfe-4d9f-47bc-92cb-e3e22f2a95b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220923-Cjf3Px1T2pbJA-178&s=KOL2023&nf=P3598&i=17.50&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
