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
(4750, 1, 174, 1, 0, NULL, 0, '2024-03-15 11:41:11', '2024-03-15 11:41:11', '2024-03-15', 'P4446', '', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'Calle Cervantes 13', 'Santander', 'CANTABRIA', '39001', '', 413.82, 0, '2024-03-15 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150324-dIy4L9uG1Wl6m-215', 'cbcc0d3d-0ac1-4170-ae54-bf32fea472b7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150324-dIy4L9uG1Wl6m-215&s=KOL2024&nf=P4446&i=413.82&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4751, 1, 1147, 2, 0, NULL, 0, '2024-03-15 12:46:32', '2024-03-18 08:56:22', '2024-03-18', 'P4453', '24-06040-03-15', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Avenida Aragón 14, Primero c', 'Teruel', 'Teruel', '44001', 'España', 41.50, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-180324-aFYe5Y/eCEMOO-091', 'a02b3ee1-540c-446b-9bee-2fa2f7e47000', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180324-aFYe5Y%2FeCEMOO-091&s=KOL2024&nf=P4453&i=41.50&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4752, 1, 236, 2, 0, NULL, 0, '2024-03-15 14:27:00', '2024-03-18 09:02:37', '2024-03-18', 'P4447', '24-06041-03-15', '', 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-03-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180324-CklMepPvsmyRu-094', 'f86bc60d-c02b-4846-9e1f-8c823562cb44', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180324-CklMepPvsmyRu-094&s=KOL2024&nf=P4447&i=206.91&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4753, 1, 192, 2, 0, NULL, 0, '2024-03-15 16:45:17', '2024-03-18 09:05:11', '2024-03-18', 'P4448', '24-06042-03-15', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'plaza San Cristobal 3,bajo', 'Gernika-Lumo', 'Bizkaia', '48300', 'España', 275.88, 0, '2024-03-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180324-hvcigQ2XtAYtp-122', 'af288619-0aee-43cb-9500-aff534d90df3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180324-hvcigQ2XtAYtp-122&s=KOL2024&nf=P4448&i=275.88&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4754, 1, 693, 2, 0, NULL, 0, '2024-03-15 18:35:39', '2024-03-18 09:07:03', '2024-03-18', 'P4449', '24-06043-03-15', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Gran Vía 45, 3ª planta (SRB)', 'Bilbao', 'Bizkaia', '48011', 'España', 17.50, 0, '2024-03-15 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180324-MpheQaNtNvSmW-037', '5ffcbb22-80f1-4639-b9b8-ecd12ff59d34', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180324-MpheQaNtNvSmW-037&s=KOL2024&nf=P4449&i=17.50&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4755, 1, 215, 2, 0, NULL, 0, '2024-03-16 06:53:47', '2024-03-18 09:09:07', '2024-03-18', 'P4450', '24-06044-03-16', '', 0.00, 329.78, 69.25, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 399.03, 0, '2024-03-16 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180324-A+RSsSS8HosYx-169', 'af6d1d17-1501-4f05-90f9-b189f6fdba13', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180324-A%2BRSsSS8HosYx-169&s=KOL2024&nf=P4450&i=399.03&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
(4756, 1, 284, 2, 0, NULL, 0, '2024-03-17 16:16:17', '2024-03-18 09:11:26', '2024-03-18', 'P4451', '24-06046-03-17', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'AV MIL.LENARI Nº29 3º1ª', 'Viladecans', 'Barcelona', '08840', 'España', 56.82, 0, '2024-03-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180324-exhf73wmt9S6O-077', '37bde156-9ff1-4e26-9e7a-db10c82a0765', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180324-exhf73wmt9S6O-077&s=KOL2024&nf=P4451&i=56.82&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4757, 1, 1206, 2, 0, NULL, 0, '2024-03-17 20:03:56', '2024-03-18 09:14:13', '2024-03-18', 'P4452', '24-06047-03-17', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Kale Nagusia 69', 'Arbizu', 'Navarra', '31839', 'España', 43.71, 0, '2024-03-17 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-180324-FQlQypD3bZYl0-126', 'd99762be-911c-4fc9-b250-d767660c5f56', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180324-FQlQypD3bZYl0-126&s=KOL2024&nf=P4452&i=43.71&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4758, 1, 720, 2, 0, NULL, 0, '2024-03-18 10:16:59', '2024-03-18 11:18:27', '2024-03-18', 'P4454', '24-06048-03-18', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Sipiri 18, 2, D', 'Sopelana', 'Bizkaia', '48600', 'España', 28.39, 0, '2024-03-18 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-180324-U8pkgsSRIZzZV-057', '0ac22b22-848b-4a26-88aa-da62dac6b2e1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-180324-U8pkgsSRIZzZV-057&s=KOL2024&nf=P4454&i=28.39&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4759, 1, 350, 2, 0, NULL, 0, '2024-03-18 15:51:27', '2024-03-19 09:23:23', '2024-03-19', 'P4455', '24-06050-03-18', 'PELUQUERIA BEGOÑA ITURRIOZ', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle Balleneros 19 Bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 137.94, 0, '2024-03-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190324-Dlu3fIfZCHthd-080', 'c9b7345c-3ebc-428b-8caf-b3465229779d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190324-Dlu3fIfZCHthd-080&s=KOL2024&nf=P4455&i=137.94&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4760, 1, 190, 3, 0, NULL, 0, '2024-03-18 17:30:02', '2024-10-15 16:06:55', '2024-03-18', '', 'Consumo interno', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 34.48, 0, '2024-03-18 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),
(4761, 1, 221, 2, 0, NULL, 0, '2024-03-18 17:52:11', '2024-03-19 09:25:54', '2024-03-19', 'P4456', '24-06051-03-18', 'necesitamos folletos', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 241.40, 0, '2024-03-18 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190324-RcMzELcxw+bXa-083', '1aa3636b-77f6-4e34-82bb-cf6c9eff48bb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190324-RcMzELcxw%2BbXa-083&s=KOL2024&nf=P4456&i=241.40&cr=034', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4762, 1, 152, 1, 0, NULL, 0, '2024-03-19 09:34:51', '2024-03-19 09:34:51', '2024-03-19', 'P4457', '', '', 0.00, 111.54, 23.42, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 134.96, 0, '2024-03-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190324-cN3HWJla4ghME-195', 'fb536877-6336-4014-8eae-eb0d71fb8f20', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190324-cN3HWJla4ghME-195&s=KOL2024&nf=P4457&i=134.96&cr=001', '[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
(4763, 1, 67, 2, 0, NULL, 0, '2024-03-19 08:41:26', '2024-03-19 09:55:31', '2024-03-19', 'P4458', '24-06052-03-19', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190324-MnncNe9Qg0Usj-212', 'fcb4e117-713f-4042-a162-a83956d67a67', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190324-MnncNe9Qg0Usj-212&s=KOL2024&nf=P4458&i=275.88&cr=076', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4764, 1, 1158, 2, 0, NULL, 0, '2024-03-19 10:09:14', '2024-03-19 11:17:05', '2024-03-19', 'P4459', '24-06053-03-19', 'peluqueria Marai', 0.00, 56.98, 11.96, 0.00, 0, 0.00, 0.00, 'republica Argentina 3 bajo 2', 'Irun', 'Gipuzkoa', '20301', 'España', 68.95, 0, '2024-03-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-190324-MgJAbvN4YQQ8/-066', '2fdda56a-6996-45f9-86ea-427f8db76764', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190324-MgJAbvN4YQQ8%2F-066&s=KOL2024&nf=P4459&i=68.95&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4765, 1, 687, 1, 0, NULL, 0, '2024-03-19 12:17:51', '2024-03-19 12:22:39', '2024-03-19', 'P4460', '', '', 0.00, 61.06, 12.82, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 73.88, 0, '2024-03-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-190324-BrmaBDq9PzN47-063', '8d01cae5-4b35-4524-8eba-ea7cd53b3f19', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-190324-BrmaBDq9PzN47-063&s=KOL2024&nf=P4460&i=73.88&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4766, 1, 345, 2, 0, NULL, 0, '2024-03-19 13:02:27', '2024-03-20 09:25:59', '2024-03-20', 'P4461', '24-06054-03-19', '', 0.00, 81.40, 17.09, 0.00, 0, 0.00, 0.00, 'Espronceda 336', 'Barcelona', 'Barcelona', '08027', 'España', 98.49, 0, '2024-03-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200324-KeHcq/z6xaVdu-135', 'd95dc7fb-7b1f-49de-971a-bf4b6bb2d97f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200324-KeHcq%2Fz6xaVdu-135&s=KOL2024&nf=P4461&i=98.49&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4767, 1, 1207, 2, 0, NULL, 0, '2024-03-19 13:08:30', '2024-03-20 09:26:13', '2024-03-20', 'P4462', '24-06055-03-19', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Escuelas 61, 1°C', 'Valdepeñas', 'Ciudad Real', '13300', 'España', 17.50, 0, '2024-03-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200324-k3h8Uds/ozBKj-054', '14eff1fa-ed5c-4a26-96b9-c0164a82b11f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200324-k3h8Uds%2FozBKj-054&s=KOL2024&nf=P4462&i=17.50&cr=079', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4768, 1, 407, 2, 0, NULL, 0, '2024-03-19 16:41:13', '2024-03-20 09:27:51', '2024-03-20', 'P4463', '24-06056-03-19', 'Llamar antes de entregar por favor gracias ', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'calle fuentarrabia n5 bajo2', 'Irun', 'Gipuzkoa', '20301', 'España', 172.43, 0, '2024-03-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200324-eVr6w4Iem+Jps-185', '61c9d982-c8ce-4f3e-b56e-2741341601c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200324-eVr6w4Iem%2BJps-185&s=KOL2024&nf=P4463&i=172.43&cr=183', '[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
(4769, 1, 1208, 2, 0, NULL, 0, '2024-03-19 17:34:53', '2024-03-20 09:28:00', '2024-03-20', 'P4464', '24-06058-03-19', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Mallorca número 2 / 6 C', 'Madrid', 'Madrid', '28012', 'España', 17.50, 0, '2024-03-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200324-UXO2xKsF1CiEd-006', 'd06c8dca-cf37-4c4a-ba3b-a230df81d81b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200324-UXO2xKsF1CiEd-006&s=KOL2024&nf=P4464&i=17.50&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4770, 1, 1209, 2, 0, NULL, 0, '2024-03-19 21:00:46', '2024-03-20 09:28:14', '2024-03-20', 'P4465', '24-06059-03-19', 'En horario de 10 a 13 y de 16 a 20', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Zaragoza, 12 C', 'Montesinos (Los)', 'Alicante', '03187', 'España', 30.61, 0, '2024-03-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200324-X9fcWvg15NSVO-127', '4298eca6-9c49-47f2-b50c-0149420bfdf7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200324-X9fcWvg15NSVO-127&s=KOL2024&nf=P4465&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),
(4771, 1, 304, 2, 0, NULL, 0, '2024-03-19 21:04:51', '2024-03-20 09:28:27', '2024-03-20', 'P4466', '24-06060-03-19', 'La entrega a poder ser antes de las once y media,gracias', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Bersolari txirrita ñ5 4ºC', 'Donostia-San Sebasti', 'Gipuzkoa', '20017', 'España', 71.98, 0, '2024-03-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200324-NcF5iVzMPJcH5-033', '43c11227-0172-4e83-87d0-fa3c7da7b0d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200324-NcF5iVzMPJcH5-033&s=KOL2024&nf=P4466&i=71.98&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4772, 1, 1064, 2, 0, NULL, 0, '2024-03-20 11:40:22', '2024-03-20 12:43:35', '2024-03-20', 'P4467', '24-06061-03-20', 'Peluquería Patricia Alcántara ', 0.00, 36.64, 8.46, 0.00, 0, 0.00, 4.40, 'Lorenzo Cendra Busca', 'Málaga', 'Málaga', '29007', 'España', 48.73, 0, '2024-03-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-200324-ErfY9/4qg3pdH-251', 'befdf922-19e5-4f91-8ea2-5dc967a53ca3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-200324-ErfY9%2F4qg3pdH-251&s=KOL2024&nf=P4467&i=48.73&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4773, 1, 155, 2, 0, NULL, 0, '2024-03-20 13:20:50', '2024-03-21 08:50:32', '2024-03-21', 'P4474', '24-06063-03-20', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210324-QqtYjrnKnJPYm-244', '806967de-4923-4d32-9e40-d65229333085', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210324-QqtYjrnKnJPYm-244&s=KOL2024&nf=P4474&i=172.43&cr=217', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4774, 1, 155, 2, 0, NULL, 0, '2024-03-20 13:20:54', '2024-03-20 13:20:54', '2024-03-20', '', '24-06064-03-20', NULL, 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'oriamendi Nº29', 'Beasain', 'Gipuzkoa', '20200', '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),
(4775, 1, 1210, 2, 0, NULL, 0, '2024-03-20 14:20:30', '2024-03-21 08:54:33', '2024-03-21', 'P4468', '24-06066-03-20', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Rua das Chorimas nº 2', 'Pontes de García Rod', 'A Coruña', '15320', 'España', 28.39, 0, '2024-03-20 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-210324-HowwELkTgZnJA-124', '216ac590-414c-4a9b-874e-125cb78e7488', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210324-HowwELkTgZnJA-124&s=KOL2024&nf=P4468&i=28.39&cr=068', '[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
(4776, 1, 30, 2, 0, NULL, 0, '2024-03-20 15:05:05', '2024-03-21 08:57:01', '2024-03-21', 'P4469', '24-06067-03-20', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle González tablas, 3 bajo', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 137.94, 0, '2024-03-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210324-eHk/C99WthgVh-028', '4849a362-dd1a-46da-9b47-3cfbd7db9c6b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210324-eHk%2FC99WthgVh-028&s=KOL2024&nf=P4469&i=137.94&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4777, 1, 91, 2, 0, NULL, 0, '2024-03-20 15:36:04', '2024-03-21 09:00:59', '2024-03-21', 'P4470', '24-06068-03-20', '', 0.00, 150.64, 31.63, 0.00, 0, 0.00, 0.00, 'calle la perla 16 bajo', 'Sanxenxo', 'Pontevedra', '36970', 'España', 182.27, 0, '2024-03-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210324-ODNU/Lk0RIYup-086', 'bdc5b489-ec76-4568-b359-6f53b2556630', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210324-ODNU%2FLk0RIYup-086&s=KOL2024&nf=P4470&i=182.27&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4778, 1, 556, 2, 0, NULL, 0, '2024-03-20 16:40:14', '2024-03-21 09:02:28', '2024-03-21', 'P4471', '24-06069-03-20', '', 0.00, 44.78, 10.17, 0.00, 0, 0.00, 4.40, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 58.58, 0, '2024-03-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210324-UGT99Ub81ROF5-031', '7b705cce-cc4f-4ab1-a4d1-73bcaf9b6d79', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210324-UGT99Ub81ROF5-031&s=KOL2024&nf=P4471&i=58.58&cr=028', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4779, 1, 1211, 2, 0, NULL, 0, '2024-03-20 21:11:03', '2024-03-21 09:04:13', '2024-03-21', 'P4472', '24-06070-03-20', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Luis Olariaga 3, 5 dcha.', 'Vitoria-Gasteiz', 'Álava', '01010', 'España', 17.50, 0, '2024-03-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210324-Ls4FSYNvq1/kj-139', '6192368d-3f0a-400d-b386-913a98727db6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210324-Ls4FSYNvq1%2Fkj-139&s=KOL2024&nf=P4472&i=17.50&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4780, 1, 314, 2, 0, NULL, 0, '2024-03-20 22:25:40', '2024-03-21 09:09:08', '2024-03-21', 'P4473', '24-06071-03-20', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'CALLE DEMOCRACIA 49, PUERTA 9', 'Valencia', 'Valencia', '46018', 'España', 71.98, 0, '2024-03-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-210324-h2igiHFSSUq37-248', '50f31c83-c240-461f-bf9a-c026a78fc7a0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210324-h2igiHFSSUq37-248&s=KOL2024&nf=P4473&i=71.98&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4781, 1, 701, 2, 0, NULL, 0, '2024-03-20 23:04:20', '2024-03-21 09:12:07', '2024-03-21', 'P4475', '24-06072-03-20', '', 0.00, 54.15, 11.81, 0.00, 0, 0.00, 2.50, 'Rua palamios 21', 'Pontevedra', 'Pontevedra', '36001', 'España', 68.02, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-210324-NWP/c0PKZ1oBN-004', 'e117701c-1235-409d-9f37-b1d944adaab2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210324-NWP%2Fc0PKZ1oBN-004&s=KOL2024&nf=P4475&i=68.02&cr=009', '[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
(4782, 1, 236, 1, 0, NULL, 0, '2024-03-21 09:21:56', '2024-03-21 10:02:45', '2024-03-21', 'P4476', '', '', 0.00, 40.70, 8.55, 0.00, 0, 0.00, 0.00, 'Avda. de la Policía Nacional, Edificio Don Ives, 24', 'Antequera', 'Málaga', '29200', 'España', 49.25, 0, '2024-03-21 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-210324-dFZ1TVzZVnqj+-170', 'e38c8dc7-85b9-42d1-b41b-33e805666f11', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-210324-dFZ1TVzZVnqj%2B-170&s=KOL2024&nf=P4476&i=49.25&cr=212', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4783, 1, 170, 1, 0, NULL, 0, '2024-03-22 09:18:54', '2024-03-22 09:18:54', '2024-03-22', 'P4477', '', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Plaza de las agustinas N°5  ', 'Hernani', 'Gipuzkoa', '20120', 'España', 241.40, 0, '2024-03-22 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-220324-XXHOvOCiyHdkT-237', '938a6446-dfc4-4ca4-9751-c29b97b0517b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220324-XXHOvOCiyHdkT-237&s=KOL2024&nf=P4477&i=241.40&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4784, 1, 127, 2, 0, NULL, 0, '2024-03-22 08:59:21', '2024-03-22 10:10:31', '2024-03-22', 'P4478', '24-06078-03-22', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'C/ Esperanza frente n26', 'Bilbao', 'Bizkaia', '48005', 'España', 137.94, 0, '2024-03-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220324-ZHjuDvvsF1Z7R-102', '9062474f-874f-40a3-a17f-a29f7be20c71', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220324-ZHjuDvvsF1Z7R-102&s=KOL2024&nf=P4478&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),
(4785, 1, 4, 2, 0, NULL, 0, '2024-03-22 09:17:51', '2024-03-22 10:49:24', '2024-03-22', 'P4479', '24-06080-03-22', '', 0.00, 272.78, 57.28, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 330.06, 0, '2024-03-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-220324-jqS5e+CMbuuzW-058', 'ab74383f-ef63-4212-9be5-d34319f6ffe5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-220324-jqS5e%2BCMbuuzW-058&s=KOL2024&nf=P4479&i=330.06&cr=011', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4786, 1, 522, 2, 0, NULL, 0, '2024-03-22 12:10:46', '2024-03-25 09:21:52', '2024-03-25', 'P4480', '24-06081-03-22', 'Abrimos lunes 25,por si pudiera llegar, gracias ', 0.00, 179.14, 37.62, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 216.76, 0, '2024-03-22 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250324-XlF/NBwlTrzvO-219', 'fe1c279c-c440-49b0-bee1-606db64ceb39', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-XlF%2FNBwlTrzvO-219&s=KOL2024&nf=P4480&i=216.76&cr=234', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4787, 1, 43, 2, 0, NULL, 0, '2024-03-22 12:24:17', '2024-03-25 09:24:12', '2024-03-25', 'P4481', '24-06082-03-22', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Nagusia 5', 'Tolosa', 'Gipuzkoa', '20400', 'España', 206.91, 0, '2024-03-22 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-250324-fhjPaTY9dY+/O-199', '4148d4f5-2f2e-47d1-b301-d22037a92002', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-fhjPaTY9dY%2B%2FO-199&s=KOL2024&nf=P4481&i=206.91&cr=013', '[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
(4788, 1, 1212, 2, 0, NULL, 0, '2024-03-23 06:19:40', '2024-03-25 09:25:57', '2024-03-25', 'P4482', '24-06087-03-23', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Narkis Balentziaga 8 1A', 'Zestoa', 'Gipuzkoa', '20749', 'España', 28.39, 0, '2024-03-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250324-goBN78PNnxIFJ-024', '73558130-ca19-4afb-a5f0-d48b0b15f465', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-goBN78PNnxIFJ-024&s=KOL2024&nf=P4482&i=28.39&cr=143', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4789, 1, 259, 2, 0, NULL, 0, '2024-03-23 10:00:31', '2024-03-25 09:30:38', '2024-03-25', 'P4483', '24-06088-03-23', 'ENTREGAR 9 A 1 AVISAR TEL. 680750573', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'GIPUZKOA KALEA 53', 'Zarautz', 'Gipuzkoa', '20800', 'España', 275.88, 0, '2024-03-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250324-Ma+t7wzF2DE6v-198', '76d485a1-fedb-4125-a073-4c13f25da148', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-Ma%2Bt7wzF2DE6v-198&s=KOL2024&nf=P4483&i=275.88&cr=160', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4790, 1, 1213, 2, 0, NULL, 0, '2024-03-23 15:30:23', '2024-03-25 09:32:50', '2024-03-25', 'P4484', '24-06093-03-23', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Emili Grahit,58, 4-1', 'Girona', 'Girona', '17003', 'España', 43.71, 0, '2024-03-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250324-SwrLAEwDZVviB-065', '2b4f1682-0bc3-42f6-b8ef-a47cb87a8f54', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-SwrLAEwDZVviB-065&s=KOL2024&nf=P4484&i=43.71&cr=175', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4791, 1, 270, 2, 0, NULL, 0, '2024-03-24 08:44:14', '2024-03-25 09:35:05', '2024-03-25', 'P4485', '24-06094-03-24', 'Sabado 30 estara comerio cerrado\r\n\r\n', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Juan Bautista Zabala 9 (Comercio Gaurko)', 'Getxo', 'Bizkaia', '48991', 'España', 52.39, 0, '2024-03-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250324-fmFd0MAZjsPg9-116', 'adbf5a69-8b1e-4ae6-96c2-f55627bcb5c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-fmFd0MAZjsPg9-116&s=KOL2024&nf=P4485&i=52.39&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4792, 1, 1139, 2, 0, NULL, 0, '2024-03-24 09:54:12', '2024-03-25 09:39:21', '2024-03-25', 'P4486', '24-06095-03-24', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Avda castrelos,9,3d', 'Vigo', 'Pontevedra', '36210', 'España', 28.39, 0, '2024-03-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250324-Vt8TpZooVmD20-068', '150353f3-759c-4945-ae9d-7daedf63b33a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-Vt8TpZooVmD20-068&s=KOL2024&nf=P4486&i=28.39&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4793, 1, 754, 2, 0, NULL, 0, '2024-03-24 17:12:59', '2024-03-25 09:45:58', '2024-03-25', 'P4487', '24-06097-03-24', 'Tal como quedamos 6+1 REGALO RUBIO EXTRACLARO.\r\nMuchas gracias', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Amposta', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-03-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250324-oK/1XsEOIkKqe-133', '4be5a3a3-b6cb-4155-a9aa-bc8b1ae90964', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-oK%2F1XsEOIkKqe-133&s=KOL2024&nf=P4487&i=61.64&cr=186', '[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
(4794, 1, 1214, 2, 0, NULL, 0, '2024-03-24 21:06:52', '2024-03-25 09:47:19', '2024-03-25', 'P4488', '24-06098-03-24', 'PISO 1 PUERTA 1', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'POETA AUSIAS MARCH NUM 20 PTA 1', 'Ontinyent', 'Valencia', '46870', 'España', 41.50, 0, '2024-03-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250324-lq287fcWYfmp0-188', '8a57658a-ebe6-47ed-a258-c763e9d67851', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-lq287fcWYfmp0-188&s=KOL2024&nf=P4488&i=41.50&cr=182', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4795, 1, 686, 2, 0, NULL, 0, '2024-03-25 09:02:37', '2024-03-25 10:32:33', '2024-03-25', 'P4489', '24-06099-03-25', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Sancho el sabio 11. Local 3. UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 206.91, 0, '2024-03-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-250324-iCkgS9ZFodLGd-114', '6f6c5556-7e8f-45ac-ac28-3a66efbb2706', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-iCkgS9ZFodLGd-114&s=KOL2024&nf=P4489&i=206.91&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4796, 1, 121, 2, 0, NULL, 0, '2024-03-25 10:01:45', '2024-03-25 11:12:38', '2024-03-25', 'P4490', '24-06100-03-25', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 172.43, 0, '2024-03-25 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-250324-NznFYGsO2yjIo-164', 'ec7d1122-3ef8-4405-a0e8-0d0c404f247a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-250324-NznFYGsO2yjIo-164&s=KOL2024&nf=P4490&i=172.43&cr=045', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4797, 1, 190, 3, 0, NULL, 0, '2024-03-25 11:04:00', '2024-10-15 16:08:07', '2024-03-25', '', 'Consumo interno', '', 0.00, 2157.60, 453.10, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2610.70, 0, '2024-03-25 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),
(4798, 1, 1215, 2, 0, NULL, 0, '2024-03-25 12:54:57', '2024-03-26 10:50:37', '2024-03-26', 'P4491', '24-06104-03-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Francisco Pizarro,17-9B', 'Portugalete', 'Bizkaia', '48920', 'España', 30.61, 0, '2024-03-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260324-R80r93Kt+Ncx6-076', '6db51264-3f7f-4322-be79-fc930c11a81e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260324-R80r93Kt%2BNcx6-076&s=KOL2024&nf=P4491&i=30.61&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4799, 1, 272, 2, 0, NULL, 0, '2024-03-25 22:17:55', '2024-03-26 10:51:43', '2024-03-26', 'P4492', '24-06105-03-25', 'Tlf contacto 921 44 89 56 ', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Los Cerros 27C', 'Palazuelos de Eresma', 'Segovia', '40194', 'España', 65.52, 0, '2024-03-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260324-bXHw52gw/1fPH-084', '9dfcab03-9eeb-4827-979d-7eccfa789d53', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260324-bXHw52gw%2F1fPH-084&s=KOL2024&nf=P4492&i=65.52&cr=108', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4800, 1, 17, 2, 0, NULL, 0, '2024-03-26 08:43:29', '2024-03-26 10:52:31', '2024-03-26', 'P4493', '24-06106-03-26', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'San José num 64 ', 'San Vicente del Rasp', 'Alicante', '03690', 'España', 241.40, 0, '2024-03-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260324-US/OGvRN/fJrY-019', '6778c286-a4cb-4778-ae3a-6f6dbf28321e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260324-US%2FOGvRN%2FfJrY-019&s=KOL2024&nf=P4493&i=241.40&cr=067', '[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
(4801, 1, 110, 2, 0, NULL, 0, '2024-03-26 10:43:22', '2024-03-26 11:58:21', '2024-03-26', 'P4494', '24-06107-03-26', 'lunes cerrado\r\n', 0.00, 211.70, 44.46, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 256.16, 0, '2024-03-26 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-260324-N2yyp3uLSU2vO-222', '97778aab-f588-4a73-a11a-2542c5ba9872', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260324-N2yyp3uLSU2vO-222&s=KOL2024&nf=P4494&i=256.16&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4802, 1, 1110, 2, 0, NULL, 0, '2024-03-26 10:54:12', '2024-03-26 12:01:36', '2024-03-26', 'P4495', '24-06110-03-26', '', 0.00, 48.84, 10.26, 0.00, 0, 0.00, 0.00, 'C/unió N015', 'Lleida', 'Lleida', '25002', 'España', 59.10, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-260324-mLMfuVLySODFJ-143', '725d58b9-7ca2-4c27-a052-512362171a21', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260324-mLMfuVLySODFJ-143&s=KOL2024&nf=P4495&i=59.10&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4803, 1, 87, 2, 0, NULL, 0, '2024-03-26 11:59:17', '2024-03-26 13:08:00', '2024-03-26', 'P4496', '24-06111-03-26', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Cc arcco local p 17', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 137.94, 0, '2024-03-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-260324-QmUKwGjjOVe5F-203', 'a33eef01-2176-49cf-a8d0-a9c099a72bf5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-260324-QmUKwGjjOVe5F-203&s=KOL2024&nf=P4496&i=137.94&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4804, 1, 1216, 2, 0, NULL, 0, '2024-03-27 17:05:53', '2024-04-02 09:13:42', '2024-04-02', 'P4497', '24-06113-03-27', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Grupo Serantes 18, 4 Izq', 'Santurtzi', 'Bizkaia', '48980', 'España', 17.50, 0, '2024-03-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-lVbKsPHqOftr4-195', '5e7104cb-bacc-4e42-b574-0267d5e8c66d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-lVbKsPHqOftr4-195&s=KOL2024&nf=P4497&i=17.50&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4805, 1, 1148, 2, 0, NULL, 0, '2024-03-27 20:36:33', '2024-04-02 09:28:28', '2024-04-02', 'P4498', '24-06115-03-27', 'En el portal nº 6 hay portero 24x7', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Travesía de Téllez 8, 1T', 'Madrid', 'Madrid', '28007', 'España', 65.52, 0, '2024-03-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-YX49yecmfN0L6-042', '3e1c5254-2e36-4ef4-a1d4-bdc1b4e3605a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-YX49yecmfN0L6-042&s=KOL2024&nf=P4498&i=65.52&cr=027', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4806, 1, 1217, 2, 0, NULL, 0, '2024-03-28 07:27:00', '2024-04-02 09:28:47', '2024-04-02', 'P4499', '24-06116-03-28', 'Si no estuviera pueden dejarlo algún  vecino', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Camí  Labores Agrícolas, 37 bloq.10 2A', 'Gavà', 'Barcelona', '08850', 'España', 17.50, 0, '2024-03-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020424-jsRz3hyEEyrVd-049', '52e805b1-1057-4071-8e7e-63f366b2dee4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020424-jsRz3hyEEyrVd-049&s=KOL2024&nf=P4499&i=17.50&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
