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
(3607, 1, 247, 1, 0, NULL, 0, '2023-08-08 09:10:19', '2023-08-08 09:11:02', '2023-08-08', 'P3387', '', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Calle Marqués de Riestra 14, bajo', 'PONTEVEDRA', 'PONTEVEDRA', '36001', 'ESPAÑA', 379.34, 0, '2023-08-08 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080823-ElbcE9LJG4N+d-175', '1a892fb5-816c-4d3b-bef2-79fcc853ae00', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080823-ElbcE9LJG4N%2Bd-175&s=KOL2023&nf=P3387&i=379.34&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3608, 1, 397, 2, 0, NULL, 0, '2023-08-08 10:00:46', '2023-08-08 12:10:30', '2023-08-08', 'P3388', '23-04800-08-08', 'Por favor,avisad cuando entrega.gracias', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Alberga ...69..1 izda', 'Errenteria', 'Gipuzkoa', '20100', 'España', 30.61, 0, '2023-08-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080823-Zv6EGbJ0Hoim1-067', '38bc0b98-8db9-449c-b7be-2554a98e79b2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080823-Zv6EGbJ0Hoim1-067&s=KOL2023&nf=P3388&i=30.61&cr=122', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3609, 1, 190, 3, 0, NULL, 0, '2023-08-08 12:59:22', '2023-08-08 12:59:22', '2023-08-08', '', '2023-08-08', '', 0.00, 142.50, 29.92, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 172.42, 0, '2023-08-08 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),
(3610, 1, 703, 2, 0, NULL, 0, '2023-08-08 13:46:51', '2023-08-09 09:11:14', '2023-08-08', 'P3389', '23-04801-08-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Oficina de correos Nocedillo 22', 'Lardero', 'La Rioja', '26140', 'España', 17.50, 0, '2023-08-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080823-m2aKOh9FtSuOG-100', '2527d5c3-40d7-4077-a9a9-6aa7a2ec23bd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080823-m2aKOh9FtSuOG-100&s=KOL2023&nf=P3389&i=17.50&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3611, 1, 439, 2, 0, NULL, 0, '2023-08-08 18:17:04', '2023-08-09 09:28:17', '2023-08-08', 'P3390', '23-04803-08-08', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Kukutza 4', 'Laudio/Llodio', 'Álava', '01400', 'España', 43.71, 0, '2023-08-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080823-YJRFhLDqNBuzA-209', 'd437b7d7-4966-43f4-8098-4343f72b5306', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080823-YJRFhLDqNBuzA-209&s=KOL2023&nf=P3390&i=43.71&cr=040', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3612, 1, 910, 2, 0, NULL, 0, '2023-08-09 07:15:59', '2023-08-09 09:30:53', '2023-08-09', 'P3391', '23-04804-08-09', 'De 8a15', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Kristobal Balenciaga,14 bajo', 'Getaria', 'Gipuzkoa', '20808', 'España', 30.61, 0, '2023-08-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090823-NqoC6Mkz5nF6F-068', 'b89724e9-4e62-4de5-bef0-be49784f9a5c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090823-NqoC6Mkz5nF6F-068&s=KOL2023&nf=P3391&i=30.61&cr=035', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3613, 1, 67, 2, 0, NULL, 0, '2023-08-09 07:31:47', '2023-08-09 09:42:12', '2023-08-09', 'P3392', '23-04805-08-09', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090823-PTrP08fYaQf7y-120', '919f09c0-5b93-4cde-bc59-22591b34e55c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090823-PTrP08fYaQf7y-120&s=KOL2023&nf=P3392&i=379.34&cr=148', '[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
(3614, 1, 80, 2, 0, NULL, 0, '2023-08-09 14:03:49', '2023-08-10 09:18:33', '2023-08-09', 'P3393', '23-04806-08-09', '', 0.00, 456.00, 95.76, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 551.76, 0, '2023-08-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090823-DHDlxG02VUeBb-126', '93278d5c-7166-477e-81ac-636234463ee6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090823-DHDlxG02VUeBb-126&s=KOL2023&nf=P3393&i=551.76&cr=175', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3615, 1, 244, 2, 0, NULL, 0, '2023-08-09 15:00:22', '2023-08-10 09:21:32', '2023-08-09', 'P3394', '23-04808-08-09', 'Peluquería Maimar', 0.00, 158.78, 33.34, 0.00, 0, 0.00, 0.00, 'Carrer Balmes 79 Local 3', 'Calella', 'Barcelona', '08370', 'España', 192.12, 0, '2023-08-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090823-ldowRg0eVuj2n-010', '10a6c1d6-594a-4e2e-bb73-c77e0cd3d104', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090823-ldowRg0eVuj2n-010&s=KOL2023&nf=P3394&i=192.12&cr=246', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3616, 1, 215, 2, 0, NULL, 0, '2023-08-09 18:10:31', '2023-08-10 09:23:44', '2023-08-09', 'P3395', '23-04811-08-09', '', 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, '2023-08-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090823-Ccv3WTVIts46m-238', '0e2c9fb1-5e6a-49da-9301-8ec562a4184e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090823-Ccv3WTVIts46m-238&s=KOL2023&nf=P3395&i=275.88&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3617, 1, 911, 2, 0, NULL, 0, '2023-08-09 22:16:12', '2023-08-10 09:28:36', '2023-08-09', 'P3396', '23-04812-08-09', 'Llamar para decir cuando lo entregan.', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/Ugarte, 1 ', 'Salvatierra/Agurain', 'Álava', '01200', 'España', 30.61, 0, '2023-08-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090823-jr6acScCZqAkP-164', '43626ec9-e2eb-4365-a448-36a1506318b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090823-jr6acScCZqAkP-164&s=KOL2023&nf=P3396&i=30.61&cr=040', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3618, 1, 912, 2, 0, NULL, 0, '2023-08-10 06:21:49', '2023-08-10 09:32:13', '2023-08-10', 'P3397', '23-04813-08-10', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Vid 2 Almagro', 'Almagro', 'Ciudad Real', '13270', 'España', 41.50, 0, '2023-08-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100823-ZXqwFHw453ZwC-188', '00dcb232-7848-4302-b13b-4421bc93943d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100823-ZXqwFHw453ZwC-188&s=KOL2023&nf=P3397&i=41.50&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3619, 1, 913, 2, 0, NULL, 0, '2023-08-10 09:20:26', '2023-08-10 11:56:06', '2023-08-10', 'P3398', '23-04814-08-10', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Av. España 34, 2D', 'Hoyos', 'Cáceres', '10850', 'España', 43.71, 0, '2023-08-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100823-joj2yurSCvRl7-190', '968e1384-9176-4c3a-a8e9-70faac27cd3a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100823-joj2yurSCvRl7-190&s=KOL2023&nf=P3398&i=43.71&cr=185', '[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
(3620, 1, 76, 1, 0, NULL, 0, '2023-08-10 12:41:46', '2023-08-10 12:41:46', '2023-08-10', 'P3399', '2023-08-10', '', 0.00, 334.62, 70.27, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 404.89, 0, '2023-08-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100823-kRXWalqQOWPlM-152', '8898cf18-a275-4481-880b-bbfe5e0a6388', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100823-kRXWalqQOWPlM-152&s=KOL2023&nf=P3399&i=404.89&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3621, 1, 914, 2, 0, NULL, 0, '2023-08-10 11:02:26', '2023-08-10 13:11:59', '2023-08-10', 'P3400', '23-04815-08-10', 'Llamar antes', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Orden De Santiago, 34', 'Mérida', 'Badajoz', '06800', 'España', 30.61, 0, '2023-08-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100823-M8a2VoBSH2nZi-113', 'c60d3c16-8b99-46d9-9921-52b6fcabbb60', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100823-M8a2VoBSH2nZi-113&s=KOL2023&nf=P3400&i=30.61&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3622, 1, 915, 2, 0, NULL, 0, '2023-08-10 11:11:16', '2023-08-10 13:12:30', '2023-08-10', 'P3401', '23-04816-08-10', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Nube de Magallanes, 61', 'Valladolid', 'Valladolid', '47011', 'España', 28.39, 0, '2023-08-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100823-eRrwGzaTrmC9J-178', '26daa7ae-8078-421a-96e0-a0edf411b093', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100823-eRrwGzaTrmC9J-178&s=KOL2023&nf=P3401&i=28.39&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3623, 1, 10, 2, 0, NULL, 0, '2023-08-10 15:43:27', '2023-08-11 09:13:09', '2023-08-10', 'P3402', '23-04817-08-10', '', 0.00, 118.06, 24.79, 0.00, 0, 0.00, 0.00, 'Agirre auzunea 1 behea', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 142.85, 0, '2023-08-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100823-CdbD8aPVYzORs-030', 'c8398b5f-f033-4b93-8b50-6f9551f90582', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100823-CdbD8aPVYzORs-030&s=KOL2023&nf=P3402&i=142.85&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3624, 1, 916, 2, 0, NULL, 0, '2023-08-11 06:13:49', '2023-08-11 09:18:03', '2023-08-11', 'P3403', '23-04818-08-11', 'Entregar por las mañanas, por favor', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Plaza Kontxa Etxeberria, 9, piso 5 D', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 17.50, 0, '2023-08-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110823-nhN48EzjF9ibb-004', 'f3876109-4b83-46d9-8141-ac8e46ff6a31', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110823-nhN48EzjF9ibb-004&s=KOL2023&nf=P3403&i=17.50&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3625, 1, 696, 1, 0, NULL, 0, '2023-08-11 09:43:48', '2023-08-11 09:43:48', '2023-08-11', 'P3404', '2023-08-11', '', 0.00, 291.72, 61.26, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 352.98, 0, '2023-08-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-110823-b01T987QcINrI-246', '8f737ff1-3083-4921-abd1-90e808f4c586', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110823-b01T987QcINrI-246&s=KOL2023&nf=P3404&i=352.98&cr=135', '[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
(3626, 1, 57, 2, 0, NULL, 0, '2023-08-11 07:52:12', '2023-08-11 09:53:35', '2023-08-11', 'P3405', '23-04819-08-11', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 275.88, 0, '2023-08-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110823-ITUF+xq+i434u-141', '3119e704-8792-4c50-beb1-179400d11134', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110823-ITUF%2Bxq%2Bi434u-141&s=KOL2023&nf=P3405&i=275.88&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3627, 1, 917, 2, 0, NULL, 0, '2023-08-11 12:32:41', '2023-08-14 08:59:11', '2023-08-11', 'P3406', '23-04820-08-11', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'calle Irunlarrea, 18 4B', 'Pamplona/Iruña', 'Navarra', '31008', 'España', 30.61, 0, '2023-08-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110823-HNtRJJfzlUijI-157', 'e628ed76-80f8-48df-9b0e-387c28502999', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110823-HNtRJJfzlUijI-157&s=KOL2023&nf=P3406&i=30.61&cr=064', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3628, 1, 391, 2, 0, NULL, 0, '2023-08-11 14:58:04', '2023-08-14 09:02:44', '2023-08-11', 'P3407', '23-04822-08-11', 'Hola,hay un paquete de precolor de una clienta pendiente de recoger(Nerea)', 0.00, 16.28, 4.18, 0.00, 0, 0.00, 4.40, 'Calle divina pastora 13 bajo', 'Ansoáin', 'Navarra', '31013', 'España', 24.10, 0, '2023-08-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-110823-dztBdNASHVikv-244', 'e11ce45f-78a6-4651-bf1d-270866cd5af2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110823-dztBdNASHVikv-244&s=KOL2023&nf=P3407&i=24.10&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3629, 1, 97, 2, 0, NULL, 0, '2023-08-12 07:42:15', '2023-08-14 09:06:34', '2023-08-12', 'P3408', '23-04823-08-12', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Bidasoa 8, Bajo Bera', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 103.46, 0, '2023-08-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120823-CLuJU2vdSquTE-180', 'ffe1e38b-6ba1-406d-b1bf-cfb9dfc0c8ae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120823-CLuJU2vdSquTE-180&s=KOL2023&nf=P3408&i=103.46&cr=202', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3630, 1, 164, 2, 0, NULL, 0, '2023-08-12 11:17:22', '2023-08-14 09:09:20', '2023-08-12', 'P3409', '23-04824-08-12', 'Hola!! El lunes tenemos cerrado', 0.00, 366.42, 76.95, 0.00, 0, 0.00, 0.00, 'Rambla la Girada 93 local2', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 443.37, 0, '2023-08-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120823-mxvoG/tHfW4V5-229', '3ce24ff2-d417-4c52-a55b-4b0a74d6c74f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120823-mxvoG%2FtHfW4V5-229&s=KOL2023&nf=P3409&i=443.37&cr=182', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3631, 1, 813, 2, 0, NULL, 0, '2023-08-13 17:35:11', '2023-08-14 09:13:19', '2023-08-13', 'P3410', '23-04826-08-13', 'Si no estamos en casa, tirar el paquete por encima de la verja de la puerta (es una casa, no un piso/.', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Antzalde, 12B', 'Lazkao', 'Gipuzkoa', '20210', 'España', 30.61, 0, '2023-08-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130823-dZgeERf9/p0b1-107', '4ed92172-a7bf-4a0b-99f1-2190a198a573', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130823-dZgeERf9%2Fp0b1-107&s=KOL2023&nf=P3410&i=30.61&cr=072', '[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
(3632, 1, 389, 2, 0, NULL, 0, '2023-08-13 18:05:27', '2023-08-14 09:16:37', '2023-08-13', 'P3411', '23-04827-08-13', 'Saludos a Oihana ', 0.00, 52.32, 10.99, 0.00, 0, 0.00, 0.00, 'Casa rural Os Lambrans - aldea de Lamas ', 'Padrón', 'A Coruña', '15910', 'España', 63.31, 0, '2023-08-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130823-cZwlttYsFjzr2-199', 'fb5fa775-34b0-4545-adb3-76d4e008ba4b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130823-cZwlttYsFjzr2-199&s=KOL2023&nf=P3411&i=63.31&cr=129', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3633, 1, 394, 2, 0, NULL, 0, '2023-08-14 10:14:26', '2023-08-14 12:19:49', '2023-08-14', 'P3412', '23-04828-08-14', 'Entrar por la segunda entrada del pueblo, por el parque. ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Barrio alto, 17', 'Molvízar', 'Granada', '18611', 'España', 30.61, 0, '2023-08-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140823-MK2cFOCZnH9k5-231', '18ae2eab-d2d1-4fb8-9339-dcf106f22328', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140823-MK2cFOCZnH9k5-231&s=KOL2023&nf=P3412&i=30.61&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3634, 1, 918, 2, 0, NULL, 0, '2023-08-14 16:56:53', '2023-08-16 09:36:23', '2023-08-14', 'P3413', '23-04829-08-14', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'General freire, 11', 'Irun', 'Gipuzkoa', '20303', 'España', 41.50, 0, '2023-08-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140823-dfkF1ygNoVuPb-057', '3f6fc17f-a036-4035-8ad9-d5cd8d6ee5dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140823-dfkF1ygNoVuPb-057&s=KOL2023&nf=P3413&i=41.50&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3635, 1, 919, 2, 0, NULL, 0, '2023-08-14 20:55:05', '2023-08-16 09:39:57', '2023-08-14', 'P3414', '23-04830-08-14', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Celorio - Pensión Mariaje', 'Llanes', 'Asturias', '33595', 'España', 41.50, 0, '2023-08-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140823-KjH0M4wBRK44R-019', '9d314043-1d54-421a-8f0c-af4c84d47b30', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140823-KjH0M4wBRK44R-019&s=KOL2023&nf=P3414&i=41.50&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3636, 1, 920, 2, 0, NULL, 0, '2023-08-15 11:57:27', '2023-08-30 10:54:46', '2023-08-15', 'P3417', '23-04853-08-15', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle Rafaël Alberti 37 A', 'Riogordo', 'Málaga', '29180', 'España', 56.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150823-GJ83m83ekyxC0-144', 'c6c9d70c-5fe5-435d-b5e3-6572309f1b35', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150823-GJ83m83ekyxC0-144&s=KOL2023&nf=P3417&i=56.82&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3637, 1, 857, 2, 0, NULL, 0, '2023-08-15 16:10:54', '2023-08-16 09:50:40', '2023-08-15', 'P3415', '23-04854-08-15', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'C/ Lince 175', 'Almonte', 'Huelva', '21750', 'España', 61.09, 0, '2023-08-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150823-i954OVFokQaNu-215', '717bb5f2-e88a-4f19-a1d8-66f4b160d255', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150823-i954OVFokQaNu-215&s=KOL2023&nf=P3415&i=61.09&cr=191', '[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
(3638, 1, 337, 2, 0, NULL, 0, '2023-08-15 17:06:04', '2023-08-16 09:57:07', '2023-08-15', 'P3418', '23-04855-08-15', '', 0.00, 56.98, 11.97, 0.00, 0, 0.00, 0.00, '????  A VECINAL (Coopolis S.C.) ???? C/ Santiago Lapuente, 5 (mapa) ???? 50014 Zaragoza', 'Zaragoza', 'Zaragoza', '50014', 'España', 68.95, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150823-WcwoyrZDjgPNl-192', 'b392f5fc-95a7-458c-aef0-445c5a39a9c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150823-WcwoyrZDjgPNl-192&s=KOL2023&nf=P3418&i=68.95&cr=066', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3639, 1, 398, 2, 0, NULL, 0, '2023-08-15 19:05:04', '2023-08-16 10:09:26', '2023-08-15', 'P3416', '23-04856-08-15', 'Entregar envío por las tardes.', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paseo De La Verneda 111/3/3', 'Barcelona', 'Barcelona', '08020', 'España', 30.61, 0, '2023-08-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150823-hj7jMAcMITfW4-011', 'b17fb8d9-acfd-454f-9cc2-87e1c3bf6f96', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150823-hj7jMAcMITfW4-011&s=KOL2023&nf=P3416&i=30.61&cr=045', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3640, 1, 921, 2, 0, NULL, 0, '2023-08-15 19:56:40', '2023-08-16 10:11:37', '2023-08-15', 'P3419', '23-04857-08-15', '', 0.00, 86.64, 18.20, 0.00, 0, 0.00, 0.00, 'Axular Ibiltokia 8-2A', 'Zumaia', 'Gipuzkoa', '20750', 'España', 104.83, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150823-DdDXaUBAiJA0a-010', '5fee530a-0a09-45b5-9396-9136eb810bb8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150823-DdDXaUBAiJA0a-010&s=KOL2023&nf=P3419&i=104.83&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3641, 1, 922, 2, 0, NULL, 0, '2023-08-15 22:18:27', '2023-08-15 22:18:27', '2023-08-15', '', '23-04858-08-15', NULL, 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Oihana kalea 32, 1 A', 'Huarte/Uharte', 'Navarra', '31620', 'España', 30.61, 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),
(3642, 1, 922, 2, 0, NULL, 0, '2023-08-15 22:19:00', '2023-08-15 22:19:00', '2023-08-15', '', '23-04859-08-15', NULL, 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Oihana kalea 32, 1 A', 'Huarte/Uharte', 'Navarra', '31620', 'España', 30.61, 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),
(3643, 1, 922, 2, 0, NULL, 0, '2023-08-15 22:19:30', '2023-08-17 08:52:00', '2023-08-15', 'P3425', '23-04860-08-15', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Oihana kalea 32, 1 A', 'Huarte/Uharte', 'Navarra', '31620', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150823-X4gid/m8s/5zL-046', 'f2826a72-c5d4-48b1-aa41-ba7f6684ad89', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150823-X4gid%2Fm8s%2F5zL-046&s=KOL2023&nf=P3425&i=30.61&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3644, 1, 239, 1, 0, NULL, 0, '2023-08-16 12:39:00', '2023-08-16 12:39:00', '2023-08-16', 'P3420', '2023-08-16', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, '', '', '', '0', '', 68.97, 0, '2023-08-16 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-160823-YSuL+RSkfDztq-083', '6dca279f-80ad-4be2-8725-6e5bbc9e6f3b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160823-YSuL%2BRSkfDztq-083&s=KOL2023&nf=P3420&i=68.97&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3645, 1, 174, 2, 0, NULL, 0, '2023-08-16 15:55:50', '2023-08-17 08:55:24', '2023-08-16', 'P3421', '23-04862-08-16', 'servir el pedido lo antes posible.\r\nGracias', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 310.37, 0, '2023-08-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160823-S9UFNp3dbf0lm-039', '1f218929-51f7-4247-b32e-24c30b17a6ec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160823-S9UFNp3dbf0lm-039&s=KOL2023&nf=P3421&i=310.37&cr=211', '[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
(3646, 1, 923, 2, 0, NULL, 0, '2023-08-16 16:32:13', '2023-08-17 08:57:04', '2023-08-16', 'P3422', '23-04863-08-16', 'Sí no estoy en casa dejar el producto en la puerta.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Mintegi Kalea 1A, 3A', 'Zarautz', 'Gipuzkoa', '20800', 'España', 17.50, 0, '2023-08-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160823-c8WSGr7srenle-228', '054d5b33-3af6-4119-8c3a-e11f58f46e27', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160823-c8WSGr7srenle-228&s=KOL2023&nf=P3422&i=17.50&cr=225', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3647, 1, 924, 2, 0, NULL, 0, '2023-08-16 16:51:16', '2023-08-17 08:59:19', '2023-08-16', 'P3423', '23-04865-08-16', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Pelegrin de Uranzu n° 11 , 2° izqda.', 'Irun', 'Gipuzkoa', '20304', 'España', 30.61, 0, '2023-08-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-160823-JQo65nHLp8a7z-187', '116e05da-74dc-48f7-a798-e5b51a95fe70', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160823-JQo65nHLp8a7z-187&s=KOL2023&nf=P3423&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),
(3648, 1, 925, 2, 0, NULL, 0, '2023-08-16 18:47:38', '2023-08-17 09:02:23', '2023-08-16', 'P3424', '2023-08-16', '', 0.00, 142.50, 29.93, 0.00, 1, 7.41, 0.00, 'Perú número 16 Bloq 2 Bajo DCH', 'Alicante/Alacant', 'Alicante', '03008', 'España', 179.84, 0, '2023-08-16 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-160823-iurw4rAksW/YQ-144', '0f7eed7f-acd6-460f-9afd-022ca4a79c12', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-160823-iurw4rAksW%2FYQ-144&s=KOL2023&nf=P3424&i=179.84&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3649, 1, 926, 2, 0, NULL, 0, '2023-08-17 08:36:43', '2023-08-17 11:07:14', '2023-08-17', 'P3426', '2023-08-17', 'Tocar timbre de la puerta ya que es una sala que está cerrada', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Hospital clinic (escalera 11,4a planta,psiqui infantil)', 'Barcelona', 'Barcelona', '08036', 'España', 30.61, 0, '2023-08-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170823-d3Aexyqktsm60-093', 'ff07582a-5771-494f-ae3a-79c6b0b100bf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170823-d3Aexyqktsm60-093&s=KOL2023&nf=P3426&i=30.61&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3650, 1, 221, 2, 0, NULL, 0, '2023-08-17 10:46:39', '2023-08-17 12:48:07', '2023-08-17', 'P3427', '23-04868-08-17', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 103.46, 0, '2023-08-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170823-FTlEwpwWJjpX+-184', '86f28384-a8f2-4f2f-8dab-e212be3576fa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170823-FTlEwpwWJjpX%2B-184&s=KOL2023&nf=P3427&i=103.46&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3651, 1, 262, 2, 0, NULL, 0, '2023-08-17 11:10:35', '2023-08-17 13:12:27', '2023-08-17', 'P3428', '23-04869-08-17', 'Lunes Cerrado', 0.00, 105.84, 22.23, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 128.07, 0, '2023-08-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170823-mZvAM7OjYrilq-029', '48e81b77-874b-476b-8fa3-2e7785dc8f88', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170823-mZvAM7OjYrilq-029&s=KOL2023&nf=P3428&i=128.07&cr=190', '[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
(3652, 1, 681, 2, 0, NULL, 0, '2023-08-17 19:58:47', '2023-08-18 09:19:56', '2023-08-17', 'P3429', '23-04870-08-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Juan María Guelbenzu 48, 1ro izda', 'Pamplona/Iruña', 'Navarra', '31005', 'España', 17.50, 0, '2023-08-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-170823-KWY9aIK6oZv9a-253', '6d520c06-cbc1-41cc-b5c2-2685e88aff11', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170823-KWY9aIK6oZv9a-253&s=KOL2023&nf=P3429&i=17.50&cr=039', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3653, 1, 927, 2, 0, NULL, 0, '2023-08-17 21:36:25', '2023-08-18 09:23:59', '2023-08-17', 'P3430', '23-04871-08-17', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Toledo,25', 'Villaviciosa de Odón', 'Madrid', '28670', 'España', 17.50, 0, '2023-08-17 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-170823-JsP636NkJhK4a-242', 'cb1f5a1f-4cf7-4ccd-9e48-26bb0a35e90a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-170823-JsP636NkJhK4a-242&s=KOL2023&nf=P3430&i=17.50&cr=117', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3654, 1, 460, 2, 0, NULL, 0, '2023-08-18 09:23:53', '2023-08-18 11:25:27', '2023-08-18', 'P3431', '23-04874-08-18', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Avda Ategorrieta 23 1°izda', 'Donostia-San Sebasti', 'Gipuzkoa', '20013', 'España', 65.52, 0, '2023-08-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180823-QkSGH1+Q9pvAo-201', '6f188991-fa57-4c11-a9fc-7504fa90a034', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180823-QkSGH1%2BQ9pvAo-201&s=KOL2023&nf=P3431&i=65.52&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3655, 1, 544, 2, 0, NULL, 0, '2023-08-18 11:08:11', '2023-08-21 09:11:28', '2023-08-18', 'P3432', '23-04875-08-18', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'calle vista alegre Nº2 6ºA', 'Zaragoza', 'Zaragoza', '50007 ', 'España', 30.61, 0, '2023-08-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180823-lt/wwJlg/ON2s-146', '89d02851-2ab1-46c1-a7b2-b91620ad7d11', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180823-lt%2FwwJlg%2FON2s-146&s=KOL2023&nf=P3432&i=30.61&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3656, 1, 306, 2, 0, NULL, 0, '2023-08-18 14:55:29', '2023-08-21 09:13:23', '2023-08-18', 'P3433', '23-04876-08-18', 'horario: de lunes a viernes de 9:00h a 18:30h y sabados de 8:30 a 13:30h .', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'carrer puigmolto,9', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 206.91, 0, '2023-08-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180823-g5hsAc5Gcei7s-223', '82a7fa0f-60a1-4441-8186-758fd8517ed9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180823-g5hsAc5Gcei7s-223&s=KOL2023&nf=P3433&i=206.91&cr=166', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3657, 1, 928, 2, 0, NULL, 0, '2023-08-18 16:37:12', '2023-08-21 09:15:09', '2023-08-18', 'P3434', '23-04877-08-18', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'donestebe plaza 12 bajo. Kutxabank', 'Oiartzun', 'Gipuzkoa', '20170', 'España', 30.61, 0, '2023-08-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180823-lM2pFEAtXPYJ1-069', '64ea00fb-e032-4f79-80c6-c555095e707b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180823-lM2pFEAtXPYJ1-069&s=KOL2023&nf=P3434&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);
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
(3658, 1, 929, 2, 0, NULL, 0, '2023-08-19 09:13:45', '2023-08-21 09:17:52', '2023-08-19', 'P3435', '23-04878-08-19', 'Si no estoy en casa dejar en el jardín ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Luberrietaondo 56B', 'Gatika', 'Bizkaia', '48110', 'España', 17.50, 0, '2023-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190823-Ujx6kWb9aXjp8-212', 'ddc3f356-d71a-439d-a5be-e859c6cd6457', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190823-Ujx6kWb9aXjp8-212&s=KOL2023&nf=P3435&i=17.50&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3659, 1, 930, 2, 0, NULL, 0, '2023-08-19 09:25:41', '2023-08-21 09:24:19', '2023-08-19', 'P3436', '23-04879-08-19', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'C/O Recreo, 38, 2', 'Ordes', 'A Coruña', '15680', 'España', 56.82, 0, '2023-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190823-m7Q7sdo1H+6Ff-098', '5561892e-5de1-4136-a939-91fd9e6c7be3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190823-m7Q7sdo1H%2B6Ff-098&s=KOL2023&nf=P3436&i=56.82&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3660, 1, 258, 2, 0, NULL, 0, '2023-08-19 10:56:31', '2023-08-21 09:27:52', '2023-08-19', 'P3437', '23-04880-08-19', '', 0.00, 79.32, 16.66, 0.00, 0, 0.00, 0.00, 'calle Maria Zambrano, 14', 'Viladecans', 'Barcelona', '08840', 'España', 95.98, 0, '2023-08-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190823-hcO6GDxA3J9ai-052', '295f1924-b805-4214-b434-1b9888d74105', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190823-hcO6GDxA3J9ai-052&s=KOL2023&nf=P3437&i=95.98&cr=146', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3661, 1, 731, 2, 0, NULL, 0, '2023-08-19 20:55:19', '2023-08-21 09:30:29', '2023-08-19', 'P3438', '23-04881-08-19', 'Entregar en oficina correos', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'CALLE NAGUSIA, 3 (CITYPAQ)', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 17.50, 0, '2023-08-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190823-Kp9ebDTXOMY8J-226', '218114b8-8a6b-40e0-a5e9-7166595e60d8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190823-Kp9ebDTXOMY8J-226&s=KOL2023&nf=P3438&i=17.50&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3662, 1, 538, 2, 0, NULL, 0, '2023-08-21 07:15:34', '2023-08-21 09:36:08', '2023-08-21', 'P3439', '23-04882-08-21', '', 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, '2023-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210823-nzr7pWd4VDDrw-140', 'c80395e3-cb9a-4eab-8d66-63a7839ffeb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210823-nzr7pWd4VDDrw-140&s=KOL2023&nf=P3439&i=43.71&cr=110', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3663, 1, 635, 2, 0, NULL, 0, '2023-08-21 10:29:57', '2023-08-21 12:32:06', '2023-08-21', 'P3440', '23-04883-08-21', 'SI EL LOCAL ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703 (ESTOY AL LADO). GRACIAS.', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 275.88, 0, '2023-08-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210823-eS+kkAStDhk9r-039', '422b790f-867b-49b9-9896-e8361558bc60', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210823-eS%2BkkAStDhk9r-039&s=KOL2023&nf=P3440&i=275.88&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
