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
(4176, 1, 906, 2, 0, NULL, 0, '2023-11-27 14:57:18', '2023-11-28 09:42:31', '2023-11-27', 'P3919', '23-05429-11-27', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Porto Colón 6, Escalera izda. 1C', 'Alcorcón', 'Madrid', '28924', 'España', 61.09, 0, '2023-11-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271123-F0L4w1LVjvfXe-015', 'b1d29c8a-fff9-416a-bda0-424c6c1aaac4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-F0L4w1LVjvfXe-015&s=KOL2023&nf=P3919&i=61.09&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4177, 1, 222, 2, 0, NULL, 0, '2023-11-27 18:10:51', '2023-11-28 09:43:41', '2023-11-27', 'P3923', '23-05430-11-27', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Cartagena 296 ', 'Barcelona', 'Barcelona', '08025', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-271123-inc+nGbfWME8d-255', '108261fe-3302-4fcb-9bcd-eb41ba6b7c3a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-inc%2BnGbfWME8d-255&s=KOL2023&nf=P3923&i=137.94&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4178, 1, 1061, 2, 0, NULL, 0, '2023-11-27 19:26:46', '2023-11-28 09:44:23', '2023-11-27', 'P3920', '23-05431-11-27', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Larrea 14B, 3° izq', 'Villabona', 'Gipuzkoa', '20150', 'España', 17.50, 0, '2023-11-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271123-miyenMLnruM14-069', '7a5fdeb5-f709-4836-bc9a-c4a4c57e3260', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271123-miyenMLnruM14-069&s=KOL2023&nf=P3920&i=17.50&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4179, 1, 1062, 2, 0, NULL, 0, '2023-11-28 06:19:05', '2023-11-28 09:44:59', '2023-11-28', 'P3921', '23-05434-11-28', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/CASTILLO DE CANDANCHU 48', 'Madrid', 'Madrid', '28050', 'España', 30.61, 0, '2023-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281123-TiK19h69sLnkK-222', 'a3ec9214-5ac3-4867-a500-ba915916905b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281123-TiK19h69sLnkK-222&s=KOL2023&nf=P3921&i=30.61&cr=043', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4180, 1, 1063, 2, 0, NULL, 0, '2023-11-28 08:30:40', '2023-11-28 09:45:29', '2023-11-28', 'P3922', '23-05435-11-28', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Gabriel Kurutzelaegi 2, 4 B', 'Elgoibar', 'Gipuzkoa', '20870', 'España', 30.61, 0, '2023-11-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-281123-G0gnfuKF9EUst-137', 'bc41fd9b-f2b3-4b2a-ba15-33d5cc5e2300', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281123-G0gnfuKF9EUst-137&s=KOL2023&nf=P3922&i=30.61&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4181, 1, 1064, 2, 0, NULL, 0, '2023-11-28 08:38:32', '2023-11-28 09:47:31', '2023-11-28', 'P3924', '23-05436-11-28', '', 0.00, 162.45, 34.54, 0.00, 0, 0.00, 2.50, 'C/ Lorenzo Cendra Busca bloq 2 ', 'Málaga', 'Málaga', '29007', 'España', 199.06, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-281123-USd1N12aMjKjJ-248', '9bb05bb2-97bc-49b0-abb3-4679cc1c1442', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281123-USd1N12aMjKjJ-248&s=KOL2023&nf=P3924&i=199.06&cr=061', '[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
(4182, 1, 1011, 2, 0, NULL, 0, '2023-11-28 09:49:16', '2023-11-28 10:54:06', '2023-11-28', 'P3925', '23-05437-11-28', 'Urbanizacion Hacienda del Mar', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Avenida Condomina 70 bl4 esc9 6Q', 'Alicante/Alacant', 'Alicante', '03540', 'España', 172.43, 0, '2023-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281123-BAYmDqbkviB5j-052', 'cac63981-8292-493a-9920-a1f9b9f23abc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281123-BAYmDqbkviB5j-052&s=KOL2023&nf=P3925&i=172.43&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4183, 1, 381, 2, 0, NULL, 0, '2023-11-28 09:52:14', '2023-12-01 09:51:15', '2023-11-28', 'P3926', '23-05438-11-28', 'Por favor, avisar antes de la entrega al teléfono móvil 610684114. Gracias', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Avenida Sierra, nº 5, 6ºG', 'Logroño ', 'La Rioja', '26007', 'España', 71.98, 0, '2023-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281123-Bu2lWHafF3O8h-233', 'd22d8923-ed05-4a55-abe6-493e804a6845', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281123-Bu2lWHafF3O8h-233&s=KOL2023&nf=P3926&i=71.98&cr=197', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4184, 1, 956, 2, 0, NULL, 0, '2023-11-28 15:07:34', '2023-11-29 09:38:46', '2023-11-28', '', '23-05439-11-28', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1 bajo ', 'Vigo', 'Pontevedra', '36204', 'España', 68.97, 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),
(4185, 1, 108, 2, 0, NULL, 0, '2023-11-28 15:54:06', '2023-11-29 09:39:40', '2023-11-28', 'P3930', '23-05440-11-28', '', 0.00, 109.92, 23.08, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 133.00, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-281123-FCVBRUJ2lu82y-017', 'ecf25be2-6729-4bdb-99f5-f95dae1f89e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281123-FCVBRUJ2lu82y-017&s=KOL2023&nf=P3930&i=133.00&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4186, 1, 174, 2, 0, NULL, 0, '2023-11-28 19:59:46', '2023-11-29 09:40:49', '2023-11-28', 'P3927', '23-05441-11-28', 'hola , ya siento las prisas pero me he descuidado un poco y casi no tengo plantas.\r\n¿podría salir el pedido mañana miércoles?\r\nMuchas gracias \r\nUn saludo\r\nMarga', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 241.40, 0, '2023-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281123-kpZ+gaF8/WnZv-052', '89984bb2-252a-4466-840a-65c670201e7e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281123-kpZ%2BgaF8%2FWnZv-052&s=KOL2023&nf=P3927&i=241.40&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4187, 1, 1065, 2, 0, NULL, 0, '2023-11-28 22:21:31', '2023-11-29 09:41:29', '2023-11-28', 'P3928', '23-05442-11-28', 'Mar Hotels', 0.00, 43.32, 10.52, 0.00, 0, 0.00, 8.19, 'Gran Vía Asima, 1 Polígono Son Castelló', 'Palma de Mallorca', 'Baleares (Illes)', '07009', 'España', 60.61, 0, '2023-11-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-281123-RP8RKjUbKHk3d-217', '65273937-ba41-465b-8c6b-bbcf393ae5fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281123-RP8RKjUbKHk3d-217&s=KOL2023&nf=P3928&i=60.61&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4188, 1, 956, 2, 0, NULL, 0, '2023-11-29 09:39:01', '2023-11-29 09:39:01', '2023-11-28', 'P3929', '23-05439-11-28', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1 bajo ', 'Vigo', 'Pontevedra', '36204', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-281123-Rxi12xeEbANWV-100', '7d513e70-af4b-4e09-838e-4404670e3c3a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-281123-Rxi12xeEbANWV-100&s=KOL2023&nf=P3929&i=68.97&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
(4189, 1, 1066, 2, 0, NULL, 0, '2023-11-29 08:59:19', '2023-11-29 10:06:28', '2023-11-29', 'P3931', '23-05444-11-29', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/Martinez Villergas 5', 'Zamora', 'Zamora', '49003', 'España', 43.71, 0, '2023-11-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291123-mA8OU1sRHbxWm-055', 'e2a83a43-3130-41c4-a125-b8e41a363f7a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291123-mA8OU1sRHbxWm-055&s=KOL2023&nf=P3931&i=43.71&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4190, 1, 97, 2, 0, NULL, 0, '2023-11-29 09:56:19', '2023-11-29 11:02:46', '2023-11-29', 'P3932', '23-05445-11-29', '', 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-11-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291123-K+sFMRs4huSxT-141', 'e704cdc4-d0a0-4ee7-95b7-0dbe8a53634d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291123-K%2BsFMRs4huSxT-141&s=KOL2023&nf=P3932&i=68.97&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4191, 1, 77, 1, 0, NULL, 0, '2023-11-29 11:56:53', '2023-11-29 11:56:53', '2023-11-29', 'P3933', '2023-11-29', '', 0.00, 1372.80, 288.29, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1661.09, 0, '2023-11-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-291123-JuGui+MdAUfVI-171', '73d29739-5f1e-456f-bc44-db9b52da4871', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291123-JuGui%2BMdAUfVI-171&s=KOL2023&nf=P3933&i=1661.09&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4192, 1, 4, 2, 0, NULL, 0, '2023-11-29 11:33:52', '2023-11-29 12:47:18', '2023-11-29', 'P3934', '23-05446-11-29', '', 0.00, 321.64, 67.54, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 389.18, 0, '2023-11-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291123-HbDA/vrf4lmOH-249', '4c0b4f40-9204-486f-b02a-65b276efb079', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291123-HbDA%2Fvrf4lmOH-249&s=KOL2023&nf=P3934&i=389.18&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4193, 1, 280, 2, 0, NULL, 0, '2023-11-29 12:31:07', '2023-11-29 13:52:50', '2023-11-29', 'P3935', '23-05447-11-29', 'lunes cerrado', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'RUA CODESAL Nº2', 'Pino (O)', 'A Coruña', '15821', 'España', 172.43, 0, '2023-11-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291123-JJ9ile+487/49-074', 'a49d0747-9b0d-452f-9c45-cb6a15066212', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291123-JJ9ile%2B487%2F49-074&s=KOL2023&nf=P3935&i=172.43&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4194, 1, 941, 2, 0, NULL, 0, '2023-11-29 17:14:03', '2023-11-30 09:43:12', '2023-11-29', 'P3936', '23-05448-11-29', 'Si no estuviera dejar al conserje.\r\nGracias ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Limonita n.7, 3C', 'Madrid', 'Madrid', '28021', 'España', 17.50, 0, '2023-11-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-291123-oWUqW96AcNeXr-188', 'f8b2480b-9b20-48d1-becf-f1d1683e06dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-291123-oWUqW96AcNeXr-188&s=KOL2023&nf=P3936&i=17.50&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
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
(4195, 1, 870, 2, 0, NULL, 0, '2023-11-30 08:32:43', '2023-11-30 09:43:29', '2023-11-30', 'P3937', '23-05449-11-30', 'Se puede entregar en portería si no estamos. Gracias ', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Fuente Carrantona 38 C 4 izquierda ', 'Madrid', 'Madrid', '28030', 'España', 103.46, 0, '2023-11-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301123-QvnIoAjAVMS+k-240', '145ae3b2-9e1f-4a21-b67e-4a94f357a440', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301123-QvnIoAjAVMS%2Bk-240&s=KOL2023&nf=P3937&i=103.46&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4196, 1, 164, 2, 0, NULL, 0, '2023-11-30 09:17:18', '2023-11-30 10:59:46', '2023-11-30', 'P3938', '23-05450-11-30', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 379.34, 0, '2023-11-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301123-TQ+Zvic7dnrO7-050', 'e7c4070b-4a10-4306-bd11-bbc11bb9d1d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301123-TQ%2BZvic7dnrO7-050&s=KOL2023&nf=P3938&i=379.34&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4197, 1, 195, 1, 0, NULL, 0, '2023-11-30 10:55:20', '2023-11-30 10:55:20', '2023-11-30', 'P3939', '2023-11-30', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, '', '', '', '0', '', 137.94, 0, '2023-11-30 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-301123-OTpHk4UF6HER2-150', '2c27b8b4-2004-4228-8208-759fc45cc93b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301123-OTpHk4UF6HER2-150&s=KOL2023&nf=P3939&i=137.94&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4198, 1, 65, 2, 0, NULL, 0, '2023-11-30 11:01:36', '2024-07-17 13:13:21', '2023-11-30', 'P3940', '23-05451-11-30', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-301123-A9/V8OzHRe+i2-161', 'ca507a45-f2d8-4687-9d65-57dae58e84d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301123-A9%2FV8OzHRe%2Bi2-161&s=KOL2023&nf=P3940&i=413.82&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4199, 1, 1067, 2, 0, NULL, 0, '2023-11-30 17:29:02', '2023-12-01 09:51:10', '2023-11-30', 'P3941', '23-05453-11-30', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Villa del Castillo, 4 Bajo A', 'Pinto', 'Madrid', '28320', 'España', 28.39, 0, '2023-11-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301123-Sg+8p37HZje5y-060', 'b24c6390-ff3d-4278-84fc-9fc16f8fe32a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301123-Sg%2B8p37HZje5y-060&s=KOL2023&nf=P3941&i=28.39&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4200, 1, 144, 2, 0, NULL, 0, '2023-11-30 17:59:50', '2023-12-01 09:51:43', '2023-11-30', 'P3942', '23-05454-11-30', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 172.43, 0, '2023-11-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301123-ZVmnVgeodWnaV-252', '081db92e-0dc5-45a4-965f-d49692da7c24', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301123-ZVmnVgeodWnaV-252&s=KOL2023&nf=P3942&i=172.43&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
(4201, 1, 271, 2, 0, NULL, 0, '2023-12-01 12:32:49', '2023-12-04 09:09:54', '2023-12-01', 'P3943', '23-05455-12-01', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Jose Joaquin Tadeo Murguia 4, 3.D', 'Irun', 'Gipuzkoa', '20304', 'España', 30.61, 0, '2023-12-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-011223-ou1j+mVpkVUyX-161', '2c7e6dbe-1648-4fba-926e-2c7de17e6e9c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011223-ou1j%2BmVpkVUyX-161&s=KOL2023&nf=P3943&i=30.61&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4202, 1, 28, 2, 0, NULL, 0, '2023-12-01 13:52:50', '2023-12-04 09:11:29', '2023-12-01', 'P3952', '23-05457-12-01', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-011223-MAa2hFGeTQiGK-111', '2618d615-70d5-40bf-b863-f33b75c48182', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011223-MAa2hFGeTQiGK-111&s=KOL2023&nf=P3952&i=137.94&cr=110', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4203, 1, 1068, 2, 0, NULL, 0, '2023-12-01 14:13:27', '2023-12-04 09:14:17', '2023-12-01', 'P3944', '23-05458-12-01', 'Empresa\r\nKit Moto Recambios', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Barrio  Olabarri 25', 'Galdakao', 'Bizkaia', '48960', 'España', 30.61, 0, '2023-12-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-011223-RjFyCI73cdgkb-102', 'e85d881a-d62c-4e4e-8182-f20a2aa1aee3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011223-RjFyCI73cdgkb-102&s=KOL2023&nf=P3944&i=30.61&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4204, 1, 583, 2, 0, NULL, 0, '2023-12-01 17:59:20', '2023-12-04 09:17:17', '2023-12-01', 'P3945', '23-05459-12-01', 'Entregar a partir de las 15.30h', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Migdia 22-3-1', 'Sant Joan de Vilator', 'Barcelona', '08250', 'España', 78.63, 0, '2023-12-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-011223-d3LOj5PP9Sw6u-139', 'bc40597b-4617-434a-a53b-f477342648cc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-011223-d3LOj5PP9Sw6u-139&s=KOL2023&nf=P3945&i=78.63&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4205, 1, 1069, 2, 0, NULL, 0, '2023-12-02 08:19:33', '2023-12-04 09:19:11', '2023-12-02', 'P3946', '23-05461-12-02', 'Llamar por teléfono antes de venir para comprobar la recepción del paquete y indicaciones para la localización de la casa.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Camí Fondo de Somella 7', 'Vilanova i la Geltrú', 'Barcelona', '08800', 'España', 28.39, 0, '2023-12-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021223-WAs/VH7Q0p/te-117', 'a0817c42-0e77-4a07-8158-8e8b91eeb1b9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021223-WAs%2FVH7Q0p%2Fte-117&s=KOL2023&nf=P3946&i=28.39&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4206, 1, 1070, 2, 0, NULL, 0, '2023-12-02 14:35:46', '2023-12-04 09:23:27', '2023-12-02', 'P3947', '23-05466-12-02', '', 0.00, 86.64, 18.19, 0.00, 0, 0.00, 0.00, 'Bernardo Ezenarro. 15. Esc.2-2A', 'Elgoibar', 'Gipuzkoa', '20870', 'España', 104.83, 0, '2023-12-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021223-GWa24O/MykL74-242', 'ccda297c-8155-486a-9f75-70110dbab541', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021223-GWa24O%2FMykL74-242&s=KOL2023&nf=P3947&i=104.83&cr=074', '[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
(4207, 1, 1071, 2, 0, NULL, 0, '2023-12-02 15:48:29', '2023-12-04 09:26:15', '2023-12-02', 'P3948', '23-05468-12-02', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avda. Navarra 4   1°A', 'Pamplona/Iruña', 'Navarra', '31012', 'España', 52.39, 0, '2023-12-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021223-GK8ExmqdgteB3-247', 'db79717e-9a3c-4888-9d34-b247263d8f72', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021223-GK8ExmqdgteB3-247&s=KOL2023&nf=P3948&i=52.39&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4208, 1, 1072, 2, 0, NULL, 0, '2023-12-02 17:55:55', '2023-12-04 09:30:09', '2023-12-02', 'P3953', '23-05469-12-02', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Calle Santo Cristo de Cadrete número 5 casa 46', 'Cadrete', 'Zaragoza', '50420', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-021223-Sl0WXpCLVn4WQ-217', '5f6186a5-2e87-41d6-998c-319730430892', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021223-Sl0WXpCLVn4WQ-217&s=KOL2023&nf=P3953&i=20.00&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4209, 1, 1073, 2, 0, NULL, 0, '2023-12-02 18:46:21', '2023-12-04 09:35:11', '2023-12-02', 'P3949', '23-05470-12-02', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avda. Navarra 4   1°A', 'Pamplona/Iruña', 'Navarra', '31012', 'España', 52.39, 0, '2023-12-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-021223-ox883uGoZRO82-247', '488e7bec-21b1-45a0-97bb-e66137eadefd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-021223-ox883uGoZRO82-247&s=KOL2023&nf=P3949&i=52.39&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4210, 1, 1074, 2, 0, NULL, 0, '2023-12-03 09:33:46', '2023-12-04 09:38:46', '2023-12-03', 'P3950', '23-05471-12-03', 'No funciona interfono. ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Plaça dels Vents, 13, esc. 2, 2-1', 'Calonge', 'Girona', '17252', 'España', 28.39, 0, '2023-12-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-031223-jAFOjIeSG+aVt-073', '4ac741f8-0a73-4ad0-a72e-525e96d0e0a5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031223-jAFOjIeSG%2BaVt-073&s=KOL2023&nf=P3950&i=28.39&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4211, 1, 384, 2, 0, NULL, 0, '2023-12-03 21:46:16', '2023-12-04 09:41:36', '2023-12-03', 'P3951', '23-05472-12-03', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ HORTALEZA 116 1º EXT DCHA', 'Madrid', 'Madrid', '28004', 'España', 65.52, 0, '2023-12-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-031223-fMZkJ7UsPExjX-110', '6255e1ae-1cf1-4357-8635-2ae43b7e7fb7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-031223-fMZkJ7UsPExjX-110&s=KOL2023&nf=P3951&i=65.52&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4212, 1, 1075, 2, 0, NULL, 0, '2023-12-04 11:15:35', '2023-12-04 11:15:35', '2023-12-04', '', '23-05473-12-04', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Calle General Egia, frente al 31', 'Bilbao', 'Bizkaia', '48013', '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),
(4213, 1, 1075, 2, 0, NULL, 0, '2023-12-04 11:17:58', '2023-12-04 12:19:42', '2023-12-04', 'P3954', '23-05474-12-04', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Calle General Egia, frente al 31', 'Bilbao', 'Bizkaia', '48013', 'España', 344.85, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-041223-OopdBjFHM328K-090', '89a423e8-70e2-4115-a5c7-f642f377e8e6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041223-OopdBjFHM328K-090&s=KOL2023&nf=P3954&i=344.85&cr=237', '[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
(4214, 1, 78, 2, 0, NULL, 0, '2023-12-04 13:00:58', '2023-12-05 09:22:08', '2023-12-04', 'P3956', '23-05475-12-04', '', 0.00, 883.50, 185.54, 0.00, 0, 0.00, 0.00, 'avda, de satrustegui 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 1069.04, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-041223-Y8oDBnKup8rXE-007', '0e777b35-e580-40bf-9ed6-42940cb1a451', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041223-Y8oDBnKup8rXE-007&s=KOL2023&nf=P3956&i=1069.04&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4215, 1, 1076, 2, 0, NULL, 0, '2023-12-04 13:09:47', '2023-12-05 09:20:26', '2023-12-04', 'P3955', '23-05476-12-04', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle San Andrés, 3', 'Estella/Lizarra', 'Navarra', '31200', 'España', 43.71, 0, '2023-12-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-041223-F5q8Dq6a35lGt-196', '37beeece-800e-4785-94d3-be6e98c6a7aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-041223-F5q8Dq6a35lGt-196&s=KOL2023&nf=P3955&i=43.71&cr=122', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4216, 1, 896, 1, 0, NULL, 0, '2023-12-05 09:35:01', '2023-12-05 09:35:30', '2023-12-05', 'P3957', '2023-12-05', '', 0.00, 32.56, 6.84, 0.00, 0, 0.00, 0.00, 'Marrutxipi 24', 'Donostia-San Sebasti', 'Gipuzkoa', '20013', 'España', 39.40, 0, '2023-12-05 00:00:00', '', '', 3, 6, 1, 'TBAI-B20930640-051223-QqlLCr5p0//Iv-168', 'd7ee095d-4807-4520-8a9b-b066579571d6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051223-QqlLCr5p0%2F%2FIv-168&s=KOL2023&nf=P3957&i=39.40&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4217, 1, 127, 2, 0, NULL, 0, '2023-12-05 09:51:29', '2023-12-05 11:04:34', '2023-12-05', 'P3958', '23-05477-12-05', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 68.97, 0, '2023-12-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051223-S+n49lzCTRONu-022', '5c3dd625-cfc5-4986-82c6-b0d77e14d242', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051223-S%2Bn49lzCTRONu-022&s=KOL2023&nf=P3958&i=68.97&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4218, 1, 262, 2, 0, NULL, 0, '2023-12-05 16:12:49', '2023-12-07 09:24:35', '2023-12-05', 'P3959', '23-05478-12-05', '', 0.00, 81.40, 17.09, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 98.49, 0, '2023-12-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-051223-C6a1IMFVPcDLS-031', '6cd952e5-5e7f-4524-936f-c40151ec0241', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-051223-C6a1IMFVPcDLS-031&s=KOL2023&nf=P3959&i=98.49&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4219, 1, 1077, 2, 0, NULL, 0, '2023-12-06 10:32:12', '2023-12-07 09:26:45', '2023-12-06', 'P3960', '23-05479-12-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Cerdanya 29 SIS Municipal Ginjol', 'Lleida', 'Lleida', '25003', 'España', 17.50, 0, '2023-12-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-061223-UZwyYJs/ROGSL-156', '31833c88-8d6f-4986-a9ef-5c3289f93c1e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061223-UZwyYJs%2FROGSL-156&s=KOL2023&nf=P3960&i=17.50&cr=213', '[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
(4220, 1, 1078, 2, 0, NULL, 0, '2023-12-06 14:58:08', '2023-12-07 09:30:47', '2023-12-06', 'P3961', '23-05480-12-06', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Ronda De Las Ventas 23, 3 A', 'Burlada/Burlata', 'Navarra', '31600', 'España', 30.61, 0, '2023-12-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-061223-kgt8rgWCAZ+cW-222', '45e16e36-7541-4f6e-98cf-5db2d725daef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061223-kgt8rgWCAZ%2BcW-222&s=KOL2023&nf=P3961&i=30.61&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4221, 1, 1079, 2, 0, NULL, 0, '2023-12-06 18:26:07', '2023-12-07 09:34:07', '2023-12-06', 'P3962', '23-05481-12-06', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'bulevar de salburua 46, esc 2; 6A', 'Vitoria-Gasteiz', 'Álava', '01003', 'España', 65.52, 0, '2023-12-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-061223-h8TQmJQVUY2ao-058', '5128ca24-d37b-4052-ae4e-eefed0d7b67e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-061223-h8TQmJQVUY2ao-058&s=KOL2023&nf=P3962&i=65.52&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4222, 1, 98, 2, 0, NULL, 0, '2023-12-07 16:42:21', '2023-12-11 09:26:51', '2023-12-07', 'P3964', '23-05482-12-07', '', 0.00, 89.56, 19.24, 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', 110.87, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-071223-OdAGPrrgstiL+-031', 'c0cfc851-bdb3-4052-8143-e1ebbbd0b5f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071223-OdAGPrrgstiL%2B-031&s=KOL2023&nf=P3964&i=110.87&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4223, 1, 632, 2, 0, NULL, 0, '2023-12-07 17:10:04', '2023-12-11 09:46:23', '2023-12-07', 'P3963', '23-05483-12-07', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'Urbieta 57, bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 172.42, 0, '2023-12-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-071223-fWUHA9fFUop5j-041', 'c0814015-d897-4917-be6e-a5ebeba77428', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-071223-fWUHA9fFUop5j-041&s=KOL2023&nf=P3963&i=172.43&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4224, 1, 67, 1, 0, NULL, 0, '2023-12-11 09:34:07', '2023-12-11 09:34:21', '2023-12-11', 'P3965', '2023-12-11', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 344.85, 0, '2023-12-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111223-G0Wva1PpK2Kz3-255', '4a961530-1cce-40af-b02d-7db07641f538', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111223-G0Wva1PpK2Kz3-255&s=KOL2023&nf=P3965&i=344.85&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4225, 1, 73, 2, 0, NULL, 0, '2023-12-11 09:14:18', '2023-12-11 10:21:29', '2023-12-11', '', '23-05484-12-11', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'zapatari 2a peluqueria', 'Beasain', 'Gipuzkoa', '20200', 'España', 241.40, 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),
(4226, 1, 73, 2, 0, NULL, 0, '2023-12-11 10:21:46', '2023-12-11 10:21:46', '2023-12-11', 'P3966', '23-05484-12-11', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'zapatari 2a peluqueria', 'Beasain', 'Gipuzkoa', '20200', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111223-IGs9BMyzLZ9X5-157', '3f6fb3a3-f3b0-469e-88a7-fe03a0af48e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111223-IGs9BMyzLZ9X5-157&s=KOL2023&nf=P3966&i=241.40&cr=124', '[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
(4227, 1, 1080, 2, 0, NULL, 0, '2023-12-11 10:07:59', '2023-12-11 11:08:40', '2023-12-11', 'P3967', '23-05485-12-11', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, ' Camino Viejo de Simancas Número 50', 'Valladolid', 'Valladolid', '47008', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-111223-EXo6/8xxPZ5n8-073', '2d80d2f3-0aba-40ad-a2fd-364a5ba972b0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111223-EXo6%2F8xxPZ5n8-073&s=KOL2023&nf=P3967&i=33.11&cr=087', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4228, 1, 65, 2, 0, NULL, 0, '2023-12-11 10:50:02', '2024-07-17 13:13:39', '2023-12-11', 'P3969', '23-05486-12-11', '', 0.00, 399.00, 83.79, 0.00, 0, 0.00, 0.00, 'balmes 133', 'Barcelona', 'Barcelona', '08008', 'España', 482.79, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-111223-WGMV3DVxVZ6bE-226', 'e1da884a-05d6-4fad-9ce6-a3fe8b31c0d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111223-WGMV3DVxVZ6bE-226&s=KOL2023&nf=P3969&i=482.79&cr=160', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4229, 1, 1001, 2, 0, NULL, 0, '2023-12-11 10:54:17', '2023-12-11 11:56:44', '2023-12-11', 'P3968', '23-05487-12-11', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Barrio Kareaga s/n Max Center tienda Cortefiel', 'Barakaldo', 'Bizkaia', '48903', 'España', 30.61, 0, '2023-12-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-111223-meTt8ZH8tPTC5-137', 'd8921ac7-e7e0-41fd-920f-39028169106f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111223-meTt8ZH8tPTC5-137&s=KOL2023&nf=P3968&i=30.61&cr=087', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4230, 1, 1081, 2, 0, NULL, 0, '2023-12-11 12:00:33', '2023-12-12 09:34:10', '2023-12-11', 'P3970', '23-05489-12-11', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer de la industria 58 2.1', 'Barcelona', 'Barcelona', '08025', 'España', 17.50, 0, '2023-12-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-111223-QUo1qLgCTIiPN-003', 'f190fc31-8720-4c3d-a599-69f5d693ecc0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111223-QUo1qLgCTIiPN-003&s=KOL2023&nf=P3970&i=17.50&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4231, 1, 1082, 2, 0, NULL, 0, '2023-12-11 20:03:09', '2023-12-12 09:34:20', '2023-12-11', 'P3971', '23-05491-12-11', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Av. Anglaterra, 26 1-2 Urb. Rocamar', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 17.50, 0, '2023-12-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111223-WuYarldPyrhkc-101', 'fb27c1cf-1340-4bea-ae55-65f2e7d1b552', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111223-WuYarldPyrhkc-101&s=KOL2023&nf=P3971&i=17.50&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4232, 1, 1083, 2, 0, NULL, 0, '2023-12-11 20:11:41', '2023-12-12 09:34:29', '2023-12-11', 'P3972', '23-05492-12-11', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Calle de Fermín Caballero, 28, 9D', 'Madrid', 'Madrid', '28034', 'España', 43.71, 0, '2023-12-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-111223-SsjdwP3Kc9GH0-218', 'c2e019f3-c8bf-4f55-8685-ba16121be5f1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-111223-SsjdwP3Kc9GH0-218&s=KOL2023&nf=P3972&i=43.71&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
