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
(4061, 1, 1033, 2, 0, NULL, 0, '2023-11-08 08:17:50', '2023-11-08 09:20:26', '2023-11-08', 'P3813', '23-05306-11-08', '', 0.00, 162.45, 34.54, 0.00, 0, 0.00, 2.50, 'Lersundi 18, bajo', 'Deba', 'Gipuzkoa', '20820', 'España', 199.06, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-081123-Z7sBk5u8zok9g-159', 'ac59b151-4c92-4cd4-b48d-7a8a57e78d73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081123-Z7sBk5u8zok9g-159&s=KOL2023&nf=P3813&i=199.06&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4062, 1, 696, 1, 0, NULL, 0, '2023-11-08 09:52:28', '2023-11-08 09:58:38', '2023-11-08', 'P3814', '2023-11-08', '', 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-11-08 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-081123-enEtLGephkXia-180', '09524566-9876-4b96-ac34-62eb2caa1626', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081123-enEtLGephkXia-180&s=KOL2023&nf=P3814&i=436.04&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4063, 1, 420, 2, 0, NULL, 0, '2023-11-08 13:09:49', '2023-11-09 08:31:40', '2023-11-08', '', '23-05307-11-08', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Sabino Arana 80, 4 A', 'Leioa', 'Bizkaia', '48940', 'España', 65.52, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4064, 1, 1034, 2, 0, NULL, 0, '2023-11-08 13:26:20', '2023-11-09 08:33:44', '2023-11-08', 'P3815', '23-05308-11-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Pintor Losada 19, 4D', 'Bilbao', 'Bizkaia', '48004', 'España', 17.50, 0, '2023-11-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-081123-S3zUHmYS640tS-011', 'fadf29bc-e39c-4b58-a34a-ee84624002cd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081123-S3zUHmYS640tS-011&s=KOL2023&nf=P3815&i=17.50&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4065, 1, 87, 2, 0, NULL, 0, '2023-11-08 16:20:24', '2023-11-09 08:36:36', '2023-11-08', 'P3816', '23-05309-11-08', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Cc arcco local p 17', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 103.46, 0, '2023-11-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-081123-lTQyeRdTRxvRU-001', '033b563f-1227-42af-8941-4dbb3188b9a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081123-lTQyeRdTRxvRU-001&s=KOL2023&nf=P3816&i=103.46&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4066, 1, 956, 2, 0, NULL, 0, '2023-11-08 16:53:43', '2023-11-09 08:40:06', '2023-11-08', 'P3819', '23-05310-11-08', '', 0.00, 57.00, 11.97, 0.00, 1, 2.96, 0.00, 'Santo Domingo 1 bajo ', 'Vigo', 'Pontevedra', '36204', 'España', 71.93, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-081123-IsMqPqX5ngpaa-183', '1719a6fd-1159-4b65-9f34-0a91c6b219ee', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-081123-IsMqPqX5ngpaa-183&s=KOL2023&nf=P3819&i=71.93&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4067, 1, 172, 2, 0, NULL, 0, '2023-11-09 06:06:07', '2023-11-09 08:42:24', '2023-11-09', 'P3817', '23-05313-11-09', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Soldevila, 6 baixos', 'Tremp', 'Lleida', '25620', 'España', 103.46, 0, '2023-11-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091123-PwxRhvHrU3V00-034', '578c5987-1ffd-4875-8734-7c0a21c0acfc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091123-PwxRhvHrU3V00-034&s=KOL2023&nf=P3817&i=103.46&cr=068', '[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
(4068, 1, 291, 2, 0, NULL, 0, '2023-11-09 06:40:38', '2023-11-09 08:44:07', '2023-11-09', 'P3818', '23-05314-11-09', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle Begonia 66', 'Alcobendas', 'Madrid', '28109', 'España', 43.71, 0, '2023-11-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-091123-lGj4fSSSZBVXL-105', 'a7d66412-269c-450c-9df6-5eaa49f24624', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091123-lGj4fSSSZBVXL-105&s=KOL2023&nf=P3818&i=43.71&cr=208', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4069, 1, 1035, 2, 0, NULL, 0, '2023-11-09 07:56:29', '2023-11-09 08:58:52', '2023-11-09', 'P3820', '23-05315-11-09', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Ronda Josep Anselm Clavé 2.3-3', 'Canet de Mar', 'Barcelona', '08360', 'España', 28.39, 0, '2023-11-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091123-VRfk5rBZOIHIl-209', 'feae5688-542a-4c99-8368-ded401a9b6c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091123-VRfk5rBZOIHIl-209&s=KOL2023&nf=P3820&i=28.39&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4070, 1, 929, 2, 0, NULL, 0, '2023-11-09 09:47:39', '2023-11-09 12:06:48', '2023-11-09', 'P3821', '23-05316-11-09', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Urbanización Luberrietaondo 56B', 'Gatika', 'Bizkaia', '48110', 'España', 17.50, 0, '2023-11-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091123-ZDvsofcQbTRCs-182', '813edcf4-71ac-4972-807c-a65aea99b539', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091123-ZDvsofcQbTRCs-182&s=KOL2023&nf=P3821&i=17.50&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4071, 1, 696, 1, 0, NULL, 0, '2023-11-09 11:10:54', '2023-11-09 11:58:47', '2023-11-09', 'P3822', '2023-11-09', '', 0.00, 900.90, 189.19, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 1090.09, 0, '2023-11-09 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-091123-hw2kq3rUI0iTo-126', '6166c988-987c-4bba-9a73-aad2d39389e1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091123-hw2kq3rUI0iTo-126&s=KOL2023&nf=P3822&i=1090.08&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4072, 1, 420, 2, 0, NULL, 0, '2023-11-09 13:28:32', '2023-11-10 08:26:48', '2023-11-09', 'P3823', '23-05317-11-09', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Sabino Arana 80 4A', 'Leioa', 'Bizkaia', '48940', 'España', 65.52, 0, '2023-11-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091123-om95SF/zpt7W9-066', 'b86b0a8d-fcd7-49fe-9da9-b89c3c9a8681', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091123-om95SF%2Fzpt7W9-066&s=KOL2023&nf=P3823&i=65.52&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4073, 1, 94, 2, 0, NULL, 0, '2023-11-09 16:16:00', '2023-11-10 08:29:43', '2023-11-09', 'P3824', '23-05318-11-09', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'C/mayor número 11', 'Ausejo', 'La Rioja', '26513', 'España', 59.10, 0, '2023-11-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-091123-H7+P1id5fBGAQ-035', 'bd70efa6-6d2a-408b-9a7e-1d44dda271fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-091123-H7%2BP1id5fBGAQ-035&s=KOL2023&nf=P3824&i=59.10&cr=019', '[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
(4074, 1, 355, 2, 0, NULL, 0, '2023-11-10 08:57:02', '2023-11-10 10:05:36', '2023-11-10', 'P3825', '23-05319-11-10', '', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'Sebastián Fernández de Leceta 10 7 Izqd', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 54.60, 0, '2023-11-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101123-b3i9OcWd7XcfY-040', '5163d628-e3e8-4417-a912-635796468905', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101123-b3i9OcWd7XcfY-040&s=KOL2023&nf=P3825&i=54.60&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4075, 1, 1036, 2, 0, NULL, 0, '2023-11-10 11:13:16', '2023-11-10 12:15:24', '2023-11-10', 'P3826', '23-05320-11-10', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle Gurmendi 10 1-A', 'Zarautz', 'Gipuzkoa', '20800', 'España', 65.52, 0, '2023-11-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-101123-k1St63ficBvre-082', 'ffc116ea-68e8-480c-aef8-456cac7fee17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101123-k1St63ficBvre-082&s=KOL2023&nf=P3826&i=65.52&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4076, 1, 53, 2, 0, NULL, 0, '2023-11-10 14:17:00', '2023-11-13 08:53:19', '2023-11-10', 'P3831', '23-05321-11-10', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-101123-OR1sa6bh/h5uI-213', '206168ca-4536-4486-ac49-3100657dbb2d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101123-OR1sa6bh%2Fh5uI-213&s=KOL2023&nf=P3831&i=105.96&cr=123', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4077, 1, 1037, 2, 0, NULL, 0, '2023-11-10 21:13:19', '2023-11-13 08:54:09', '2023-11-10', 'P3827', '23-05322-11-10', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Av/ Nuestra Señora de la Asunción,  Número 4. 1-1ª', 'Bellvei', 'Tarragona', '43719', 'España', 17.50, 0, '2023-11-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-101123-C/DqLrCjOvUl+-177', '2fbe72c3-eb14-4f90-bc1f-e2a536810cfa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-101123-C%2FDqLrCjOvUl%2B-177&s=KOL2023&nf=P3827&i=17.50&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4078, 1, 444, 2, 0, NULL, 0, '2023-11-11 08:15:00', '2023-11-13 08:55:04', '2023-11-11', 'P3828', '23-05323-11-11', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Antziola 9,3ºdcha', 'Hernani', 'Gipuzkoa', '20120', 'España', 30.61, 0, '2023-11-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111123-Wtc6RQF10ztpW-016', '37184b95-5e77-44f2-94d1-c2a6855abd17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111123-Wtc6RQF10ztpW-016&s=KOL2023&nf=P3828&i=30.61&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4079, 1, 80, 2, 0, NULL, 0, '2023-11-11 09:02:09', '2023-11-13 08:56:13', '2023-11-11', 'P3829', '23-05324-11-11', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 620.73, 0, '2023-11-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111123-BD4UE3+1ltlmk-089', '71f0bff9-9d67-480e-9870-23773e48e77a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111123-BD4UE3%2B1ltlmk-089&s=KOL2023&nf=P3829&i=620.73&cr=094', '[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
(4080, 1, 262, 2, 0, NULL, 0, '2023-11-11 12:35:12', '2023-11-13 08:57:33', '2023-11-11', 'P3830', '23-05325-11-11', '', 0.00, 215.76, 45.31, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 261.07, 0, '2023-11-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111123-NKGDEw4x7qffh-241', '9ee13d72-441f-4ad6-8884-3082bb0dec99', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111123-NKGDEw4x7qffh-241&s=KOL2023&nf=P3830&i=261.07&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4081, 1, 77, 1, 0, NULL, 0, '2023-11-13 09:23:59', '2023-11-13 09:24:30', '2023-11-13', 'P3832', '2023-11-13', '', 0.00, 622.05, 130.63, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 752.68, 0, '2023-11-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-131123-e3qP9POAaT4YJ-224', '2fde767f-556d-47b2-b968-9bc1f10c883e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131123-e3qP9POAaT4YJ-224&s=KOL2023&nf=P3832&i=752.68&cr=118', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4082, 1, 65, 2, 0, NULL, 0, '2023-11-13 11:33:03', '2024-07-17 13:13:12', '2023-11-13', 'P3833', '23-05326-11-13', '', 0.00, 826.50, 173.57, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 1000.07, 0, '2023-11-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-131123-A8ECe+jh+S6OU-019', '5a320260-0845-4f7b-ada3-3f79108cbcfe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131123-A8ECe%2Bjh%2BS6OU-019&s=KOL2023&nf=P3833&i=1000.07&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4083, 1, 190, 3, 0, NULL, 0, '2023-11-13 13:18:09', '2023-11-13 13:18:09', '2023-11-13', '', '2023-11-13', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 68.97, 0, '2023-11-13 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),
(4084, 1, 329, 2, 0, NULL, 0, '2023-11-13 13:43:13', '2023-11-13 15:43:28', '2023-11-13', 'P3834', '23-05327-11-13', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'JUAN BAUTISTA ZABALA nº9 GAURKO', 'Getxo', 'Bizkaia', '48991', 'España', 43.71, 0, '2023-11-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-131123-YAd1d53JFW2sC-016', 'aea5143c-1361-45c9-9902-b71e7e1aed3d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-131123-YAd1d53JFW2sC-016&s=KOL2023&nf=P3834&i=43.71&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4085, 1, 34, 2, 0, NULL, 0, '2023-11-14 08:57:23', '2023-11-14 10:07:38', '2023-11-14', 'P3835', '23-05332-11-14', 'Entregar de martes a viernes hasta  las 12', 0.00, 427.50, 89.78, 0.00, 0, 0.00, 0.00, 'peluqueria Marzo21 calle iparraguirre34 plaza trasera   Leioa Bizkaia', 'Leioa', 'Bizkaia', '48940', 'España', 517.28, 0, '2023-11-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-141123-AxaJHH2NuD22k-197', 'aec4f227-883f-4191-a6a4-e70074798ec4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141123-AxaJHH2NuD22k-197&s=KOL2023&nf=P3835&i=517.28&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4086, 1, 681, 2, 0, NULL, 0, '2023-11-14 14:21:03', '2023-11-15 09:30:40', '2023-11-14', 'P3836', '23-05333-11-14', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'CALLE DUBLIN 12, 2ºA', 'Burlada/Burlata', 'Navarra', '31600', 'España', 65.52, 0, '2023-11-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141123-CLvd7+JEdWCaL-044', '059e0e86-6371-4020-9a82-c03aea0a331d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141123-CLvd7%2BJEdWCaL-044&s=KOL2023&nf=P3836&i=65.52&cr=087', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4087, 1, 974, 2, 0, NULL, 0, '2023-11-14 14:42:40', '2023-11-15 09:31:21', '2023-11-14', 'P3837', '23-05334-11-14', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avinguda Estudi General,, num 7, 6e  4a', 'Lleida', 'Lleida', '25001', 'España', 28.39, 0, '2023-11-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-141123-R587f208n9DVH-007', '177cd8bc-b0b9-40b4-9729-672888efbe58', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141123-R587f208n9DVH-007&s=KOL2023&nf=P3837&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),
(4088, 1, 1038, 2, 0, NULL, 0, '2023-11-14 21:37:26', '2023-11-15 09:32:07', '2023-11-14', 'P3838', '23-05341-11-14', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Menendez Pelayo 88, 1', 'Santander', 'Cantabria', '39006', 'España', 30.61, 0, '2023-11-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-141123-fE97zr9NXNtxh-169', '93179234-412e-497c-86b5-760e51d4c0f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-141123-fE97zr9NXNtxh-169&s=KOL2023&nf=P3838&i=30.61&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4089, 1, 605, 2, 0, NULL, 0, '2023-11-15 07:31:21', '2023-11-15 09:32:51', '2023-11-15', 'P3839', '23-05345-11-15', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'PASEO DE LOS OLMOS 30 - 8º DCHA', 'Donostia-San Sebasti', 'Gipuzkoa', '20016', 'España', 61.09, 0, '2023-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151123-W9L1d8D9CPFpS-246', '8ba47628-abc7-449a-a141-3af162fee876', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-W9L1d8D9CPFpS-246&s=KOL2023&nf=P3839&i=61.09&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4090, 1, 155, 2, 0, NULL, 0, '2023-11-15 08:13:50', '2023-11-15 09:34:11', '2023-11-15', 'P3840', '23-05346-11-15', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-151123-GAWiCO3e3vL86-106', '25edf36d-bafe-45d7-93a1-49f30036b4ae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-GAWiCO3e3vL86-106&s=KOL2023&nf=P3840&i=206.91&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4091, 1, 1039, 2, 0, NULL, 0, '2023-11-15 12:52:21', '2023-11-16 07:56:15', '2023-11-15', 'P3841', '23-05347-11-15', 'Ondategui (Zigoitia)', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Elizalde 19', 'Zigoitia', 'Álava', '01138', 'España', 71.98, 0, '2023-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151123-N0F3KKs3nvMaS-148', 'e046f737-763c-4b3d-a1d2-4876b48e4f36', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-N0F3KKs3nvMaS-148&s=KOL2023&nf=P3841&i=71.98&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4092, 1, 269, 2, 0, NULL, 0, '2023-11-15 13:49:10', '2023-11-16 07:59:55', '2023-11-15', 'P3842', '23-05348-11-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Atxutegi 2 1°E', 'Erandio', 'Bizkaia', '48950', 'España', 17.50, 0, '2023-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151123-WLyIxBAH+Xsjl-136', 'bf9793f6-c3ff-4ac2-a0e7-c0dac65f3014', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-WLyIxBAH%2BXsjl-136&s=KOL2023&nf=P3842&i=17.50&cr=051', '[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
(4093, 1, 1040, 2, 0, NULL, 0, '2023-11-15 16:05:48', '2023-11-16 08:04:17', '2023-11-15', 'P3843', '23-05349-11-15', 'Confirmar horario de entrega para estar en casa.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo de Urkizu 9 - 8C ', 'Eibar', 'Gipuzkoa', '20600', 'España', 17.50, 0, '2023-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151123-ZhNaKepCkHHIC-236', '230d75aa-69e9-41ff-818c-cd65d14ea280', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-ZhNaKepCkHHIC-236&s=KOL2023&nf=P3843&i=17.50&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4094, 1, 1041, 2, 0, NULL, 0, '2023-11-15 17:09:06', '2023-11-16 08:05:12', '2023-11-15', 'P3844', '23-05350-11-15', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Arriaga 11 ', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 30.61, 0, '2023-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151123-JbAAO6UG2ANXA-011', 'c7ebdb87-dc9a-4269-91fb-1df46b050f72', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-JbAAO6UG2ANXA-011&s=KOL2023&nf=P3844&i=30.61&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4095, 1, 94, 2, 0, NULL, 0, '2023-11-15 17:16:09', '2023-11-16 08:09:45', '2023-11-15', 'P3845', '23-05351-11-15', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'C/mayor número 11', 'Ausejo', 'La Rioja', '26513', 'España', 206.91, 0, '2023-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151123-JLkQf3tz402GS-157', '36629787-5ab6-41c4-bd46-6636af0b36c8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-JLkQf3tz402GS-157&s=KOL2023&nf=P3845&i=206.91&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4096, 1, 1042, 2, 0, NULL, 0, '2023-11-15 18:19:06', '2023-11-16 08:11:24', '2023-11-15', 'P3846', '23-05352-11-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Santu enea N°6, 1° Derecha', 'Usurbil', 'Gipuzkoa', '20170', 'España', 17.50, 0, '2023-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151123-kitSy7tZ9Rqfj-222', '4f300e24-b2cb-47f7-8ca2-2bce048fcb4e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-kitSy7tZ9Rqfj-222&s=KOL2023&nf=P3846&i=17.50&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4097, 1, 635, 2, 0, NULL, 0, '2023-11-15 21:06:06', '2023-11-16 08:14:30', '2023-11-15', 'P3847', '23-05353-11-15', 'SI ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703. GRACIAS.', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 275.88, 0, '2023-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151123-Do90ZQzAIK39m-054', '2f7d1326-aae1-4d8b-8eed-cde1c3be71c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-Do90ZQzAIK39m-054&s=KOL2023&nf=P3847&i=275.88&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4098, 1, 659, 2, 0, NULL, 0, '2023-11-15 22:13:40', '2023-11-16 08:16:15', '2023-11-15', 'P3848', '23-05354-11-15', 'Si no estoy en casa entregar en San Lázaro,16', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'San Lázaro, 11', 'Medina del Campo', 'Valladolid', '47400', 'España', 54.60, 0, '2023-11-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-151123-mjo3UC69fEyAi-190', '12fe6084-b9d5-4f36-ba8b-c7e844b242ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-151123-mjo3UC69fEyAi-190&s=KOL2023&nf=P3848&i=54.60&cr=244', '[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
(4099, 1, 152, 1, 0, NULL, 0, '2023-11-16 07:52:34', '2023-11-16 08:17:31', '2023-11-16', 'P3849', '2023-11-16', '', 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-11-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-161123-Dwob5FTq9XQTb-035', '96387761-4072-4952-8a51-031dc9bf867e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161123-Dwob5FTq9XQTb-035&s=KOL2023&nf=P3849&i=186.87&cr=247', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4100, 1, 314, 2, 0, NULL, 0, '2023-11-16 08:04:48', '2023-11-16 09:20:02', '2023-11-16', 'P3850', '23-05355-11-16', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Biblioteca Universidad de Castilla la Mancha. Avda de los Alfares 42', 'Cuenca', 'Cuenca', '16071', 'España', 61.09, 0, '2023-11-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161123-ovBnqbD5RxScb-069', '5f3c933c-4fb4-4586-957d-4d49c02d1303', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161123-ovBnqbD5RxScb-069&s=KOL2023&nf=P3850&i=61.09&cr=167', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4101, 1, 687, 1, 0, NULL, 0, '2023-11-16 09:24:54', '2023-11-16 09:24:54', '2023-11-16', 'P3851', '2023-11-16', '', 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-11-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-161123-BkhfrRTiVW5s0-147', 'f4916246-13e9-451c-b5fa-2c32520bb868', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161123-BkhfrRTiVW5s0-147&s=KOL2023&nf=P3851&i=68.97&cr=026', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4102, 1, 951, 2, 0, NULL, 0, '2023-11-16 09:06:43', '2023-11-16 10:18:19', '2023-11-16', 'P3852', '23-05356-11-16', '', 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-11-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161123-H3vpxaiin9L4B-150', '23764877-d657-4618-98f8-038ed9dc73ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161123-H3vpxaiin9L4B-150&s=KOL2023&nf=P3852&i=28.39&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4103, 1, 878, 2, 0, NULL, 0, '2023-11-16 09:17:24', '2023-11-16 10:20:01', '2023-11-16', 'P3853', '23-05357-11-16', 'Entregar por la mañana antes de las 13h por favor.', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Plaza Anzaran, 11 - 1Izda', 'Irun', 'Gipuzkoa', '20301', 'España', 30.61, 0, '2023-11-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161123-KtnuvEOZTXNJz-110', '6cb7322b-4f45-4873-b9f0-6a8b575c8723', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161123-KtnuvEOZTXNJz-110&s=KOL2023&nf=P3853&i=30.61&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4104, 1, 248, 2, 0, NULL, 0, '2023-11-16 10:58:40', '2023-11-16 12:14:35', '2023-11-16', 'P3854', '23-05358-11-16', 'Cerrado miércoles ', 0.00, 65.12, 13.67, 0.00, 0, 0.00, 0.00, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 78.80, 0, '2023-11-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161123-o2fBsjT3MuUYH-065', '506b6471-8155-4083-bf97-5969eb475291', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161123-o2fBsjT3MuUYH-065&s=KOL2023&nf=P3854&i=78.80&cr=007', '[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
(4105, 1, 145, 2, 0, NULL, 0, '2023-11-16 15:42:15', '2023-11-17 10:03:19', '2023-11-16', 'P3856', '23-05359-11-16', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-161123-VHgf6yny9J5Pv-017', '75d2e0ab-6990-4628-999f-8e39658cc11a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161123-VHgf6yny9J5Pv-017&s=KOL2023&nf=P3856&i=174.93&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4106, 1, 120, 2, 0, NULL, 0, '2023-11-16 17:42:42', '2023-11-17 10:10:41', '2023-11-16', 'P3855', '23-05360-11-16', '', 0.00, 219.84, 46.16, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 266.01, 0, '2023-11-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-161123-WAVIlmZKOWNgU-095', '497a3a19-b248-4720-9cd8-54f2694874a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-161123-WAVIlmZKOWNgU-095&s=KOL2023&nf=P3855&i=266.01&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4107, 1, 340, 2, 0, NULL, 0, '2023-11-17 10:01:46', '2023-11-17 11:05:19', '2023-11-17', 'P3857', '23-05361-11-17', '9.30 a 1.30 y 4.30 a 7.30 \r\nsabado 9.30 a 1.30 \r\nMIERCOLES CERRADO', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'juan carlos 1 17,', 'Sesma', 'Navarra', '31293', 'España', 137.94, 0, '2023-11-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-171123-RCLRPgv1BiFcZ-049', '345401cf-4fca-4c66-a0e0-a5e947ff3c31', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171123-RCLRPgv1BiFcZ-049&s=KOL2023&nf=P3857&i=137.94&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4108, 1, 241, 2, 0, NULL, 0, '2023-11-17 10:11:01', '2023-11-17 11:15:01', '2023-11-17', 'P3858', '23-05364-11-17', '', 0.00, 219.78, 46.15, 0.00, 1, 11.43, 0.00, 'Morales Hidalgo,4', 'Ponteareas', 'Pontevedra', '36860', 'España', 277.36, 0, '2023-11-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171123-jXRUfaQhb/rdc-059', 'f14c145d-1c11-4fde-9e36-583db28f8115', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171123-jXRUfaQhb%2Frdc-059&s=KOL2023&nf=P3858&i=277.36&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4109, 1, 870, 2, 0, NULL, 0, '2023-11-17 16:59:41', '2023-11-20 08:55:36', '2023-11-17', 'P3859', '23-05365-11-17', 'Si no estamos, se puede entregar en portería. Gracias ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Fuente Carrantona 38C4 izquierda ', 'Madrid', 'Madrid', '28030', 'España', 137.94, 0, '2023-11-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171123-Kqvp/V3R6mOz/-152', '3900b517-5bd1-4639-9e01-bcee096de7d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171123-Kqvp%2FV3R6mOz%2F-152&s=KOL2023&nf=P3859&i=137.94&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4110, 1, 4, 2, 0, NULL, 0, '2023-11-17 18:10:07', '2023-11-20 08:56:49', '2023-11-17', 'P3860', '23-05366-11-17', '', 0.00, 309.42, 64.98, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 374.40, 0, '2023-11-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171123-c8evZ6N7Lo1YU-237', '0e364669-51e1-42e1-b7d6-f24b6e68b434', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171123-c8evZ6N7Lo1YU-237&s=KOL2023&nf=P3860&i=374.40&cr=192', '[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
(4111, 1, 494, 2, 0, NULL, 0, '2023-11-17 21:58:55', '2023-11-20 08:57:08', '2023-11-17', 'P3861', '23-05368-11-17', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Segura,14', 'Monzón', 'Huesca', '22400', 'España', 30.61, 0, '2023-11-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-171123-LMZyIzdhrdCL0-106', 'a15ab8ab-a951-4269-bc6b-13bdc2a7d939', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-171123-LMZyIzdhrdCL0-106&s=KOL2023&nf=P3861&i=30.61&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4112, 1, 68, 2, 0, NULL, 0, '2023-11-18 14:28:35', '2023-11-20 08:58:16', '2023-11-18', 'P3866', '23-05369-11-18', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'murgis 45', 'Ejido (El)', 'Almería', '04700', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-181123-nNHWzkiFYgFxH-123', '34484ddc-d6aa-4942-a901-4fbe73332946', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181123-nNHWzkiFYgFxH-123&s=KOL2023&nf=P3866&i=174.93&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4113, 1, 1043, 2, 0, NULL, 0, '2023-11-18 15:35:40', '2023-11-20 08:58:44', '2023-11-18', 'P3862', '23-05370-11-18', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Larrakotorre 18- 2 drch', 'Bilbao', 'Bizkaia', '48015', 'España', 17.50, 0, '2023-11-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-181123-QfPTPTGN6bzUl-135', '15df0606-e4d7-46ee-a5b6-3ab26eb3a9c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181123-QfPTPTGN6bzUl-135&s=KOL2023&nf=P3862&i=17.50&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4114, 1, 278, 2, 0, NULL, 0, '2023-11-18 19:35:08', '2023-11-20 09:02:28', '2023-11-18', 'P3867', '23-05372-11-18', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'INNOVA PASEO SAN JUAN BOSCO 27 BJ', 'Monzón', 'Huesca', '22400', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-181123-AJnhOuz+2qemi-026', 'f3a924d1-9834-4abe-a161-7c33002e73d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-181123-AJnhOuz%2B2qemi-026&s=KOL2023&nf=P3867&i=33.11&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4115, 1, 1044, 2, 0, NULL, 0, '2023-11-19 17:21:18', '2023-11-20 09:10:59', '2023-11-19', 'P3868', '23-05373-11-19', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/ MARINES S/N C.V Eliavet', 'Eliana (l\')', 'Valencia', '46183', 'España', 43.71, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-191123-FNjzGPnatotIB-148', '4f8808e3-d6d1-487e-aa39-15745776246e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191123-FNjzGPnatotIB-148&s=KOL2023&nf=P3868&i=43.71&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4116, 1, 126, 2, 0, NULL, 0, '2023-11-19 18:47:49', '2023-11-20 09:00:00', '2023-11-19', 'P3863', '23-05375-11-19', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'C/ Santa Lucía Nº 8 ocal', 'Valladolid', 'Valladolid', '47005', 'España', 172.43, 0, '2023-11-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191123-kGG9frqCvHEs9-041', '5a7a9de0-e928-42c4-a387-a754d693ba5d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191123-kGG9frqCvHEs9-041&s=KOL2023&nf=P3863&i=172.43&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
