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
(5261, 1, 1312, 2, 0, NULL, 0, '2024-06-24 20:37:55', '2024-06-25 09:57:51', '2024-06-25', 'P4924', '24-06589-06-24', 'se puede dejar en conserjeria . ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'MAGALLANES 1 , APARTAMENTO 605', 'Madrid', 'Madrid', '28015', 'España', 28.39, 0, '2024-06-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250624-EYFlR6wS+U7jb-043', '4a96e73c-6420-4b45-8b55-a39c15ffe3e1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250624-EYFlR6wS%2BU7jb-043&s=KOL2024&nf=P4924&i=28.39&cr=032', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5262, 1, 325, 2, 0, NULL, 0, '2024-06-24 20:54:47', '2024-06-25 10:03:19', '2024-06-25', 'P4925', '24-06592-06-24', 'En caso de no encontrarse en casa dejar en tienda de surf al lado .', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'San pelaio bide nagusia 52 bajo 6', 'Bakio', 'Bizkaia', '48130', 'España', 30.61, 0, '2024-06-24 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-250624-FJ7UG0nSCTVEq-163', '020e0670-24dd-400e-8c01-f0ef03248db3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250624-FJ7UG0nSCTVEq-163&s=KOL2024&nf=P4925&i=30.61&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5263, 1, 34, 2, 0, NULL, 0, '2024-06-25 07:43:37', '2024-06-25 07:43:37', '2024-06-25', 'P4926', '24-06593-06-25', 'Entregar de martes a viernes hasta las 12', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'peluqueria Marzo21 calle iparraguirre34 plaza trasera   Leioa Bizkaia', 'Leioa', 'Bizkaia', '48940', 'España', 379.34, 0, '2024-06-25 07:43:37', '', '', 3, 5, 1, 'TBAI-B20930640-250624-Ce0bF5T1JnjGm-050', 'bdc82b9b-5fe2-4855-958f-648b9dd29cc2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250624-Ce0bF5T1JnjGm-050&s=KOL2024&nf=P4926&i=379.34&cr=197', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 1, 1),
(5264, 1, 696, 1, 0, NULL, 0, '2024-06-25 12:56:21', '2024-07-08 13:23:13', '2024-06-25', 'P4927', '2024-06-25', '', 0.00, 531.96, 111.71, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 643.67, 0, '2024-06-25 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(5265, 1, 696, 1, 0, NULL, 0, '2024-06-25 16:28:37', '2024-06-25 16:28:37', '2024-06-25', 'P4928', '2024-06-25', '', 0.00, 497.64, 104.50, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 602.14, 0, '2024-06-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-250624-oD8KU3enfCIaE-118', '74606307-e7e1-42e8-91d4-35f1f5d72ec3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250624-oD8KU3enfCIaE-118&s=KOL2024&nf=P4928&i=602.14&cr=098', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5266, 1, 77, 1, 0, NULL, 0, '2024-06-25 17:17:11', '2024-06-25 17:17:59', '2024-06-26', 'P4929', '2024-06-25', '', 0.00, 1072.50, 225.23, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1297.73, 0, '2024-06-25 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260624-VoGGzpEikJfpq-124', '5af8866a-b85f-4bbb-b682-5508662a5d22', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260624-VoGGzpEikJfpq-124&s=KOL2024&nf=P4929&i=1297.73&cr=146', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5267, 1, 1313, 2, 0, NULL, 0, '2024-06-25 17:46:05', '2024-06-26 08:56:44', '2024-06-26', 'P4930', '24-06594-06-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, ' Pol.Ind.El Sequero - Avda Cameros, Parc. 57', 'Agoncillo', 'La Rioja', '26150', 'España', 30.61, 0, '2024-06-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260624-Tem6bNaboIrmm-179', '0ef1f89c-1b0b-4989-bdff-b61a956da734', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260624-Tem6bNaboIrmm-179&s=KOL2024&nf=P4930&i=30.61&cr=005', '[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
(5268, 1, 1314, 2, 0, NULL, 0, '2024-06-25 18:49:50', '2024-06-26 08:59:32', '2024-06-26', 'P4931', '24-06595-06-25', 'Llamar por teléfono cuando venga el repartidor, no funciona timbre\r\nGracias ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Altos de mentrida, número 26', 'Méntrida', 'Toledo', '45930', 'España', 17.50, 0, '2024-06-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260624-JXP12K4nzO6tT-190', '80ca0941-0318-41d5-a4eb-0ef2a3111b69', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260624-JXP12K4nzO6tT-190&s=KOL2024&nf=P4931&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),
(5269, 1, 215, 2, 0, NULL, 0, '2024-06-26 08:45:33', '2024-06-26 12:36:24', '2024-06-26', 'P4932', '24-06596-06-26', '', 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-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260624-fqDMQEb3Eliz0-197', 'ac1fd8ee-0e06-4462-831c-bd975a97cb24', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260624-fqDMQEb3Eliz0-197&s=KOL2024&nf=P4932&i=241.40&cr=148', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5270, 1, 623, 2, 0, NULL, 0, '2024-06-26 08:54:12', '2024-06-26 12:38:51', '2024-06-26', 'P4933', '24-06599-06-26', '', 0.00, 97.68, 20.51, 0.00, 0, 0.00, 0.00, 'Gaiteira 66, Bajo ', 'Coruña (A)', 'A Coruña', '15006', 'España', 118.19, 0, '2024-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260624-pS5UbGbYRCq/v-092', '5140f2fb-47f0-4db6-b0e2-427aabfe6489', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260624-pS5UbGbYRCq%2Fv-092&s=KOL2024&nf=P4933&i=118.19&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5271, 1, 754, 2, 0, NULL, 0, '2024-06-26 09:59:35', '2024-06-26 12:41:21', '2024-06-26', 'P4934', '24-06600-06-26', '6+1 de regalo Castaño Oscuro', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260624-G4iJvanQJt1t2-075', '0ed7635c-3c6c-4d28-9fc2-6bb0d0a27c10', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260624-G4iJvanQJt1t2-075&s=KOL2024&nf=P4934&i=61.64&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5272, 1, 1315, 2, 0, NULL, 0, '2024-06-26 11:24:25', '2024-06-27 09:39:17', '2024-06-27', 'P4935', '24-06601-06-26', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Av. Sancho el Fuerte, 35 - 5 A', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 30.61, 0, '2024-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270624-HDiJru84z9oW3-209', 'fd2cfc99-e996-4648-a53b-84c028cc9c7c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270624-HDiJru84z9oW3-209&s=KOL2024&nf=P4935&i=30.61&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5273, 1, 1316, 2, 0, NULL, 0, '2024-06-26 11:25:48', '2024-06-27 09:45:04', '2024-06-27', 'P4936', '24-06602-06-26', 'lunes cerrdo', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'AVENIDA DE SANTIAGO 18', 'Pino (O)', 'A Coruña', '15821', 'España', 275.88, 0, '2024-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270624-QYVd/LEKEsNxv-009', '34ee7a41-b1cd-46a3-bc4d-ee36032b7f40', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270624-QYVd%2FLEKEsNxv-009&s=KOL2024&nf=P4936&i=275.88&cr=180', '[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
(5274, 1, 40, 2, 0, NULL, 0, '2024-06-26 11:36:16', '2024-06-27 09:58:51', '2024-06-27', 'P4937', '24-06603-06-26', 'martes cerrado y lunes por la mañana tambien', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 68.97, 0, '2024-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270624-Qw3uIAtFi9sUU-218', '9273f863-a8fe-4ce1-bbb9-a2f423bf1f78', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270624-Qw3uIAtFi9sUU-218&s=KOL2024&nf=P4937&i=68.97&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5275, 1, 4, 2, 0, NULL, 0, '2024-06-26 16:42:59', '2024-06-27 10:01:13', '2024-06-27', 'P4938', '24-06604-06-26', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 344.85, 0, '2024-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270624-R2UU+DgMEp2gb-189', '160c309d-474b-488a-ad61-6cc5d319dd19', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270624-R2UU%2BDgMEp2gb-189&s=KOL2024&nf=P4938&i=344.85&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5276, 1, 932, 2, 0, NULL, 0, '2024-06-27 09:13:05', '2024-06-27 11:16:14', '2024-06-27', 'P4939', '24-06607-06-27', '', 0.00, 228.00, 48.31, 0.00, 0, 0.00, 2.50, 'Calle acera del pilar, edificio residencial casa fuerte, local 2 peluquería ', 'Almuñécar', 'Granada', '18697', 'España', 278.38, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-270624-b85hz4v31L8pz-234', '725b99ea-6fdb-4296-9caa-1604765e2504', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270624-b85hz4v31L8pz-234&s=KOL2024&nf=P4939&i=278.38&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5277, 1, 57, 2, 0, NULL, 0, '2024-06-27 09:52:36', '2024-06-27 12:15:41', '2024-06-27', 'P4940', '24-06608-06-27', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 206.91, 0, '2024-06-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270624-j+fbTB6KdUdEp-216', '4383f0e7-6777-475e-b525-8730ad87b0dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270624-j%2BfbTB6KdUdEp-216&s=KOL2024&nf=P4940&i=206.91&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5278, 1, 547, 2, 0, NULL, 0, '2024-06-27 11:43:25', '2024-06-28 09:32:31', '2024-06-28', 'P4941', '24-06609-06-27', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Humboldt 2, 1° derecha', 'Oleiros', 'A Coruña', '15172', 'España', 30.61, 0, '2024-06-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280624-J3o6WU7qfDf2W-084', '4e7904cb-3455-45e1-a923-558dc0453170', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280624-J3o6WU7qfDf2W-084&s=KOL2024&nf=P4941&i=30.61&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5279, 1, 1317, 2, 0, NULL, 0, '2024-06-27 13:57:38', '2024-06-28 09:32:46', '2024-06-28', 'P4942', '24-06610-06-27', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Jaca 4, Casa 2', 'Cuarte de Huerva', 'Zaragoza', '50410', 'España', 28.39, 0, '2024-06-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280624-G0l64fTVv+4cZ-210', '7d6c3ba8-2230-4515-bfee-770a2929cf3c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280624-G0l64fTVv%2B4cZ-210&s=KOL2024&nf=P4942&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);
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
(5280, 1, 174, 2, 0, NULL, 0, '2024-06-27 18:03:53', '2024-06-28 09:39:00', '2024-06-28', 'P4943', '24-06611-06-27', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 68.97, 0, '2024-06-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280624-DUDYbHunQVefe-222', 'aab4d59c-6840-4ea0-aa7e-f116fc06d3d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280624-DUDYbHunQVefe-222&s=KOL2024&nf=P4943&i=68.97&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5281, 1, 239, 1, 0, NULL, 0, '2024-06-28 09:41:46', '2024-06-28 09:42:00', '2024-06-28', 'P4944', '2024-06-28', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'San Marcial 37', 'Donostia', 'Gipuzkoa', '20005', 'España', 68.97, 0, '2024-06-28 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-280624-k9XqF799Iq6Cz-117', '6796dc04-78c2-452a-8b2c-1ac5c9c776b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280624-k9XqF799Iq6Cz-117&s=KOL2024&nf=P4944&i=68.97&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5282, 1, 30, 2, 0, NULL, 0, '2024-06-28 07:42:46', '2024-06-28 09:46:03', '2024-06-28', 'P4945', '24-06612-06-28', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Calle González tablas, 3 bajo', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 206.91, 0, '2024-06-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280624-oiIG7/fryO3uW-138', '506b03a1-527d-4a97-856c-4f3002420d51', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280624-oiIG7%2FfryO3uW-138&s=KOL2024&nf=P4945&i=206.91&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5283, 1, 1318, 2, 0, NULL, 0, '2024-06-28 12:57:17', '2024-07-01 09:19:59', '2024-07-01', 'P4954', '24-06613-06-28', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'carrer San Jaume 37', 'Sant Iscle de Vallal', 'Barcelona', '08359', 'España', 28.39, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010724-iAjrzVqvtgbix-204', 'e9dc7a73-1ad0-40d5-b335-1daf972a362c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-iAjrzVqvtgbix-204&s=KOL2024&nf=P4954&i=28.39&cr=229', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5284, 1, 1319, 2, 0, NULL, 0, '2024-06-28 14:17:05', '2024-07-01 09:39:45', '2024-07-01', 'P4946', '24-06614-06-28', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Miguel de Unamuno 13', 'Madrid', 'Madrid', '28813', 'España', 52.39, 0, '2024-06-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-010724-XCIRws85ZT1gD-239', 'b640db7d-0e8b-4f79-913e-3d3ccb98f56e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-XCIRws85ZT1gD-239&s=KOL2024&nf=P4946&i=52.39&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5285, 1, 270, 2, 0, NULL, 0, '2024-06-29 13:15:12', '2024-07-01 09:46:53', '2024-07-01', 'P4947', '24-06615-06-29', 'entrega en horario comercial', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Juan Bautista Zabala 9 (Comercio Gaurko)', 'Getxo', 'Bizkaia', '48991', 'España', 56.82, 0, '2024-06-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010724-VWsaTwZ3ZC7h1-113', '6d810f67-9ae6-4ee9-97ed-4c9bfbd38a5f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-VWsaTwZ3ZC7h1-113&s=KOL2024&nf=P4947&i=56.82&cr=057', '[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
(5286, 1, 53, 2, 0, NULL, 0, '2024-06-29 17:42:05', '2024-07-01 09:51:45', '2024-07-01', 'P4955', '24-06616-06-29', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-010724-E4lCMimL0Xh/j-003', 'f7993f6e-8420-49d6-9b07-4db32f8e5155', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-E4lCMimL0Xh%2Fj-003&s=KOL2024&nf=P4955&i=174.93&cr=254', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5287, 1, 1320, 2, 0, NULL, 0, '2024-06-29 18:08:17', '2024-07-01 09:55:05', '2024-07-01', 'P4948', '24-06617-06-29', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Campo de la Cruz Kalea 8, 1A', 'Zuia', 'Álava', '01130', 'España', 30.61, 0, '2024-06-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-010724-gIMUkq67dDEwW-031', '05badc47-2cdf-43de-803e-9a5c28d12300', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-gIMUkq67dDEwW-031&s=KOL2024&nf=P4948&i=30.61&cr=124', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5288, 1, 1321, 2, 0, NULL, 0, '2024-06-29 18:46:31', '2024-07-01 09:58:51', '2024-07-01', 'P4949', '24-06618-06-29', 'Dejar en garita de seguridad', 0.00, 10.83, 3.79, 0.00, 0, 0.00, 8.76, 'Av. CAP Martinet 110. Es Pouet. Apart. 27D', 'Santa Eulalia del Rí', 'Baleares (Illes)', '07819', 'España', 21.86, 0, '2024-06-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010724-U91ifog7Z+P7q-130', 'a5efe522-1449-4f5a-9976-19ff69f8bf03', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-U91ifog7Z%2BP7q-130&s=KOL2024&nf=P4949&i=21.86&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5289, 1, 75, 2, 0, NULL, 0, '2024-06-30 16:01:37', '2024-07-01 10:06:51', '2024-07-01', 'P4950', '24-06619-06-30', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 206.91, 0, '2024-06-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010724-JRBaTWLp7pmQF-024', 'eaefd87a-d447-4527-bda0-9936eee8e37f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-JRBaTWLp7pmQF-024&s=KOL2024&nf=P4950&i=206.91&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5290, 1, 635, 2, 0, NULL, 0, '2024-06-30 17:17:49', '2024-07-01 10:10:54', '2024-07-01', 'P4951', '24-06620-06-30', 'SI ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703 (VIVO AL LADO). GRACIAS.', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 137.94, 0, '2024-06-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010724-Ev77wdeLbtCxL-138', '6c9a84a5-9af0-42df-a89f-67a2ab46d262', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-Ev77wdeLbtCxL-138&s=KOL2024&nf=P4951&i=137.94&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5291, 1, 1305, 2, 0, NULL, 0, '2024-06-30 20:19:49', '2024-07-01 10:13:25', '2024-07-01', 'P4952', '24-06621-06-30', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle cruz malpelo 9', 'Arenas de San Pedro', 'Ávila', '05400', 'España', 65.52, 0, '2024-06-30 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-010724-RczHSVuqcko+l-178', 'dc75c937-a121-4f17-b085-74def47a88dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-RczHSVuqcko%2Bl-178&s=KOL2024&nf=P4952&i=65.52&cr=230', '[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
(5292, 1, 1322, 2, 0, NULL, 0, '2024-06-30 22:33:59', '2024-07-01 10:26:56', '2024-07-01', 'P4953', '24-06622-06-30', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Carrer Garrofers 36', 'Sant Pere de Ribes', 'Barcelona', '01180', 'España', 43.71, 0, '2024-06-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010724-N4YgpvD6oQrQW-206', '776eebdc-7567-4758-b41b-5e2909a1bbb4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010724-N4YgpvD6oQrQW-206&s=KOL2024&nf=P4953&i=43.71&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5293, 1, 108, 2, 0, NULL, 0, '2024-07-01 20:15:33', '2024-07-02 09:21:47', '2024-07-02', 'P4956', '24-06623-07-01', '', 0.00, 187.28, 39.33, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 226.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020724-UkP6s7djm/WAb-054', '4ca3ed59-4fee-4e05-beee-05ae6d40bdd9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020724-UkP6s7djm%2FWAb-054&s=KOL2024&nf=P4956&i=226.61&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5294, 1, 694, 2, 0, NULL, 0, '2024-07-01 20:25:18', '2024-07-02 09:30:40', '2024-07-02', 'P4957', '24-06624-07-01', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'DICES 33', 'Rois', 'A Coruña', '15911', 'España', 17.50, 0, '2024-07-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020724-EYUDHckNz5uwY-142', '9869a377-92df-445f-83d2-19b5026f8d91', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020724-EYUDHckNz5uwY-142&s=KOL2024&nf=P4957&i=17.50&cr=102', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5295, 1, 538, 2, 0, NULL, 0, '2024-07-02 04:26:09', '2024-07-02 09:33:11', '2024-07-02', 'P4958', '24-06625-07-02', 'Hay 2 números 24 deben entregar en la casa que indica Cal Sellares.', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'C/Raval n24', 'Olesa de Bonesvalls', 'Barcelona', '08795', 'España', 43.71, 0, '2024-07-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020724-bcFsK8zu+tmUP-145', 'afad361c-29e4-428b-ada3-1367a507c67f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020724-bcFsK8zu%2BtmUP-145&s=KOL2024&nf=P4958&i=43.71&cr=230', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5296, 1, 784, 2, 0, NULL, 0, '2024-07-02 07:41:54', '2024-07-02 10:02:30', '2024-07-02', 'P4959', '24-06626-07-02', '', 0.00, 69.20, 14.53, 0.00, 1, 3.60, 0.00, 'Calle san francisco 30 bis bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20002', 'España', 87.33, 0, '2024-07-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020724-GPM0FgaNjwZ2s-118', 'aa5e3c91-300b-4d97-a102-8ece3ed7f702', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020724-GPM0FgaNjwZ2s-118&s=KOL2024&nf=P4959&i=87.33&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5297, 1, 23, 2, 0, NULL, 0, '2024-07-02 08:11:06', '2024-07-02 10:13:54', '2024-07-02', 'P4960', '24-06627-07-02', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 103.46, 0, '2024-07-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020724-V/6kFpnRh1uXi-085', '2ff37502-7312-4928-b7ee-4fc434f4430e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020724-V%2F6kFpnRh1uXi-085&s=KOL2024&nf=P4960&i=103.46&cr=031', '[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
(5298, 1, 571, 2, 0, NULL, 0, '2024-07-02 09:37:21', '2024-07-03 09:10:32', '2024-07-03', 'P4961', '24-06628-07-02', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'TOLOSA', 'Tolosa', 'Gipuzkoa', '20400', 'España', 52.39, 0, '2024-07-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030724-Ng9SrOWRGVIch-127', '7b39db9d-d3cd-4667-9cec-99557b4b2e09', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030724-Ng9SrOWRGVIch-127&s=KOL2024&nf=P4961&i=52.39&cr=075', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5299, 1, 1050, 2, 0, NULL, 0, '2024-07-02 10:33:51', '2024-07-03 09:14:55', '2024-07-03', 'P4964', '24-06629-07-02', '', 0.00, 57.00, 12.40, 0.00, 1, 3.07, 2.50, 'Carlos Caamaño ,3 peluquería ', 'Madrid', 'Madrid', '28016', 'España', 74.54, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-030724-g6wR30mg0eBIb-076', 'd4171177-3a89-480b-bb16-c9a1ae0e60de', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030724-g6wR30mg0eBIb-076&s=KOL2024&nf=P4964&i=74.54&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5300, 1, 623, 2, 0, NULL, 0, '2024-07-02 11:07:58', '2024-07-03 09:18:21', '2024-07-03', 'P4965', '24-06630-07-02', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'C/ Gaiteira, 66 bajo', 'Coruña (A)', 'A Coruña', '15006', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030724-oc4z2ZDGcz6sE-188', 'a2343eb2-3d96-4005-a274-76a4a3189d23', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030724-oc4z2ZDGcz6sE-188&s=KOL2024&nf=P4965&i=413.82&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5301, 1, 1250, 2, 0, NULL, 0, '2024-07-02 19:49:18', '2024-07-03 09:21:24', '2024-07-03', 'P4962', '24-06631-07-02', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Errekarte 46, 4. esk', 'Beasain', 'Gipuzkoa', '20200', 'España', 28.39, 0, '2024-07-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030724-iuryLEQmrZ9ua-214', 'a647b3e8-2af0-4b02-a3cb-0a7b4c59dffa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030724-iuryLEQmrZ9ua-214&s=KOL2024&nf=P4962&i=28.39&cr=112', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5302, 1, 940, 2, 0, NULL, 0, '2024-07-02 20:55:50', '2024-07-03 09:24:32', '2024-07-03', 'P4963', '24-06632-07-02', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Matilde Orbegozo 17. 3c', 'Bilbao', 'Bizkaia', '48003', 'España', 30.61, 0, '2024-07-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030724-CeJgkbrsy5vOr-068', '45575142-3035-4863-889f-97dfd4f89787', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030724-CeJgkbrsy5vOr-068&s=KOL2024&nf=P4963&i=30.61&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5303, 1, 85, 2, 0, NULL, 0, '2024-07-02 21:18:30', '2024-07-03 09:31:01', '2024-07-03', 'P4966', '24-06633-07-02', '', 0.00, 191.34, 40.18, 0.00, 0, 0.00, 0.00, 'Paseo ondarreta 6/8 bj', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 231.52, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030724-UECydsT3xlnB1-007', '4420d686-7b2a-4ba5-9fea-694521d59fcc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030724-UECydsT3xlnB1-007&s=KOL2024&nf=P4966&i=231.52&cr=097', '[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
(5304, 1, 80, 2, 0, NULL, 0, '2024-07-03 08:42:16', '2024-07-03 11:09:26', '2024-07-03', 'P4967', '24-06634-07-03', '', 0.00, 655.50, 137.66, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 793.16, 0, '2024-07-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030724-NBqFxrnubvxDZ-221', '35a5a26c-9a60-4847-aaa2-a8304fec2f0b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030724-NBqFxrnubvxDZ-221&s=KOL2024&nf=P4967&i=793.16&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5305, 1, 1323, 2, 0, NULL, 0, '2024-07-03 11:15:49', '2024-07-04 09:20:48', '2024-07-04', 'P4968', '24-06635-07-03', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'C/ Las Huertas nº 7', 'Mérida', 'Badajoz', '06800', 'España', 41.50, 0, '2024-07-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040724-DKcebNiVLdk4T-255', '043a1eaf-8058-42cc-ac84-ec32a38e0d31', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040724-DKcebNiVLdk4T-255&s=KOL2024&nf=P4968&i=41.50&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5306, 1, 1064, 2, 0, NULL, 0, '2024-07-03 16:33:58', '2024-07-04 09:24:29', '2024-07-04', 'P4969', '24-06636-07-03', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'C/Lorenzo Cendra Busca', 'Málaga', 'Málaga', '29007', 'España', 172.43, 0, '2024-07-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040724-RtU15ltVaTqvX-252', '230c354a-3a9d-4a5a-a1a4-e3fdcd6daae5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040724-RtU15ltVaTqvX-252&s=KOL2024&nf=P4969&i=172.43&cr=198', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5307, 1, 1005, 2, 0, NULL, 0, '2024-07-03 18:50:56', '2024-07-04 09:32:31', '2024-07-04', 'P4970', '24-06637-07-03', 'primera puerta verde', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'c/ San Isidro Labrador 19, local A', 'Madrid', 'Madrid', '28005', 'España', 17.50, 0, '2024-07-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040724-jnkaFCfwfjcYZ-206', '3946a621-fb6c-4126-81c1-cabe65f38aa6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040724-jnkaFCfwfjcYZ-206&s=KOL2024&nf=P4970&i=17.50&cr=013', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5308, 1, 166, 1, 0, NULL, 0, '2024-07-04 09:43:52', '2024-07-04 09:43:52', '2024-07-04', 'P4971', '2024-07-04', '', 0.00, 214.50, 45.05, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 259.55, 0, '2024-07-04 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040724-fKISw6ydNcqq5-131', '02945592-a834-41fe-bea4-fe6e86908f61', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040724-fKISw6ydNcqq5-131&s=KOL2024&nf=P4971&i=259.55&cr=225', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5309, 1, 1324, 2, 0, NULL, 0, '2024-07-04 10:02:04', '2024-07-04 12:25:16', '2024-07-04', 'P4972', '24-06638-07-04', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Francisco Javier Landaburu, 44- 4Izq', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 43.71, 0, '2024-07-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040724-eUEOp8GlnVaMz-021', 'b3b09dad-4f28-485c-a3a9-e7f2c34f62e0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040724-eUEOp8GlnVaMz-021&s=KOL2024&nf=P4972&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);
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
(5310, 1, 522, 2, 0, NULL, 0, '2024-07-04 12:52:04', '2024-07-05 09:27:58', '2024-07-05', 'P4973', '24-06639-07-04', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 275.88, 0, '2024-07-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050724-lqcK63TPgAVzJ-073', '2627c2c3-89d3-46c9-b3e7-40ada36eb467', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050724-lqcK63TPgAVzJ-073&s=KOL2024&nf=P4973&i=275.88&cr=097', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5311, 1, 754, 2, 0, NULL, 0, '2024-07-04 13:56:39', '2024-07-05 09:32:54', '2024-07-05', 'P4974', '24-06640-07-04', '6+1 de regalo quiero el tratamiento NEUTRAL, pero porfavor que sea la nueva formulación con solo 2 plantas, ya que tengo 5 paquetes de la antigua.\r\ngracias', 0.00, 48.84, 10.25, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-07-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050724-fGybGTZ+z1RXX-011', '8ddd53a5-9ec0-4b53-9bee-2a684868baaf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050724-fGybGTZ%2Bz1RXX-011&s=KOL2024&nf=P4974&i=61.64&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5312, 1, 65, 2, 0, NULL, 0, '2024-07-04 13:58:00', '2024-07-17 13:19:10', '2024-07-05', 'P4976', '24-06641-07-04', '', 0.00, 655.50, 137.66, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 793.16, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050724-PpUTRvy3ZBU9W-037', 'f132cad7-a083-4476-b0de-a76f4d11109b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050724-PpUTRvy3ZBU9W-037&s=KOL2024&nf=P4976&i=793.16&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5313, 1, 617, 2, 0, NULL, 0, '2024-07-04 21:37:43', '2024-07-05 09:38:57', '2024-07-05', 'P4975', '24-06643-07-04', 'Enviar factura \r\nGracias ', 0.00, 321.64, 67.54, 0.00, 0, 0.00, 0.00, 'Riestra, 14', 'Pontevedra', 'Pontevedra', '36001', 'España', 389.18, 0, '2024-07-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050724-g2gOorr1IzDfs-134', '868ca1ee-1152-4789-ae4b-5a3bd72d136b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050724-g2gOorr1IzDfs-134&s=KOL2024&nf=P4975&i=389.18&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5314, 1, 77, 1, 0, NULL, 0, '2024-07-05 10:22:59', '2024-07-05 10:24:23', '2024-07-05', 'P4977', '2024-07-05', '', 0.00, 557.70, 117.12, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 674.82, 0, '2024-07-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050724-amE1Omeajxs33-118', 'fae2ca5e-fe70-4c01-9b17-8f1e0449d371', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050724-amE1Omeajxs33-118&s=KOL2024&nf=P4977&i=674.82&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5315, 1, 76, 1, 0, NULL, 0, '2024-07-05 12:23:38', '2024-07-05 12:23:38', '2024-07-05', 'P4978', '2024-07-05', '', 0.00, 283.14, 59.46, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 342.60, 0, '2024-07-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050724-GmcWicCTYmXla-172', '795bbe84-43b4-4fb2-927e-3205ddd5813a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050724-GmcWicCTYmXla-172&s=KOL2024&nf=P4978&i=342.60&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
