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
(4466, 1, 4, 2, 0, NULL, 0, '2024-01-25 16:18:00', '2024-01-26 09:29:28', '2024-01-25', 'P4186', '24-05750-01-25', '', 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-01-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250124-HlUp9YHHxpoYn-151', 'da059526-a7b0-43a4-bd99-0e5206de893c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250124-HlUp9YHHxpoYn-151&s=KOL2024&nf=P4186&i=413.82&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4467, 1, 115, 2, 0, NULL, 0, '2024-01-26 09:18:31', '2024-01-26 10:54:34', '2024-01-26', 'P4187', '24-05751-01-26', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'MONASTERIO DE URDAX NR. 38', 'Pamplona/Iruña', 'Navarra', '31011', 'España', 379.34, 0, '2024-01-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260124-LA1anCrUspIQ0-213', '54d2f540-788d-4c6e-bd06-2fcf7b64cd55', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260124-LA1anCrUspIQ0-213&s=KOL2024&nf=P4187&i=379.34&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4468, 1, 589, 2, 0, NULL, 0, '2024-01-26 10:47:13', '2024-01-26 11:49:00', '2024-01-26', 'P4188', '24-05752-01-26', 'A partir de las 15:30 en diario y por las mañanas en fin de semana ', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Avenida Constitución 184, esc 5,1 E', 'Torrejón de Ardoz', 'Madrid', '28850', 'España', 78.63, 0, '2024-01-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260124-e3/WUGN+yyJNj-028', '2be237a3-c959-4c72-8a01-6d2496c3b06a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260124-e3%2FWUGN%2ByyJNj-028&s=KOL2024&nf=P4188&i=78.63&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4469, 1, 1023, 2, 0, NULL, 0, '2024-01-26 12:08:33', '2024-01-29 09:01:56', '2024-01-26', 'P4189', '24-05755-01-26', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'La Quimera del Oro, 14 - 2ºi', 'Zaragoza', 'Zaragoza', '50019', 'España', 56.82, 0, '2024-01-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260124-o0mNjxe3TrSV3-033', '3da631b3-59a0-447a-9058-86dbf246ba8c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260124-o0mNjxe3TrSV3-033&s=KOL2024&nf=P4189&i=56.82&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4470, 1, 1142, 2, 0, NULL, 0, '2024-01-27 10:32:09', '2024-01-29 09:10:38', '2024-01-27', 'P4190', '24-05759-01-27', '', 0.00, 32.49, 11.30, 0.00, 0, 0.00, 25.77, 'via Pietro Zorutti, 32 ', 'Trieste', 'Trieste', '34144', 'Italia', 65.08, 0, '2024-01-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270124-TIXVbS8peqZBU-176', '9df8486a-7fc0-4359-b4db-88bdb6853105', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270124-TIXVbS8peqZBU-176&s=KOL2024&nf=P4190&i=65.08&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4471, 1, 522, 2, 0, NULL, 0, '2024-01-27 11:16:21', '2024-01-29 09:12:01', '2024-01-27', 'P4191', '24-05760-01-27', '', 0.00, 378.64, 79.51, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 458.15, 0, '2024-01-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270124-nAPUMtQFhvilA-054', 'b247d9c5-8a93-4813-8705-29db728af058', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270124-nAPUMtQFhvilA-054&s=KOL2024&nf=P4191&i=458.15&cr=202', '[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
(4472, 1, 1143, 2, 0, NULL, 0, '2024-01-28 10:04:48', '2024-01-29 09:14:37', '2024-01-28', 'P4192', '24-05762-01-28', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Los huetos 1, 8A', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 17.50, 0, '2024-01-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280124-GWsUWKxZoDoNA-238', '3b318eba-3a23-49ed-bf4a-5c9d8965aa5a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280124-GWsUWKxZoDoNA-238&s=KOL2024&nf=P4192&i=17.50&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4473, 1, 521, 2, 0, NULL, 0, '2024-01-28 10:06:43', '2024-01-29 09:17:38', '2024-01-28', 'P4193', '24-05763-01-28', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ Vidangoz n° 7 - 4° izd', 'Pamplona/Iruña', 'Navarra', '31014', 'España', 65.52, 0, '2024-01-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280124-pDtn9MHJ/BQhK-110', '7bb4f40a-0a7a-4997-93b4-6a041e2b680c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280124-pDtn9MHJ%2FBQhK-110&s=KOL2024&nf=P4193&i=65.52&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4474, 1, 1008, 2, 0, NULL, 0, '2024-01-28 14:40:19', '2024-01-29 09:24:07', '2024-01-28', 'P4194', '24-05765-01-28', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Candelario 2 esc.I 2A', 'Salamanca', 'Salamanca', '37007', 'España', 30.61, 0, '2024-01-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280124-MffHAcIx+NYCM-070', '2cb0a45c-ba4e-48bf-bcb2-cd1d6a25b9e5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280124-MffHAcIx%2BNYCM-070&s=KOL2024&nf=P4194&i=30.61&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4475, 1, 854, 2, 0, NULL, 0, '2024-01-28 18:40:20', '2024-01-29 09:25:44', '2024-01-28', 'P4195', '24-05766-01-28', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Trañabarren n11 5A', 'Abadiño', 'Bizkaia', '48220', 'España', 43.71, 0, '2024-01-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280124-TpVkC9lBExHQq-253', '3cc29b54-d943-40dd-a670-c876ea9f3270', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280124-TpVkC9lBExHQq-253&s=KOL2024&nf=P4195&i=43.71&cr=077', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4476, 1, 152, 1, 0, NULL, 0, '2024-01-29 09:34:59', '2024-01-29 09:35:10', '2024-01-29', 'P4196', '2024-01-29', '', 0.00, 85.80, 18.02, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 103.82, 0, '2024-01-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290124-ggZiBNyAH8Mkr-199', 'a65c9563-2fcd-4f2a-b558-1050c6d76672', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290124-ggZiBNyAH8Mkr-199&s=KOL2024&nf=P4196&i=103.82&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4477, 1, 190, 3, 0, NULL, 0, '2024-01-29 11:15:52', '2024-10-15 16:06:16', '2024-01-29', '', 'Consumo interno', '', 0.00, 56.10, 11.78, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 67.88, 0, '2024-01-29 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),
(4478, 1, 61, 2, 0, NULL, 0, '2024-01-29 10:46:36', '2024-01-29 11:50:23', '2024-01-29', 'P4197', '24-05767-01-29', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Maestro Gozalbo 4 bajo', 'Valencia', 'Valencia', '46005', 'España', 137.94, 0, '2024-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290124-isRZradU9X2PA-108', '27876b23-c31e-40aa-aea5-283e86849471', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290124-isRZradU9X2PA-108&s=KOL2024&nf=P4197&i=137.94&cr=032', '[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
(4479, 1, 1144, 2, 0, NULL, 0, '2024-01-29 15:11:58', '2024-01-30 09:53:42', '2024-01-29', 'P4201', '24-05768-01-29', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Alejandro Rodríguez de Valcárcel  n 20 2 A', 'Villarcayo de Merind', 'Burgos', '09550', 'España', 41.50, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290124-b2rUearQM1t79-017', '118903cb-e4b7-446e-a1ba-37cb8d88c284', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290124-b2rUearQM1t79-017&s=KOL2024&nf=P4201&i=41.50&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4480, 1, 1145, 2, 0, NULL, 0, '2024-01-29 16:29:59', '2024-01-30 09:53:58', '2024-01-29', 'P4198', '24-05769-01-29', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avenida, PINTOR GENARO PALAU, 14, 2° piso, puerta 5', 'Torrent', 'Valencia', '46900', 'España', 28.39, 0, '2024-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290124-GlK/K6H2YyfA5-241', '055b2e13-9be8-4de6-a024-78690bcde856', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290124-GlK%2FK6H2YyfA5-241&s=KOL2024&nf=P4198&i=28.39&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4481, 1, 1146, 2, 0, NULL, 0, '2024-01-29 18:51:35', '2024-01-30 09:56:37', '2024-01-29', 'P4202', '24-05770-01-29', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Paseo del parque ,5 1-2°', 'Sant Sadurní d\'Anoia', 'Barcelona', '08770', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-290124-iEo3MAGRA5aDD-061', '9012e90d-2c38-4f04-868d-5659ed494a94', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290124-iEo3MAGRA5aDD-061&s=KOL2024&nf=P4202&i=20.00&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4482, 1, 40, 2, 0, NULL, 0, '2024-01-29 19:49:31', '2024-01-30 09:54:24', '2024-01-29', 'P4199', '24-05771-01-29', 'martes cerrado', 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-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290124-CYMUYQC4OumAU-062', 'cac68e38-f9da-49e2-8211-6dd167bea333', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290124-CYMUYQC4OumAU-062&s=KOL2024&nf=P4199&i=68.97&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4483, 1, 754, 2, 0, NULL, 0, '2024-01-29 21:45:42', '2024-01-30 09:54:50', '2024-01-29', 'P4200', '24-05772-01-29', 'Tal como quedamos hazme un 6+1 de regalo RUBIO ARENA.\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-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290124-OHFjs9Ugna60C-242', '0ab6516b-356b-433d-9fa1-f47844c3b0d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290124-OHFjs9Ugna60C-242&s=KOL2024&nf=P4200&i=61.64&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4484, 1, 754, 4, 0, NULL, 0, '2024-01-30 09:58:01', '2024-01-30 09:58:01', '2024-01-30', '', 'PROMOCIÓN', '', 0.00, 8.14, 1.71, 0.00, 1, 0.42, 0.00, 'Josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 10.27, 0, '2024-01-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),
(4485, 1, 162, 2, 0, NULL, 0, '2024-01-30 09:40:50', '2024-01-30 11:34:47', '2024-01-30', 'P4203', '24-05773-01-30', 'Entrega en horario de mañana', 0.00, 118.04, 24.79, 0.00, 0, 0.00, 0.00, 'Ronda del Salvador,27 (local)', 'Plasencia', 'Cáceres', '10600', 'España', 142.83, 0, '2024-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300124-fILbbKtZTX/yB-073', 'c34e36e7-083b-485f-ab47-50ef4933ac39', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300124-fILbbKtZTX%2FyB-073&s=KOL2024&nf=P4203&i=142.83&cr=059', '[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
(4486, 1, 25, 2, 0, NULL, 0, '2024-01-30 10:50:26', '2024-01-30 11:54:40', '2024-01-30', 'P4204', '24-05775-01-30', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'araba 1 bjo', 'Ordizia', 'Gipuzkoa', '20240', 'España', 103.46, 0, '2024-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300124-do5qv2HlK46XI-127', 'cc2717ba-e664-47dc-922c-5cbbf304b580', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300124-do5qv2HlK46XI-127&s=KOL2024&nf=P4204&i=103.46&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4487, 1, 1147, 2, 0, NULL, 0, '2024-01-30 11:34:49', '2024-01-30 12:49:11', '2024-01-30', 'P4205', '24-05777-01-30', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Avd Aragon 14 1c', 'Teruel', 'Teruel', '44002', 'España', 61.09, 0, '2024-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300124-PZ61kjJXa1nw8-074', 'e47f02b7-3f25-4044-9460-688915e4853f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300124-PZ61kjJXa1nw8-074&s=KOL2024&nf=P4205&i=61.09&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4488, 1, 333, 2, 0, NULL, 0, '2024-01-30 13:34:03', '2024-01-31 09:49:40', '2024-01-30', 'P4206', '24-05778-01-30', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Laxosa 2 Gurgueiro, ', 'Agolada', 'Pontevedra', '36520', 'España', 52.39, 0, '2024-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300124-TJkpXk3cmM+Pb-041', 'd42f82ed-210b-446c-abc9-c1e0d9fdff17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300124-TJkpXk3cmM%2BPb-041&s=KOL2024&nf=P4206&i=52.39&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4489, 1, 1148, 2, 0, NULL, 0, '2024-01-30 17:11:25', '2024-01-31 09:49:51', '2024-01-30', 'P4207', '24-05779-01-30', 'En el portal número 6 hay portero 24x7. ', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Travesía de Téllez 8, 1T', 'Madrid', 'Madrid', '28007', 'España', 56.82, 0, '2024-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300124-PINRXo/xkOg/U-203', '5a66c266-8d7b-4ce3-9f23-c88b8575badf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300124-PINRXo%2FxkOg%2FU-203&s=KOL2024&nf=P4207&i=56.82&cr=054', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4490, 1, 102, 2, 0, NULL, 0, '2024-01-30 17:37:02', '2024-01-31 09:50:08', '2024-01-30', 'P4212', '24-05780-01-30', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Riera Gavarra  numero 73 local', 'Canet de Mar', 'Barcelona', '08360', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-300124-hPtV8xbIE3yXe-202', '7649b47c-b1b7-4754-8fd8-d28380d5ada5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300124-hPtV8xbIE3yXe-202&s=KOL2024&nf=P4212&i=71.47&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4491, 1, 566, 2, 0, NULL, 0, '2024-01-30 18:26:36', '2024-01-31 09:50:33', '2024-01-30', 'P4208', '24-05781-01-30', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 241.40, 0, '2024-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300124-CTYtOIUwpm+Vf-213', '46f427b4-477a-41f2-b1fa-8b4b8748e8da', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300124-CTYtOIUwpm%2BVf-213&s=KOL2024&nf=P4208&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
(4492, 1, 1149, 2, 0, NULL, 0, '2024-01-30 21:10:54', '2024-01-31 09:50:48', '2024-01-30', 'P4209', '24-05782-01-30', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'calle Fernández de los Ríos 42 (Teatro de La Abadía)', 'Madrid', 'Madrid', '28015', 'España', 52.39, 0, '2024-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300124-axPUxwz6HCKSB-237', 'f7a2b239-2119-4b7a-b9f1-a469f21f4c16', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300124-axPUxwz6HCKSB-237&s=KOL2024&nf=P4209&i=52.39&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4493, 1, 164, 2, 0, NULL, 0, '2024-01-30 22:25:53', '2024-01-31 09:51:08', '2024-01-30', 'P4210', '24-05783-01-30', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 310.37, 0, '2024-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300124-KgpNSAMBxCVah-126', '2060f173-7725-422a-ab03-26531eebba6e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300124-KgpNSAMBxCVah-126&s=KOL2024&nf=P4210&i=310.37&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4494, 1, 252, 2, 0, NULL, 0, '2024-01-31 07:23:01', '2024-01-31 09:51:16', '2024-01-31', 'P4211', '24-05784-01-31', 'Si no hay nadie para recoger el paquete, depositar en el buzón aunque se tenga que abrir la caja. Gracias ', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Pl. Pedro Astigarraga N°2 6° Pta 613', 'Bilbao', 'Bizkaia', '48015', 'España', 43.71, 0, '2024-01-31 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-310124-iwPMVlPs4fBFI-165', '489b43c7-9095-44fc-9c95-a3739e78589a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310124-iwPMVlPs4fBFI-165&s=KOL2024&nf=P4211&i=43.71&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4495, 1, 65, 2, 0, NULL, 0, '2024-01-31 09:23:09', '2024-07-17 13:17:06', '2024-01-31', 'P4213', '24-05785-01-31', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 172.42, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-310124-nRmEjQZOvLDzU-200', 'cd901edf-22fd-4319-8d95-2c63146e03bf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310124-nRmEjQZOvLDzU-200&s=KOL2024&nf=P4213&i=172.43&cr=095', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4496, 1, 560, 2, 0, NULL, 0, '2024-01-31 09:23:11', '2024-01-31 09:23:11', '2024-01-31', '', '24-05786-01-31', NULL, 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'balmes 133', 'Barcelona', 'Barcelona', '08008', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4497, 1, 560, 2, 0, NULL, 0, '2024-01-31 09:23:13', '2024-01-31 09:23:13', '2024-01-31', '', '24-05787-01-31', NULL, 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'balmes 133', 'Barcelona', 'Barcelona', '08008', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4498, 1, 1075, 2, 0, NULL, 0, '2024-01-31 11:20:04', '2024-01-31 12:33:55', '2024-01-31', 'P4214', '24-05788-01-31', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'General  Eguia 40', 'Bilbao', 'Bizkaia', '48013', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-310124-eT8juaAz4aABh-116', '46bea794-de41-4797-9967-eccc73574cc0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310124-eT8juaAz4aABh-116&s=KOL2024&nf=P4214&i=379.34&cr=239', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4499, 1, 236, 2, 0, NULL, 0, '2024-01-31 17:25:16', '2024-02-01 09:22:41', '2024-01-31', 'P4215', '24-05789-01-31', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'AVDA. DE LA POLICÍA NACIONAL, EDF. DONI IVES, 24', 'Antequera', 'Málaga', '29200', 'España', 206.91, 0, '2024-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310124-NDbQbdE17ZEPI-008', '5f8ff5ce-c910-4cde-acb1-2d8b5721234a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310124-NDbQbdE17ZEPI-008&s=KOL2024&nf=P4215&i=206.91&cr=099', '[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
(4500, 1, 635, 2, 0, NULL, 0, '2024-01-31 18:06:55', '2024-02-01 09:24:40', '2024-01-31', 'P4216', '24-05790-01-31', '', 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-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310124-dhoCq1/17uws/-150', '4d86e591-6d79-4009-b0e4-631c40dda2a5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310124-dhoCq1%2F17uws%2F-150&s=KOL2024&nf=P4216&i=137.94&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4501, 1, 1150, 2, 0, NULL, 0, '2024-01-31 19:15:33', '2024-02-01 09:26:13', '2024-01-31', 'P4217', '24-05791-01-31', 'si no estamos en domicilio, dejar al conserje Jon,en el bar txintxua (a 15 mts de la vivienda) o contactar conmigo', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Catalina Erauso,12 5º d', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 41.50, 0, '2024-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310124-Qjxs8d2I0gh42-243', '18b18cce-1b85-463e-9982-e377eb47b2ca', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310124-Qjxs8d2I0gh42-243&s=KOL2024&nf=P4217&i=41.50&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4502, 1, 808, 2, 0, NULL, 0, '2024-01-31 20:16:19', '2024-02-01 09:30:17', '2024-01-31', 'P4218', '24-05792-01-31', 'Fontanería Larrañaga Eguren', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Plz Juan XXIII', 'Bergara', 'Gipuzkoa', '20570', 'España', 17.50, 0, '2024-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310124-WtX7FTF75vJmh-031', '3ef134a3-d305-425c-a26c-5922d0b2d385', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310124-WtX7FTF75vJmh-031&s=KOL2024&nf=P4218&i=17.50&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4503, 1, 1151, 2, 0, NULL, 0, '2024-02-01 00:09:07', '2024-02-01 09:35:40', '2024-02-01', 'P4219', '24-05793-02-01', 'Horario de tarde y avisar al 659048095 antes.', 0.00, 82.98, 17.43, 0.00, 0, 0.00, 0.00, 'C/ Pedro Martin N 2, 2 E', 'Don Benito', 'Badajoz', '06400', 'España', 100.41, 0, '2024-02-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010224-BuuXbY1Mha9lh-105', '5f5091e7-1d9a-406b-9edf-cb52ee36d8fd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010224-BuuXbY1Mha9lh-105&s=KOL2024&nf=P4219&i=100.41&cr=005', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4504, 1, 127, 2, 0, NULL, 0, '2024-02-01 08:09:20', '2024-02-01 09:38:03', '2024-02-01', 'P4220', '24-05794-02-01', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 103.46, 0, '2024-02-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010224-QUDosM3gpjt7H-164', 'a56d6ceb-30cd-43a4-a2fd-9662627ed418', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010224-QUDosM3gpjt7H-164&s=KOL2024&nf=P4220&i=103.46&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4505, 1, 65, 2, 0, NULL, 0, '2024-02-01 09:50:51', '2024-07-17 13:17:16', '2024-02-01', 'P4221', '24-05795-02-01', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010224-QaQoBBbdevJxk-250', '3545dadc-fcc9-491e-94cc-2b7c840611b4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010224-QaQoBBbdevJxk-250&s=KOL2024&nf=P4221&i=206.91&cr=040', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4506, 1, 560, 2, 0, NULL, 0, '2024-02-01 09:53:16', '2024-02-01 09:53:16', '2024-02-01', '', '24-05796-02-01', NULL, 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'balmes 133', 'Barcelona', 'Barcelona', '08008', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0);
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
(4507, 1, 77, 1, 0, NULL, 0, '2024-02-01 11:15:29', '2024-02-01 11:15:54', '2024-02-01', 'P4222', '2024-02-01', '', 0.00, 626.34, 131.53, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 757.87, 0, '2024-02-01 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010224-NH6npi93gBTJC-029', 'bb47b080-68ed-4a67-9488-e797d2098879', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010224-NH6npi93gBTJC-029&s=KOL2024&nf=P4222&i=757.87&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4508, 1, 75, 2, 0, NULL, 0, '2024-02-01 11:52:50', '2024-02-01 12:58:00', '2024-02-01', 'P4223', '24-05798-02-01', 'De martes a viernes de 10 a 19 ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 137.94, 0, '2024-02-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010224-hm8WACKooDUtS-158', '8df96188-0f43-4fd8-8cde-fce02187abcd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010224-hm8WACKooDUtS-158&s=KOL2024&nf=P4223&i=137.94&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4509, 1, 1068, 2, 0, NULL, 0, '2024-02-01 12:37:08', '2024-02-02 09:26:30', '2024-02-01', 'P4224', '24-05799-02-01', 'Estamos abiertos de 15h a 20h', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Kit moto recambios Ba. olabarri 25', 'Galdakao', 'Bizkaia', '48960', 'España', 30.61, 0, '2024-02-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010224-hHbyZNSzzPXe2-220', '12001e9e-ed1c-435e-b378-9c5bc018f3f2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010224-hHbyZNSzzPXe2-220&s=KOL2024&nf=P4224&i=30.61&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4510, 1, 337, 2, 0, NULL, 0, '2024-02-01 17:48:08', '2024-02-02 09:42:44', '2024-02-01', 'P4225', '24-05800-02-01', '', 0.00, 97.68, 20.51, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaida (La)', 'Zaragoza', '50014', 'España', 118.19, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-010224-EYHR/2l9ksMyC-219', '53bdbc93-2958-4f0a-891b-56798f6a9298', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010224-EYHR%2F2l9ksMyC-219&s=KOL2024&nf=P4225&i=118.19&cr=071', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4511, 1, 1152, 2, 0, NULL, 0, '2024-02-02 10:41:43', '2024-02-02 11:53:44', '2024-02-02', 'P4226', '24-05801-02-02', 'Tocar al 4-2 o dejar en la tienda Mándala, junto al portal', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ Jerez Perchet 2, 2°4.', 'Málaga', 'Málaga', '29014', 'España', 30.61, 0, '2024-02-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020224-GJA4VXg8StLm5-227', '8404e7f4-ce9b-44f1-9cfe-1f4c0ba75575', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020224-GJA4VXg8StLm5-227&s=KOL2024&nf=P4226&i=30.61&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4512, 1, 3, 1, 0, NULL, 0, '2024-02-02 12:42:19', '2024-02-02 12:42:36', '2024-02-02', 'P4227', '2024-02-02', '', 0.00, 256.50, 53.86, 0.00, 0, 0.00, 0.00, 'C/ PINTOR AURELIO VIRAFAJARDO Nº2 B', 'VITORIA', 'ÁLAVA', '01008', 'España', 310.36, 0, '2024-02-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020224-Vwg2ph0muH6gC-027', '43498abd-0047-49e1-af4e-c1253bd37872', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020224-Vwg2ph0muH6gC-027&s=KOL2024&nf=P4227&i=310.36&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4513, 1, 3, 4, 0, NULL, 0, '2024-02-02 12:48:38', '2024-02-02 12:48:38', '2024-02-02', '', 'promocion', '', 0.00, 8.14, 1.71, 0.00, 0, 0.00, 0.00, 'C/ PINTOR AURELIO VIRAFAJARDO Nº2 B', 'VITORIA', 'ÁLAVA', '01008', 'España', 9.85, 0, '2024-02-02 00:00:00', '', '', 1, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0);
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
(4514, 1, 3, 1, 1, 'falta un producto', 4512, '2024-02-02 12:51:43', '2024-02-02 12:51:43', '2024-02-02', 'R65', 'P4227 RECT.', '', 0.00, 256.50, 53.86, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 310.36, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-020224-ovBKCq7tZ3ZJg-254', 'db1d6dba-ef8f-4ede-b12b-051dc85d8cba', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020224-ovBKCq7tZ3ZJg-254&s=KOL2024&nf=R65&i=-310.36&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4515, 1, 3, 1, 0, NULL, 0, '2024-02-02 12:56:03', '2024-02-02 12:56:03', '2024-02-02', 'P4228', '2024-02-02', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'C/ PINTOR AURELIO VIRAFAJARDO Nº2 B', 'VITORIA', 'ÁLAVA', '01008', 'España', 379.34, 0, '2024-02-02 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-020224-T6SRAbIJ2Pqy9-047', 'e865e9b1-411e-44b2-a311-94c6be894741', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020224-T6SRAbIJ2Pqy9-047&s=KOL2024&nf=P4228&i=379.34&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4516, 1, 1000, 2, 0, NULL, 0, '2024-02-02 15:58:13', '2024-02-05 09:29:25', '2024-02-02', 'P4229', '24-05802-02-02', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Del Abanico , 6 B', 'Cartagena', 'Murcia', '30330', 'España', 17.50, 0, '2024-02-02 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-020224-EUzvjLpMtn1DB-037', 'f51989ab-916c-4609-91dc-17fcee227df8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020224-EUzvjLpMtn1DB-037&s=KOL2024&nf=P4229&i=17.50&cr=092', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4517, 1, 1153, 2, 0, NULL, 0, '2024-02-04 06:25:40', '2024-02-05 09:29:42', '2024-02-04', 'P4230', '24-05803-02-04', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Aingeru kale 9 trasera (elkarmedia)', 'Azkoitia', 'Gipuzkoa', '20720', 'España', 28.39, 0, '2024-02-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040224-F8MnrewzZ0sZv-159', '9978bf13-db30-415d-8d64-7083674545aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040224-F8MnrewzZ0sZv-159&s=KOL2024&nf=P4230&i=28.39&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4518, 1, 199, 2, 0, NULL, 0, '2024-02-04 16:52:45', '2024-02-05 11:04:27', '2024-02-04', 'P4239', '24-05804-02-04', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Zumaia 17- 3 -C', 'Bilbao', 'Bizkaia', '48007', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-040224-j05HN8RRB5Nv5-018', 'b4ca56c0-e7e6-491f-8d81-d2562398fce3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040224-j05HN8RRB5Nv5-018&s=KOL2024&nf=P4239&i=71.47&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4519, 1, 1154, 2, 0, NULL, 0, '2024-02-04 16:54:14', '2024-02-05 11:01:32', '2024-02-04', '', '24-05805-02-04', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Fueros, 10- 6°dcha ', 'Vitoria-Gasteiz', 'Álava', '01004', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 5, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(4520, 1, 1154, 2, 0, NULL, 0, '2024-02-04 17:00:26', '2024-02-05 09:30:51', '2024-02-04', 'P4231', '24-05806-02-04', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Fueros, 10- 6°dcha ', 'Vitoria-Gasteiz', 'Álava', '01004', 'España', 30.61, 0, '2024-02-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040224-WAX5hvJtKoM7k-011', '7e7d5e03-5a84-400c-9b4c-3ebd14067f7e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040224-WAX5hvJtKoM7k-011&s=KOL2024&nf=P4231&i=30.61&cr=149', '[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
(4521, 1, 520, 2, 0, NULL, 0, '2024-02-04 21:22:18', '2024-02-05 09:31:10', '2024-02-04', 'P4232', '24-05807-02-04', 'Lunes a la tarde y miércoles a la mañana cerrado.', 0.00, 93.64, 19.66, 0.00, 0, 0.00, 0.00, 'Calle Andreszar, 34, ZAR Peluqueria', 'Villava/Atarrabia', 'Navarra', '31610', 'España', 113.30, 0, '2024-02-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040224-D9DN7h2fWSg26-177', '52e758e1-ece2-4f06-872e-9a76b2b14f47', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040224-D9DN7h2fWSg26-177&s=KOL2024&nf=P4232&i=113.30&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4522, 1, 121, 2, 0, NULL, 0, '2024-02-04 22:06:20', '2024-02-05 09:31:30', '2024-02-04', 'P4233', '24-05809-02-04', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 241.40, 0, '2024-02-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040224-VGh5U6+VEHQqB-194', '57fc2f76-20ec-4405-ba69-f1a1d10bf08d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040224-VGh5U6%2BVEHQqB-194&s=KOL2024&nf=P4233&i=241.40&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4523, 1, 1029, 2, 0, NULL, 0, '2024-02-04 22:32:20', '2024-02-05 09:31:57', '2024-02-04', 'P4234', '24-05811-02-04', 'Llamar al 606124585 antes de entregar', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Periodista Quesada Chacon N°2..bloque 3,4°f', 'Córdoba', 'Córdoba', '14005', 'España', 30.61, 0, '2024-02-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040224-G1/L8ZaszYnj0-172', '09be4642-36c3-42a8-bf86-2fdba8be74e3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040224-G1%2FL8ZaszYnj0-172&s=KOL2024&nf=P4234&i=30.61&cr=123', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4524, 1, 1155, 2, 0, NULL, 0, '2024-02-05 07:14:41', '2024-02-05 09:32:11', '2024-02-05', 'P4235', '24-05812-02-05', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Calle Corbera 13, casa ', 'Torrent', 'Valencia', '46900', 'España', 52.39, 0, '2024-02-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-050224-Nw5ucmGFtYZZY-068', '0d80da6f-c850-42d3-8ba4-ad077a7a822b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050224-Nw5ucmGFtYZZY-068&s=KOL2024&nf=P4235&i=52.39&cr=026', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4525, 1, 1156, 2, 0, NULL, 0, '2024-02-05 08:04:29', '2024-02-05 09:32:27', '2024-02-05', 'P4236', '24-05813-02-05', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Playa del Rompido 37', 'Madrid', 'Madrid', '28660', 'España', 30.61, 0, '2024-02-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050224-CW1ysS4gqwDyC-063', 'b2919317-4abf-4451-867d-24ca3d4d7971', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050224-CW1ysS4gqwDyC-063&s=KOL2024&nf=P4236&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),
(4526, 1, 215, 2, 0, NULL, 0, '2024-02-05 08:21:41', '2024-02-05 09:32:54', '2024-02-05', 'P4237', '24-05814-02-05', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 275.88, 0, '2024-02-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050224-g0FvJlcceVsfL-127', '246f9362-c1ae-4e00-95b9-954ef5e0509f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050224-g0FvJlcceVsfL-127&s=KOL2024&nf=P4237&i=275.88&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
