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
(3944, 1, 773, 2, 0, NULL, 0, '2023-10-18 19:04:49', '2023-10-19 09:16:42', '2023-10-18', 'P3709', '23-05190-10-18', '', 0.00, 19.83, 5.36, 0.00, 0, 0.00, 6.90, 'Artekale 18', 'Otxandio', 'Bizkaia', '48210', 'España', 30.89, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-181023-aPrUHP9LwY3wy-025', 'f7ecfe6e-b330-4783-b90b-10a0e8fff183', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181023-aPrUHP9LwY3wy-025&s=KOL2023&nf=P3709&i=30.89&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3945, 1, 1003, 2, 0, NULL, 0, '2023-10-19 05:41:15', '2023-10-19 09:18:39', '2023-10-19', 'P3707', '23-05191-10-19', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle Buenavista 56 bajo', 'Alicante/Alacant', 'Alicante', '03008', 'España', 43.71, 0, '2023-10-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191023-LoegIXwcV3g4r-151', 'a93a2a9a-e91a-4535-a667-801826fe23c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191023-LoegIXwcV3g4r-151&s=KOL2023&nf=P3707&i=43.71&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3946, 1, 57, 2, 0, NULL, 0, '2023-10-19 07:09:30', '2023-10-19 09:21:08', '2023-10-19', 'P3708', '23-05192-10-19', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 517.28, 0, '2023-10-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191023-ZrIF2jm8uKEAt-085', 'ae699c0a-7d79-489b-8a4b-c69a6e77e106', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191023-ZrIF2jm8uKEAt-085&s=KOL2023&nf=P3708&i=517.28&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3947, 1, 152, 1, 0, NULL, 0, '2023-10-19 10:30:56', '2023-10-19 10:31:48', '2023-10-19', 'P3710', '2023-10-19', '', 0.00, 154.44, 32.43, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 186.87, 0, '2023-10-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-191023-CJ+4EegvUnlkD-074', '220fe61f-7508-4eb0-b721-27b5cd79cf17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191023-CJ%2B4EegvUnlkD-074&s=KOL2023&nf=P3710&i=186.87&cr=171', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3948, 1, 470, 2, 0, NULL, 0, '2023-10-19 09:05:10', '2023-10-19 11:11:07', '2023-10-19', 'P3711', '23-05194-10-19', 'horario de 8 a 14 horas de Lunes  a Viernes', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Jose Ramon Lopez Doriga nº 3, 1', 'Santander', 'Cantabria', '39003', 'España', 78.63, 0, '2023-10-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191023-j60RL4zXJ1rGn-008', '768bc5e8-2a7b-4e6c-a2be-2a5faa5418ad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191023-j60RL4zXJ1rGn-008&s=KOL2023&nf=P3711&i=78.63&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3949, 1, 687, 1, 0, NULL, 0, '2023-10-19 11:15:24', '2023-10-19 11:15:24', '2023-10-19', 'P3712', '2023-10-19', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 68.97, 0, '2023-10-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-191023-YRuzbLuc6eP+P-001', '4be96978-4943-4083-a5df-89171dd27ca4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191023-YRuzbLuc6eP%2BP-001&s=KOL2023&nf=P3712&i=68.97&cr=247', '[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
(3950, 1, 1004, 2, 0, NULL, 0, '2023-10-19 12:12:28', '2023-10-20 09:17:10', '2023-10-19', 'P3715', '23-05195-10-19', '', 0.00, 43.32, 10.30, 0.00, 0, 0.00, 6.90, 'C/ san martin nº 2 b, en lo mas alto del pueblo', 'Atez', 'Navarra', '31193', 'España', 59.32, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-191023-Qtl2IFZMmtUBp-148', '37f710d9-d230-4be0-acf0-ce6a98ac2d20', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191023-Qtl2IFZMmtUBp-148&s=KOL2023&nf=P3715&i=59.32&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3951, 1, 144, 2, 0, NULL, 0, '2023-10-19 14:05:05', '2023-10-20 09:22:14', '2023-10-19', 'P3713', '23-05196-10-19', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 103.46, 0, '2023-10-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191023-EBk+4W4tvf38r-058', 'b16d9857-7e3b-4e85-9bfd-2541731e02be', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191023-EBk%2B4W4tvf38r-058&s=KOL2023&nf=P3713&i=103.46&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3952, 1, 765, 2, 0, NULL, 0, '2023-10-19 19:35:52', '2023-10-20 09:24:33', '2023-10-19', 'P3716', '23-05199-10-19', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-191023-GfwUtqLzeZT0V-160', '87e04aaa-30d9-4b88-9d62-990b0911b49d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191023-GfwUtqLzeZT0V-160&s=KOL2023&nf=P3716&i=105.96&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3953, 1, 862, 2, 0, NULL, 0, '2023-10-19 20:47:46', '2023-10-20 09:29:12', '2023-10-19', 'P3717', '23-05200-10-19', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Finca san Anton, s/n', 'Mirabel', 'Cáceres', '10540', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-191023-BONJiCltEfIbc-179', '5ac63c7d-d8ee-4121-ba7f-33dbd71ff27f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191023-BONJiCltEfIbc-179&s=KOL2023&nf=P3717&i=20.00&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3954, 1, 832, 2, 0, NULL, 0, '2023-10-20 06:56:31', '2023-10-20 09:34:26', '2023-10-20', 'P3714', '23-05201-10-20', 'Horario comercial 10 a 13\r\n16 a 20 lunes a jueves ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Cami capellans 18- 20, Planta baja clínica dental', 'Sitges', 'Barcelona', '08870', 'España', 17.50, 0, '2023-10-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201023-iYjtKHbhNPw6Q-005', 'deda2b10-d3d2-450f-8455-fad2f51bb2c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201023-iYjtKHbhNPw6Q-005&s=KOL2023&nf=P3714&i=17.50&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3955, 1, 1005, 2, 0, NULL, 0, '2023-10-20 07:52:51', '2023-10-20 10:02:33', '2023-10-20', 'P3718', '23-05202-10-20', 'Local puerta verde', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'c/ San Isidro Labrador 19, local A', 'Madrid', 'Madrid', '28005', 'España', 30.61, 0, '2023-10-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201023-a2ZTQg99x2kUe-072', '4a154e03-678f-4f1c-89d7-cb389b9a12fd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201023-a2ZTQg99x2kUe-072&s=KOL2023&nf=P3718&i=30.61&cr=126', '[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
(3956, 1, 519, 1, 0, NULL, 0, '2023-10-20 11:23:18', '2023-10-20 11:23:53', '2023-10-20', 'P3719', '2023-10-20', '', 0.00, 130.28, 27.36, 0.00, 0, 0.00, 0.00, 'CALLE DE SAN AGUSTÍN \'EL VIEJO\' 25', 'TALAVERA DE LA REINA', 'TOLEDO', '45600', 'España', 157.64, 0, '2023-10-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-201023-MRx1SBCU9kEGX-218', '69a0abf2-ce04-4fac-94f7-4a21952a3410', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201023-MRx1SBCU9kEGX-218&s=KOL2023&nf=P3719&i=157.63&cr=043', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3957, 1, 696, 1, 0, NULL, 0, '2023-10-20 12:46:29', '2023-10-20 12:46:48', '2023-10-20', 'P3720', '2023-10-20', '', 0.00, 360.36, 75.68, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 436.04, 0, '2023-10-20 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-201023-VARmaPWZWPbhi-215', '736aa149-c9da-4f6a-bf33-073330988cf6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201023-VARmaPWZWPbhi-215&s=KOL2023&nf=P3720&i=436.04&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3958, 1, 144, 2, 0, NULL, 0, '2023-10-20 17:26:59', '2023-10-23 09:03:59', '2023-10-20', 'P3721', '23-05203-10-20', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 68.97, 0, '2023-10-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201023-eZEu8xnQfqFSK-171', '8b68feb0-1d60-4f05-82aa-2fdc6c2710c4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201023-eZEu8xnQfqFSK-171&s=KOL2023&nf=P3721&i=68.97&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3959, 1, 446, 2, 0, NULL, 0, '2023-10-21 09:27:18', '2023-10-23 09:05:19', '2023-10-21', 'P3722', '23-05205-10-21', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Kälber Ria 40 -1', 'Andoain', 'Gipuzkoa', '20140', 'España', 65.52, 0, '2023-10-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211023-BJCX7tJURKLoo-214', 'b1aef8ac-1b61-4f6d-97e0-ed105833b709', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211023-BJCX7tJURKLoo-214&s=KOL2023&nf=P3722&i=65.52&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3960, 1, 863, 2, 0, NULL, 0, '2023-10-21 15:59:53', '2023-10-23 09:06:36', '2023-10-21', 'P3723', '23-05206-10-21', 'si no estoy dejar en un bar o super cercano ', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/ Peñota, 2- 1°A, Loredo', 'Ribamontán al Mar', 'Cantabria', '39160', 'España', 43.71, 0, '2023-10-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211023-oo76U9ny6n0ab-078', 'c62997fb-5b23-48cc-a95b-99fa7b439503', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211023-oo76U9ny6n0ab-078&s=KOL2023&nf=P3723&i=43.71&cr=146', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3961, 1, 76, 1, 0, NULL, 0, '2023-10-23 09:09:11', '2023-10-23 09:09:11', '2023-10-23', 'P3724', '', '', 0.00, 154.44, 32.43, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 186.87, 0, '2023-10-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-231023-dJUHcWixHiFF1-140', 'd50c7bbc-568c-4e41-866f-259ee880d32a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231023-dJUHcWixHiFF1-140&s=KOL2023&nf=P3724&i=186.87&cr=054', '[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
(3962, 1, 76, 1, 0, NULL, 0, '2023-10-23 10:54:22', '2023-10-23 10:54:22', '2023-10-23', 'P3725', '2023-10-23', '', 0.00, 25.74, 5.41, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 31.15, 0, '2023-10-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-231023-da9qDYDQ/ScTx-119', 'df19f8a6-42e2-4ab9-a7ac-8f29f403d8d1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231023-da9qDYDQ%2FScTx-119&s=KOL2023&nf=P3725&i=31.15&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3963, 1, 65, 2, 0, NULL, 0, '2023-10-23 09:52:24', '2024-07-17 13:13:01', '2023-10-23', 'P3726', '23-05207-10-23', '', 0.00, 541.50, 113.71, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 655.21, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-231023-SUODoAgCJY4xf-068', '4786f92d-42d7-4dcc-abbb-2e1c3917edc7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231023-SUODoAgCJY4xf-068&s=KOL2023&nf=P3726&i=655.22&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3964, 1, 114, 2, 0, NULL, 0, '2023-10-23 10:13:10', '2023-10-23 12:14:34', '2023-10-23', 'P3727', '23-05208-10-23', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Catalina de Erauso 10 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-231023-B3BYuhBJL1NLi-213', '0039ece5-5e7e-4dc5-98cb-cec820716876', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231023-B3BYuhBJL1NLi-213&s=KOL2023&nf=P3727&i=379.34&cr=089', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3965, 1, 1006, 2, 0, NULL, 0, '2023-10-23 11:42:52', '2023-10-23 15:21:09', '2023-10-23', 'P3728', '23-05209-10-23', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Barrio La Iglesia, 176A, Pedreña', 'Marina de Cudeyo', 'Cantabria', '39130', 'España', 28.39, 0, '2023-10-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231023-M/8uKrPpbLEFn-009', 'b6031c9d-f587-416b-a3ad-e0fd7453c7d7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231023-M%2F8uKrPpbLEFn-009&s=KOL2023&nf=P3728&i=28.39&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3966, 1, 1007, 2, 0, NULL, 0, '2023-10-23 14:44:48', '2023-10-24 09:07:47', '2023-10-23', 'P3729', '23-05211-10-23', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Las Violetas, 56', 'Cáceres', 'Cáceres', '10004', 'España', 17.50, 0, '2023-10-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231023-KEc9s7i1HdVTh-077', '801af90d-1ffe-46f0-b534-40902921916c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231023-KEc9s7i1HdVTh-077&s=KOL2023&nf=P3729&i=17.50&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3967, 1, 1008, 2, 0, NULL, 0, '2023-10-23 14:46:35', '2023-10-24 09:10:41', '2023-10-23', 'P3730', '23-05210-10-23', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Candelario 2.esc.I 2A', 'Salamanca', 'Salamanca', '37007', 'España', 30.61, 0, '2023-10-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231023-QhlSWNxnDNIEX-245', '54cf4347-9f1a-4707-93eb-7d54abc9e252', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231023-QhlSWNxnDNIEX-245&s=KOL2023&nf=P3730&i=30.61&cr=136', '[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
(3968, 1, 522, 2, 0, NULL, 0, '2023-10-23 16:55:07', '2023-10-24 09:13:15', '2023-10-23', 'P3731', '23-05212-10-23', '', 0.00, 350.14, 73.53, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 423.67, 0, '2023-10-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231023-FR7FsAsE2JAhi-218', 'ae2dea64-28a8-450f-82e5-1cca74646a94', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231023-FR7FsAsE2JAhi-218&s=KOL2023&nf=P3731&i=423.67&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3969, 1, 980, 2, 0, NULL, 0, '2023-10-24 09:08:33', '2023-10-24 11:16:01', '2023-10-24', 'P3732', '23-05213-10-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Principe de Vergara 255, 2E', 'Madrid', 'Madrid', '28016', 'España', 30.61, 0, '2023-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241023-TQc9vguo3Zxlj-042', '27e80f5f-9af2-4311-a02c-3ee753d9e905', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241023-TQc9vguo3Zxlj-042&s=KOL2023&nf=P3732&i=30.61&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3970, 1, 569, 2, 0, NULL, 0, '2023-10-24 10:24:46', '2023-10-24 12:25:32', '2023-10-24', 'P3733', '23-05214-10-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Av. Barcelona N°2,  pta.19', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 30.61, 0, '2023-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241023-XCbDpayNJO+J4-083', '98d626d0-3dc6-4211-a40a-05c415bbde06', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241023-XCbDpayNJO%2BJ4-083&s=KOL2023&nf=P3733&i=30.61&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3971, 1, 85, 2, 0, NULL, 0, '2023-10-24 10:28:31', '2023-10-24 12:29:55', '2023-10-24', 'P3734', '23-05215-10-24', '', 0.00, 113.98, 23.93, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 137.92, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-241023-dtLewg558+dAI-160', '3fcea231-b569-4e98-8493-39a8bf9dc6b7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241023-dtLewg558%2BdAI-160&s=KOL2023&nf=P3734&i=137.91&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3972, 1, 85, 2, 0, NULL, 0, '2023-10-24 10:28:40', '2023-10-24 10:28:40', '2023-10-24', '', '23-05216-10-24', NULL, 0.00, 113.98, 23.93, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 137.92, 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),
(3973, 1, 1009, 2, 0, NULL, 0, '2023-10-24 10:42:26', '2023-10-25 09:39:11', '2023-10-24', 'P3735', '23-05217-10-24', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'c/del Bailío nº 11', 'Tudela', 'Navarra', '31500', 'España', 43.71, 0, '2023-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241023-ZN8uJ2hsfcLUZ-162', 'a43de2bd-51d1-45b0-8d6f-c913566589a8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241023-ZN8uJ2hsfcLUZ-162&s=KOL2023&nf=P3735&i=43.71&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3974, 1, 75, 2, 0, NULL, 0, '2023-10-24 10:59:21', '2023-10-25 09:42:54', '2023-10-24', 'P3736', '23-05218-10-24', 'Horario de martes a viernes de 10 00 a 19 00 ', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 103.46, 0, '2023-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241023-U/506Ha0PeB0r-010', 'c75c35d4-6b7a-4f9f-9ce8-820a69925c9c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241023-U%2F506Ha0PeB0r-010&s=KOL2023&nf=P3736&i=103.46&cr=010', '[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
(3975, 1, 933, 2, 0, NULL, 0, '2023-10-24 16:25:47', '2023-10-25 09:48:57', '2023-10-24', 'P3737', '23-05219-10-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Mayor, 4', 'Manises', 'Valencia', '46940', 'España', 30.61, 0, '2023-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241023-AuVyA1gudq3CN-155', 'd1a3a45d-d99a-4606-a1b4-2bd1762f8abd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241023-AuVyA1gudq3CN-155&s=KOL2023&nf=P3737&i=30.61&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3976, 1, 33, 2, 0, NULL, 0, '2023-10-24 18:53:27', '2023-10-24 18:53:27', '2023-10-24', '', '23-05221-10-24', NULL, 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Medio N 24 bajo', 'Errenteria', 'Gipuzkoa', '20100', '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),
(3977, 1, 33, 2, 0, NULL, 0, '2023-10-24 19:00:02', '2023-10-24 19:00:02', '2023-10-24', '', '23-05222-10-24', NULL, 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Medio N 24 bajo', 'Errenteria', 'Gipuzkoa', '20100', '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),
(3978, 1, 33, 2, 0, NULL, 0, '2023-10-24 19:00:06', '2023-10-24 19:00:06', '2023-10-24', '', '23-05223-10-24', NULL, 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Medio N 24 bajo', 'Errenteria', 'Gipuzkoa', '20100', '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),
(3979, 1, 33, 2, 0, NULL, 0, '2023-10-24 19:03:44', '2023-10-25 10:00:57', '2023-10-24', 'P3740', '23-05224-10-24', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Medio N 24 bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-241023-VYJ/aGGUlgLmG-029', '5e771601-13f4-47ae-b18b-5d23000abb4b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241023-VYJ%2FaGGUlgLmG-029&s=KOL2023&nf=P3740&i=137.94&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3980, 1, 98, 2, 0, NULL, 0, '2023-10-24 19:19:00', '2023-10-25 09:34:36', '2023-10-24', 'P3738', '23-05225-10-24', '', 0.00, 113.98, 23.93, 0.00, 0, 0.00, 0.00, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 137.92, 0, '2023-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241023-h9dhp8kU+zltT-231', 'eb96f57f-4036-4fc9-8aff-fc460dec351d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241023-h9dhp8kU%2BzltT-231&s=KOL2023&nf=P3738&i=137.91&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3981, 1, 1010, 2, 0, NULL, 0, '2023-10-24 20:59:55', '2023-10-25 09:53:55', '2023-10-24', 'P3739', '23-05226-10-24', 'En el campo localidad no está Mutilva mi dirección sería\r\nRaquel Gastesi Barasoain\r\nC/Intxaurreta 6\r\n31192 Mutilva ( Navarra)\r\n', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Intxaurreta 6', 'Aranguren', 'Navarra', '31192', 'España', 78.63, 0, '2023-10-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241023-IyGzsliMvMnhc-218', 'c10da1bc-bf09-4b3c-8984-c80b0429b016', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241023-IyGzsliMvMnhc-218&s=KOL2023&nf=P3739&i=78.63&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3982, 1, 77, 1, 0, NULL, 0, '2023-10-25 10:06:28', '2023-10-25 10:12:33', '2023-10-25', 'P3741', '2023-10-25', '', 0.00, 1784.64, 374.77, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 2159.41, 0, '2023-10-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-251023-HysoE2REeLF0D-112', '6f30deaa-4e08-4e1a-b094-94a99727d5e1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251023-HysoE2REeLF0D-112&s=KOL2023&nf=P3741&i=2159.41&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3983, 1, 932, 2, 0, NULL, 0, '2023-10-25 09:42:00', '2023-10-25 11:45:04', '2023-10-25', 'P3742', '23-05227-10-25', 'Llamar antes de entregar', 0.00, 211.70, 44.46, 0.00, 0, 0.00, 0.00, 'Calle acera del pilar, edificio residencial casa fuerte local 2 peluquería ', 'Almuñécar', 'Granada', '18697', 'España', 256.16, 0, '2023-10-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-251023-VcNYlxxiwQDGp-122', '731a9c86-09d6-4f94-9f0e-8bd08d950920', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251023-VcNYlxxiwQDGp-122&s=KOL2023&nf=P3742&i=256.16&cr=227', '[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
(3984, 1, 99, 2, 0, NULL, 0, '2023-10-25 09:55:22', '2023-10-25 12:04:56', '2023-10-25', 'P3743', '23-05228-10-25', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Iñigo arista 19 Trasera ', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 103.46, 0, '2023-10-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251023-SJW31YQqDQs2r-060', '1cb3a42d-a268-4bb3-b613-c14c926395b5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251023-SJW31YQqDQs2r-060&s=KOL2023&nf=P3743&i=103.46&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3985, 1, 257, 2, 0, NULL, 0, '2023-10-25 13:16:55', '2023-10-26 09:47:03', '2023-10-25', 'P3744', '23-05229-10-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer Sant Mariá 99, escalera C, 5-4', 'Viladecans', 'Barcelona', '08840', 'España', 30.61, 0, '2023-10-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251023-XeyIDImXJNWCH-195', '50086a19-a136-47cc-8d9e-35e0d5d8c02e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251023-XeyIDImXJNWCH-195&s=KOL2023&nf=P3744&i=30.61&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3986, 1, 244, 2, 0, NULL, 0, '2023-10-25 14:54:42', '2023-10-26 09:53:29', '2023-10-25', 'P3747', '23-05230-10-25', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'Calle Balmes 79 Local 3', 'Calella', 'Barcelona', '08370', 'España', 147.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-251023-Y7oNUw21UIdYC-173', '1db9ab9b-dc7d-4e39-b78e-5357426fd451', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251023-Y7oNUw21UIdYC-173&s=KOL2023&nf=P3747&i=147.79&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3987, 1, 111, 2, 0, NULL, 0, '2023-10-25 18:59:26', '2023-10-26 09:57:18', '2023-10-25', 'P3745', '23-05231-10-25', '', 0.00, 138.42, 29.07, 0.00, 0, 0.00, 0.00, 'c/ Loza, nº1 piso 7b', 'Ansoáin', 'Navarra', '31013', 'España', 167.49, 0, '2023-10-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251023-FZVjCJcKTC9kM-229', 'baae83ab-39a6-44ae-8d83-93c2d69da04b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251023-FZVjCJcKTC9kM-229&s=KOL2023&nf=P3745&i=167.49&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3988, 1, 310, 2, 0, NULL, 0, '2023-10-25 19:25:27', '2023-10-26 09:58:32', '2023-10-25', 'P3746', '23-05232-10-25', '', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'JOSE LUIS ISASI, 6  3º-C', 'Vitoria-Gasteiz', 'Álava', '01006', 'España', 95.98, 0, '2023-10-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251023-IZBwVb8SYxPDd-152', 'b152ba23-d861-4776-afb3-8febe148f819', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251023-IZBwVb8SYxPDd-152&s=KOL2023&nf=P3746&i=95.98&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3989, 1, 956, 1, 0, NULL, 0, '2023-10-26 10:30:49', '2023-10-26 10:32:14', '2023-10-26', 'P3748', '2023-10-26', '', 0.00, 142.50, 29.92, 0.00, 1, 7.41, 0.00, 'Santo Domingo 1, bajo', 'Vigo', 'Pontevedra', '36204', 'España', 179.83, 0, '2023-10-26 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-261023-BDB8fO58wjK0z-167', '0184fcbb-844b-435c-81f7-0e23e78d2893', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261023-BDB8fO58wjK0z-167&s=KOL2023&nf=P3748&i=179.83&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0);
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
(3990, 1, 1011, 2, 0, NULL, 0, '2023-10-26 09:43:26', '2023-10-26 11:55:04', '2023-10-26', 'P3749', '23-05233-10-26', 'Local 7 Peluquería Arte&Cabello', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Avenida Goleta 23-25', 'Alicante/Alacant', 'Alicante', '03550', 'España', 196.56, 0, '2023-10-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261023-jgQYe6xUuSA5t-252', '3c131641-a808-4a4c-b93c-d59b22b3f408', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261023-jgQYe6xUuSA5t-252&s=KOL2023&nf=P3749&i=196.56&cr=026', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3991, 1, 618, 2, 0, NULL, 0, '2023-10-26 09:47:49', '2023-10-26 11:58:46', '2023-10-26', 'P3750', '23-05234-10-26', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle domenec sugrañes y gras n6 bajo7', 'Salou', 'Tarragona', '43840', 'España', 65.52, 0, '2023-10-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-261023-GZDZkR5RXneQG-217', 'a77c22e3-e7a9-46fc-bfc8-8905c095887f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261023-GZDZkR5RXneQG-217&s=KOL2023&nf=P3750&i=65.52&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3992, 1, 474, 1, 0, NULL, 0, '2023-10-26 13:06:42', '2023-10-30 11:02:48', '2023-10-26', 'P3752', '2023-10-26', '', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'C Ntra Sra de los clarines 56', 'Beas', 'Huelva', '21630', 'España', 133.00, 0, '2023-10-26 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-261023-i6Rbinw5tegHx-213', '4beeefce-5af5-4ad0-9868-ffac7fac9512', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261023-i6Rbinw5tegHx-213&s=KOL2023&nf=P3752&i=133.00&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3993, 1, 1012, 2, 0, NULL, 0, '2023-10-26 12:09:18', '2023-10-27 09:14:07', '2023-10-26', 'P3753', '2023-10-26', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ Josep de Peray, 17 bj 1', 'Sant Cugat del Vallè', 'Barcelona', '08173', 'España', 28.39, 0, '2023-10-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261023-DzNK56CJjc8oc-069', '39534692-a74e-4fe4-a880-26aa3ba2dd75', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261023-DzNK56CJjc8oc-069&s=KOL2023&nf=P3753&i=28.39&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3994, 1, 573, 2, 0, NULL, 0, '2023-10-26 15:06:53', '2023-10-27 09:17:15', '2023-10-26', 'P3755', '23-05236-10-26', '', 0.00, 59.49, 12.93, 0.00, 0, 0.00, 2.50, 'paseo margallo 22 urbanización Quint Mar', 'Sitges', 'Barcelona', '08870', 'España', 74.48, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-261023-g6Qt7SfaRjald-222', 'a1c4c9c9-e243-47ab-9556-7eaa25b8042d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261023-g6Qt7SfaRjald-222&s=KOL2023&nf=P3755&i=74.48&cr=175', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3995, 1, 715, 2, 0, NULL, 0, '2023-10-26 16:46:41', '2023-10-27 09:18:29', '2023-10-26', 'P3754', '23-05237-10-26', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sanguino Michel n 16, 4 A', 'Cáceres', 'Cáceres', '10001', 'España', 28.39, 0, '2023-10-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-261023-NnQTj+JSZUTsV-171', 'bafab0e9-5802-4ada-b851-bdf4e40780a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261023-NnQTj%2BJSZUTsV-171&s=KOL2023&nf=P3754&i=28.39&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3996, 1, 190, 3, 0, NULL, 0, '2023-10-27 10:02:26', '2023-10-27 10:03:18', '2023-10-27', '', 'consumo peluquería', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 103.46, 0, '2023-10-27 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);
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
(3997, 1, 1013, 2, 0, NULL, 0, '2023-10-28 13:17:42', '2023-10-30 11:52:26', '2023-10-28', 'P3756', '23-05238-10-28', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avda Monasterio de silos 38 B 1A', 'Madrid', 'Madrid', '28049', 'España', 17.50, 0, '2023-10-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-281023-MLCpwz2mP+y54-071', '177587e5-043b-4f18-84e7-25818589dea1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281023-MLCpwz2mP%2By54-071&s=KOL2023&nf=P3756&i=17.50&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3998, 1, 571, 2, 0, NULL, 0, '2023-10-29 14:34:09', '2023-10-30 11:53:22', '2023-10-29', 'P3761', '23-05239-10-29', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'ANAROTZ 30,2B', 'Tolosa', 'Gipuzkoa', '20400', 'España', 52.39, 0, '2023-10-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291023-VsfjNRXgg/cVl-131', '5404887a-844f-44c6-8bb0-911193a1e2d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291023-VsfjNRXgg%2FcVl-131&s=KOL2023&nf=P3761&i=52.39&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3999, 1, 80, 2, 0, NULL, 0, '2023-10-29 14:37:36', '2023-10-30 08:50:15', '2023-10-29', 'P3757', '23-05240-10-29', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 344.85, 0, '2023-10-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291023-dJ1OT/dofogEY-034', '7109d1df-f957-4ea2-9bf2-85e3ce5b2374', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291023-dJ1OT%2FdofogEY-034&s=KOL2023&nf=P3757&i=344.85&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4000, 1, 754, 2, 0, NULL, 0, '2023-10-29 15:31:34', '2023-10-30 08:51:46', '2023-10-29', 'P3758', '23-05241-10-29', 'de forma puntual mándame el pedido a\r\nCalle Mallorca nº 5 Local\r\n43870\r\nAmposta', 0.00, 48.84, 10.25, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2023-10-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-291023-QSnngBWf6M1np-137', '3d77ed16-3654-4b27-b4f0-2af4f375faf6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291023-QSnngBWf6M1np-137&s=KOL2023&nf=P3758&i=61.64&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4001, 1, 1014, 2, 0, NULL, 0, '2023-10-29 16:01:44', '2023-10-30 08:54:25', '2023-10-29', 'P3759', '23-05242-10-29', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Belorrieta 2, 2 D', 'Aretxabaleta', 'Gipuzkoa', '20550', 'España', 28.39, 0, '2023-10-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291023-ZePGtyWlBDMAE-198', '31f37b43-76f1-48c8-a3d8-723bf315b6ca', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291023-ZePGtyWlBDMAE-198&s=KOL2023&nf=P3759&i=28.39&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4002, 1, 1015, 2, 0, NULL, 0, '2023-10-29 16:30:19', '2023-10-30 08:57:02', '2023-10-29', 'P3760', '23-05244-10-29', '', 0.00, 81.15, 17.04, 0.00, 0, 0.00, 0.00, 'Calle Badalona, 102, 4A', 'Madrid', 'Madrid', '28034', 'España', 98.19, 0, '2023-10-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291023-Wrhj6AOf6xhc1-160', '9b40e6f0-2c26-4a7e-a336-0a6d72eaa98e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291023-Wrhj6AOf6xhc1-160&s=KOL2023&nf=P3760&i=98.19&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
