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
(4117, 1, 973, 2, 0, NULL, 0, '2023-11-19 19:44:02', '2023-11-20 09:00:23', '2023-11-19', 'P3864', '23-05377-11-19', 'Entregar pedido de 9 a.m. a 16:00 p.m.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Alejandro Dumas, 4', 'Madrid', 'Madrid', '28005', 'España', 28.39, 0, '2023-11-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191123-bbnXU5g/5PN1e-157', 'acb6e028-197a-498a-8e0a-d8e01c6b3da4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191123-bbnXU5g%2F5PN1e-157&s=KOL2023&nf=P3864&i=28.39&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4118, 1, 1045, 2, 0, NULL, 0, '2023-11-19 21:03:05', '2023-11-20 09:01:54', '2023-11-19', 'P3865', '23-05378-11-19', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Monasterio del paular 16 bajo F', 'Valladolid', 'Valladolid', '47015', 'España', 17.50, 0, '2023-11-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191123-jrZUYOJ9iDUyr-044', '72d1a581-342d-4641-aff9-ef991a61cb5e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191123-jrZUYOJ9iDUyr-044&s=KOL2023&nf=P3865&i=17.50&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4119, 1, 75, 2, 0, NULL, 0, '2023-11-20 08:50:51', '2023-11-20 10:12:35', '2023-11-20', 'P3869', '23-05379-11-20', 'Horario de martes a viernes de 10 00 a 19 00 ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 137.94, 0, '2023-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201123-eqvvcgqrZDUCS-009', '3c056602-fe69-4414-a0a8-134c1e7179d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201123-eqvvcgqrZDUCS-009&s=KOL2023&nf=P3869&i=137.94&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4120, 1, 661, 2, 0, NULL, 0, '2023-11-20 09:59:45', '2023-11-20 11:11:13', '2023-11-20', 'P3870', '23-05380-11-20', '', 0.00, 43.32, 10.30, 0.00, 0, 0.00, 6.90, 'redonde fragas nº9 campolameiro o fraginox', 'Campo Lameiro', 'Pontevedra', '36118', 'España', 59.32, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-201123-d8KbOfKmXKWza-025', '1c9dde68-683a-4701-84fb-1141ca482ae7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201123-d8KbOfKmXKWza-025&s=KOL2023&nf=P3870&i=59.32&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4121, 1, 1046, 2, 0, NULL, 0, '2023-11-20 10:23:37', '2023-11-20 11:25:57', '2023-11-20', 'P3871', '23-05381-11-20', '', 0.00, 75.81, 15.92, 0.00, 0, 0.00, 0.00, 'Kamiñopea N3 6D', 'Abadiño', 'Bizkaia', '48220', 'España', 91.73, 0, '2023-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201123-Bil08K8XVKzZV-058', 'a4aee317-6980-4c22-af9e-e2373bf2fb0e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201123-Bil08K8XVKzZV-058&s=KOL2023&nf=P3871&i=91.73&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4122, 1, 901, 2, 0, NULL, 0, '2023-11-20 13:03:07', '2023-11-20 15:28:30', '2023-11-20', 'P3872', '23-05383-11-20', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'c/Encina 16, Urb. Los Peñascales - Las Rozas', 'Madrid', 'Madrid', '28290', 'España', 17.50, 0, '2023-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201123-VvXkYT+T0dOix-185', 'b8bf8b4a-065e-428f-a595-3099336d83e2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201123-VvXkYT%2BT0dOix-185&s=KOL2023&nf=P3872&i=17.50&cr=020', '[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
(4123, 1, 1047, 2, 0, NULL, 0, '2023-11-20 14:07:08', '2023-11-20 15:29:08', '2023-11-20', 'P3873', '23-05384-11-20', 'Es una empresa (PASCH) \r\n. Preguntar por Susana Diz. Horario de 8-14,30h', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Gran Vía de les Corts Catalanes, 645, 2º-1', 'Barcelona', 'Barcelona', '08010', 'España', 28.39, 0, '2023-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201123-ZvJq5FneeWdNl-012', '54cc3fb4-d07d-4595-8dea-48f910100145', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201123-ZvJq5FneeWdNl-012&s=KOL2023&nf=P3873&i=28.39&cr=075', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4124, 1, 40, 2, 0, NULL, 0, '2023-11-20 15:44:45', '2023-11-21 09:31:03', '2023-11-20', 'P3874', '23-05385-11-20', 'martes cerrado ,puedes dejarlo en la panaderia ogi-koskorra', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 133.00, 0, '2023-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201123-BGbpWbU9kO3I/-238', 'a273447b-a626-4f4c-924c-a48ece13d1eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201123-BGbpWbU9kO3I%2F-238&s=KOL2023&nf=P3874&i=133.00&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4125, 1, 1048, 2, 0, NULL, 0, '2023-11-20 17:42:16', '2023-11-21 09:32:28', '2023-11-20', 'P3875', '23-05386-11-20', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Gipuzkoa 4, bajo B', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 65.52, 0, '2023-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201123-ZEig5kBxkkLuy-150', '631d6523-96a3-4c35-a668-3372c31a84e6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201123-ZEig5kBxkkLuy-150&s=KOL2023&nf=P3875&i=65.52&cr=192', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4126, 1, 782, 2, 0, NULL, 0, '2023-11-20 18:31:58', '2023-11-21 09:33:25', '2023-11-20', 'P3876', '23-05387-11-20', 'Llamar antes de la entrega', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Ronda Intermedia', 'Antequera', 'Málaga', '29200', 'España', 28.39, 0, '2023-11-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-201123-IAdg5988lt7FE-125', 'a68be64c-3019-448f-83df-b9959b35d98f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201123-IAdg5988lt7FE-125&s=KOL2023&nf=P3876&i=28.39&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4127, 1, 1049, 2, 0, NULL, 0, '2023-11-20 22:32:35', '2023-11-21 09:33:45', '2023-11-20', 'P3877', '23-05390-11-20', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Luis Luciano Bonaparte 20 4D', 'Bilbao', 'Bizkaia', '48004', 'España', 17.50, 0, '2023-11-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201123-m9m/4cdnbQzCw-163', '60d69b05-ad63-4bd8-8477-c78590eb867b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201123-m9m%2F4cdnbQzCw-163&s=KOL2023&nf=P3877&i=17.50&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4128, 1, 957, 2, 0, NULL, 0, '2023-11-21 05:51:10', '2023-11-21 09:33:58', '2023-11-21', 'P3878', '23-05391-11-21', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Av. Baixador 122', 'Sant Cugat del Vallè', 'Barcelona', '08197', 'España', 30.61, 0, '2023-11-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211123-fRNq0h0oV9vv1-187', '40603889-fce5-494d-8d06-07bb3e615086', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-fRNq0h0oV9vv1-187&s=KOL2023&nf=P3878&i=30.61&cr=168', '[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
(4129, 1, 382, 2, 0, NULL, 0, '2023-11-21 08:25:32', '2023-11-21 09:34:11', '2023-11-21', 'P3879', '23-05392-11-21', 'Si no estamos en el domicilio, entregar en el 2A (Ikerne y Esteban)', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/ Bulevar de Mariturri 60 - 2B', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 43.71, 0, '2023-11-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211123-D+At6iSfNpkwW-102', 'cc9c9775-f5eb-4248-9df9-86f72eacf78d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-D%2BAt6iSfNpkwW-102&s=KOL2023&nf=P3879&i=43.71&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4130, 1, 23, 2, 0, NULL, 0, '2023-11-21 10:19:16', '2023-11-21 11:44:46', '2023-11-21', 'P3880', '23-05393-11-21', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 275.88, 0, '2023-11-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211123-ISjBn6fV73hn8-185', '421fd83a-9eea-41a9-91d6-f141cfc3feb6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-ISjBn6fV73hn8-185&s=KOL2023&nf=P3880&i=275.88&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4131, 1, 956, 2, 1, 'error por cargarle recargo de equivalencia', 3749, '2023-11-21 12:28:30', '2023-11-21 12:28:30', '2023-11-21', 'R60', 'P3520 RECT.', '', 0.00, 427.50, 89.78, 0.00, 0, 22.23, 0.00, '', '', '', '', '', 539.51, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-211123-NjmS3IrFPKKM+-111', '056e2591-7651-4b15-af97-517a9040d4d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-NjmS3IrFPKKM%2B-111&s=KOL2023&nf=R60&i=-539.51&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4132, 1, 956, 1, 0, NULL, 0, '2023-11-21 12:33:22', '2023-11-21 13:50:16', '2023-11-21', 'P3881', '2023-11-21', '', 0.00, 427.50, 89.77, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1, bajo', 'Vigo', 'Pontevedra', '36204', 'España', 517.27, 0, '2023-11-21 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-211123-UppuxDEsRutfT-179', '5ef63aeb-7ac7-4b5f-8d50-88268cf79fa6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-UppuxDEsRutfT-179&s=KOL2023&nf=P3881&i=517.27&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4133, 1, 956, 1, 1, 'no había que cobrarle el recargo de equivalencia', 3989, '2023-11-21 12:39:13', '2023-11-21 12:39:13', '2023-11-21', 'R61', 'P3748 RECT.', '', 0.00, 142.50, 29.92, 0.00, 0, 7.41, 0.00, '', '', '', '', '', 179.83, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-211123-nxwZwBGScoHMn-122', 'e398fd02-ec49-4216-a330-e12250dcb4d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-nxwZwBGScoHMn-122&s=KOL2023&nf=R61&i=-179.83&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4134, 1, 956, 1, 0, NULL, 0, '2023-11-21 12:43:08', '2023-11-21 13:40:31', '2023-11-21', 'P3882', '2023-11-21', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1, bajo', 'Vigo', 'Pontevedra', '36204', 'España', 172.42, 0, '2023-11-21 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-211123-CX58QX4w2V+sH-176', '5cbe8773-0068-4b01-b783-d571eb293093', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-CX58QX4w2V%2BsH-176&s=KOL2023&nf=P3882&i=172.42&cr=050', '[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
(4135, 1, 522, 2, 0, NULL, 0, '2023-11-21 12:30:35', '2023-11-21 13:44:17', '2023-11-21', 'P3883', '23-05394-11-21', '', 0.00, 195.42, 41.04, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 236.46, 0, '2023-11-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211123-I4sKibdqmmIw6-242', 'f2e78d0c-9cb2-4f11-9681-d6190d11af38', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-I4sKibdqmmIw6-242&s=KOL2023&nf=P3883&i=236.46&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4136, 1, 1050, 2, 0, NULL, 0, '2023-11-21 17:38:32', '2023-11-22 08:55:50', '2023-11-21', '', '23-05395-11-21', '', 0.00, 162.45, 34.54, 0.00, 1, 8.56, 2.50, 'Carlos caamaño,3', 'Madrid', 'Madrid', '28016', 'España', 207.62, 0, '0000-00-00 00:00:00', '', '', 1, 4, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(4137, 1, 1051, 2, 0, NULL, 0, '2023-11-21 18:27:27', '2023-11-22 08:59:26', '2023-11-21', 'P3884', '23-05396-11-21', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Pedro Pérez Fernández, 13 -5°', 'Sevilla', 'Sevilla', '41011', 'España', 17.50, 0, '2023-11-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-211123-RTLeR+UmFsJfh-065', '451a0896-ceb1-48d1-9618-1b0e2e8181d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-RTLeR%2BUmFsJfh-065&s=KOL2023&nf=P3884&i=17.50&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4138, 1, 1050, 2, 0, NULL, 0, '2023-11-22 08:56:13', '2023-11-22 08:59:02', '2023-11-21', 'P3885', '23-05395-11-21', '', 0.00, 162.45, 34.54, 0.00, 1, 8.56, 2.50, 'Carlos caamaño,3', 'Madrid', 'Madrid', '28016', 'España', 207.62, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-211123-hzjZJ9LsTgQtt-073', 'ec3f768b-ac4d-4a2c-92fc-4abbf7e5ca23', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-211123-hzjZJ9LsTgQtt-073&s=KOL2023&nf=P3885&i=207.62&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4139, 1, 154, 2, 0, NULL, 0, '2023-11-22 08:20:37', '2023-11-22 09:56:47', '2023-11-22', 'P3886', '23-05397-11-22', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 68.97, 0, '2023-11-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221123-SgQnyT7GOeg+S-233', '8194dd70-392c-4bda-b9b3-ec298e69e499', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221123-SgQnyT7GOeg%2BS-233&s=KOL2023&nf=P3886&i=68.97&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4140, 1, 1052, 2, 0, NULL, 0, '2023-11-22 09:05:26', '2023-11-22 10:35:31', '2023-11-22', 'P3887', '23-05398-11-22', '', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'Eltzeta 3', 'Lesaka', 'Navarra', '31770', 'España', 78.82, 0, '2023-11-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221123-bnN8t3gP5pj/h-139', '3ec074bb-ec1f-4fb8-91fc-a5932dbe71eb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221123-bnN8t3gP5pj%2Fh-139&s=KOL2023&nf=P3887&i=78.81&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4141, 1, 215, 1, 0, NULL, 0, '2023-11-22 13:49:01', '2023-11-22 13:49:27', '2023-11-22', 'P3888', '', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 209.41, 0, '2023-11-22 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-221123-WNAStwVUeZxFy-170', '21ab32f1-1d5c-4eb1-a4c1-016977709b1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221123-WNAStwVUeZxFy-170&s=KOL2023&nf=P3888&i=209.41&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
(4142, 1, 247, 1, 0, NULL, 0, '2023-11-22 13:56:04', '2023-11-22 13:56:17', '2023-11-22', 'P3889', '2023-11-22', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Marqués de Riestra 14, bajo', 'PONTEVEDRA', 'PONTEVEDRA', '36001', 'ESPAÑA', 103.46, 0, '2023-11-22 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-221123-G5b3FVcR4v9CF-163', '45f138e2-4bcf-4fc3-b367-2b85a0473a45', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221123-G5b3FVcR4v9CF-163&s=KOL2023&nf=P3889&i=103.46&cr=162', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4143, 1, 1053, 2, 0, NULL, 0, '2023-11-22 14:54:46', '2023-11-23 09:26:49', '2023-11-22', 'P3890', '23-05399-11-22', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Bera Bera 16 1º izda', 'Donostia-San Sebasti', 'Gipuzkoa', '20009', 'España', 17.50, 0, '2023-11-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221123-kLMbPeEnzI8fC-009', '3e3bf62c-921e-41e5-acd7-a2fcd37f7f6c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221123-kLMbPeEnzI8fC-009&s=KOL2023&nf=P3890&i=17.50&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4144, 1, 932, 2, 0, NULL, 0, '2023-11-22 19:16:09', '2023-11-23 09:27:29', '2023-11-22', 'P3891', '23-05400-11-22', 'Llamar antes de entregar ', 0.00, 114.00, 23.94, 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', 137.94, 0, '2023-11-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-221123-ECBH11AOqmGMj-084', '9d4ac262-3580-46ad-81eb-be0976f2afb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221123-ECBH11AOqmGMj-084&s=KOL2023&nf=P3891&i=137.94&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4145, 1, 554, 2, 0, NULL, 0, '2023-11-22 21:26:31', '2023-11-23 09:27:55', '2023-11-22', 'P3892', '23-05402-11-22', 'Ex oficina de La Caixa ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paseo del Jardín Botánico 1', 'Sanlúcar de Barramed', 'Cádiz', '11540', 'España', 30.61, 0, '2023-11-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-221123-R8XKH9ETcGGja-227', '7ce71b1f-de20-43fc-9d5d-fa1f3c14fdf3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-221123-R8XKH9ETcGGja-227&s=KOL2023&nf=P3892&i=30.61&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4146, 1, 147, 2, 0, NULL, 0, '2023-11-23 09:07:44', '2023-11-23 10:09:51', '2023-11-23', 'P3893', '23-05403-11-23', 'Llamar antes de la entrega', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'C/ RÍO DUERO Nº 49   28913-LEGANÉS', 'Leganés', 'Madrid', '28913', 'España', 172.43, 0, '2023-11-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231123-OjRUUqhPEdsoB-246', '24defb30-ff60-42e0-8648-20cf2bd3c97d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231123-OjRUUqhPEdsoB-246&s=KOL2023&nf=P3893&i=172.43&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4147, 1, 152, 1, 0, NULL, 0, '2023-11-23 10:29:49', '2023-11-23 10:29:49', '2023-11-23', 'P3894', '2023-11-23', '', 0.00, 214.50, 45.04, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 259.54, 0, '2023-11-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-231123-IrxYzf/rOomx6-074', 'eb38f643-01da-4ae3-8e03-f796f4ae1429', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231123-IrxYzf%2FrOomx6-074&s=KOL2023&nf=P3894&i=259.54&cr=145', '[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
(4148, 1, 242, 1, 0, NULL, 0, '2023-11-23 11:21:50', '2023-11-23 11:22:48', '2023-11-23', 'P3895', '2023-11-23', '', 0.00, 195.36, 41.03, 0.00, 1, 10.16, 0.00, 'Paseo Matutino 13, bajo', 'Puenteareas', 'Pontevedra', '36860', 'ESPAÑA', 246.55, 0, '2023-11-23 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-231123-fKygRyPzPY5pQ-062', '7529debd-ca5b-406b-a482-dd68d916c6ac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231123-fKygRyPzPY5pQ-062&s=KOL2023&nf=P3895&i=246.55&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4149, 1, 367, 2, 0, NULL, 0, '2023-11-23 21:01:15', '2023-11-24 09:17:30', '2023-11-23', 'P3896', '23-05404-11-23', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Arenal 7', 'Castelló d\'Empúries', 'Girona', '17486', 'España', 30.61, 0, '2023-11-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231123-duso4XUx7QvDN-111', 'adaa1185-d255-45ef-8be4-a013aaa40ee6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231123-duso4XUx7QvDN-111&s=KOL2023&nf=P3896&i=30.61&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4150, 1, 79, 1, 0, NULL, 0, '2023-11-24 09:23:20', '2023-11-24 09:23:25', '2023-11-24', 'P3897', '2023-11-24', '', 0.00, 228.00, 48.31, 0.00, 0, 0.00, 2.50, 'Calle María Paya 8, planta baja', 'Biar', 'Alicante', '03410', 'España', 278.38, 0, '2023-11-24 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-241123-OjuXL4bwOv+59-162', 'e259106c-4989-4b0f-8438-3d424706e955', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241123-OjuXL4bwOv%2B59-162&s=KOL2023&nf=P3897&i=278.38&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4151, 1, 190, 3, 0, NULL, 0, '2023-11-24 10:52:24', '2023-11-24 10:52:24', '2023-11-24', '', 'consumo peluquería', '', 0.00, 146.56, 30.78, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 177.34, 0, '2023-11-24 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),
(4152, 1, 1054, 2, 0, NULL, 0, '2023-11-24 12:00:13', '2023-11-24 12:00:13', '2023-11-24', '', '23-05405-11-24', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Ibaiondo 10', 'Orio', 'Gipuzkoa', '20810', 'España', 196.56, 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),
(4153, 1, 1054, 2, 0, NULL, 0, '2023-11-24 12:04:15', '2023-11-24 13:05:32', '2023-11-24', 'P3898', '23-05406-11-24', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Ibai-Ondo 10. 20810 Gipuzkoa', 'Orio', 'Gipuzkoa', '20810', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-241123-dkhyzekNCSeCt-091', '8417d3b5-f13b-4588-b0a2-2d2c8dd995db', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241123-dkhyzekNCSeCt-091&s=KOL2023&nf=P3898&i=172.43&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4154, 1, 1055, 2, 0, NULL, 0, '2023-11-24 14:48:44', '2023-11-27 09:15:57', '2023-11-24', 'P3899', '23-05407-11-24', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Avenida de la Ribera 44, 2°', 'Lodosa', 'Navarra', '31580', 'España', 43.71, 0, '2023-11-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-241123-WPUlxx4HszVYT-023', '025cf109-9472-4604-bf01-c7fe17830b36', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241123-WPUlxx4HszVYT-023&s=KOL2023&nf=P3899&i=43.71&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4155, 1, 779, 2, 0, NULL, 0, '2023-11-24 14:52:28', '2023-11-27 09:19:16', '2023-11-24', 'P3900', '23-05408-11-24', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Plaza Arsenio Fernández, 22', 'Villaquejida', 'León', '24235', 'España', 28.39, 0, '2023-11-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241123-DgGm6IMVFeDva-224', '6f39a2db-2846-4ba2-a5f8-3cf02019f107', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241123-DgGm6IMVFeDva-224&s=KOL2023&nf=P3900&i=28.39&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
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
(4156, 1, 342, 2, 0, NULL, 0, '2023-11-24 17:16:21', '2023-11-27 09:21:14', '2023-11-24', 'P3901', '23-05409-11-24', '', 0.00, 81.15, 17.04, 0.00, 0, 0.00, 0.00, 'Renaixement, 115 bajos 1a', 'Cerdanyola del Vallè', 'Barcelona', '08290', 'España', 98.19, 0, '2023-11-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241123-RdqA5o37BfCEG-139', '6bdd0165-2b56-42fa-9c4e-1850fb4d3b4d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241123-RdqA5o37BfCEG-139&s=KOL2023&nf=P3901&i=98.19&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4157, 1, 215, 2, 0, NULL, 0, '2023-11-25 06:24:45', '2023-11-27 09:23:15', '2023-11-25', 'P3910', '23-05410-11-25', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-251123-dI2nFvxV1Lo7a-017', '598b0be0-71df-4a77-874d-53c60c099c1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251123-dI2nFvxV1Lo7a-017&s=KOL2023&nf=P3910&i=174.93&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4158, 1, 1056, 2, 0, NULL, 0, '2023-11-25 09:35:31', '2023-11-27 09:27:06', '2023-11-25', 'P3902', '23-05411-11-25', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'VILLODAS, c/ Mayor, número 14', 'Iruña Oka/Iruña de O', 'Álava', '01195', 'España', 65.52, 0, '2023-11-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251123-DlVan6gD8huzJ-039', 'd959f063-d515-4f11-9a18-a520c479b077', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251123-DlVan6gD8huzJ-039&s=KOL2023&nf=P3902&i=65.52&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4159, 1, 106, 2, 0, NULL, 0, '2023-11-25 14:40:40', '2023-11-27 09:30:04', '2023-11-25', 'P3903', '23-05412-11-25', '', 0.00, 207.64, 43.60, 0.00, 0, 0.00, 0.00, 'Hipodromo 10bajo', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 251.24, 0, '2023-11-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251123-XqadEEzPplz2L-009', 'b170d303-b334-4fdd-907c-4628ed01fd1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251123-XqadEEzPplz2L-009&s=KOL2023&nf=P3903&i=251.24&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4160, 1, 844, 2, 0, NULL, 0, '2023-11-25 15:16:18', '2023-11-27 09:32:29', '2023-11-25', 'P3904', '23-05413-11-25', 'Llamar por telefono y vengo a la puerta, no tenemos timbre. Estamos en una finca al campo. Gracias! 650 312 607', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Camí del Coll del Perelló, num 2', 'Castellvell del Camp', 'Tarragona', '43392', 'España', 30.61, 0, '2023-11-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-251123-TC5iBDCaxL3ne-195', 'e1b8f1bf-86b6-405e-8ad5-fd282d3861c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-251123-TC5iBDCaxL3ne-195&s=KOL2023&nf=P3904&i=30.61&cr=110', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4161, 1, 17, 2, 0, NULL, 0, '2023-11-26 12:18:10', '2023-11-27 09:34:26', '2023-11-26', 'P3905', '23-05414-11-26', 'Lunes cerrado', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 241.40, 0, '2023-11-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261123-K7EeqrJ6pDIbM-000', '67d9fe6d-7bd3-4cff-b211-c4837f73c953', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261123-K7EeqrJ6pDIbM-000&s=KOL2023&nf=P3905&i=241.40&cr=169', '[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
(4162, 1, 1057, 2, 0, NULL, 0, '2023-11-26 17:09:46', '2023-11-27 09:36:03', '2023-11-26', 'P3906', '23-05415-11-26', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'portuetxe 13', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 43.71, 0, '2023-11-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261123-cKp7S1nXsJx61-252', '655d194f-9c2d-46d7-9611-6be35cb20721', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261123-cKp7S1nXsJx61-252&s=KOL2023&nf=P3906&i=43.71&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4163, 1, 1058, 2, 0, NULL, 0, '2023-11-26 18:48:25', '2023-11-26 18:48:25', '2023-11-26', '', '23-05416-11-26', NULL, 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Juan Bravo 41  3dcha', 'Madrid', 'Madrid', '28006', 'España', 17.50, 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),
(4164, 1, 625, 2, 0, NULL, 0, '2023-11-26 18:50:42', '2023-11-27 09:39:21', '2023-11-26', 'P3907', '23-05417-11-26', 'Es una casa unifamiliar. ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Valle de Oro 48 A', 'Madrid', 'Madrid', '28019', 'España', 30.61, 0, '2023-11-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-261123-S7yL9MOYhSqmE-214', '03dd9b03-ac92-4a83-960e-8ef0a9cd680a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261123-S7yL9MOYhSqmE-214&s=KOL2023&nf=P3907&i=30.61&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4165, 1, 1058, 2, 0, NULL, 0, '2023-11-26 19:02:52', '2023-11-27 09:40:52', '2023-11-26', 'P3908', '23-05418-11-26', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/Juan Bravo 41  3dcha ', 'Madrid', 'Madrid', '28006', 'España', 17.50, 0, '2023-11-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261123-SbAWuh+AZF89P-126', '719e7d40-f357-49cc-a5ac-88f1afcffd18', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261123-SbAWuh%2BAZF89P-126&s=KOL2023&nf=P3908&i=17.50&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4166, 1, 71, 2, 0, NULL, 0, '2023-11-26 21:29:06', '2023-11-27 10:59:39', '2023-11-26', 'P3913', '23-05419-11-26', '', 0.00, 81.42, 17.10, 0.00, 0, 0.00, 0.00, 'Rua de vilariño 31', 'Nigrán', 'Pontevedra', '36370', 'España', 98.52, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-261123-fNiXSFJvFLxkS-241', '722d9a42-d39b-4400-a99b-4e243becd77f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261123-fNiXSFJvFLxkS-241&s=KOL2023&nf=P3913&i=98.52&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4167, 1, 121, 2, 0, NULL, 0, '2023-11-27 07:22:51', '2023-11-27 09:44:12', '2023-11-27', 'P3911', '23-05420-11-27', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-271123-iMJ9jfIJgmRXS-228', '32a435c4-bbfb-43b0-8a82-1877f8aeb8f6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-iMJ9jfIJgmRXS-228&s=KOL2023&nf=P3911&i=209.41&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4168, 1, 1059, 2, 0, NULL, 0, '2023-11-27 08:12:37', '2023-11-27 09:45:48', '2023-11-27', 'P3909', '23-05421-11-27', 'Si no estamos, llamar o dejar a vecina de en frente.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Ramón Pignatelli 42, bajoB ', 'Burgo de Ebro (El)', 'Zaragoza', '50730', 'España', 28.39, 0, '2023-11-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271123-SoqqClvnfokPj-151', '133f7879-5ed2-478a-bb21-c81eaf389aec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-SoqqClvnfokPj-151&s=KOL2023&nf=P3909&i=28.39&cr=171', '[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
(4169, 1, 991, 2, 0, NULL, 0, '2023-11-27 09:11:22', '2023-11-27 10:45:45', '2023-11-27', 'P3912', '23-05422-11-27', 'Peluquería Gottlich ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/Castilla 10', 'Sevilla', 'Sevilla', '41010', 'España', 137.94, 0, '2023-11-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271123-ctR6PrffqjNFJ-096', '8a133dbc-e433-413a-8f5b-7f01d0917937', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-ctR6PrffqjNFJ-096&s=KOL2023&nf=P3912&i=137.94&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4170, 1, 152, 1, 0, NULL, 0, '2023-11-27 11:10:50', '2023-11-27 11:16:17', '2023-11-27', 'P3914', '2023-11-27', '', 0.00, 158.73, 33.33, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 192.06, 0, '2023-11-27 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-271123-Y6yVO76gdcEr1-139', 'a9bdf248-24b3-4397-a86a-65c114b0b9b4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-Y6yVO76gdcEr1-139&s=KOL2023&nf=P3914&i=192.06&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4171, 1, 152, 1, 1, 'FALTAN ARTÍCULOS', 4170, '2023-11-27 11:13:17', '2023-11-27 11:14:06', '2023-11-27', 'R62', 'P3914 RECT.', '', 0.00, 145.86, 30.63, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 176.49, 0, '0000-00-00 00:00:00', '', '', 0, 1, 2, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4172, 1, 110, 2, 0, NULL, 0, '2023-11-27 11:11:57', '2023-11-27 12:15:14', '2023-11-27', 'P3915', '23-05423-11-27', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 241.40, 0, '2023-11-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-271123-jd3Q9dpGONy76-210', '7e5271d2-57bb-45dc-9d2b-b65cde54cb0c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-jd3Q9dpGONy76-210&s=KOL2023&nf=P3915&i=241.40&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4173, 1, 754, 2, 0, NULL, 0, '2023-11-27 13:33:55', '2023-11-27 15:12:06', '2023-11-27', 'P3916', '23-05425-11-27', 'Enviar de forma puntual al mismo municipio \r\nCalle Mallorca N°5 local', 0.00, 65.12, 13.67, 0.00, 1, 3.39, 0.00, 'Josep Tarradellas 166 2*1*', 'Amposta', 'Tarragona', '43870', 'España', 82.19, 0, '2023-11-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-271123-coZv9Qez+UX8Y-051', '36ee3041-058c-4c58-8197-a942afe5330f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-coZv9Qez%2BUX8Y-051&s=KOL2023&nf=P3916&i=82.19&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4174, 1, 1060, 2, 0, NULL, 0, '2023-11-27 13:57:11', '2023-11-27 15:14:41', '2023-11-27', 'P3917', '23-05426-11-27', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'DR AUGUST PI Y SUNYER 2, 5-1ª', 'Barcelona', 'Barcelona', '08034', 'España', 17.50, 0, '2023-11-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271123-e22G6sngKv2nX-095', 'f42b9781-6792-4ee0-8264-1f022617703a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-e22G6sngKv2nX-095&s=KOL2023&nf=P3917&i=17.50&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4175, 1, 527, 2, 0, NULL, 0, '2023-11-27 14:53:13', '2023-11-28 09:41:32', '2023-11-27', 'P3918', '23-05428-11-27', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Paseo Alameda 39 C31', 'Valencia', 'Valencia', '46023', 'España', 43.71, 0, '2023-11-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-271123-N81eXGo6hB7XU-213', '8520c782-da53-4e5b-ae35-a0f80cbd023b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-N81eXGo6hB7XU-213&s=KOL2023&nf=P3918&i=43.71&cr=204', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
