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
(5150, 1, 1290, 2, 0, NULL, 0, '2024-06-02 07:29:13', '2024-06-03 08:39:07', '2024-06-03', 'P4817', '24-06469-06-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Alfonso Batallador 35, 1º Izq.', 'Sangüesa/Zangoza', 'Navarra', '31400', 'España', 28.39, 0, '2024-06-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030624-FQuyS1byHXqQ5-044', '0bbc8a9b-5a35-4db4-84a1-b14bd2d1e3b9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-FQuyS1byHXqQ5-044&s=KOL2024&nf=P4817&i=28.39&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5151, 1, 862, 2, 0, NULL, 0, '2024-06-02 13:24:22', '2024-06-03 08:41:06', '2024-06-03', 'P4818', '24-06471-06-02', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Finca san Anton, s/n', 'Mirabel', 'Cáceres', '10540', 'España', 17.50, 0, '2024-06-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030624-nKIBJQyhQVXog-026', 'd2a3568a-2f3a-4e88-81db-284caca07cec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-nKIBJQyhQVXog-026&s=KOL2024&nf=P4818&i=17.50&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5152, 1, 77, 1, 0, NULL, 0, '2024-06-03 08:58:51', '2024-06-03 08:58:51', '2024-06-03', 'P4819', '', '', 0.00, 1029.60, 216.22, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1245.82, 0, '2024-06-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030624-OFu1xW5/Bx+BL-070', 'c1a54ec2-f4f2-4d1a-9ad3-f7a9ea4797e4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-OFu1xW5%2FBx%2BBL-070&s=KOL2024&nf=P4819&i=1245.82&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5153, 1, 689, 2, 0, NULL, 0, '2024-06-03 07:59:08', '2024-06-03 10:10:28', '2024-06-03', 'P4820', '24-06475-06-03', 'Zero estilistas (peluquería)', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Dr Espinosa Oribe 19 bajo ', 'Bilbao', 'Bizkaia', '48003', 'España', 43.71, 0, '2024-06-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030624-L7WifXm0UT3GW-073', '5f79b5dd-6f20-4833-b50b-38e467941a72', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-L7WifXm0UT3GW-073&s=KOL2024&nf=P4820&i=43.71&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5154, 1, 375, 2, 0, NULL, 0, '2024-06-03 08:26:55', '2024-06-03 10:51:18', '2024-06-03', 'P4821', '24-06476-06-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Mayor 12', 'Asteasu', 'Gipuzkoa', '20159', 'España', 30.61, 0, '2024-06-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-030624-Rsm21m6V4F/ad-084', 'f1fb02ef-3590-4e27-9fec-1d43341d0662', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-Rsm21m6V4F%2Fad-084&s=KOL2024&nf=P4821&i=30.61&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5155, 1, 221, 2, 0, NULL, 0, '2024-06-03 09:57:16', '2024-06-03 12:32:47', '2024-06-03', 'P4822', '24-06477-06-03', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 137.94, 0, '2024-06-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030624-DJ+/4nXc1IREX-023', 'b7f4bf8a-c3dc-4ba4-928f-de07cf00bbcc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030624-DJ%2B%2F4nXc1IREX-023&s=KOL2024&nf=P4822&i=137.94&cr=067', '[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
(5156, 1, 1291, 2, 0, NULL, 0, '2024-06-03 11:20:25', '2024-06-04 08:55:51', '2024-06-04', 'P4824', '24-06478-06-03', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'BLAS DE OTERO  22- 5° B', 'Bilbao', 'Bizkaia', '48014', 'España', 17.50, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040624-fyZIHnv+Bw+gc-101', '620b045d-d87b-4cd8-9c18-1598ecae7453', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040624-fyZIHnv%2BBw%2Bgc-101&s=KOL2024&nf=P4824&i=17.50&cr=223', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5157, 1, 88, 2, 0, NULL, 0, '2024-06-03 12:50:42', '2024-06-04 08:57:22', '2024-06-04', 'P4823', '24-06479-06-03', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Turina 2bj  peluqueria ecologica valderros ', 'Valladolid', 'Valladolid', '47006', 'España', 206.91, 0, '2024-06-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040624-GzzdFV9FIjEsy-125', 'bdb1f429-48f9-4515-abdb-c1863f5f415b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040624-GzzdFV9FIjEsy-125&s=KOL2024&nf=P4823&i=206.91&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5158, 1, 1292, 2, 0, NULL, 0, '2024-06-03 17:56:40', '2024-06-04 08:58:43', '2024-06-04', 'P4826', '24-06482-06-03', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Luces de la ciudad 27. 5 b', 'Zaragoza', 'Zaragoza', '50019', 'España', 65.52, 0, '2024-06-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040624-PhD0LWtGYubfv-124', '5686e4d0-0789-4a71-92c5-16682a19e0a3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040624-PhD0LWtGYubfv-124&s=KOL2024&nf=P4826&i=65.52&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5159, 1, 1293, 2, 0, NULL, 0, '2024-06-03 21:32:43', '2024-06-04 09:00:09', '2024-06-04', 'P4825', '24-06483-06-03', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avenida Ocho de marzo 29 2° A', 'Vitoria-Gasteiz', 'Álava', '01002', 'España', 30.61, 0, '2024-06-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040624-C4o9IgkO6eOSD-105', '4a711e44-69f7-4883-a65b-e4fbd09d69b5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040624-C4o9IgkO6eOSD-105&s=KOL2024&nf=P4825&i=30.61&cr=119', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5160, 1, 67, 1, 0, NULL, 0, '2024-06-04 11:00:29', '2024-06-04 11:01:20', '2024-06-04', 'P4827', '', '', 0.00, 313.50, 66.27, 0.00, 0, 0.00, 2.50, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 381.84, 0, '2024-06-04 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-040624-EGEVA1QQT6c5G-155', '195a1798-52f2-424c-8483-d9beb8b81252', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040624-EGEVA1QQT6c5G-155&s=KOL2024&nf=P4827&i=381.84&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5161, 1, 259, 1, 0, NULL, 0, '2024-06-04 11:10:51', '2024-06-04 11:10:51', '2024-06-04', 'P4828', '', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'GIPUZKOA KALEA 53 BAJO', 'Zarautz', 'Zarautz', '20800', 'España', 275.88, 0, '2024-06-04 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040624-WOL5oQx8c+gdD-156', '923ca5a2-44c4-46fb-97c0-e449069314fc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040624-WOL5oQx8c%2BgdD-156&s=KOL2024&nf=P4828&i=275.88&cr=085', '[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
(5162, 1, 1294, 2, 0, NULL, 0, '2024-06-04 09:59:04', '2024-06-04 12:01:57', '2024-06-04', 'P4829', '24-06485-06-04', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Tiebas 1-1ºD', 'Pamplona/Iruña', 'Navarra', '31015', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040624-flG826EUMQl6v-085', 'b8739d36-4241-48c9-9254-882ec3922971', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040624-flG826EUMQl6v-085&s=KOL2024&nf=P4829&i=30.61&cr=187', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5163, 1, 190, 3, 0, NULL, 0, '2024-06-04 13:06:40', '2024-10-15 16:04:41', '2024-06-04', '', 'Consumo interno', '', 0.00, 1872.60, 393.25, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2265.85, 0, '2024-06-04 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5164, 1, 147, 2, 0, NULL, 0, '2024-06-04 15:22:11', '2024-06-05 08:18:08', '2024-06-05', 'P4830', '24-06493-06-04', 'Horario de martes a viernes de 10 a 17', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'C/ de la palmera 23   28918-LEGANÉS', 'Leganés', 'Madrid', '28913', 'España', 206.91, 0, '2024-06-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050624-gOp9PuIo4/3NS-087', '1d9c9f08-511c-40fc-890a-a28d582dbcb5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050624-gOp9PuIo4%2F3NS-087&s=KOL2024&nf=P4830&i=206.91&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5165, 1, 1134, 1, 0, NULL, 0, '2024-06-04 17:27:36', '2024-06-04 17:27:36', '2024-06-05', 'P4831', '', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Aoiz 14, bajo.   ', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 68.97, 0, '2024-06-04 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050624-FsR6LyUwSHMbt-178', '55fd1dce-42a0-4772-8492-77ec07fafd02', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050624-FsR6LyUwSHMbt-178&s=KOL2024&nf=P4831&i=68.97&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5166, 1, 1134, 1, 1, 'Falta lote en el producto', 5165, '2024-06-05 08:22:05', '2024-06-05 08:22:05', '2024-06-05', 'R81', 'P4831 RECT.', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 68.97, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-050624-R4PJtKcngjNwH-021', '429c6651-f2ee-46fe-8b9a-0ff88f4cd435', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050624-R4PJtKcngjNwH-021&s=KOL2024&nf=R81&i=-68.97&cr=248', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(5167, 1, 1134, 1, 0, NULL, 0, '2024-06-05 08:23:08', '2024-06-05 08:23:08', '2024-06-05', 'P4832', '', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Aoiz 14, bajo.   ', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 68.97, 0, '2024-06-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050624-HIQjlMrD+KnbG-207', '39dbac15-6ab9-4875-ab24-3418af84aa55', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050624-HIQjlMrD%2BKnbG-207&s=KOL2024&nf=P4832&i=68.97&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5168, 1, 1155, 2, 0, NULL, 0, '2024-06-05 06:39:23', '2024-06-05 09:09:19', '2024-06-05', 'P4833', '24-06495-06-05', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer Corbera 13 ', 'Torrent', 'Valencia', '46900', 'España', 17.50, 0, '2024-06-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050624-UKJhhBv8uyHXr-102', '321030e6-eff9-4e12-9f7d-f5a58e4f209d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050624-UKJhhBv8uyHXr-102&s=KOL2024&nf=P4833&i=17.50&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
(5169, 1, 127, 2, 0, NULL, 0, '2024-06-05 07:54:46', '2024-06-05 10:15:38', '2024-06-05', 'P4834', '24-06496-06-05', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 172.43, 0, '2024-06-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050624-ow9UlvgL+zMJX-045', '80281c9f-7bd9-4172-bc4a-e3516a6f5d39', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050624-ow9UlvgL%2BzMJX-045&s=KOL2024&nf=P4834&i=172.43&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5170, 1, 91, 1, 0, NULL, 0, '2024-06-05 11:44:30', '2024-06-05 11:44:54', '2024-06-05', 'P4835', '', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'Calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 209.41, 0, '2024-06-05 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-050624-HmupPsEFtNDk8-190', 'fed6d9d0-0928-4d2f-a316-520be8131ded', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050624-HmupPsEFtNDk8-190&s=KOL2024&nf=P4835&i=209.41&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5171, 1, 956, 2, 0, NULL, 0, '2024-06-05 09:50:56', '2024-06-05 11:59:29', '2024-06-05', 'P4836', '24-06503-06-05', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1 ', 'Vigo', 'Pontevedra', '36204', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050624-T1Lrr/e0bn4E3-192', '61522b6b-451c-45c5-9014-82add27760f5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050624-T1Lrr%2Fe0bn4E3-192&s=KOL2024&nf=P4836&i=68.97&cr=227', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5172, 1, 345, 2, 0, NULL, 0, '2024-06-05 12:40:37', '2024-06-06 09:04:24', '2024-06-06', 'P4837', '24-06504-06-05', 'Los lunes por la tarde está cerrado. El resto de días estámos hasta las 19h \r\nLLAMAR ANTES DE VENIR!! ', 0.00, 73.26, 15.38, 0.00, 0, 0.00, 0.00, 'Espronceda 336', 'Barcelona', 'Barcelona', '08027', 'España', 88.64, 0, '2024-06-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060624-BDp67348dWd3g-017', '45c93369-9295-4aa4-a82e-cb3d108f8895', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060624-BDp67348dWd3g-017&s=KOL2024&nf=P4837&i=88.64&cr=208', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5173, 1, 1295, 2, 0, NULL, 0, '2024-06-05 17:38:49', '2024-06-06 09:07:05', '2024-06-06', 'P4838', '24-06507-06-05', 'Si no se encuentra en la dirección indicada, se puede dejar en el buzón (no hay nombre solo bajos 2ª) ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Pere Vilella, 5, Escala B, bajos 2ª o bien Escala A 1º 2ª', 'Manresa', 'Barcelona', '08243', 'España', 17.50, 0, '2024-06-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060624-a1IjKgqF+8Gq4-032', 'b92fcc18-9aed-4783-beda-4f306c5a74c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060624-a1IjKgqF%2B8Gq4-032&s=KOL2024&nf=P4838&i=17.50&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5174, 1, 439, 2, 0, NULL, 0, '2024-06-05 21:10:36', '2024-06-06 09:10:37', '2024-06-06', 'P4839', '24-06508-06-05', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Kukutza 4', 'Laudio/Llodio', 'Álava', '01400', 'España', 30.61, 0, '2024-06-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060624-e0yTd9vP4HCsQ-033', '35da5dbf-16d4-40f3-88e7-3b3d2cad5f31', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060624-e0yTd9vP4HCsQ-033&s=KOL2024&nf=P4839&i=30.61&cr=183', '[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
(5175, 1, 1050, 2, 0, NULL, 0, '2024-06-05 21:16:36', '2024-06-06 09:12:26', '2024-06-06', 'P4841', '24-06509-06-05', '', 0.00, 89.56, 19.24, 0.00, 1, 4.76, 2.50, 'Carlos caamaño,3', 'Madrid', 'Madrid', '28016', 'España', 115.63, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-060624-GMoEsHk1Xp3Rf-050', 'e2ee57f4-e290-4c5c-af93-6429b1ad1d6d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060624-GMoEsHk1Xp3Rf-050&s=KOL2024&nf=P4841&i=115.63&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5176, 1, 1264, 2, 0, NULL, 0, '2024-06-06 06:58:40', '2024-06-06 09:14:29', '2024-06-06', 'P4840', '24-06510-06-06', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Santiago Rusiñol 14-16,3°1a', 'Esplugues de Llobreg', 'Barcelona', '08950', 'España', 28.39, 0, '2024-06-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060624-pddTf1cvLZZNv-240', '735fc5b1-1c0b-4cc1-9451-b8b46171ed11', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060624-pddTf1cvLZZNv-240&s=KOL2024&nf=P4840&i=28.39&cr=119', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5177, 1, 1147, 2, 0, NULL, 0, '2024-06-06 08:42:17', '2024-06-06 10:54:20', '2024-06-06', 'P4842', '24-06511-06-06', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Avenida Aragón 14, Primero C', 'Teruel', 'Teruel', '44001', 'España', 65.52, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060624-D0yL45442cign-238', '05490cf2-fa89-4515-aabd-29fa09a9a9b4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060624-D0yL45442cign-238&s=KOL2024&nf=P4842&i=65.52&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5178, 1, 1037, 2, 0, NULL, 0, '2024-06-06 10:54:50', '2024-06-07 09:12:53', '2024-06-07', 'P4843', '24-06512-06-06', '', 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, '2024-06-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070624-j62Tes6AgaFe8-020', 'ae9c98bb-4fe9-44e1-b8b8-0948ee570949', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070624-j62Tes6AgaFe8-020&s=KOL2024&nf=P4843&i=17.50&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5179, 1, 522, 2, 0, NULL, 0, '2024-06-06 11:38:16', '2024-06-07 09:14:24', '2024-06-07', 'P4844', '24-06514-06-06', '', 0.00, 122.14, 25.65, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 147.79, 0, '2024-06-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070624-kvJEjkXjSDJ8y-159', 'af1885b1-d2a9-43f1-a9c7-793e14cc85d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070624-kvJEjkXjSDJ8y-159&s=KOL2024&nf=P4844&i=147.79&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5180, 1, 1296, 2, 0, NULL, 0, '2024-06-06 17:24:06', '2024-06-07 09:15:03', '2024-06-07', 'P4845', '24-06515-06-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avenida navarra 30', 'Lodosa', 'Navarra', '31580', 'España', 17.50, 0, '2024-06-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070624-M38VnAhE4odlZ-220', '85294761-f583-4be1-9fb5-aeb0f55b9504', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070624-M38VnAhE4odlZ-220&s=KOL2024&nf=P4845&i=17.50&cr=146', '[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
(5181, 1, 17, 2, 0, NULL, 0, '2024-06-07 15:47:23', '2024-06-10 09:00:30', '2024-06-10', 'P4846', '24-06516-06-07', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 137.94, 0, '2024-06-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-eckkiThRqPz2K-169', 'd786b566-7deb-4285-91bc-fc0369d95ccb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-eckkiThRqPz2K-169&s=KOL2024&nf=P4846&i=137.94&cr=058', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5182, 1, 1297, 2, 0, NULL, 0, '2024-06-07 18:35:43', '2024-06-10 09:02:34', '2024-06-10', 'P4847', '24-06517-06-07', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'CALLE JOSE LUIS SAMPEDRO, 8 3B', 'Rivas-Vaciamadrid', 'Madrid', '28522', 'España', 17.50, 0, '2024-06-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-hHpX5smplXU53-189', '38b2d0d4-513b-4efa-aa9a-f50b8abedf1b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-hHpX5smplXU53-189&s=KOL2024&nf=P4847&i=17.50&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5183, 1, 855, 2, 0, NULL, 0, '2024-06-08 14:35:45', '2024-06-10 09:07:04', '2024-06-10', 'P4848', '24-06518-06-08', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Avda. Valdegudin, 13', 'Villamuriel de Cerra', 'Palencia', '34190', 'España', 30.61, 0, '2024-06-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-JLR6J11mlQX8A-014', 'a38938f5-a3a5-4630-82d6-b9e06580e2af', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-JLR6J11mlQX8A-014&s=KOL2024&nf=P4848&i=30.61&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5184, 1, 755, 2, 0, NULL, 0, '2024-06-09 09:47:36', '2024-06-10 09:08:11', '2024-06-10', 'P4849', '24-06519-06-09', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Estrada pola Vía, 21', 'Nigrán', 'Pontevedra', '36350', 'España', 30.61, 0, '2024-06-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-W6FvPCqKaZgj7-071', '559fd706-0997-4d81-854b-0a41d91154e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-W6FvPCqKaZgj7-071&s=KOL2024&nf=P4849&i=30.61&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5185, 1, 754, 2, 0, NULL, 0, '2024-06-09 10:27:00', '2024-06-10 09:09:49', '2024-06-10', 'P4850', '24-06521-06-09', '6+1 GRATIS. \r\nGRATIS EL INCOLORO NEUTRAL.\r\nGRACIAS.', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradelles 166 2*1*', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-06-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-kgZHehb5cPpeD-249', 'de24a1d0-d5ed-4081-8705-9db040588508', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-kgZHehb5cPpeD-249&s=KOL2024&nf=P4850&i=61.64&cr=146', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5186, 1, 1298, 2, 0, NULL, 0, '2024-06-09 10:35:35', '2024-06-10 09:11:19', '2024-06-10', 'P4851', '24-06523-06-09', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carretera del Faro 5A Candas Asturias', 'Carreño', 'Asturias', '33430', 'España', 30.61, 0, '2024-06-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-U1nKJxfVBWkrh-233', 'a7452e02-0990-4ea4-a42c-a0981edccecb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-U1nKJxfVBWkrh-233&s=KOL2024&nf=P4851&i=30.61&cr=138', '[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
(5187, 1, 1299, 2, 0, NULL, 0, '2024-06-09 19:05:51', '2024-06-10 09:14:22', '2024-06-10', 'P4852', '24-06524-06-09', 'Recogen, en caso de estar yo ausente, en el 1º izquierda, y en el tercero, tanto derecha como izquierda. ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'SEBASTIAN ELCANO 1 1º DERECHA', 'Vigo', 'Pontevedra', '36208', 'España', 30.61, 0, '2024-06-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-H/DzZle1uxzVd-213', '4be1ddaa-e778-4c67-8b97-96b5fabf55fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-H%2FDzZle1uxzVd-213&s=KOL2024&nf=P4852&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),
(5188, 1, 999, 2, 0, NULL, 0, '2024-06-09 20:04:18', '2024-06-10 09:18:23', '2024-06-10', 'P4853', '24-06525-06-09', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Calle la matiella 5 2°D', 'Carreño', 'Asturias', '33430', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-100624-F/8rBjBlAxHtF-052', 'da40996f-b1d4-4978-a0b6-fdb674de7d95', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-F%2F8rBjBlAxHtF-052&s=KOL2024&nf=P4853&i=20.00&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5189, 1, 152, 1, 0, NULL, 0, '2024-06-10 09:20:46', '2024-06-10 09:20:46', '2024-06-10', 'P4854', '', '', 0.00, 77.22, 16.22, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 93.44, 0, '2024-06-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100624-FixvE38/LN7pD-121', '0e5c3068-91c3-4069-a718-f50abf464ed0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-FixvE38%2FLN7pD-121&s=KOL2024&nf=P4854&i=93.44&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5190, 1, 162, 2, 0, NULL, 0, '2024-06-10 07:43:53', '2024-06-10 09:51:16', '2024-06-10', 'P4855', '24-06526-06-10', 'Entrega en horario de mañana', 0.00, 134.34, 28.21, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 162.55, 0, '2024-06-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-FJHX3d3WVINxk-048', '38d66195-4c0a-4e56-993c-0e636b042278', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-FJHX3d3WVINxk-048&s=KOL2024&nf=P4855&i=162.55&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5191, 1, 1158, 2, 0, NULL, 0, '2024-06-10 09:01:40', '2024-06-10 11:34:11', '2024-06-10', 'P4856', '24-06527-06-10', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'Republica argentina 3, bajo 2', 'Irun', 'Gipuzkoa', '20302', 'España', 59.10, 0, '2024-06-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-fQCkdbIF8ZWaX-144', '4a2f46dd-6574-4820-8899-1ec58e1d7c95', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-fQCkdbIF8ZWaX-144&s=KOL2024&nf=P4856&i=59.10&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5192, 1, 1300, 2, 0, NULL, 0, '2024-06-10 10:41:28', '2024-06-10 12:56:16', '2024-06-10', 'P4857', '24-06528-06-10', 'Llamar antes de entregar', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Camino Arquilla N6 P1', 'Teruel', 'Teruel', '44003', 'España', 17.50, 0, '2024-06-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100624-HjOR44soSl61z-077', '6fc9780a-7a91-49bf-bf71-dfe188263bb5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100624-HjOR44soSl61z-077&s=KOL2024&nf=P4857&i=17.50&cr=165', '[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
(5193, 1, 731, 2, 0, NULL, 0, '2024-06-10 13:51:47', '2024-06-11 09:19:48', '2024-06-11', 'P4858', '24-06529-06-10', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, ' CALLE NAGUSIA 3 (CITYPAQ CORREOS)', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 17.50, 0, '2024-06-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110624-mTV6D6QKfUAPs-078', 'dff4ed5c-e1bc-48bb-9977-14e3e62170ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110624-mTV6D6QKfUAPs-078&s=KOL2024&nf=P4858&i=17.50&cr=184', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5194, 1, 519, 1, 0, NULL, 0, '2024-06-10 16:20:01', '2024-06-10 16:20:01', '2024-06-11', 'P4859', '', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'CALLE DE SAN AGUSTÍN \'EL VIEJO\' 25', 'TALAVERA DE LA REINA', 'TOLEDO', '45600', 'España', 68.97, 0, '2024-06-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110624-GE3kYJf7QhVtD-009', '950262ce-3a82-45de-8a67-13f0aa8775c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110624-GE3kYJf7QhVtD-009&s=KOL2024&nf=P4859&i=68.97&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5195, 1, 4, 2, 0, NULL, 0, '2024-06-10 17:34:39', '2024-06-11 09:27:19', '2024-06-11', 'P4860', '24-06530-06-10', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 275.88, 0, '2024-06-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110624-Z9xWvdx+YUqR+-120', '0c2023f8-b796-4946-bd38-6c7376dad7f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110624-Z9xWvdx%2BYUqR%2B-120&s=KOL2024&nf=P4860&i=275.88&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5196, 1, 68, 2, 0, NULL, 0, '2024-06-11 06:55:19', '2024-06-11 09:28:59', '2024-06-11', 'P4861', '24-06531-06-11', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'Julio cesar 148', 'Ejido (El)', 'Almería', '04700', 'España', 140.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-110624-fiGfSbkZvedKc-083', '4860b664-04bd-4fcb-83fa-fb92375c0afc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110624-fiGfSbkZvedKc-083&s=KOL2024&nf=P4861&i=140.44&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5197, 1, 1212, 2, 0, NULL, 0, '2024-06-11 08:18:31', '2024-06-11 10:25:35', '2024-06-11', 'P4862', '24-06532-06-11', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Narkis Balentziaga 8 1A', 'Zestoa', 'Gipuzkoa', '20749', 'España', 28.39, 0, '2024-06-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110624-VYJUea754Dy0t-200', 'ae9f3cdd-3180-4dd8-9298-7966f4dbbf76', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110624-VYJUea754Dy0t-200&s=KOL2024&nf=P4862&i=28.39&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5198, 1, 1158, 1, 0, NULL, 0, '2024-06-11 12:27:59', '2024-06-11 12:27:59', '2024-06-11', 'P4863', '', '', 0.00, 32.56, 6.84, 0.00, 0, 0.00, 0.00, 'Republica Argentina 3, bajo 2', 'Irun', 'Gipuzkoa', '20302', 'ESPAÑA', 39.40, 0, '2024-06-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110624-eFNAZTrt1Uree-173', '6330eea5-c8ec-4ff6-a466-149159809c51', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110624-eFNAZTrt1Uree-173&s=KOL2024&nf=P4863&i=39.40&cr=067', '[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
(5199, 1, 25, 2, 0, NULL, 0, '2024-06-11 10:48:12', '2024-06-11 12:50:49', '2024-06-11', 'P4864', '24-06533-06-11', '', 0.00, 337.86, 70.95, 0.00, 0, 0.00, 0.00, 'araba kalea 1 bajo', 'Ordizia', 'Gipuzkoa', '20240', 'España', 408.81, 0, '2024-06-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110624-lThmwZDehhdZK-187', 'ea0163f6-1149-4723-a57f-b0996249ad12', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110624-lThmwZDehhdZK-187&s=KOL2024&nf=P4864&i=408.81&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5200, 1, 1301, 2, 0, NULL, 0, '2024-06-11 14:57:58', '2024-06-12 08:48:12', '2024-06-12', 'P4865', '24-06534-06-11', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Plaza valle de Aranguren 13,1A. 31192 Mutilva (Navarra)', 'Aranguren', 'Navarra', '31192', 'España', 65.52, 0, '2024-06-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-120624-R/R9EtXtC+K1U-143', '0df96f40-a9ce-494e-822f-1fcf9ff6a992', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120624-R%2FR9EtXtC%2BK1U-143&s=KOL2024&nf=P4865&i=65.52&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5201, 1, 262, 2, 0, NULL, 0, '2024-06-11 17:53:49', '2024-06-12 08:53:08', '2024-06-12', 'P4866', '24-06535-06-11', 'Lunes y sabado tarde cerrado', 0.00, 199.48, 41.89, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 241.37, 0, '2024-06-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120624-AQ5ftYFKqioNr-132', '0a5c0495-17da-460e-b695-4816aa3d8430', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120624-AQ5ftYFKqioNr-132&s=KOL2024&nf=P4866&i=241.37&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5202, 1, 110, 2, 0, NULL, 0, '2024-06-12 11:52:14', '2024-06-13 09:02:41', '2024-06-13', 'P4867', '24-06536-06-12', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 206.91, 0, '2024-06-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130624-QccT7AJxp5mV/-126', 'f2e060a0-f5fc-436d-a448-4b8fc2ba3936', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130624-QccT7AJxp5mV%2F-126&s=KOL2024&nf=P4867&i=206.91&cr=225', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5203, 1, 1302, 2, 0, NULL, 0, '2024-06-12 13:40:53', '2024-06-13 09:07:31', '2024-06-13', 'P4868', '24-06537-06-12', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Bilbao número 2, 5A', 'Almería', 'Almería', '04007', 'España', 30.61, 0, '2024-06-12 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130624-mZj0m+J0kjVA2-141', 'd7742c46-da94-4a3c-9f08-8847e7595c93', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130624-mZj0m%2BJ0kjVA2-141&s=KOL2024&nf=P4868&i=30.61&cr=045', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5204, 1, 174, 2, 0, NULL, 0, '2024-06-12 19:22:49', '2024-06-13 09:11:16', '2024-06-13', 'P4869', '24-06538-06-12', 'Hola , como siempre servir el pedido lo antes posible ( que ya lo hacéis)  muchas gracias\r\nun saludo', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 241.40, 0, '2024-06-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130624-nHN2XWGastnJF-219', '75503aba-7f0f-4ded-a378-1b9f701974b4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130624-nHN2XWGastnJF-219&s=KOL2024&nf=P4869&i=241.40&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
