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
(3378, 1, 849, 2, 0, NULL, 0, '2023-06-19 15:31:54', '2023-06-20 09:27:24', '2023-06-19', 'P3178', '23-04529-06-19', '', 0.00, 9.83, 3.26, 0.00, 0, 0.00, 6.90, 'Lluis Companys número  22 1-2 ', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 18.79, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-190623-K+xBGXXGgXx+1-234', 'a388b57a-6559-4997-bb35-e95422af285d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190623-K%2BxBGXXGgXx%2B1-234&s=KOL2023&nf=P3178&i=18.79&cr=044', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3379, 1, 616, 2, 0, NULL, 0, '2023-06-19 17:04:32', '2023-06-20 09:31:08', '2023-06-19', 'P3174', '23-04530-06-19', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle de la Cadena 31, 1º IZQ', 'Zaragoza', 'Zaragoza', '50001', 'España', 16.29, 0, '2023-06-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-190623-kDcOxyvVaanYB-244', '68da613e-b0ea-4a0f-8a0c-b2eae03e7435', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190623-kDcOxyvVaanYB-244&s=KOL2023&nf=P3174&i=16.29&cr=037', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3380, 1, 520, 2, 0, NULL, 0, '2023-06-20 05:35:57', '2023-06-20 09:35:18', '2023-06-20', 'P3175', '23-04531-06-20', '', 0.00, 128.80, 27.05, 0.00, 0, 0.00, 0.00, 'Calle Andreszar, 34 bajo', 'Villava/Atarrabia', 'Navarra', '31610', 'España', 155.85, 0, '2023-06-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200623-fW+4MNC8/8yTd-244', '18b8c8bf-c8b6-4bb2-9ea6-5c3365a8bbe2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200623-fW%2B4MNC8%2F8yTd-244&s=KOL2023&nf=P3175&i=155.85&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3381, 1, 850, 2, 0, NULL, 0, '2023-06-20 09:16:20', '2023-06-20 11:33:51', '2023-06-20', 'P3179', '23-04532-06-20', 'Clínica Dental G&H Odontólogos', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Nou de Octubre 1', 'Altea', 'Alicante', '03530', 'España', 16.29, 0, '2023-06-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200623-jPdmXdYjR6T1b-238', '8bd7dec0-059c-4651-909f-be9ccd0dbe05', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200623-jPdmXdYjR6T1b-238&s=KOL2023&nf=P3179&i=16.29&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3382, 1, 333, 2, 0, NULL, 0, '2023-06-20 10:36:42', '2023-06-20 13:05:12', '2023-06-20', 'P3180', '23-04533-06-20', '', 0.00, 36.36, 8.40, 0.00, 0, 0.00, 4.40, 'Laxosa 2 Gurgueiro ', 'Agolada', 'Pontevedra', '36520', 'España', 48.40, 0, '2023-06-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200623-nB+m11mBVk3mt-001', '69e96e88-c2d8-4a84-8916-a822cecda997', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200623-nB%2Bm11mBVk3mt-001&s=KOL2023&nf=P3180&i=48.40&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3383, 1, 851, 2, 0, NULL, 0, '2023-06-20 14:45:26', '2023-06-21 08:32:37', '2023-06-20', 'P3181', '23-04534-06-20', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'C/ Manuel Jose Garcia Caparros 2-2B', 'Vélez-Málaga', 'Málaga', '29700', 'España', 28.19, 0, '2023-06-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200623-KZdm7FImiNCu2-182', 'f63cb7e7-5082-4915-ab5e-a9ef3e09be27', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200623-KZdm7FImiNCu2-182&s=KOL2023&nf=P3181&i=28.19&cr=246', '[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
(3384, 1, 852, 2, 0, NULL, 0, '2023-06-21 05:37:22', '2023-06-21 08:35:13', '2023-06-21', 'P3182', '23-04535-06-21', 'Clínica Dental Bastida', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Avenida Hispanidad, 96', 'Vigo', 'Pontevedra', '36203', 'España', 16.29, 0, '2023-06-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210623-UnU0664KzNY+3-058', '63097daa-7828-4333-ad2f-7d8e568e4a74', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210623-UnU0664KzNY%2B3-058&s=KOL2023&nf=P3182&i=16.29&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3385, 1, 491, 2, 0, NULL, 0, '2023-06-21 08:13:22', '2023-06-21 10:22:58', '2023-06-21', 'P3183', '23-04536-06-21', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'PORTUA 30 (PESCADOS OLIVERI)', 'Getaria', 'Gipuzkoa', '20808', 'España', 16.29, 0, '2023-06-21 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210623-efJWut/bKLjZI-063', 'a2b7b50a-01c4-43cc-8bba-8439d8bb7fdb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210623-efJWut%2FbKLjZI-063&s=KOL2023&nf=P3183&i=16.29&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3386, 1, 223, 2, 0, NULL, 0, '2023-06-21 11:47:41', '2023-06-22 09:26:44', '2023-06-21', 'P3187', '23-04537-06-21', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'c/damas apostolicas,8 -bajo D.  A Ramallosa', 'Nigrán', 'Pontevedra', '36370', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210623-hcWgtdzKHWomE-211', 'f6070eb4-a857-4321-b875-8cc4e9b195d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210623-hcWgtdzKHWomE-211&s=KOL2023&nf=P3187&i=137.94&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3387, 1, 468, 2, 0, NULL, 0, '2023-06-21 11:53:49', '2023-06-22 09:11:56', '2023-06-21', 'P3186', '23-04538-06-21', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Rof carballo 1 peluqueria', 'Lugo', 'Lugo', '27002', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210623-OGS47Cu3A1+9G-002', 'e61354af-fe24-4c3d-bc4c-9d463b73401e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210623-OGS47Cu3A1%2B9G-002&s=KOL2023&nf=P3186&i=172.43&cr=023', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3388, 1, 802, 2, 0, NULL, 0, '2023-06-21 18:08:36', '2023-06-22 09:12:52', '2023-06-21', 'P3184', '23-04540-06-21', 'se puede entregar en la puerta A si no hay nadie en casa.\r\ngracias', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Calle/ Poeta Blas de Otero, nº 14, piso:3ºB', 'Madrid', 'Madrid', '28017', 'España', 28.19, 0, '2023-06-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210623-MoxC+JMoi8OkH-180', '3cf29d49-e3bf-4391-90c3-8d3d2e93766b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210623-MoxC%2BJMoi8OkH-180&s=KOL2023&nf=P3184&i=28.19&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3389, 1, 803, 2, 0, NULL, 0, '2023-06-21 20:19:20', '2023-06-22 09:17:59', '2023-06-21', 'P3185', '23-04541-06-21', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Calle Piscis 17-23, 2C ', 'Zaragoza', 'Zaragoza', '50012', 'España', 28.19, 0, '2023-06-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210623-Jc5saX5wgMm0D-128', '2f37d9a3-97c8-44c1-8d0e-3b4ad1cc72dc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210623-Jc5saX5wgMm0D-128&s=KOL2023&nf=P3185&i=28.19&cr=055', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3390, 1, 853, 2, 0, NULL, 0, '2023-06-22 10:04:17', '2023-06-22 10:04:17', '2023-06-22', '', '23-04542-06-22', NULL, 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'DARIO DE REGOYOS, 19-BAJO (MAFER)', 'Irun', 'Gipuzkoa', '20301', 'España', 28.19, 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),
(3391, 1, 190, 3, 0, NULL, 0, '2023-06-22 12:13:32', '2023-06-22 12:13:32', '2023-06-22', '', 'consumo interno pelu', '', 0.00, 200.60, 42.13, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 242.73, 0, '2023-06-22 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);
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
(3392, 1, 4, 2, 0, NULL, 0, '2023-06-22 11:11:03', '2023-06-22 13:22:55', '2023-06-22', 'P3188', '23-04543-06-22', '', 0.00, 329.40, 69.17, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 398.57, 0, '2023-06-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220623-nK79p9sP4pzeQ-032', 'c63ffba2-d437-41f5-8d16-71fe0a954c20', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220623-nK79p9sP4pzeQ-032&s=KOL2023&nf=P3188&i=398.57&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3393, 1, 28, 2, 0, NULL, 0, '2023-06-22 12:41:40', '2023-06-22 12:41:40', '2023-06-22', '', '23-04544-06-22', NULL, 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', '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),
(3394, 1, 28, 2, 0, NULL, 0, '2023-06-22 12:41:43', '2023-06-22 12:41:43', '2023-06-22', '', '23-04545-06-22', NULL, 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', '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),
(3395, 1, 28, 2, 0, NULL, 0, '2023-06-22 12:41:45', '2023-06-23 09:24:12', '2023-06-22', 'P3191', '23-04546-06-22', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220623-MG8MsvfzOu26R-205', '43124382-dc32-4caf-9d8f-8afe566738c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220623-MG8MsvfzOu26R-205&s=KOL2023&nf=P3191&i=206.91&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3396, 1, 854, 2, 0, NULL, 0, '2023-06-22 13:34:17', '2023-06-23 09:28:43', '2023-06-22', 'P3189', '23-04547-06-22', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Trañabarren n11 5A', 'Abadiño', 'Bizkaia', '48220', 'España', 28.19, 0, '2023-06-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220623-iO2BLmjONGs+H-021', 'a0916934-cc91-4387-bbf1-e11e07944438', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220623-iO2BLmjONGs%2BH-021&s=KOL2023&nf=P3189&i=28.19&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3397, 1, 407, 2, 0, NULL, 0, '2023-06-22 14:47:05', '2023-06-23 09:33:11', '2023-06-22', 'P3190', '23-04548-06-22', 'Kaixo !!!\r\nSe me puede mandar el cartel de Koloreko si es posible para poner en el local.\r\nEskerrik asko \r\nMaddisormena8 ', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle fuentarrabia n2 ', 'Irun', 'Gipuzkoa', '20301', 'España', 172.43, 0, '2023-06-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-220623-RLZXly9/G+jnq-182', 'a7621470-f634-414f-9453-0bf43f9f2cec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220623-RLZXly9%2FG%2Bjnq-182&s=KOL2023&nf=P3190&i=172.43&cr=224', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3398, 1, 40, 2, 0, NULL, 0, '2023-06-23 08:01:40', '2023-06-23 10:03:33', '2023-06-23', 'P3192', '23-04556-06-23', 'martes cerrado y lunes por la mañana tambien ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 137.94, 0, '2023-06-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230623-PmrWATW1D+Rwd-069', 'a5d363de-383d-4872-8f48-957f170a2608', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230623-PmrWATW1D%2BRwd-069&s=KOL2023&nf=P3192&i=137.94&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3399, 1, 127, 2, 0, NULL, 0, '2023-06-23 11:27:01', '2023-06-26 08:57:13', '2023-06-23', 'P3193', '23-04557-06-23', '', 0.00, 71.80, 15.08, 0.00, 0, 0.00, 0.00, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 86.88, 0, '2023-06-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230623-PVgDoAUpwNfe6-114', 'd20217bd-6530-40aa-be09-4f4c15b0af46', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230623-PVgDoAUpwNfe6-114&s=KOL2023&nf=P3193&i=86.88&cr=091', '[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
(3400, 1, 693, 2, 0, NULL, 0, '2023-06-23 11:29:57', '2023-06-26 08:59:14', '2023-06-23', 'P3194', '23-04558-06-23', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, '​Gran Vía 45, 3ª planta (SRB)', 'Bilbao', 'Bizkaia', '48011', 'España', 16.29, 0, '2023-06-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-230623-mk56BAQAhyzEN-028', 'ec52df43-60a0-4baa-8645-061643cf75aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-230623-mk56BAQAhyzEN-028&s=KOL2023&nf=P3194&i=16.29&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3401, 1, 111, 2, 0, NULL, 0, '2023-06-24 09:08:00', '2023-06-26 09:02:06', '2023-06-24', 'P3198', '23-04562-06-24', '', 0.00, 107.70, 22.62, 0.00, 0, 0.00, 0.00, 'c/ Loza, nº1 piso 7b', 'Ansoáin', 'Navarra', '31013', 'España', 130.32, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-240623-HiBFNTXrEfKja-024', 'fa29164a-15ca-4c67-958b-cf0d95a01d94', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240623-HiBFNTXrEfKja-024&s=KOL2023&nf=P3198&i=130.32&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3402, 1, 111, 2, 0, NULL, 0, '2023-06-24 09:08:05', '2023-06-24 09:08:05', '2023-06-24', '', '23-04563-06-24', NULL, 0.00, 107.70, 22.62, 0.00, 0, 0.00, 0.00, 'c/ Loza, nº1 piso 7b', 'Ansoáin', 'Navarra', '31013', 'España', 130.32, 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),
(3403, 1, 111, 2, 0, NULL, 0, '2023-06-24 09:08:11', '2023-06-24 09:08:11', '2023-06-24', '', '23-04564-06-24', NULL, 0.00, 107.70, 22.62, 0.00, 0, 0.00, 0.00, 'c/ Loza, nº1 piso 7b', 'Ansoáin', 'Navarra', '31013', 'España', 130.32, 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),
(3404, 1, 111, 2, 0, NULL, 0, '2023-06-24 09:08:17', '2023-06-24 09:08:17', '2023-06-24', '', '23-04565-06-24', NULL, 0.00, 107.70, 22.62, 0.00, 0, 0.00, 0.00, 'c/ Loza, nº1 piso 7b', 'Ansoáin', 'Navarra', '31013', 'España', 130.32, 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),
(3405, 1, 855, 2, 0, NULL, 0, '2023-06-24 14:11:38', '2023-06-26 09:04:18', '2023-06-24', 'P3195', '23-04566-06-24', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Avenida Valdegudin 13', 'Villamuriel de Cerra', 'Palencia', '34190', 'España', 16.29, 0, '2023-06-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240623-YtO0qv8vCIkUr-178', '3c468ecb-5725-48e2-bba6-040c9ed23e17', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240623-YtO0qv8vCIkUr-178&s=KOL2023&nf=P3195&i=16.29&cr=023', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3406, 1, 596, 2, 0, NULL, 0, '2023-06-24 14:43:37', '2023-06-26 09:07:23', '2023-06-24', 'P3196', '23-04567-06-24', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Centro Salud Intxaurrondo Paseo Zarategi 92', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 28.19, 0, '2023-06-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-240623-MC3bTdmBen93q-056', 'ef095ae4-3778-409e-8549-6846897e9a7d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-240623-MC3bTdmBen93q-056&s=KOL2023&nf=P3196&i=28.19&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3407, 1, 724, 2, 0, NULL, 0, '2023-06-25 20:35:55', '2023-06-26 09:10:17', '2023-06-25', 'P3197', '23-04568-06-25', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Los planos 1 3a', 'Entrena', 'La Rioja', '26375', 'España', 16.29, 0, '2023-06-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250623-iH0yrzHkqKvHV-163', '62333314-008d-4bb6-9dc6-13cf01a76225', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250623-iH0yrzHkqKvHV-163&s=KOL2023&nf=P3197&i=16.29&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3408, 1, 856, 2, 0, NULL, 0, '2023-06-26 08:27:11', '2023-06-26 10:33:14', '2023-06-26', 'P3199', '23-04569-06-26', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle de Aralar 28, 4ºDrcha, 4º Drcha', 'Pamplona/Iruña', 'Navarra', '31004', 'España', 16.29, 0, '2023-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260623-bDRf+cA3mcq9b-136', 'f55b51fd-998e-46a1-a525-5724f339945a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260623-bDRf%2BcA3mcq9b-136&s=KOL2023&nf=P3199&i=16.29&cr=153', '[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
(3409, 1, 604, 2, 0, NULL, 0, '2023-06-26 10:08:53', '2023-06-26 12:14:11', '2023-06-26', 'P3200', '23-04570-06-26', '', 0.00, 29.49, 6.96, 0.00, 0, 0.00, 4.40, 'Julio caro Baroja 6 Bajo', 'Bera/Vera de Bidasoa', 'Navarra', '31780', 'España', 40.08, 0, '2023-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260623-UHKGbhRPa6bdb-110', '9695bd84-0ea4-4b1a-80f2-09a061760c38', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260623-UHKGbhRPa6bdb-110&s=KOL2023&nf=P3200&i=40.08&cr=207', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3410, 1, 570, 2, 0, NULL, 0, '2023-06-26 10:50:15', '2023-06-26 12:57:03', '2023-06-26', 'P3201', '23-04571-06-26', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Alamo n23', 'Mancera de Abajo', 'Salamanca', '37315', 'España', 16.29, 0, '2023-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260623-Sn4rDdADsJO3+-051', '8518d9c4-80ef-42de-a8cb-1a881c8ffd06', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260623-Sn4rDdADsJO3%2B-051&s=KOL2023&nf=P3201&i=16.29&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3411, 1, 522, 2, 0, NULL, 0, '2023-06-26 11:25:01', '2023-06-26 13:29:29', '2023-06-26', 'P3202', '23-04572-06-26', '', 0.00, 242.80, 50.99, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 293.79, 0, '2023-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260623-M+1D/rReZv56i-153', 'ac99d69f-b44b-439f-a5f1-9d0899905b2b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260623-M%2B1D%2FrReZv56i-153&s=KOL2023&nf=P3202&i=293.79&cr=186', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3412, 1, 222, 2, 0, NULL, 0, '2023-06-26 12:58:03', '2023-06-26 15:25:50', '2023-06-26', 'P3203', '23-04573-06-26', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Cartagena 296 tenda 1 ', 'Barcelona', 'Barcelona', '08025', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260623-Yg7Ywwp6KWxNX-115', 'cf6431c3-0935-4576-a9b4-d081337a7792', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260623-Yg7Ywwp6KWxNX-115&s=KOL2023&nf=P3203&i=379.34&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3413, 1, 857, 2, 0, NULL, 0, '2023-06-26 14:12:53', '2023-06-26 16:21:12', '2023-06-26', 'P3204', '23-04574-06-26', '', 0.00, 46.19, 9.70, 0.00, 0, 0.00, 0.00, 'C/ Doctor Marañón 12', 'Almonte', 'Huelva', '21730', 'España', 55.89, 0, '2023-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260623-XBcE+Cyoye+Ps-033', '821902a7-974b-4361-9193-9b543ce86d44', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260623-XBcE%2BCyoye%2BPs-033&s=KOL2023&nf=P3204&i=55.89&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3414, 1, 157, 2, 0, NULL, 0, '2023-06-26 16:21:36', '2023-06-27 09:15:24', '2023-06-26', 'P3205', '23-04575-06-26', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'CALLE APODACA,1 LOCAL', 'Madrid', 'Madrid', '28004', 'España', 137.94, 0, '2023-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260623-UNea+o1HCNfN7-132', '7d527447-f4e5-48ac-8948-e50694778db4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260623-UNea%2Bo1HCNfN7-132&s=KOL2023&nf=P3205&i=137.94&cr=163', '[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
(3415, 1, 382, 2, 0, NULL, 0, '2023-06-26 18:46:01', '2023-06-27 09:17:32', '2023-06-26', 'P3206', '23-04576-06-26', 'Si no estamos, entregar en el 2A o 3A. Gracias', 0.00, 39.32, 9.02, 0.00, 0, 0.00, 4.40, 'C/ Bulevar de Mariturri 60 - 2B', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 51.98, 0, '2023-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260623-EfdzYKSObZkMM-077', '8964c12c-036a-4d59-b4de-f68804b6c245', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260623-EfdzYKSObZkMM-077&s=KOL2023&nf=P3206&i=51.98&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3416, 1, 285, 2, 0, NULL, 0, '2023-06-26 22:29:54', '2023-06-27 09:20:13', '2023-06-26', 'P3207', '23-04577-06-26', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'PASAJE PUIGVERT, 8, 3C', 'Santa Coloma de Cerv', 'Barcelona', '08690', 'España', 28.19, 0, '2023-06-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260623-Gq9tDgKvBedLY-178', 'e7039f45-05cd-4217-9730-4b5fd7a1664b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260623-Gq9tDgKvBedLY-178&s=KOL2023&nf=P3207&i=28.19&cr=184', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3417, 1, 662, 2, 0, NULL, 0, '2023-06-27 02:24:04', '2023-06-27 09:21:42', '2023-06-27', 'P3208', '23-04579-06-27', '', 0.00, 56.02, 11.77, 0.00, 0, 0.00, 0.00, 'passatge mercè rodoreda 13, local 8', 'Castelldefels', 'Barcelona', '08860', 'España', 67.78, 0, '2023-06-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270623-IUK2DYKnMn4HP-165', '7d044000-faff-49e4-86c0-19d20da8acda', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270623-IUK2DYKnMn4HP-165&s=KOL2023&nf=P3208&i=67.78&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3418, 1, 57, 2, 0, NULL, 0, '2023-06-27 10:41:11', '2023-06-27 12:42:49', '2023-06-27', 'P3209', '23-04580-06-27', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 379.34, 0, '2023-06-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270623-pRIR0Q/MDNeud-013', 'ad3adf32-3ae8-4fbc-8951-fd626d405718', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270623-pRIR0Q%2FMDNeud-013&s=KOL2023&nf=P3209&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),
(3419, 1, 226, 2, 0, NULL, 0, '2023-06-27 12:53:46', '2023-06-27 15:42:03', '2023-06-27', 'P3210', '23-04581-06-27', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'CALLE LOGROÑO 5 BAJO', 'Donostia-San Sebasti', 'Gipuzkoa', '20018', 'España', 68.97, 0, '2023-06-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270623-jAXQXM+noGMjt-076', 'f62c6311-bb95-4c96-b327-d29ad8d26fa4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270623-jAXQXM%2BnoGMjt-076&s=KOL2023&nf=P3210&i=68.97&cr=040', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3420, 1, 858, 2, 0, NULL, 0, '2023-06-27 16:54:12', '2023-06-28 09:17:10', '2023-06-27', 'P3211', '23-04583-06-27', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Amplaries 23 escalera 2 planta 3 apto 160 Acapulco IV ', 'Oropesa del Mar/Orpe', 'Castellón', '12594', 'España', 16.29, 0, '2023-06-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270623-l6FDv/jMpN3e1-221', '3842ef39-7c87-4656-bf99-46b9c6ab5ec5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270623-l6FDv%2FjMpN3e1-221&s=KOL2023&nf=P3211&i=16.29&cr=083', '[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
(3421, 1, 859, 2, 0, NULL, 0, '2023-06-28 08:34:06', '2023-06-28 11:09:19', '2023-06-28', 'P3212', '23-04584-06-28', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Carretera EX-208 Kilometro 95', 'Conquista de la Sier', 'Cáceres', '10240', 'España', 26.40, 0, '2023-06-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280623-kKL4rFWyusakL-089', 'db102164-0977-463d-9bea-e9ec7245e2e1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280623-kKL4rFWyusakL-089&s=KOL2023&nf=P3212&i=26.40&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3422, 1, 88, 2, 0, NULL, 0, '2023-06-28 08:46:44', '2023-06-28 11:10:30', '2023-06-28', 'P3213', '23-04585-06-28', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Turina 2bj  peluqueria ecologica valderros ', 'Valladolid', 'Valladolid', '47006', 'España', 172.43, 0, '2023-06-28 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280623-ODvOimgIdSJfP-223', '2d039729-abec-4b14-b7a6-a65e1b68e67a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280623-ODvOimgIdSJfP-223&s=KOL2023&nf=P3213&i=172.43&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3423, 1, 280, 2, 0, NULL, 0, '2023-06-28 10:23:55', '2023-06-28 12:28:43', '2023-06-28', 'P3214', '23-04586-06-28', 'lunes cerrado', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'RUA CODESAL Nº2', 'Pino (O)', 'A Coruña', '15821', 'España', 137.94, 0, '2023-06-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280623-ktAUISInPofCV-135', '7fe1beef-5833-4b37-b5ac-d3659c064647', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280623-ktAUISInPofCV-135&s=KOL2023&nf=P3214&i=137.94&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3424, 1, 860, 2, 0, NULL, 0, '2023-06-28 11:05:47', '2023-06-28 13:07:55', '2023-06-28', 'P3215', '23-04587-06-28', '', 0.00, 18.18, 4.58, 0.00, 0, 0.00, 4.40, 'Luis Luciano Bonaparte 20 4D', 'Bilbao', 'Bizkaia', '48004', 'España', 26.40, 0, '2023-06-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280623-Ye5qHVNi2AnL/-239', '1cbaf3df-1d57-4f79-9ccb-ae2e73517544', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280623-Ye5qHVNi2AnL%2F-239&s=KOL2023&nf=P3215&i=26.40&cr=029', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3425, 1, 861, 2, 0, NULL, 0, '2023-06-28 14:47:21', '2023-06-29 09:03:39', '2023-06-28', 'P3216', '23-04592-06-28', 'Casa y entrega a Paquita en Puig den Valls ', 0.00, 36.36, 9.06, 0.00, 0, 0.00, 8.19, 'Calle alcalde torres tur 28', 'Santa Eulalia del Rí', 'Baleares (Illes)', '07813', 'España', 52.19, 0, '2023-06-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280623-crGG1o9/GNLmZ-070', '748baeb9-3695-424c-ad27-c7cee4d08028', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280623-crGG1o9%2FGNLmZ-070&s=KOL2023&nf=P3216&i=52.19&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3426, 1, 862, 2, 0, NULL, 0, '2023-06-28 17:44:22', '2023-06-29 09:09:14', '2023-06-28', 'P3219', '23-04593-06-28', '', 0.00, 9.83, 3.26, 0.00, 0, 0.00, 6.90, 'Finca san Anton, s/n', 'Mirabel', 'Cáceres', '10540', 'España', 18.79, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-280623-BYu/GdQDQIAaL-110', '530f6113-6057-4957-b768-f6e8207c88cc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280623-BYu%2FGdQDQIAaL-110&s=KOL2023&nf=P3219&i=18.79&cr=170', '[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
(3427, 1, 438, 2, 0, NULL, 0, '2023-06-28 18:06:12', '2023-06-29 09:17:37', '2023-06-28', 'P3217', '23-04594-06-28', 'Entrega en Oficinas. Horario: L-J: 8.00-15:00 /V: 8:00-12.30', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'CIE LEGAZPI S.A. Urola kalea 10', 'Legazpi', 'Gipuzkoa', '20230', 'España', 28.19, 0, '2023-06-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280623-de3Y/7DiL6QIf-214', '2f8b3e14-8f23-488e-9f25-c11bbab515e1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280623-de3Y%2F7DiL6QIf-214&s=KOL2023&nf=P3217&i=28.19&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3428, 1, 755, 2, 0, NULL, 0, '2023-06-28 20:46:28', '2023-06-29 09:21:04', '2023-06-28', 'P3218', '23-04595-06-28', '', 0.00, 19.66, 4.89, 0.00, 0, 0.00, 4.40, 'Estrada pola Vía, 21', 'Nigrán', 'Pontevedra', '36350', 'España', 28.19, 0, '2023-06-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280623-GJhKf9Y2h9avR-219', '69436173-a7fe-46ba-a445-ba0e15a3df87', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280623-GJhKf9Y2h9avR-219&s=KOL2023&nf=P3218&i=28.19&cr=240', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3429, 1, 77, 1, 0, NULL, 0, '2023-06-29 11:37:25', '2023-06-29 11:40:44', '2023-06-29', 'P3220', '2023-06-29', '', 0.00, 1794.00, 376.74, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 2170.74, 0, '2023-06-29 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290623-IpKJrfLTXJvzi-174', 'fa601f61-7705-49dc-aee8-9a810a878125', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290623-IpKJrfLTXJvzi-174&s=KOL2023&nf=P3220&i=2170.73&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3430, 1, 78, 2, 0, NULL, 0, '2023-06-29 10:13:35', '2023-06-29 12:48:16', '2023-06-29', 'P3221', '23-04597-06-29', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'avnd. de satrustegui, 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-290623-icZ6Erjkn98vB-247', 'a6908492-ef84-4156-9e5e-511308411695', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290623-icZ6Erjkn98vB-247&s=KOL2023&nf=P3221&i=379.34&cr=021', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3431, 1, 61, 2, 0, NULL, 0, '2023-06-29 11:25:17', '2023-06-30 08:58:25', '2023-06-29', 'P3222', '23-04598-06-29', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Maestro Gozalbo 4 bajo', 'Valencia', 'Valencia', '46005', 'España', 103.46, 0, '2023-06-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290623-PC/+mbjO3bYBe-250', '57e061bb-a3bf-4cc0-af07-10f24294f048', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290623-PC%2F%2BmbjO3bYBe-250&s=KOL2023&nf=P3222&i=103.46&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3432, 1, 92, 2, 0, NULL, 0, '2023-06-29 11:59:42', '2023-06-30 09:00:30', '2023-06-29', 'P3223', '23-04603-06-29', 'lunes cerrado', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'euskal herria 4,bajo  ibarra guipuzkoa ', 'Ibarra', 'Gipuzkoa', '20400', 'España', 379.34, 0, '2023-06-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290623-V9/+axY66yhp5-241', '1626d044-ee77-45c5-bcc9-9ddd0a274208', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290623-V9%2F%2BaxY66yhp5-241&s=KOL2023&nf=P3223&i=379.34&cr=123', '[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
(3433, 1, 781, 2, 0, NULL, 0, '2023-06-29 13:05:19', '2023-06-30 09:03:22', '2023-06-29', 'P3224', '23-04604-06-29', 'Timbre desde la calle 604 ????️ ', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'Calle Enriqueta Elizacin 2 escalera 6- 2B', 'Alicante/Alacant', 'Alicante', '03007', 'España', 16.29, 0, '2023-06-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290623-pKfcdtETTjOMy-016', 'a9ba16ff-42d1-46da-afe1-5a5e3c9ed5c5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290623-pKfcdtETTjOMy-016&s=KOL2023&nf=P3224&i=16.29&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3434, 1, 863, 2, 0, NULL, 0, '2023-06-29 14:21:50', '2023-06-30 09:05:06', '2023-06-29', 'P3225', '23-04605-06-29', 'Si no estoy dejar en la tienda o bar de al lado.', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'C/ Peñota, 2- 1°A', 'Ribamontán al Mar', 'Cantabria', '39160', 'España', 16.29, 0, '2023-06-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290623-bd3GP5yzhkwIX-015', '425b0d02-6510-44a1-8529-458871ec0011', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290623-bd3GP5yzhkwIX-015&s=KOL2023&nf=P3225&i=16.29&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3435, 1, 809, 2, 0, NULL, 0, '2023-06-29 15:00:33', '2023-06-30 09:10:21', '2023-06-29', 'P3226', '23-04606-06-29', '', 0.00, 9.83, 2.83, 0.00, 0, 0.00, 4.40, 'PASEO SAN JUAN BOSCO Nº 25 2º IZDA', 'Monzón', 'Huesca', '22400', 'España', 16.29, 0, '2023-06-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290623-bf7uJX/GDY2Yv-202', '1f815385-6fac-48ee-9856-8e16a4beccb5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290623-bf7uJX%2FGDY2Yv-202&s=KOL2023&nf=P3226&i=16.29&cr=215', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3436, 1, 17, 2, 0, NULL, 0, '2023-06-29 20:19:16', '2023-06-30 09:12:57', '2023-06-29', 'P3227', '23-04607-06-29', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 137.94, 0, '2023-06-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-290623-OKuP9KlpSSFlL-131', '1eaa6942-a699-4439-9cb7-140345d967cd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-290623-OKuP9KlpSSFlL-131&s=KOL2023&nf=P3227&i=137.94&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3437, 1, 664, 2, 0, NULL, 0, '2023-06-30 12:24:32', '2023-07-03 09:06:49', '2023-06-30', 'P3228', '23-04608-06-30', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Aranerreka 32, 3 izquierda', 'Bergara', 'Gipuzkoa', '20570', 'España', 30.61, 0, '2023-06-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300623-a2Uv+ScrFNg36-237', 'ddcd8f98-cd48-4fa9-8e9e-27dad922147e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300623-a2Uv%2BScrFNg36-237&s=KOL2023&nf=P3228&i=30.61&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(3438, 1, 864, 2, 0, NULL, 0, '2023-07-01 10:07:16', '2023-07-03 09:08:50', '2023-07-01', 'P3229', '23-04609-07-01', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Aita Lertxundi 18 3C', 'Orio', 'Gipuzkoa', '20810', 'España', 28.39, 0, '2023-07-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-010723-AZL8xk7AjYpWo-117', '8ff7d6da-ec07-40f3-a0f1-1c4f3b4bc78f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-010723-AZL8xk7AjYpWo-117&s=KOL2023&nf=P3229&i=28.39&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
