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
(5425, 1, 1216, 2, 0, NULL, 0, '2024-07-24 07:47:08', '2024-07-24 10:18:54', '2024-07-24', 'P5084', '24-06766-07-24', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Grupo Serantes 18, 4 Izq', 'Santurtzi', 'Bizkaia', '48980', 'España', 65.52, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-DwkczVj9zNVAy-093', 'ae5917ae-9369-4c92-9d9c-c6b6aba50d12', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-DwkczVj9zNVAy-093&s=KOL2024&nf=P5084&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),
(5426, 1, 1147, 2, 0, NULL, 0, '2024-07-24 07:53:34', '2024-07-24 10:21:09', '2024-07-24', 'P5085', '24-06767-07-24', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avenida Aragón 14, Primero C', 'Teruel', 'Teruel', '44001', 'España', 61.09, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-B81BEgqblEd+a-146', 'eaeeb8ef-bffd-41cd-a4cb-318c19c48f1f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-B81BEgqblEd%2Ba-146&s=KOL2024&nf=P5085&i=61.09&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5427, 1, 1027, 2, 0, NULL, 0, '2024-07-24 08:07:50', '2024-07-24 10:22:13', '2024-07-24', 'P5086', '24-06768-07-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Plaza palacio Góngora 8 4b', 'Aranguren', 'Navarra', '31192', 'España', 30.61, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-GsdYwS9x8E4M9-154', 'eb4dc33a-6b6f-4984-b32a-0ef971e49b5d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-GsdYwS9x8E4M9-154&s=KOL2024&nf=P5086&i=30.61&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5428, 1, 391, 1, 0, NULL, 0, '2024-07-24 10:25:58', '2024-07-24 10:25:58', '2024-07-24', 'P5087', '', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Paseo Santxiki, Nº 14 ', 'Mutilva', 'Navarra', '31192 ', 'España', 103.46, 0, '2024-07-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240724-ePsA6Bguvkh7n-087', '91afa3c6-a4ab-44e8-bd08-f76245f814e6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-ePsA6Bguvkh7n-087&s=KOL2024&nf=P5087&i=103.46&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5429, 1, 17, 2, 0, NULL, 0, '2024-07-24 08:50:01', '2024-07-24 10:55:40', '2024-07-24', 'P5088', '24-06774-07-24', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 68.97, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240724-MFXZaNlz3oJhi-013', '97d42e53-28aa-43b9-a189-e06ba9c4f129', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-MFXZaNlz3oJhi-013&s=KOL2024&nf=P5088&i=68.97&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5430, 1, 92, 2, 0, NULL, 0, '2024-07-24 09:14:48', '2024-07-24 11:32:24', '2024-07-24', 'P5089', '24-06775-07-24', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'euskal herria 4,bajo  ibarra guipuzkoa ', 'Ibarra', 'Gipuzkoa', '20400', 'España', 172.43, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-DE417B5h+Ql5b-108', '428c6124-697f-4800-95d1-e4645839a537', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-DE417B5h%2BQl5b-108&s=KOL2024&nf=P5089&i=172.43&cr=089', '[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
(5431, 1, 1190, 2, 0, NULL, 0, '2024-07-24 09:17:44', '2024-07-24 11:35:17', '2024-07-24', 'P5090', '24-06776-07-24', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Sagasti Auzoa N1 SM (PELUQUERIA COT)', 'Antzuola', 'Gipuzkoa', '20577', 'España', 52.39, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-oZ5WywLmT3Pd/-209', 'cabc8638-30ed-4549-8f50-c111f39433b6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-oZ5WywLmT3Pd%2F-209&s=KOL2024&nf=P5090&i=52.39&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5432, 1, 77, 1, 0, NULL, 0, '2024-07-24 11:52:52', '2024-07-24 11:55:07', '2024-07-24', 'P5091', '', '', 0.00, 1222.65, 256.76, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1479.41, 0, '2024-07-24 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240724-jdL0+FLd0fpa7-143', 'f62d2796-86de-48b6-ac90-017c2c8f6187', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-jdL0%2BFLd0fpa7-143&s=KOL2024&nf=P5091&i=1479.41&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5433, 1, 1341, 2, 0, NULL, 0, '2024-07-24 10:50:41', '2024-07-24 13:23:10', '2024-07-24', 'P5092', '24-06777-07-24', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 196.56, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-J+0ZspL2F+SKU-097', 'fbf13962-e846-4125-b121-5e2967f8fa68', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-J%2B0ZspL2F%2BSKU-097&s=KOL2024&nf=P5092&i=196.56&cr=042', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5434, 1, 197, 2, 0, NULL, 0, '2024-07-24 11:29:26', '2024-07-24 13:33:58', '2024-07-24', 'P5093', '24-06778-07-24', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'CALLE IRUNLARREA 6', 'Pamplona/Iruña', 'Navarra', '31008', 'España', 68.97, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240724-XSrK0BdiAym0u-166', '1931e5ab-a769-427d-8052-bc426fdabaec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240724-XSrK0BdiAym0u-166&s=KOL2024&nf=P5093&i=68.97&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5435, 1, 78, 2, 0, NULL, 0, '2024-07-24 11:46:12', '2024-07-26 08:27:28', '2024-07-26', 'P5104', '24-06779-07-24', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'AVND. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '2008', 'España', 310.37, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260724-Nw7Rz+T3sbt8E-144', 'e6008dde-7337-4fdf-8760-498a79d141f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-Nw7Rz%2BT3sbt8E-144&s=KOL2024&nf=P5104&i=310.37&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5436, 1, 215, 2, 0, NULL, 0, '2024-07-24 13:17:01', '2024-07-24 13:17:01', '2024-07-26', 'P5094', '24-06780-07-24', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 241.40, 0, '2024-07-24 13:16:57', '', '', 3, 1, 1, 'TBAI-B20930640-260724-Njn+HNlCuddEm-208', '5f7e9fd3-4948-459b-b668-1bbb65fb22bb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-Njn%2BHNlCuddEm-208&s=KOL2024&nf=P5094&i=241.40&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 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
(5437, 1, 215, 2, 0, NULL, 0, '2024-07-24 13:18:27', '2024-07-24 13:18:27', '2024-07-26', 'P5095', '24-06781-07-24', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 241.40, 0, '2024-07-24 13:18:27', '', '', 3, 1, 1, 'TBAI-B20930640-260724-hUfZA41TaV/ex-030', 'e3a8fc37-ddaa-4f5a-98be-e2f8751c241f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-hUfZA41TaV%2Fex-030&s=KOL2024&nf=P5095&i=241.40&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(5438, 1, 215, 2, 0, NULL, 0, '2024-07-24 13:18:45', '2024-07-26 08:33:42', '2024-07-26', 'P5105', '24-06782-07-24', '', 0.00, 199.50, 42.33, 0.00, 0, 0.00, 2.50, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 243.90, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-260724-XCZTbMwN/Uq1H-075', 'de6fc549-ff74-41cf-a2e6-b0aedf0f857a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-XCZTbMwN%2FUq1H-075&s=KOL2024&nf=P5105&i=243.90&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5439, 1, 1267, 2, 0, NULL, 0, '2024-07-24 14:12:36', '2024-07-26 08:45:18', '2024-07-26', 'P5096', '24-06783-07-24', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Katazpegi auzoa 2B', 'Lesaka', 'Navarra', '31770', 'España', 17.50, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260724-dQEnE1+vMXqmD-182', '83e5db53-60c4-4f19-b7fc-4ac017927d27', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-dQEnE1%2BvMXqmD-182&s=KOL2024&nf=P5096&i=17.50&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5440, 1, 1313, 2, 0, NULL, 0, '2024-07-24 14:34:32', '2024-07-26 08:49:08', '2024-07-26', 'P5097', '24-06785-07-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Pol. Ind. El Sequero Avda. Cameros, 57', 'Agoncillo', 'La Rioja', '26150', 'España', 30.61, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260724-hVm0qicDmlOrx-180', '2775ae87-9ecb-4af0-99b6-c563ea34ef5a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-hVm0qicDmlOrx-180&s=KOL2024&nf=P5097&i=30.61&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5441, 1, 688, 2, 0, NULL, 0, '2024-07-24 16:28:46', '2024-07-26 08:52:20', '2024-07-26', 'P5098', '24-06786-07-24', 'Peluquería Adats', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Plaza Anzaran entra planta N1', 'Irun', 'Gipuzkoa', '20301', 'España', 68.97, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260724-QI+nGF0RtgMu/-009', '6893876e-e9dd-4b2e-bc2d-33e2f7caf45e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-QI%2BnGF0RtgMu%2F-009&s=KOL2024&nf=P5098&i=68.97&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5442, 1, 1342, 2, 0, NULL, 0, '2024-07-24 19:12:00', '2024-07-26 08:53:56', '2024-07-26', 'P5099', '24-06787-07-24', 'HORARIO COMERCIAL', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'REI EN jAUME 34', 'Benicarló', 'Castellón', '12580', 'España', 30.61, 0, '2024-07-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260724-CmowWv0/uQE/T-039', '9e2871aa-d13c-40ee-be41-1ec4dc334e1b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-CmowWv0%2FuQE%2FT-039&s=KOL2024&nf=P5099&i=30.61&cr=063', '[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
(5443, 1, 1155, 2, 0, NULL, 0, '2024-07-24 19:50:08', '2024-07-26 08:57:03', '2024-07-26', 'P5100', '24-06788-07-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer Corbera 13 ', 'Torrent', 'Valencia', '46900', 'España', 30.61, 0, '2024-07-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260724-I/hNcOI0bFkvD-117', 'a6a80d8c-c3bc-4996-a6ce-7d597b992a7e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-I%2FhNcOI0bFkvD-117&s=KOL2024&nf=P5100&i=30.61&cr=069', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5444, 1, 1264, 2, 0, NULL, 0, '2024-07-25 04:29:45', '2024-07-26 09:00:10', '2024-07-26', 'P5101', '24-06789-07-25', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Calle Santiago Rusiñol, 14-16, 3º1a', 'Esplugues de Llobreg', 'Barcelona', '08950', 'España', 52.39, 0, '2024-07-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260724-fu9oQCEMOkdyr-192', '4435bee0-8efb-4473-b115-69c77185b071', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-fu9oQCEMOkdyr-192&s=KOL2024&nf=P5101&i=52.39&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5445, 1, 1046, 2, 0, NULL, 0, '2024-07-25 13:47:37', '2024-07-26 09:01:34', '2024-07-26', 'P5102', '24-06790-07-25', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Kamiñopea N3 6D', 'Abadiño', 'Bizkaia', '48220', 'España', 78.63, 0, '2024-07-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260724-E9FuZtAb8pADA-139', 'a73309c8-d5a0-4186-8a26-b5e18835cb63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-E9FuZtAb8pADA-139&s=KOL2024&nf=P5102&i=78.63&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5446, 1, 403, 2, 0, NULL, 0, '2024-07-25 20:39:24', '2024-07-26 09:04:56', '2024-07-26', 'P5103', '24-06791-07-25', 'La casa está abajo, en la primera calle a la derecha', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Urbanización Usarena, Casa 2', 'Zorraquín', 'La Rioja', '26288', 'España', 65.52, 0, '2024-07-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260724-RzT9b8GQriauH-065', '744d70f6-f67e-4ccb-a7ec-ba6116c45768', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-RzT9b8GQriauH-065&s=KOL2024&nf=P5103&i=65.52&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5447, 1, 215, 2, 1, 'error En el modo de pago, quiere contrareembolso', 5436, '2024-07-26 08:31:09', '2024-07-26 08:31:09', '2024-07-26', 'R85', 'P5094 RECT.', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 241.40, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-260724-NvQlBOqCfYQtu-040', '9beb29f3-d82d-4bff-bbee-76347f6c952e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-NvQlBOqCfYQtu-040&s=KOL2024&nf=R85&i=-241.40&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(5448, 1, 215, 2, 1, 'error en el modo de pago quiere hacerlo por contrareembolso', 5437, '2024-07-26 08:31:44', '2024-07-26 08:31:44', '2024-07-26', 'R86', 'P5095 RECT.', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 241.40, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-260724-khfu/JRBIMzBR-062', '5d2a1012-4718-4e3a-87f8-50f3aed514de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-khfu%2FJRBIMzBR-062&s=KOL2024&nf=R86&i=-241.40&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 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
(5449, 1, 1343, 2, 0, NULL, 0, '2024-07-26 10:51:27', '2024-07-26 13:01:52', '2024-07-26', 'P5106', '24-06794-07-26', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Av ciutat jardi 69, bloc 2, 2A', 'Lleida', 'Lleida', '25199', 'España', 52.39, 0, '2024-07-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260724-gsUHGfQ2YfO7Q-229', '5ea1d8f9-4864-4956-98cd-79cbb5cd2182', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260724-gsUHGfQ2YfO7Q-229&s=KOL2024&nf=P5106&i=52.39&cr=089', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5450, 1, 1049, 2, 0, NULL, 0, '2024-07-26 12:22:35', '2024-07-29 08:33:43', '2024-07-29', 'P5107', '24-06795-07-26', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Luis Luciano Bonaparte 20 4D', 'Bilbao', 'Bizkaia', '48004', 'España', 17.50, 0, '2024-07-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290724-Kehtz8ksjtLyg-046', 'f2f824ca-44d0-4821-a6b2-f75ce9473fc3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-Kehtz8ksjtLyg-046&s=KOL2024&nf=P5107&i=17.50&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5451, 1, 754, 2, 0, NULL, 0, '2024-07-26 14:20:55', '2024-07-29 08:42:50', '2024-07-29', 'P5108', '24-06796-07-26', '6+1 REGALO CASTAÑO', 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-07-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290724-pdmeOyutt81Wm-116', '0d3529e3-34d5-4381-b4f1-c0f2a74bf14a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-pdmeOyutt81Wm-116&s=KOL2024&nf=P5108&i=61.64&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5452, 1, 462, 2, 0, NULL, 0, '2024-07-26 15:25:34', '2024-07-29 08:44:53', '2024-07-29', 'P5109', '24-06797-07-26', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Santa María 12', 'Font-rubí', 'Barcelona', '08736', 'España', 56.82, 0, '2024-07-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290724-BVMjC41BLqpwA-233', '2a0df7d9-0e46-4ab0-b829-6b23fac1732f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-BVMjC41BLqpwA-233&s=KOL2024&nf=P5109&i=56.82&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5453, 1, 1297, 2, 0, NULL, 0, '2024-07-27 08:50:12', '2024-07-29 08:52:43', '2024-07-29', 'P5110', '24-06799-07-27', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Jose Luis Sampedro 8 3B', 'Rivas-Vaciamadrid', 'Madrid', '28522', 'España', 30.61, 0, '2024-07-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290724-RBRcbgsoT4iti-038', '9b29aad6-d72d-48b6-8b80-d4703cc7aed7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-RBRcbgsoT4iti-038&s=KOL2024&nf=P5110&i=30.61&cr=010', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5454, 1, 147, 2, 0, NULL, 0, '2024-07-27 10:29:04', '2024-07-29 08:56:02', '2024-07-29', 'P5111', '24-06800-07-27', 'Horario de martes a viernes de 10 a 17:30 sábados de 10 a 14h.\r\nSi no llega antes del día 2 avisarme porque no lo quiero q voy de vacaciones gracias.', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Calle de la palmera 23 Leganés Madrid ', 'Leganés', 'Madrid', '28913', 'España', 241.40, 0, '2024-07-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290724-co7OW9mjKoyey-222', 'b1bf053a-2f66-4a2b-9d8d-cce6cf14986e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-co7OW9mjKoyey-222&s=KOL2024&nf=P5111&i=241.40&cr=122', '[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
(5455, 1, 53, 2, 0, NULL, 0, '2024-07-27 16:52:03', '2024-07-29 08:58:23', '2024-07-29', 'P5113', '24-06801-07-27', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290724-X01CZr82wMBrg-051', 'e8b1e2f3-709e-440c-be73-4707a6ec6d33', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-X01CZr82wMBrg-051&s=KOL2024&nf=P5113&i=209.41&cr=107', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5456, 1, 573, 2, 0, NULL, 0, '2024-07-28 10:42:20', '2024-07-29 09:00:59', '2024-07-29', 'P5114', '24-06802-07-28', '', 0.00, 39.66, 9.53, 0.00, 0, 0.00, 6.90, 'Paseo Margallo 22', 'Sitges', 'Barcelona', '08870', 'España', 54.89, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290724-JtmigyBL2cmko-195', 'ec0adcf5-cea0-4c71-aeee-5faf2ca7d780', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-JtmigyBL2cmko-195&s=KOL2024&nf=P5114&i=54.89&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5457, 1, 1344, 2, 0, NULL, 0, '2024-07-28 14:39:28', '2024-07-29 09:04:07', '2024-07-29', 'P5112', '24-06803-07-28', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paseo Colón 62 4a', 'Irun', 'Gipuzkoa', '20301', 'España', 30.61, 0, '2024-07-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290724-ggTtcOnF72YeA-092', '5bcf82b8-c36e-45e7-bc19-d0aa3b315a9f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-ggTtcOnF72YeA-092&s=KOL2024&nf=P5112&i=30.61&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5458, 1, 560, 2, 0, NULL, 0, '2024-07-29 08:24:31', '2024-07-29 10:52:49', '2024-07-29', 'P5115', '24-06804-07-29', '', 0.00, 370.50, 77.81, 0.00, 0, 0.00, 0.00, 'balmes 133', 'Barcelona', 'Barcelona', '08008', 'España', 448.31, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290724-ICi+3s822/nEx-074', 'eb14f81a-c91b-46a0-8a56-24b3b0cd8a2f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-ICi%2B3s822%2FnEx-074&s=KOL2024&nf=P5115&i=448.31&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5459, 1, 154, 2, 0, NULL, 0, '2024-07-29 09:00:43', '2024-07-29 11:30:48', '2024-07-29', 'P5116', '24-06805-07-29', 'de 9:00 a 13:00', 0.00, 89.56, 18.81, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 108.37, 0, '2024-07-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290724-WRc4gB283d4EA-173', 'd01a712e-7bcf-46ad-90a1-433c1016dddd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-WRc4gB283d4EA-173&s=KOL2024&nf=P5116&i=108.37&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5460, 1, 102, 2, 0, NULL, 0, '2024-07-29 10:18:54', '2024-07-29 12:23:10', '2024-07-29', 'P5117', '24-06806-07-29', '', 0.00, 65.14, 14.11, 0.00, 0, 0.00, 2.50, 'Riera Lledoners, 66', 'Canet de Mar', 'Barcelona', '08360', 'España', 81.32, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290724-V34qQS38p+zGu-237', '3ac1ae60-9582-4cb4-887e-2a16abd99be0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-V34qQS38p%2BzGu-237&s=KOL2024&nf=P5117&i=81.31&cr=070', '[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
(5461, 1, 925, 2, 0, NULL, 0, '2024-07-29 16:31:15', '2024-07-29 20:50:11', '2024-07-29', 'P5118', '24-06807-07-29', '', 0.00, 171.00, 35.91, 0.00, 1, 8.89, 0.00, 'Perú número 16 Bloq 2 Bajo DCH', 'ALICANTE', 'ALICANTE', '03008', 'ESPAÑA', 215.80, 0, '2024-07-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-290724-XrMKPfVRuHUiz-228', 'bf4be374-6920-4a08-922b-0a9019d888d6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-XrMKPfVRuHUiz-228&s=KOL2024&nf=P5118&i=215.80&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5462, 1, 1121, 2, 0, NULL, 0, '2024-07-29 18:04:28', '2024-07-29 20:53:47', '2024-07-29', 'P5119', '24-06808-07-29', 'LLAMAR ANTES DE ENTREGRA PARA CONCERTAR FRANJA HORARIA', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'CL. DONOSTI 24 1º C', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 17.50, 0, '2024-07-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290724-L3K7Hyn8Zg/f5-229', '137b301d-93bc-449c-953e-bce00512187b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290724-L3K7Hyn8Zg%2Ff5-229&s=KOL2024&nf=P5119&i=17.50&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5463, 1, 222, 2, 0, NULL, 0, '2024-07-29 19:11:38', '2024-07-30 07:44:05', '2024-07-30', 'P5121', '24-06809-07-29', '', 0.00, 207.64, 43.60, 0.00, 0, 0.00, 0.00, 'Cartagena 296 ', 'Barcelona', 'Barcelona', '08025', 'España', 251.24, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300724-BzBY0xQ4Sdv5T-234', '1beb1055-8952-456d-b810-4059d61fbb1b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300724-BzBY0xQ4Sdv5T-234&s=KOL2024&nf=P5121&i=251.24&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5464, 1, 1346, 2, 0, NULL, 0, '2024-07-29 21:46:04', '2024-07-30 07:44:20', '2024-07-30', 'P5120', '24-06810-07-29', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Dublín 52 6°C', 'Burlada/Burlata', 'Navarra', '31600', 'España', 17.50, 0, '2024-07-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300724-bKLR/uzsBRrxm-086', '23ceec70-9534-4cf3-8ebb-719768642386', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300724-bKLR%2FuzsBRrxm-086&s=KOL2024&nf=P5120&i=17.50&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5465, 1, 190, 3, 0, NULL, 0, '2024-07-30 09:31:41', '2024-10-15 16:08:59', '2024-07-30', '', 'Consumo interno', '', 0.00, 1954.20, 410.38, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2364.58, 0, '2024-07-30 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),
(5466, 1, 956, 2, 0, NULL, 0, '2024-07-30 09:34:02', '2024-07-30 12:02:57', '2024-07-30', 'P5122', '24-06811-07-30', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1 bajo ', 'Vigo', 'Pontevedra', '36204', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300724-QTcYMg53jfuQh-161', 'e896fa49-8bf1-4547-84f1-f932c938c9aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300724-QTcYMg53jfuQh-161&s=KOL2024&nf=P5122&i=172.43&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5467, 1, 88, 2, 0, NULL, 0, '2024-07-30 09:47:31', '2024-07-30 12:05:02', '2024-07-30', 'P5123', '24-06812-07-30', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Turina 2bj  peluqueria ecologica valderros ', 'Valladolid', 'Valladolid', '47006', 'España', 310.37, 0, '2024-07-30 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-300724-AN30YAiY8oODB-025', 'd8aa8590-60ae-4cc0-83ed-ca92a8917530', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300724-AN30YAiY8oODB-025&s=KOL2024&nf=P5123&i=310.37&cr=055', '[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
(5468, 1, 1158, 2, 0, NULL, 0, '2024-07-30 11:28:22', '2024-08-01 08:40:50', '2024-08-01', 'P5124', '24-06813-07-30', '', 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-07-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-W74b91Cpq3oHE-159', '1e9406d6-c433-4eee-a968-105956678ae8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-W74b91Cpq3oHE-159&s=KOL2024&nf=P5124&i=59.10&cr=092', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5469, 1, 522, 2, 0, NULL, 0, '2024-07-30 12:42:49', '2024-08-01 08:43:04', '2024-08-01', 'P5125', '24-06814-07-30', 'Abrimos de Lunes a Viernes de 10h a 18:30 .', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 241.40, 0, '2024-07-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-JRnJUT+vUxIfV-121', 'a998ca5d-7168-4c12-a199-42bb587c19af', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-JRnJUT%2BvUxIfV-121&s=KOL2024&nf=P5125&i=241.40&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5470, 1, 1347, 2, 0, NULL, 0, '2024-07-30 14:37:43', '2024-08-01 08:46:13', '2024-08-01', 'P5126', '24-06815-07-30', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Fernando el Católico 7, principal izquierda', 'Zaragoza', 'Zaragoza', '50006', 'España', 43.71, 0, '2024-07-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-B21RrBEAkVerq-155', 'c56314d8-45f6-4835-b0cd-b3e1c6a54288', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-B21RrBEAkVerq-155&s=KOL2024&nf=P5126&i=43.71&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5471, 1, 356, 2, 0, NULL, 0, '2024-07-30 15:46:33', '2024-08-01 09:10:54', '2024-08-01', 'P5127', '24-06816-07-30', 'El portal está en la parte de atrás del edificio. Gracias!', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'c/ Mendarozabal, 5 - 2 izq.', 'Mendaro', 'Gipuzkoa', '20850', 'España', 28.39, 0, '2024-07-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-mtm2awcrbEUg4-033', '64dd3cfa-6e5b-43f7-a830-1fec8f7b2edc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-mtm2awcrbEUg4-033&s=KOL2024&nf=P5127&i=28.39&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5472, 1, 1348, 2, 0, NULL, 0, '2024-07-30 20:47:55', '2024-08-01 09:14:40', '2024-08-01', 'P5128', '24-06817-07-30', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Xilgaro N6 2B', 'Vigo', 'Pontevedra', '36205', 'España', 41.50, 0, '2024-07-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-CwS5F72n1+hyy-191', 'bb465d60-3faa-4c96-b960-b81074369ff8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-CwS5F72n1%2Bhyy-191&s=KOL2024&nf=P5128&i=41.50&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5473, 1, 121, 2, 0, NULL, 0, '2024-07-31 07:19:05', '2024-08-01 09:18:19', '2024-08-01', 'P5129', '24-06818-07-31', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 206.91, 0, '2024-07-31 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-010824-LCeoR0iYlFSkp-125', '33eca53b-5cea-475e-b44f-bcdbbfb66fc2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-LCeoR0iYlFSkp-125&s=KOL2024&nf=P5129&i=206.91&cr=093', '[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
(5474, 1, 1349, 2, 0, NULL, 0, '2024-07-31 07:24:10', '2024-08-01 09:20:48', '2024-08-01', 'P5130', '24-06819-07-31', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Paseo Torres Villarroel n80 4B', 'Salamanca', 'Salamanca', '37005', 'España', 28.39, 0, '2024-07-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-K5DlPa6L1CLAw-182', '08791024-5f73-4ec2-a40f-e96fad9d060a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-K5DlPa6L1CLAw-182&s=KOL2024&nf=P5130&i=28.39&cr=075', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5475, 1, 337, 2, 0, NULL, 0, '2024-07-31 09:54:24', '2024-08-01 09:27:40', '2024-08-01', 'P5133', '24-06820-07-31', '', 0.00, 179.08, 37.61, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 216.69, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010824-mnUY2NsvxfJie-075', '04200abc-edd7-4665-bf25-41086bca9c15', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-mnUY2NsvxfJie-075&s=KOL2024&nf=P5133&i=216.69&cr=247', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5476, 1, 223, 2, 0, NULL, 0, '2024-07-31 14:52:35', '2024-08-01 09:30:38', '2024-08-01', 'P5131', '24-06822-07-31', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'c/damas apostolicas,8 -bajo D.  A Ramallosa', 'Nigrán', 'Pontevedra', '36370', 'España', 206.91, 0, '2024-07-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-AZWMfYc3UwrmG-040', 'ffd99d0a-c59f-48ae-a69f-f7430e1e30f7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-AZWMfYc3UwrmG-040&s=KOL2024&nf=P5131&i=206.91&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5477, 1, 4, 2, 0, NULL, 0, '2024-07-31 16:11:50', '2024-08-01 09:35:16', '2024-08-01', 'P5132', '24-06823-07-31', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 413.82, 0, '2024-07-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-Yi//oqmjaxz+C-092', '1c308460-9cb8-408b-ac40-7f90bad1a681', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-Yi%2F%2Foqmjaxz%2BC-092&s=KOL2024&nf=P5132&i=413.82&cr=040', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5478, 1, 451, 2, 0, NULL, 0, '2024-08-01 10:59:05', '2024-08-01 13:16:27', '2024-08-01', 'P5134', '24-06824-08-01', '', 0.00, 19.83, 4.92, 0.00, 1, 1.22, 4.40, 'Av. Barcelona N°2, 19', 'San Vicente del Rasp', 'Alicante', '3690', 'España', 29.61, 0, '2024-08-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-oS3RMzlxMhwrR-030', '9e8f9c73-e3db-4ebb-90c1-12b93b367467', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-oS3RMzlxMhwrR-030&s=KOL2024&nf=P5134&i=28.39&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5479, 1, 1350, 2, 0, NULL, 0, '2024-08-01 11:38:34', '2024-08-01 14:00:32', '2024-08-01', 'P5135', '24-06825-08-01', 'Llamar antes', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Camiño Novo, 20', 'Tomiño', 'Pontevedra', '36740', 'España', 28.39, 0, '2024-08-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010824-PAcPFmSLJ+i/Y-011', 'f8ef21c5-df6a-428b-98c1-6760c9444e82', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010824-PAcPFmSLJ%2Bi%2FY-011&s=KOL2024&nf=P5135&i=28.39&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
