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
(3721, 1, 947, 2, 0, NULL, 0, '2023-09-02 08:00:17', '2023-09-04 09:18:13', '2023-09-02', 'P3494', '23-04943-09-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Av/ Profesor Sanchis guarner n°62 pta25', 'Vinalesa', 'Valencia', '46114', 'España', 28.39, 0, '2023-09-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020923-R7/mvl5HK2bMZ-011', '625bfb27-b85e-4b5d-9153-27f9f78fa2cf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020923-R7%2Fmvl5HK2bMZ-011&s=KOL2023&nf=P3494&i=28.39&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3722, 1, 935, 2, 0, NULL, 0, '2023-09-02 13:55:15', '2023-09-04 09:22:07', '2023-09-02', 'P3495', '23-04944-09-02', 'Ortopedia', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer d\'Amadeu Torner 51, Local', 'Hospitalet de Llobre', 'Barcelona', '08902', 'España', 30.61, 0, '2023-09-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020923-G2p+a3aGjqpXI-016', '7680156c-69b6-42af-9f8b-6f525b294478', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020923-G2p%2Ba3aGjqpXI-016&s=KOL2023&nf=P3495&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),
(3723, 1, 754, 2, 0, NULL, 0, '2023-09-03 08:59:43', '2023-09-04 09:27:48', '2023-09-03', 'P3496', '23-04945-09-03', 'como habeis visto he regalo vuestros tintes para hacer publicidad de la marca, a una influencer @masquemama. Si me pudierais reponer algún color para recuperarlo,os lo agradeceria. en ese caso era el color arena, pero me vale cualquier color. Ahora una chica influencer tambien sacará el tratamiento de plantas incoloro que tambien le he regalado. gracias de antemano', 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-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030923-iHtMgnyzJpkB0-225', '4095734f-dad1-44ef-9beb-2509ed5999de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030923-iHtMgnyzJpkB0-225&s=KOL2023&nf=P3496&i=61.64&cr=234', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3724, 1, 548, 2, 0, NULL, 0, '2023-09-03 11:06:07', '2023-09-04 09:30:33', '2023-09-03', 'P3497', '23-04946-09-03', 'Solo estoy por las ma', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle San Blas 10, Bajo, B', 'Humanes de Madrid', 'Madrid', '28970', 'España', 30.61, 0, '2023-09-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030923-StpKlFi6WpSZ4-255', '22f4c241-e8a0-4567-a94d-dd5254a58c89', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030923-StpKlFi6WpSZ4-255&s=KOL2023&nf=P3497&i=30.61&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3725, 1, 948, 2, 0, NULL, 0, '2023-09-03 13:23:27', '2023-09-04 09:35:15', '2023-09-03', 'P3498', '23-04947-09-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Principe de vergara 259', 'Madrid', 'Madrid', '28016', 'España', 30.61, 0, '2023-09-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030923-C0spFliwonaob-066', '7e0d2f55-7574-4de5-9f56-9e9fcbf8e467', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030923-C0spFliwonaob-066&s=KOL2023&nf=P3498&i=30.61&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3726, 1, 121, 2, 0, NULL, 0, '2023-09-03 18:23:13', '2023-09-04 09:44:45', '2023-09-03', 'P3499', '23-04948-09-03', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 310.37, 0, '2023-09-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030923-Mvz7wBP6PV3un-169', 'd159e8a3-c1a3-4e10-99eb-e78e2f8c1bb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030923-Mvz7wBP6PV3un-169&s=KOL2023&nf=P3499&i=310.37&cr=212', '[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
(3727, 1, 949, 2, 0, NULL, 0, '2023-09-03 18:49:50', '2023-09-04 09:46:31', '2023-09-03', 'P3500', '23-04949-09-03', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Isaac Peral 6 - 4E', 'Santander', 'Cantabria', '39008', 'España', 41.50, 0, '2023-09-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030923-AYO5WJaWMl2YG-028', '27c9c2ff-1759-45da-8a0a-85cfbd737f54', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030923-AYO5WJaWMl2YG-028&s=KOL2023&nf=P3500&i=41.50&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3728, 1, 532, 2, 0, NULL, 0, '2023-09-03 20:56:20', '2023-09-04 09:49:29', '2023-09-03', 'P3501', '23-04950-09-03', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Ayuntamiento de Baztan. Plaza Fueros s.n. Elizondo', 'Baztan', 'Navarra', '31700', 'España', 52.39, 0, '2023-09-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030923-ToHfTgYzRmXFM-117', '7c527990-7472-4f05-83da-2f4fb82b8259', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030923-ToHfTgYzRmXFM-117&s=KOL2023&nf=P3501&i=52.39&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3729, 1, 754, 4, 0, NULL, 0, '2023-09-04 10:05:38', '2023-09-04 10:05:38', '2023-09-04', '', 'PROMOCIÓN', '', 0.00, 24.42, 5.13, 0.00, 1, 1.27, 0.00, 'Josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 30.82, 0, '2023-09-04 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),
(3730, 1, 950, 2, 0, NULL, 0, '2023-09-04 10:25:39', '2023-09-04 12:31:44', '2023-09-04', 'P3502', '23-04951-09-04', 'Entrega a partir del día 13, gracias', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Iparragirre 5 6* dcha ', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 17.50, 0, '2023-09-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040923-FfqM5Ufpv5s04-094', 'b9fd5042-39ce-4d2e-82ff-c9ac986c3488', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040923-FfqM5Ufpv5s04-094&s=KOL2023&nf=P3502&i=17.50&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3731, 1, 951, 2, 0, NULL, 0, '2023-09-04 12:09:30', '2023-09-04 15:35:28', '2023-09-04', 'P3503', '23-04952-09-04', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'calle pedro rico 27, escalera 1. 6 A', 'Madrid', 'Madrid', '28029', 'España', 28.39, 0, '2023-09-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040923-cRaduqY5aAahA-186', 'a2a8bcc8-9918-4c41-94e2-0b04552df7aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040923-cRaduqY5aAahA-186&s=KOL2023&nf=P3503&i=28.39&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3732, 1, 75, 2, 0, NULL, 0, '2023-09-04 15:40:51', '2023-09-05 09:07:50', '2023-09-04', 'P3504', '23-04958-09-04', 'Horario de martes a viernes de 10 00 a 19 00, sábados de 10 00 a 14 00 ', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 172.43, 0, '2023-09-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040923-IdoWnJBKpCUmY-201', '2a3a6f85-9c7f-4d49-8fb5-5b7a8b36e99b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040923-IdoWnJBKpCUmY-201&s=KOL2023&nf=P3504&i=172.43&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3733, 1, 952, 2, 0, NULL, 0, '2023-09-04 16:01:39', '2023-09-05 09:09:52', '2023-09-04', 'P3505', '23-04959-09-04', 'Si no hay nadie que lo dejen en portería. Gracias ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Llull 57 4o 5a', 'Barcelona', 'Barcelona', '08005', 'España', 17.50, 0, '2023-09-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040923-AnLq4mC0H/cm4-043', 'ef27e3d3-b8d0-4119-834c-c8bdc1bf32f8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040923-AnLq4mC0H%2Fcm4-043&s=KOL2023&nf=P3505&i=17.50&cr=038', '[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
(3734, 1, 98, 2, 0, NULL, 0, '2023-09-04 20:56:13', '2023-09-05 09:12:35', '2023-09-04', 'P3506', '23-04960-09-04', '', 0.00, 81.42, 17.53, 0.00, 0, 0.00, 2.50, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 101.02, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-040923-eYCM+t/jnE0no-200', 'c91aaaaa-7078-4c94-af0d-9219501fdd26', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040923-eYCM%2Bt%2FjnE0no-200&s=KOL2023&nf=P3506&i=101.02&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3735, 1, 953, 2, 0, NULL, 0, '2023-09-05 12:38:10', '2023-09-06 09:05:29', '2023-09-05', 'P3507', '23-04961-09-05', 'Llamar antes de entregar al 654031781', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Ulargui,31', 'Gandia', 'Valencia', '46730', 'España', 17.50, 0, '2023-09-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050923-Q781fWmShNV4d-169', 'cf261c6b-3b71-4e9b-a73a-becdece2e261', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050923-Q781fWmShNV4d-169&s=KOL2023&nf=P3507&i=17.50&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3736, 1, 246, 2, 0, NULL, 0, '2023-09-05 15:06:09', '2023-09-06 09:09:28', '2023-09-05', 'P3508', '23-04962-09-05', 'alberto hidalgo atelier (peluqueria)', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'Iparragirre 9, bis. ', 'Bilbao', 'BIZKAIA', '48009', 'ESPAÑA', 59.10, 0, '2023-09-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050923-bdJNymMQXHU0c-039', 'ff9675f2-4c53-4e08-9ddd-2726b2984e60', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050923-bdJNymMQXHU0c-039&s=KOL2023&nf=P3508&i=59.10&cr=054', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3737, 1, 131, 2, 0, NULL, 0, '2023-09-05 15:14:25', '2023-09-05 15:14:25', '2023-09-05', '', '23-04963-09-05', NULL, 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 206.91, 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),
(3738, 1, 131, 2, 0, NULL, 0, '2023-09-05 15:14:28', '2023-09-06 09:12:24', '2023-09-05', 'P3514', '23-04964-09-05', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'avd.Ferrocarril 2B (peluqueria Bilbo)', 'Bilbao', 'Bizkaia', '48013', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050923-dlqYzsLQqAXJV-068', '5b950db6-9cab-4306-901e-2b05c8d180cc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050923-dlqYzsLQqAXJV-068&s=KOL2023&nf=P3514&i=206.91&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3739, 1, 793, 2, 0, NULL, 0, '2023-09-05 15:20:49', '2023-09-06 09:14:15', '2023-09-05', 'P3509', '23-04965-09-05', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'C/Igualdad, 54', 'Alcorcón', 'Madrid', '28922', 'España', 52.39, 0, '2023-09-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050923-X/5Oqv1xq/KL2-011', '8b9fd254-9271-4f5c-8e6b-1fb639b24a4b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050923-X%2F5Oqv1xq%2FKL2-011&s=KOL2023&nf=P3509&i=52.39&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3740, 1, 32, 2, 0, NULL, 0, '2023-09-05 17:19:33', '2023-09-06 09:17:28', '2023-09-05', 'P3510', '2023-09-05', 'Es una peluqueria', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'C/José Eguino,  numero 20, bajo', 'Irun', 'Gipuzkoa', '20302', 'España', 241.40, 0, '2023-09-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050923-Y/sKd5gxfGl6V-042', '940e56c1-9bf2-4678-b997-3d3a3e210613', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050923-Y%2FsKd5gxfGl6V-042&s=KOL2023&nf=P3510&i=241.40&cr=189', '[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
(3741, 1, 23, 2, 0, NULL, 0, '2023-09-05 17:36:03', '2023-09-06 09:21:56', '2023-09-05', 'P3511', '23-04967-09-05', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 137.94, 0, '2023-09-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050923-ml9kgAKuoE/SG-158', 'fa47d3ce-d44d-4213-b3dd-16312d19a36d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050923-ml9kgAKuoE%2FSG-158&s=KOL2023&nf=P3511&i=137.94&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3742, 1, 378, 2, 0, NULL, 0, '2023-09-05 22:20:57', '2023-09-06 09:24:54', '2023-09-05', 'P3512', '23-04968-09-05', 'Horario de entrega de 9´00 a 13´00 de la mañana o de 16´30 a 19´30  de la tarde', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Elizgibela 1 -Bajo', 'Burlada/Burlata', 'Navarra', '31600', 'España', 30.61, 0, '2023-09-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050923-nFGSi0jXK6vbF-070', 'd720a897-7e70-4c97-bc61-d3ee58f16807', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050923-nFGSi0jXK6vbF-070&s=KOL2023&nf=P3512&i=30.61&cr=218', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3743, 1, 955, 2, 0, NULL, 0, '2023-09-06 06:36:12', '2023-09-06 09:27:17', '2023-09-06', 'P3513', '23-04969-09-06', 'Si no estoy dejar a mi vecina 3A Begoña o 4A Saray', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paseo Olivos 59 4B', 'Madrid', 'Madrid', '28011', 'España', 30.61, 0, '2023-09-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060923-gp8MV+2IPIEru-254', 'b8d020be-fa8f-4500-af9c-66e38aeaeacf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-gp8MV%2B2IPIEru-254&s=KOL2023&nf=P3513&i=30.61&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3744, 1, 262, 2, 0, NULL, 0, '2023-09-06 07:35:27', '2023-09-06 09:58:24', '2023-09-06', 'P3515', '23-04970-09-06', 'Lunes y sábado por la tarde cerrado.', 0.00, 56.98, 11.97, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 68.95, 0, '2023-09-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060923-JCDy/H7O8VO0q-188', '3aa8b6f5-0ab8-43dc-909c-072b25ce60cb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-JCDy%2FH7O8VO0q-188&s=KOL2023&nf=P3515&i=68.95&cr=054', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3745, 1, 4, 2, 0, NULL, 0, '2023-09-06 08:04:31', '2023-09-06 10:42:23', '2023-09-06', 'P3516', '23-04971-09-06', '', 0.00, 313.48, 65.83, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 379.31, 0, '2023-09-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060923-KaUJl4grFLb7g-060', '0f466d4f-d807-417e-adee-bbf46987bdb6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-KaUJl4grFLb7g-060&s=KOL2023&nf=P3516&i=379.31&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3746, 1, 80, 2, 0, NULL, 0, '2023-09-06 08:35:15', '2023-09-06 10:44:23', '2023-09-06', 'P3517', '23-04973-09-06', '', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 517.28, 0, '2023-09-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060923-bqr36dyoMHzb6-083', 'a12baef1-d5ba-44ca-aca5-6b8da584ea95', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-bqr36dyoMHzb6-083&s=KOL2023&nf=P3517&i=517.28&cr=140', '[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
(3747, 1, 65, 2, 0, NULL, 0, '2023-09-06 08:50:46', '2024-07-17 13:07:19', '2023-09-06', 'P3518', '23-04974-09-06', '', 0.00, 627.00, 131.67, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 758.67, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060923-DHGlVr9wFcjF6-217', 'c971818e-c730-4089-9c0f-d33b2ba5e434', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-DHGlVr9wFcjF6-217&s=KOL2023&nf=P3518&i=758.67&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3748, 1, 149, 2, 0, NULL, 0, '2023-09-06 09:42:47', '2023-09-06 12:07:38', '2023-09-06', 'P3519', '23-04976-09-06', '', 0.00, 146.56, 30.78, 0.00, 0, 0.00, 0.00, 'urumea kalea 6, izeta peluqueria', 'Zumaia', 'Gipuzkoa', '20750', 'España', 177.34, 0, '2023-09-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060923-TF7eMafBXxHc2-214', '10f2cf61-7b77-495a-b025-043d17254a64', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-TF7eMafBXxHc2-214&s=KOL2023&nf=P3519&i=177.34&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3749, 1, 956, 2, 0, NULL, 0, '2023-09-06 10:15:33', '2023-09-06 12:17:43', '2023-09-06', 'P3520', '23-04977-09-06', '', 0.00, 427.50, 89.78, 0.00, 1, 22.23, 0.00, 'Santo Domingo 1, bajo', 'Vigo', 'Pontevedra', '36204', 'España', 539.51, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060923-P/UC9tAf/MvBg-240', 'e18b32db-28a8-41ed-a877-d639cc2b36da', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-P%2FUC9tAf%2FMvBg-240&s=KOL2023&nf=P3520&i=539.51&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3750, 1, 17, 2, 0, NULL, 0, '2023-09-06 13:31:47', '2023-09-07 09:33:10', '2023-09-06', 'P3521', '23-04979-09-06', '', 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, '2023-09-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060923-aX9HLofGzmE8h-211', 'a17dcbe7-cb05-4d60-88eb-a76379da96b3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-aX9HLofGzmE8h-211&s=KOL2023&nf=P3521&i=103.46&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3751, 1, 97, 2, 0, NULL, 0, '2023-09-06 18:52:11', '2023-09-07 09:35:40', '2023-09-06', 'P3522', '23-04983-09-06', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle Bidasoa 8, Bajo Bera', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 68.97, 0, '2023-09-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060923-enYxJCjleNljc-116', '6694c8f9-5088-450b-9ac1-a003ef5f6261', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-enYxJCjleNljc-116&s=KOL2023&nf=P3522&i=68.97&cr=210', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3752, 1, 957, 2, 0, NULL, 0, '2023-09-06 19:03:33', '2023-09-07 09:36:55', '2023-09-06', 'P3523', '23-04984-09-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Av. Baixador 122', 'Sant Cugat del Vallè', 'Barcelona', '08197', 'España', 17.50, 0, '2023-09-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-060923-F4A2WH/cAtJSj-109', 'cd3bd006-0295-44b7-a2de-6d11f90be033', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060923-F4A2WH%2FcAtJSj-109&s=KOL2023&nf=P3523&i=17.50&cr=082', '[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
(3753, 1, 120, 2, 0, NULL, 0, '2023-09-07 07:36:30', '2023-09-07 09:39:48', '2023-09-07', 'P3524', '23-04985-09-07', '', 0.00, 81.42, 17.10, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 98.52, 0, '2023-09-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070923-UD/Ny4EmqN9wv-095', 'b27eef6e-8a36-44b7-a5bb-0884d832b819', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070923-UD%2FNy4EmqN9wv-095&s=KOL2023&nf=P3524&i=98.52&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3754, 1, 53, 2, 0, NULL, 0, '2023-09-07 09:10:30', '2023-09-07 11:14:59', '2023-09-07', 'P3525', '23-04986-09-07', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-070923-NnpPJ90yubo0z-016', '9b386628-5196-4218-b164-5aa5aac0ee8f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070923-NnpPJ90yubo0z-016&s=KOL2023&nf=P3525&i=174.93&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3755, 1, 87, 2, 0, NULL, 0, '2023-09-07 10:27:00', '2023-09-07 12:40:56', '2023-09-07', 'P3526', '23-04987-09-07', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'CC Arcco local P17', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 103.46, 0, '2023-09-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070923-Da+1Tzy4HWUG2-113', 'bdd29672-5073-4ea3-9de3-ab36bce2b810', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070923-Da%2B1Tzy4HWUG2-113&s=KOL2023&nf=P3526&i=103.46&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3756, 1, 780, 2, 0, NULL, 0, '2023-09-07 13:58:46', '2023-09-08 10:17:09', '2023-09-07', 'P3527', '23-04988-09-07', 'Etxean ez banago berjan barrun utzi paketea. Eskerrik asko.', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Santsaerreka. 24.', 'Asparrena', 'Álava', '01250', 'España', 61.09, 0, '2023-09-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070923-g6tXYjtJg5OJg-186', '62e194f4-8482-4a42-9518-c9158e314b6f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070923-g6tXYjtJg5OJg-186&s=KOL2023&nf=P3527&i=61.09&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3757, 1, 958, 2, 0, NULL, 0, '2023-09-08 12:17:09', '2023-09-11 09:10:02', '2023-09-08', 'P3528', '23-04989-09-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer Pensaments, 41 (planta 2 casa)', 'Viladecans', 'Barcelona', '08840', 'España', 17.50, 0, '2023-09-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080923-gmd/ZrzzBcDiR-112', 'c6dd3c44-e9d4-4784-8711-660b95591893', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080923-gmd%2FZrzzBcDiR-112&s=KOL2023&nf=P3528&i=17.50&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3758, 1, 236, 2, 0, NULL, 0, '2023-09-08 16:32:18', '2023-09-11 09:13:05', '2023-09-08', 'P3529', '23-04990-09-08', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'AVDA. DE LA POLICÍA NACIONAL, EDF. DONIIVES, 24', 'Antequera', 'Málaga', '29200', 'España', 241.40, 0, '2023-09-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080923-BMJsKN9Ro504M-235', 'bfacc31c-d9d9-4aed-83f3-7703fbdcb6b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080923-BMJsKN9Ro504M-235&s=KOL2023&nf=P3529&i=241.40&cr=163', '[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
(3759, 1, 959, 2, 0, NULL, 0, '2023-09-09 13:26:10', '2023-09-11 09:17:13', '2023-09-09', 'P3530', '23-04992-09-09', 'edifificio en cruce calles infantes y calleja norte', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'avenida infantes 24 interior 2A', 'Santander', 'Cantabria', '39005', 'España', 28.39, 0, '2023-09-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090923-jlXJ08XF22N7M-038', '7daca15d-e3bb-455b-a0e6-38e2aaf47398', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090923-jlXJ08XF22N7M-038&s=KOL2023&nf=P3530&i=28.39&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3760, 1, 960, 2, 0, NULL, 0, '2023-09-10 11:38:48', '2023-09-10 11:38:48', '2023-09-10', 'P3531', '23-04993-09-10', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ La Villa, 7 bajo izquierda', 'Posadas', 'Córdoba', '14730', 'España', 28.39, 0, '2023-09-10 11:38:47', '', '', 3, 1, 1, 'TBAI-B20930640-100923-euH4Yl5Fcfrth-160', '73846e4f-c16f-46bf-bbd5-ac63b455262b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100923-euH4Yl5Fcfrth-160&s=KOL2023&nf=P3531&i=28.39&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(3761, 1, 602, 2, 0, NULL, 0, '2023-09-10 14:10:51', '2023-09-11 09:22:37', '2023-09-10', 'P3532', '23-04995-09-10', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Plaza Porticada 2 5B', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 43.71, 0, '2023-09-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100923-QYaet3IHaaI+v-230', 'b9646387-8f77-4d15-827a-573af9f3c865', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100923-QYaet3IHaaI%2Bv-230&s=KOL2023&nf=P3532&i=43.71&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3762, 1, 91, 2, 0, NULL, 0, '2023-09-10 19:15:10', '2023-09-11 09:24:38', '2023-09-10', 'P3533', '23-04996-09-10', 'Ya he pedido en varios pedidos las instrucciones en papel y nunca me llegan. Gracias ', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 275.88, 0, '2023-09-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100923-SVaS2a5YUhQlC-170', '926d6633-fbd2-4a21-942e-595864c2b4d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100923-SVaS2a5YUhQlC-170&s=KOL2023&nf=P3533&i=275.88&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3763, 1, 696, 1, 0, NULL, 0, '2023-09-11 12:25:21', '2023-09-11 12:26:13', '2023-09-11', 'P3534', '2023-09-11', '', 0.00, 265.98, 55.86, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 321.84, 0, '2023-09-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110923-K67oE0My3JNWU-065', '9e378cab-9d80-4e00-936f-a4e44097f6cb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110923-K67oE0My3JNWU-065&s=KOL2023&nf=P3534&i=321.83&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3764, 1, 961, 2, 0, NULL, 0, '2023-09-11 12:34:16', '2023-09-11 15:29:02', '2023-09-11', 'P3535', '23-05002-09-11', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle González Garbin 17, 6 - 1', 'Almería', 'Almería', '04001', 'España', 17.50, 0, '2023-09-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110923-g+9cGBbaz5Obr-253', '753ec2e5-9b17-4498-91e7-739852f4a053', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110923-g%2B9cGBbaz5Obr-253&s=KOL2023&nf=P3535&i=17.50&cr=099', '[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
(3765, 1, 733, 2, 0, NULL, 0, '2023-09-11 15:38:58', '2023-09-12 08:58:06', '2023-09-11', 'P3536', '23-05003-09-11', '4ª planta, 402', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Miguel Ángel, 8', 'Madrid', 'Madrid', '28010', 'España', 30.61, 0, '2023-09-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110923-hIwSDFMDKYs+4-250', '3ad7fe97-1b2c-4d32-a3ad-7f03526fd7ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110923-hIwSDFMDKYs%2B4-250&s=KOL2023&nf=P3536&i=30.61&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3766, 1, 443, 2, 0, NULL, 0, '2023-09-11 17:09:37', '2023-09-12 08:59:36', '2023-09-11', '', '23-05006-09-11', '', 0.00, 43.32, 10.52, 0.00, 0, 0.00, 8.19, 'Via Verdi, 14, vivenda 2', 'Ciutadella de Menorc', 'Baleares (Illes)', '07760', 'España', 60.61, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3767, 1, 443, 2, 0, NULL, 0, '2023-09-11 17:10:29', '2023-09-12 09:00:09', '2023-09-11', 'P3537', '23-05005-09-11', '', 0.00, 43.32, 10.52, 0.00, 0, 0.00, 8.19, 'Via Verdi, 14, vivenda 2', 'Ciutadella de Menorc', 'Baleares (Illes)', '07760', 'España', 60.61, 0, '2023-09-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110923-mtgFq6oMBxY4M-115', '05706b5a-56bc-46dd-abb2-c87ff20833ac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110923-mtgFq6oMBxY4M-115&s=KOL2023&nf=P3537&i=60.61&cr=229', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3768, 1, 11, 2, 0, NULL, 0, '2023-09-12 08:55:05', '2023-09-12 11:10:16', '2023-09-12', 'P3539', '23-05007-09-12', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'calle Colomeres 36 local 2', 'Gavà', 'Barcelona', '08840', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120923-mCNZb5za5Pe/x-011', '72a0c515-28dd-416e-acd1-7e9755f499e4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120923-mCNZb5za5Pe%2Fx-011&s=KOL2023&nf=P3539&i=172.43&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3769, 1, 294, 2, 0, NULL, 0, '2023-09-12 08:58:11', '2023-09-12 11:13:58', '2023-09-12', 'P3538', '23-05008-09-12', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Paseo condes de Barcelona,10-3D', 'Badajoz', 'Badajoz', '06010', 'España', 41.50, 0, '2023-09-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120923-XSjuwQVknWKd8-162', 'a92ac88c-41c6-483a-ae20-5da5d1bf945e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120923-XSjuwQVknWKd8-162&s=KOL2023&nf=P3538&i=41.50&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3770, 1, 4, 2, 0, NULL, 0, '2023-09-12 09:13:31', '2023-09-12 11:15:53', '2023-09-12', 'P3540', '23-05009-09-12', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 206.91, 0, '2023-09-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120923-ddP62Y+Ty4yC4-252', 'ccf06034-63e3-4d17-a50d-7379e975ca89', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120923-ddP62Y%2BTy4yC4-252&s=KOL2023&nf=P3540&i=206.91&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3771, 1, 28, 2, 0, NULL, 0, '2023-09-12 11:46:49', '2023-09-13 08:46:02', '2023-09-12', 'P3544', '23-05010-09-12', '', 0.00, 333.82, 70.10, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 403.92, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120923-akvOkHJdRxxKl-193', 'd807e032-a687-4c8d-9e4b-8aee3c53c1d9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120923-akvOkHJdRxxKl-193&s=KOL2023&nf=P3544&i=403.92&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
(3772, 1, 962, 2, 0, NULL, 0, '2023-09-12 14:33:46', '2023-09-13 08:48:10', '2023-09-12', 'P3541', '23-05013-09-12', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Quión- Muiña, nº20', 'Touro', 'A Coruña', '15824', 'España', 30.61, 0, '2023-09-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120923-n84t/aH7zBRG/-159', '0bdb08a3-a91c-43fb-b52e-7d13212df100', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120923-n84t%2FaH7zBRG%2F-159&s=KOL2023&nf=P3541&i=30.61&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3773, 1, 963, 2, 0, NULL, 0, '2023-09-12 16:41:38', '2023-09-13 08:51:29', '2023-09-12', 'P3542', '23-05014-09-12', '', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'Paseo Donantes de Sangre 2, esc.3-1ºC', 'Pamplona/Iruña', 'Navarra', '31015', 'España', 54.60, 0, '2023-09-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120923-MSdWTLSCTEEnD-090', 'd75b63b0-0137-466b-8259-c7ab28f43cc8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120923-MSdWTLSCTEEnD-090&s=KOL2023&nf=P3542&i=54.60&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3774, 1, 964, 2, 0, NULL, 0, '2023-09-12 20:12:51', '2023-09-13 08:54:10', '2023-09-12', 'P3543', '23-05015-09-12', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Luces De la Ciudad 27 5 B', 'Zaragoza', 'Zaragoza', '50019', 'España', 30.61, 0, '2023-09-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120923-T7E3LL5sZmmxR-018', '88a9435e-40d0-4091-a9bb-889e40b3cdae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120923-T7E3LL5sZmmxR-018&s=KOL2023&nf=P3543&i=30.61&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3775, 1, 641, 2, 0, NULL, 0, '2023-09-13 06:59:11', '2023-09-13 09:00:07', '2023-09-13', 'P3545', '23-05016-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-G2oi5e78XQUhY-189', '78f2c6d1-204c-4548-8501-1366d46483c3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-G2oi5e78XQUhY-189&s=KOL2023&nf=P3545&i=30.89&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(3776, 1, 641, 2, 1, 'CLIENTE ERRONEO', 3775, '2023-09-13 09:38:31', '2023-09-13 09:38:31', '2023-09-13', 'R54', 'P3545 RECT.', '', 0.00, 19.83, 5.36, 0.00, 0, 0.00, 6.90, '', '', '', '', '', 30.89, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-130923-DyTtlEmQGMlYy-163', '987600fd-6bff-4fef-9ed8-d8c9a1466d22', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-DyTtlEmQGMlYy-163&s=KOL2023&nf=R54&i=-30.89&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(3777, 1, 77, 1, 0, NULL, 0, '2023-09-13 09:51:10', '2023-09-13 09:51:10', '2023-09-13', 'P3546', '2023-09-13', '', 0.00, 729.30, 153.15, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 882.45, 0, '2023-09-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130923-h8Dlnwr5A0Ths-060', 'c453b732-9fe2-4207-8af4-bdad3be48669', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130923-h8Dlnwr5A0Ths-060&s=KOL2023&nf=P3546&i=882.45&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
