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
(6429, 1, 1464, 2, 0, NULL, 0, '2025-01-08 21:07:18', '2025-01-09 09:25:51', '2025-01-09', 'P6043', '25-07880-01-08', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer Cid Campeador, 1', 'Gandia', 'Valencia', '46702', 'España', 30.61, 0, '2025-01-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090125-NkceauvYVm81c-205', '60a240e3-89f3-4e26-aff8-159dd242c5d4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-NkceauvYVm81c-205&s=KOL2025&nf=P6043&i=30.61&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6430, 1, 76, 1, 0, NULL, 0, '2025-01-09 09:42:19', '2025-01-09 09:47:25', '2025-01-09', 'P6045', '2025-01-09', '', 0.00, 377.52, 79.28, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 456.80, 0, '2025-01-09 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090125-fa3VeTj+ZfO9B-022', '1ca3fad1-f4e1-4798-8491-9b94b562b087', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-fa3VeTj%2BZfO9B-022&s=KOL2025&nf=P6045&i=456.80&cr=136', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6431, 1, 1545, 2, 0, NULL, 0, '2025-01-09 09:03:34', '2025-01-09 10:05:08', '2025-01-09', 'P6046', '25-07883-01-09', 'EMPRESA LANIK', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'CAMINO MUNDAIZ 8 1º', 'Donostia-San Sebasti', 'Gipuzkoa', '20012', 'España', 17.50, 0, '2025-01-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090125-O89h54UPD0Sna-020', '514d1835-d978-47f2-9290-d10ca5edaa2c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-O89h54UPD0Sna-020&s=KOL2025&nf=P6046&i=17.50&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6432, 1, 78, 2, 0, NULL, 0, '2025-01-09 10:45:33', '2025-01-09 12:07:03', '2025-01-09', 'P6048', '25-07884-01-09', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'AVD. SATRUSTEGUI 1', 'Donostia-San Sebasti', 'Gipuzkoa', '20008', 'España', 413.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090125-DNBctKi4nIOVK-116', '368052f3-f7f3-4444-a716-451ba768a5d2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-DNBctKi4nIOVK-116&s=KOL2025&nf=P6048&i=413.82&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6433, 1, 1606, 2, 0, NULL, 0, '2025-01-09 11:42:01', '2025-01-09 12:43:14', '2025-01-09', 'P6049', '25-07885-01-09', '', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Herrilagunak Kalea, 4', 'Bergara', 'Gipuzkoa', '20570', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090125-R71M7lfUhJ9Yk-121', 'e6609a94-4ba4-4051-9aee-3843d84547dd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-R71M7lfUhJ9Yk-121&s=KOL2025&nf=P6049&i=196.56&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6434, 1, 110, 2, 0, NULL, 0, '2025-01-09 11:45:34', '2025-01-09 12:50:02', '2025-01-09', 'P6050', '25-07886-01-09', 'lunes cerrado', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 241.40, 0, '2025-01-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090125-Q4W+B4ZS4vSnp-243', '13d1054e-2bba-4740-82b6-47520f8e6cb4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-Q4W%2BB4ZS4vSnp-243&s=KOL2025&nf=P6050&i=241.40&cr=240', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6435, 1, 1607, 2, 0, NULL, 0, '2025-01-09 12:06:54', '2025-01-09 13:25:51', '2025-01-09', 'P6051', '25-07887-01-09', 'Oficina seguros o Floristería La Espiga', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle El Valle 1', 'Guardo', 'Palencia', '34880', 'España', 28.39, 0, '2025-01-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090125-ItwpgTTdZiNS3-054', '024bb44e-6ace-4a02-b27c-3d764facfb65', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-ItwpgTTdZiNS3-054&s=KOL2025&nf=P6051&i=28.39&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6436, 1, 1478, 2, 0, NULL, 0, '2025-01-09 13:31:14', '2025-01-09 15:52:50', '2025-01-09', 'P6052', '25-07888-01-09', 'Si no estoy en casa entregar al portero', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle de Yanguas y Miranda, 19, 8 Dcha.', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 30.61, 0, '2025-01-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-090125-Gocc/maOFIDsF-116', 'fa8ead03-4340-4f0c-80ed-de04e9720076', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-Gocc%2FmaOFIDsF-116&s=KOL2025&nf=P6052&i=30.61&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6437, 1, 67, 2, 0, NULL, 0, '2025-01-09 13:48:26', '2025-01-09 15:54:02', '2025-01-09', 'P6053', '25-07889-01-09', '', 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-090125-fdBRIXpXv9VaA-036', '719160ca-c2f4-45a7-899f-a3affde1af26', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090125-fdBRIXpXv9VaA-036&s=KOL2025&nf=P6053&i=275.88&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6438, 1, 1608, 2, 0, NULL, 0, '2025-01-09 16:06:01', '2025-01-10 08:46:03', '2025-01-10', 'P6054', '25-07890-01-09', '', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'Urasamendik, 22 -    2A', 'Deba', 'Gipuzkoa', '20820', 'España', 78.63, 0, '2025-01-09 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100125-UBrp1P7RBxWtv-203', '9420efb6-88f9-4176-861f-7e82d99a115c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-UBrp1P7RBxWtv-203&s=KOL2025&nf=P6054&i=78.63&cr=074', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6439, 1, 592, 2, 0, NULL, 0, '2025-01-09 17:38:36', '2025-01-10 08:47:10', '2025-01-10', 'P6055', '25-07891-01-09', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Orellana 3 Bajo (Teatro Hair&Care) ', 'Madrid', 'Madrid', '28004', 'España', 17.50, 0, '2025-01-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100125-bBjaIGw2JkJLm-108', '76dffbdd-9ef4-4796-8d80-573d3f8fd148', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-bBjaIGw2JkJLm-108&s=KOL2025&nf=P6055&i=17.50&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6440, 1, 120, 2, 0, NULL, 0, '2025-01-10 07:00:12', '2025-01-10 08:47:57', '2025-01-10', 'P6056', '25-07892-01-10', '', 0.00, 154.70, 32.49, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 187.19, 0, '2025-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100125-NiZoPkfbPsiCX-172', '716a7100-e6d6-43c1-b12e-0317c316f194', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-NiZoPkfbPsiCX-172&s=KOL2025&nf=P6056&i=187.19&cr=019', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6441, 1, 527, 2, 0, NULL, 0, '2025-01-10 08:14:31', '2025-01-10 09:47:28', '2025-01-10', 'P6057', '25-07893-01-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paseo Alameda 39 C31', 'Valencia', 'Valencia', '46023', 'España', 30.61, 0, '2025-01-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100125-Ysn1RXQzpmMTe-157', '5bf57f4e-dad5-4761-b8a0-9a9fddc2157a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-Ysn1RXQzpmMTe-157&s=KOL2025&nf=P6057&i=30.61&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6442, 1, 754, 2, 0, NULL, 0, '2025-01-10 09:16:45', '2025-01-10 10:35:04', '2025-01-10', 'P6058', '25-07894-01-10', '6+1 gratis Regalo color CASTAÑO CLARO', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2025-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100125-DRc5cKePpHsRZ-239', '06e0b8af-6295-4971-b42b-338e08b7672e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-DRc5cKePpHsRZ-239&s=KOL2025&nf=P6058&i=61.64&cr=162', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6443, 1, 1051, 2, 0, NULL, 0, '2025-01-10 09:54:05', '2025-01-10 11:17:02', '2025-01-10', 'P6059', '25-07895-01-10', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Pedro Pérez Fernández, 13 -5°', 'Sevilla', 'Sevilla', '41011', 'España', 17.50, 0, '2025-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100125-b8BZ4WNLbkClg-017', '862f312a-0fbb-4ab9-8d91-89700882674c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-b8BZ4WNLbkClg-017&s=KOL2025&nf=P6059&i=17.50&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6444, 1, 634, 2, 0, NULL, 0, '2025-01-10 09:59:20', '2025-01-10 11:19:03', '2025-01-10', 'P6060', '25-07896-01-10', 'Sobre las 2 del mediodía ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Río Duero 52', 'Aldeamayor de San Ma', 'Valladolid', '47162', 'España', 28.39, 0, '2025-01-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100125-XDEUq2+50fxyU-241', '1ccd04d7-d09e-48b7-a87d-fd52e01e044f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-XDEUq2%2B50fxyU-241&s=KOL2025&nf=P6060&i=28.39&cr=219', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6445, 1, 1430, 1, 0, NULL, 0, '2025-01-10 11:36:56', '2025-01-10 11:36:56', '2025-01-10', 'P6061', '2025-01-10', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Carrer Rei en Jaume 90, bajo', 'Vila-real', 'Castellón', '12540', 'España', 206.91, 0, '2025-01-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100125-Nv4yP89M0EzOb-110', 'e961d3c0-1b3c-448e-b813-1a4b5dfd4d37', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-Nv4yP89M0EzOb-110&s=KOL2025&nf=P6061&i=206.91&cr=238', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6446, 1, 166, 1, 0, NULL, 0, '2025-01-10 12:17:09', '2025-01-10 12:17:09', '2025-01-10', 'P6062', '', '', 0.00, 42.90, 9.01, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 51.91, 0, '2025-01-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100125-W3oUJIh7akztw-239', 'e7eea293-0959-4ab8-8ab5-fc4d896cab2c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-W3oUJIh7akztw-239&s=KOL2025&nf=P6062&i=51.91&cr=087', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6447, 1, 733, 2, 0, NULL, 0, '2025-01-10 12:59:32', '2025-01-13 08:28:51', '2025-01-13', 'P6063', '25-07900-01-10', '', 0.00, 86.64, 18.20, 0.00, 0, 0.00, 0.00, 'Calle Miguel Ángel, 8 - 4ª planta, 402', 'Madrid', 'Madrid', '28010', 'España', 104.83, 0, '2025-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-VSbs9AFO087Cy-014', '7ba79a5c-77ca-49a6-8aac-a6918124de32', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-VSbs9AFO087Cy-014&s=KOL2025&nf=P6063&i=104.83&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6448, 1, 1449, 2, 0, NULL, 0, '2025-01-10 13:09:26', '2025-01-13 08:30:38', '2025-01-13', 'P6077', '25-07901-01-10', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'Calle olimpiadas 13', 'Ejido (El)', 'Almería', '04700', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-130125-dBntWKsKNMDSk-187', 'df387a31-7bce-4503-bc69-cb9074145687', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-dBntWKsKNMDSk-187&s=KOL2025&nf=P6077&i=174.93&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6449, 1, 1088, 2, 0, NULL, 0, '2025-01-10 13:20:42', '2025-01-13 08:32:26', '2025-01-13', 'P6064', '25-07902-01-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'San Inazio Kalea, 17  2.ctro', 'Beasain', 'Gipuzkoa', '20200', 'España', 30.61, 0, '2025-01-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130125-fOfT4UzT3ugcD-000', 'da2c56df-f487-42ec-bbfe-3ea3b1699580', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-fOfT4UzT3ugcD-000&s=KOL2025&nf=P6064&i=30.61&cr=209', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6450, 1, 1251, 2, 0, NULL, 0, '2025-01-10 13:32:16', '2025-01-13 08:34:58', '2025-01-13', 'P6078', '25-07903-01-10', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'santa Clara 38 local peluqueria', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 241.40, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130125-UXQ3tTQM2h+z5-058', '1d55b1cb-d712-4a48-bd0b-3dcc43a46294', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-UXQ3tTQM2h%2Bz5-058&s=KOL2025&nf=P6078&i=241.40&cr=196', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6451, 1, 40, 2, 0, NULL, 0, '2025-01-10 14:10:54', '2025-01-13 08:35:41', '2025-01-13', 'P6065', '25-07904-01-10', 'lunes por la mañana cerrado estare a las 2 tarde ', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 103.46, 0, '2025-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-XCl2idkPrUkto-143', 'df217076-8129-4176-a7ef-c8fa18e917e6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-XCl2idkPrUkto-143&s=KOL2025&nf=P6065&i=103.46&cr=236', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6452, 1, 605, 2, 0, NULL, 0, '2025-01-10 16:37:14', '2025-01-13 08:36:52', '2025-01-13', 'P6066', '25-07906-01-10', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'PASEO DE LOS OLMOS  30 - 8º DCHA', 'Donostia-San Sebasti', 'Gipuzkoa', '20016', 'España', 71.98, 0, '2025-01-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-SQIFgOyYoozYP-209', 'd4ed7824-fb05-42ce-9134-7dbd4511a55f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-SQIFgOyYoozYP-209&s=KOL2025&nf=P6066&i=71.98&cr=255', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6453, 1, 1609, 2, 0, NULL, 0, '2025-01-10 19:09:32', '2025-01-13 08:37:53', '2025-01-13', 'P6067', '25-07907-01-10', 'Se puede dejar en porteria de 9 a 13\r\n', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Mirakontxa 10-8 a', 'Donostia-San Sebasti', 'Gipuzkoa', '20007', 'España', 56.82, 0, '2025-01-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130125-fVgedZFc2CIGz-099', 'da14d174-b328-4f59-aecf-0b419b15790d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-fVgedZFc2CIGz-099&s=KOL2025&nf=P6067&i=56.82&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6454, 1, 337, 2, 0, NULL, 0, '2025-01-11 08:32:24', '2025-01-13 08:41:16', '2025-01-13', 'P6079', '25-07908-01-11', '', 0.00, 65.12, 13.68, 0.00, 0, 0.00, 0.00, 'Santiago Lapuente 5', 'Zaragoza', 'Zaragoza', '50014', 'España', 78.80, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130125-Y+0PT4ymgXpNH-136', '97d4eeaf-426a-458f-a798-c6484bdaa863', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-Y%2B0PT4ymgXpNH-136&s=KOL2025&nf=P6079&i=78.80&cr=241', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6455, 1, 1444, 2, 0, NULL, 0, '2025-01-11 09:03:19', '2025-01-13 08:42:45', '2025-01-13', 'P6068', '25-07909-01-11', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Pintor Zubiri 4 trasera', 'Pamplona/Iruña', 'Navarra', '31008', 'España', 103.46, 0, '2025-01-11 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130125-e9hHQ2Z2H+Oev-115', '94c3d2fb-8774-45e1-9153-ed44e9b59846', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-e9hHQ2Z2H%2BOev-115&s=KOL2025&nf=P6068&i=103.46&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6456, 1, 754, 2, 0, NULL, 0, '2025-01-11 11:12:47', '2025-01-13 08:43:50', '2025-01-13', 'P6069', '25-07910-01-11', '6+1 REGALO otro sobre de castaño claro.\r\ngracias', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2025-01-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-A7oCnfKNi4/eg-138', '80e28b5b-aa21-49a6-b436-fb2229dc8755', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-A7oCnfKNi4%2Feg-138&s=KOL2025&nf=P6069&i=61.64&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6457, 1, 439, 2, 0, NULL, 0, '2025-01-11 13:34:36', '2025-01-13 08:47:13', '2025-01-13', 'P6070', '25-07911-01-11', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Jose luis isasi 10, 4A', 'Vitoria-Gasteiz', 'Álava', '01006', 'España', 43.71, 0, '2025-01-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-THqdrW1cfeec8-017', 'ff8ec359-bbaf-419c-bac5-33e4c18ad0bb', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-THqdrW1cfeec8-017&s=KOL2025&nf=P6070&i=43.71&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6458, 1, 1610, 2, 0, NULL, 0, '2025-01-11 18:18:08', '2025-01-13 08:48:18', '2025-01-13', 'P6071', '25-07912-01-11', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Pajarete 20', 'Alhaurín de la Torre', 'Málaga', '29130', 'España', 28.39, 0, '2025-01-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-fwqnxHoWtu4lu-006', 'a59986cc-5ca2-4574-ac07-636846258cd6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-fwqnxHoWtu4lu-006&s=KOL2025&nf=P6071&i=28.39&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6459, 1, 17, 2, 0, NULL, 0, '2025-01-12 10:41:55', '2025-01-13 08:49:33', '2025-01-13', 'P6072', '25-07913-01-12', '', 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, '2025-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-XQoR5DNe633aR-209', '06b7d398-0b0c-4634-bdf8-0dbae34a8fac', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-XQoR5DNe633aR-209&s=KOL2025&nf=P6072&i=137.94&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6460, 1, 1206, 2, 0, NULL, 0, '2025-01-12 15:43:41', '2025-01-13 08:50:23', '2025-01-13', 'P6073', '25-07914-01-12', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Kale Nagusia 69 ', 'Arbizu', 'Navarra', '31839', 'España', 30.61, 0, '2025-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-MRTMRucz+iKC4-142', 'a6d606b0-0aa6-4611-970b-91c86e4ff16d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-MRTMRucz%2BiKC4-142&s=KOL2025&nf=P6073&i=30.61&cr=203', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6461, 1, 1341, 2, 0, NULL, 0, '2025-01-12 23:13:08', '2025-01-13 08:51:29', '2025-01-13', 'P6074', '25-07916-01-12', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Avd ferrocarril n54 bajo', 'Coruña (A)', 'A Coruña', '15008', 'España', 68.97, 0, '2025-01-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-f0bGrKcy6XS09-129', '50c20e39-c3e5-43b7-bd9b-0ddae8e0e1ae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-f0bGrKcy6XS09-129&s=KOL2025&nf=P6074&i=68.97&cr=175', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6462, 1, 1134, 1, 0, NULL, 0, '2025-01-13 08:26:35', '2025-01-13 08:53:03', '2025-01-13', 'P6075', '', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Aoiz 14, bajo.   ', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 68.97, 0, '2025-01-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130125-I0IbdrnKQNIUe-219', '2772b170-8d51-4b7c-8285-eebf0545c979', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-I0IbdrnKQNIUe-219&s=KOL2025&nf=P6075&i=68.97&cr=061', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6463, 1, 784, 2, 0, NULL, 0, '2025-01-13 07:29:05', '2025-01-13 08:52:35', '2025-01-13', 'P6076', '25-07917-01-13', '', 0.00, 150.64, 31.63, 0.00, 1, 7.83, 0.00, 'Calle san francisco 30 bis bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20002', 'España', 190.10, 0, '2025-01-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130125-e+cjW01fahO6f-113', 'eb08a978-4987-454d-abbe-7e473196ab6f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-e%2BcjW01fahO6f-113&s=KOL2025&nf=P6076&i=190.10&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6464, 1, 120, 2, 0, NULL, 0, '2025-01-13 11:03:35', '2025-01-13 12:09:37', '2025-01-13', 'P6080', '25-07918-01-13', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'askatasun etorbidea 14 bajo durango', 'Durango', 'Bizkaia', '48200', 'España', 68.97, 0, '2025-01-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-X62jULH8N1zTs-022', 'f41cd064-7759-4dfc-b2e1-45c423a336b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-X62jULH8N1zTs-022&s=KOL2025&nf=P6080&i=68.97&cr=249', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6465, 1, 190, 3, 0, NULL, 0, '2025-01-13 12:40:43', '2025-01-13 12:40:43', '2025-01-13', '', 'Consumo interno', '', 0.00, 2198.40, 461.66, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 2660.06, 0, '2025-01-13 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6466, 1, 135, 2, 0, NULL, 0, '2025-01-13 11:50:21', '2025-01-13 13:08:52', '2025-01-13', 'P6081', '25-07919-01-13', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'C/ Moraza N15', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130125-PhAHOpAViyxJE-213', 'f679c94b-4d53-4776-a0ff-66fb2cfa60d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-PhAHOpAViyxJE-213&s=KOL2025&nf=P6081&i=275.88&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6467, 1, 221, 2, 0, NULL, 0, '2025-01-13 14:05:44', '2025-01-13 16:19:04', '2025-01-13', 'P6082', '25-07920-01-13', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'calle juan muñoz 56', 'Leganés', 'Madrid', '28911', 'España', 206.91, 0, '2025-01-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130125-Qa+M994rtOxAR-046', '4e6f249b-0b42-43a3-88e2-1f2acbc86c90', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130125-Qa%2BM994rtOxAR-046&s=KOL2025&nf=P6082&i=206.91&cr=059', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6468, 1, 1611, 2, 0, NULL, 0, '2025-01-13 16:57:44', '2025-01-14 09:06:18', '2025-01-14', 'P6083', '25-07921-01-13', '', 0.00, 32.49, 11.61, 0.00, 0, 0.00, 27.57, '6 Hither Wore', 'Abingdon', 'Oxfordshire ', 'OX14 2BG', 'Reino Unido', 66.88, 0, '2025-01-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140125-VrkfYu9jfd3Xs-008', '0ee3f957-b53b-441a-b048-fd51c59cf4bf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-VrkfYu9jfd3Xs-008&s=KOL2025&nf=P6083&i=66.88&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6469, 1, 167, 1, 0, NULL, 0, '2025-01-14 10:15:40', '2025-01-14 10:15:40', '2025-01-14', 'P6084', '', '', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 88.67, 0, '2025-01-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140125-I1rwlIzAdzN16-041', 'cd4ab347-c82b-43c9-b6a5-6ef78afa3eca', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-I1rwlIzAdzN16-041&s=KOL2025&nf=P6084&i=88.67&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6470, 1, 152, 1, 0, NULL, 0, '2025-01-14 10:52:59', '2025-01-14 11:01:57', '2025-01-14', 'P6085', '2025-01-14', '', 0.00, 270.27, 56.76, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 327.03, 0, '2025-01-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140125-eSs8R7gBck1wV-064', '6794ec2e-b76d-4df7-9524-bb6b243d91ed', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-eSs8R7gBck1wV-064&s=KOL2025&nf=P6085&i=327.02&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6471, 1, 248, 2, 0, NULL, 0, '2025-01-14 10:31:00', '2025-01-14 11:40:42', '2025-01-14', 'P6086', '25-07922-01-14', '', 0.00, 73.26, 15.82, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 91.14, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-140125-RgvayJnwrqCgK-093', '591f2f69-a838-4842-987d-c862a2cbab7a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-RgvayJnwrqCgK-093&s=KOL2025&nf=P6086&i=91.14&cr=152', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6472, 1, 1612, 2, 0, NULL, 0, '2025-01-14 11:07:21', '2025-01-14 11:07:21', '2025-01-14', '', '25-07923-01-14', NULL, 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'urdaneta 6', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 1, 4, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(6473, 1, 190, 2, 0, NULL, 0, '2025-01-14 11:09:28', '2025-01-14 11:09:28', '2025-01-14', '', '25-07924-01-14', NULL, 0.00, 28.50, 6.75, 0.00, 0, 0.00, 4.40, 'illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 38.89, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6474, 1, 686, 2, 0, NULL, 0, '2025-01-14 12:22:38', '2025-01-14 13:38:16', '2025-01-14', 'P6087', '25-07925-01-14', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'calle del parque 3 .  UDARA', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 206.91, 0, '2025-01-14 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140125-Esvg3mcglyAxc-174', '285a7df3-9852-4adb-962f-14a4a1aa646a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-Esvg3mcglyAxc-174&s=KOL2025&nf=P6087&i=206.91&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6475, 1, 1064, 2, 0, NULL, 0, '2025-01-14 14:14:44', '2025-01-14 16:01:11', '2025-01-14', 'P6088', '25-07926-01-14', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Calle Lorenzo Cendra Busca', 'Málaga', 'Málaga', '29007', 'España', 241.40, 0, '2025-01-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140125-fh/YwtGEM+u2Y-186', 'e1ef48cd-a11f-4c8a-b0ce-8ac5459227c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-fh%2FYwtGEM%2Bu2Y-186&s=KOL2025&nf=P6088&i=241.40&cr=112', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6476, 1, 174, 2, 0, NULL, 0, '2025-01-14 15:25:59', '2025-01-14 17:53:53', '2025-01-14', 'P6089', '25-07927-01-14', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 103.46, 0, '2025-01-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140125-OMRteseL3wiHw-033', 'b21f0774-83be-43e1-af1c-e797f2cbcf74', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-OMRteseL3wiHw-033&s=KOL2025&nf=P6089&i=103.46&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6477, 1, 1613, 2, 0, NULL, 0, '2025-01-14 15:36:33', '2025-01-15 09:38:55', '2025-01-14', 'P6093', '25-07928-01-14', '', 0.00, 64.98, 14.08, 0.00, 0, 0.00, 2.50, 'Paseo Salamanca n 12-1 izquierda', 'Donostia-San Sebasti', 'Gipuzkoa', '20003', 'España', 81.13, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-140125-YU9kyJHIsDgu4-054', 'a342420f-f3cc-4086-87dc-bb804bf01c6c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140125-YU9kyJHIsDgu4-054&s=KOL2025&nf=P6093&i=81.13&cr=237', '[BLOB]', 0, 'PRANHY071000004J', '2025-01-15 09:39:01', '[BLOB]', 2, '', '2025-01-15', 'S0133', 15, 20, 5, 600, 0, '', 1, 1);
