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
(4695, 1, 1193, 2, 0, NULL, 0, '2024-03-05 09:08:15', '2024-03-05 10:20:09', '2024-03-05', 'P4394', '24-05975-03-05', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Carrer Sant Jaume n. 37 (casa)', 'Sant Iscle de Vallal', 'Barcelona', '08359 ', 'España', 28.39, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050324-pG73kIMa5uUcR-185', '41fb3692-0a97-4eae-a5a8-b7c55eb791e1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050324-pG73kIMa5uUcR-185&s=KOL2024&nf=P4394&i=28.39&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4696, 1, 951, 2, 0, NULL, 0, '2024-03-05 09:09:01', '2024-03-05 10:18:33', '2024-03-05', 'P4391', '24-05974-03-05', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'calle pedro rico 27, escalera 1.6 A', 'Madrid', 'Madrid', '28029', 'España', 17.50, 0, '2024-03-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050324-BRqPVUKUj2+TW-154', 'a5d53b29-e74b-42a1-9e85-456bbb65c614', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050324-BRqPVUKUj2%2BTW-154&s=KOL2024&nf=P4391&i=17.50&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4697, 1, 976, 2, 0, NULL, 0, '2024-03-05 12:04:41', '2024-03-06 09:42:32', '2024-03-06', 'P4395', '24-05976-03-06', 'Entrada por avenida de arteixo peluquería Néstor Savi', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Bolivia n1 bajo puerta 3', 'Coruña (A)', 'A Coruña', '15004', 'España', 103.46, 0, '2024-03-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060324-MXJwzH2hKqivn-047', '3b94c79d-de2a-4ade-988d-ecb2eaf9d075', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060324-MXJwzH2hKqivn-047&s=KOL2024&nf=P4395&i=103.46&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4698, 1, 1194, 2, 0, NULL, 0, '2024-03-05 21:09:21', '2024-03-06 09:42:52', '2024-03-06', 'P4396', '24-05977-03-06', 'Llamar al teléfono 677853278 antes de entregar.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle LEON LEAL , 11, 3º D', 'Cáceres', 'Cáceres', '10002', 'España', 28.39, 0, '2024-03-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060324-nPApECf2qqDBT-101', '958727bd-f16f-4163-b03c-1549939dcebd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060324-nPApECf2qqDBT-101&s=KOL2024&nf=P4396&i=28.39&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4699, 1, 1184, 2, 0, NULL, 0, '2024-03-05 22:33:48', '2024-03-06 09:43:06', '2024-03-06', 'P4397', '24-05978-03-06', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Crta. Ant. De Málaga 115, Peluquería Almudena Mata', 'Granada', 'Granada', '18015', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-060324-E3WEFqm3V94Gc-160', '000aed3a-d8f2-4b0b-9b5f-cc9f97703b9c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060324-E3WEFqm3V94Gc-160&s=KOL2024&nf=P4397&i=20.00&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4700, 1, 77, 1, 0, NULL, 0, '2024-03-06 10:00:59', '2024-03-06 10:00:59', '2024-03-06', 'P4398', '2024-03-06', '', 0.00, 514.80, 108.11, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 622.91, 0, '2024-03-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060324-d2H1TJJl0r4IJ-032', '09c083c9-f610-464c-b500-9980f901ed4c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060324-d2H1TJJl0r4IJ-032&s=KOL2024&nf=P4398&i=622.91&cr=235', '[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
(4701, 1, 7, 1, 0, NULL, 0, '2024-03-06 12:32:48', '2024-03-06 12:32:48', '2024-03-06', 'P4399', '', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Uistin kalea 15', 'Lasarte-Oria', 'Gipuzkoa', '20160', 'España', 379.34, 0, '2024-03-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060324-NDbLxwzcBw1GL-124', 'efea8de0-5d80-47c7-8e91-ca1b9af64986', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060324-NDbLxwzcBw1GL-124&s=KOL2024&nf=P4399&i=379.34&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4702, 1, 1075, 2, 0, NULL, 0, '2024-03-06 11:46:24', '2024-03-06 12:49:21', '2024-03-06', 'P4400', '24-05979-03-06', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'General  Eguia 40', 'Bilbao', 'Bizkaia', '48012', 'España', 379.34, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060324-G4fMgFrp+/z/M-242', '43cdf8cb-fde8-4e84-b7f6-33720bd47d08', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060324-G4fMgFrp%2B%2Fz%2FM-242&s=KOL2024&nf=P4400&i=379.34&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4703, 1, 263, 2, 0, NULL, 0, '2024-03-07 08:51:08', '2024-03-07 09:52:47', '2024-03-07', 'P4401', '24-05981-03-07', 'Urbanización Quintaleja ', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle san Enrique de Ossó 123', 'Madrid', 'Madrid', '28055', 'España', 65.52, 0, '2024-03-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070324-IHJei/Rbdrlui-009', '7c81f9b5-712a-48f3-8e60-eb5d1224f020', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070324-IHJei%2FRbdrlui-009&s=KOL2024&nf=P4401&i=65.52&cr=251', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4704, 1, 154, 2, 0, NULL, 0, '2024-03-07 10:45:14', '2024-03-07 11:47:57', '2024-03-07', 'P4402', '24-05982-03-07', '', 0.00, 179.14, 37.62, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 216.76, 0, '2024-03-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070324-GssfVsgRYg238-110', '2c763dad-4c7d-45e4-b5e9-4c5be47d5551', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070324-GssfVsgRYg238-110&s=KOL2024&nf=P4402&i=216.76&cr=063', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4705, 1, 108, 2, 0, NULL, 0, '2024-03-07 11:19:28', '2024-03-07 12:26:04', '2024-03-07', 'P4403', '24-05984-03-07', '', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 78.82, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070324-CZBaoSNlxC1l/-207', 'a8573ab6-65f9-43d1-a5d5-7d37eb645fc2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070324-CZBaoSNlxC1l%2F-207&s=KOL2024&nf=P4403&i=78.81&cr=025', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4706, 1, 262, 2, 0, NULL, 0, '2024-03-07 12:17:55', '2024-03-08 08:42:31', '2024-03-08', 'P4404', '24-05985-03-07', '', 0.00, 118.06, 24.79, 0.00, 0, 0.00, 0.00, 'C/Doctor Fleming 38 2º1ª', 'Cassà de la Selva', 'Girona', '17244', 'España', 142.85, 0, '2024-03-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080324-FYUww8tDZuY0x-071', 'b5435f6a-ca8f-4cf2-8ee1-b2338a09bb4d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080324-FYUww8tDZuY0x-071&s=KOL2024&nf=P4404&i=142.85&cr=033', '[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
(4707, 1, 50, 2, 0, NULL, 0, '2024-03-07 13:02:15', '2024-03-08 08:45:57', '2024-03-08', 'P4405', '24-05986-03-07', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'CALLE ELTZETA 3, BAJO', 'LESAKA', 'NAVARRA', '31770', 'ESPAÑA', 68.97, 0, '2024-03-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080324-cjdmi4Mq5zR7d-153', '2a5d5189-62fd-4806-a42a-37fa9cc6777d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080324-cjdmi4Mq5zR7d-153&s=KOL2024&nf=P4405&i=68.97&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4708, 1, 1196, 2, 0, NULL, 0, '2024-03-07 14:03:31', '2024-03-08 08:47:24', '2024-03-08', 'P4406', '24-05987-03-07', 'Entrega de 8.30 a 14.30h', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Cl Ciudadela s/ n oficina Laboral Kutxa', 'Bilbao', 'Bizkaia', '48002', 'España', 17.50, 0, '2024-03-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080324-AKPzivnjzwmqV-228', 'b7e90483-1050-4b8b-b53a-9958f6189223', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080324-AKPzivnjzwmqV-228&s=KOL2024&nf=P4406&i=17.50&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4709, 1, 166, 1, 0, NULL, 0, '2024-03-08 08:53:07', '2024-03-08 08:54:44', '2024-03-08', 'P4407', '', '', 0.00, 128.70, 27.03, 0.00, 1, 6.69, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 162.42, 0, '2024-03-08 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080324-m45wFlpo6D0HB-137', '624cf70a-793e-4bc7-a82c-94c560f6cee7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080324-m45wFlpo6D0HB-137&s=KOL2024&nf=P4407&i=162.41&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4710, 1, 1197, 2, 0, NULL, 0, '2024-03-08 13:59:09', '2024-03-11 09:39:12', '2024-03-11', 'P4408', '24-05988-03-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle El Maquinista de la General 25, Local (SG MULTISERVICIOS)', 'Zaragoza', 'Zaragoza', '50019', 'España', 17.50, 0, '2024-03-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110324-W8hj38TwGsbzF-185', '0c900eb2-488b-4e31-aa19-68575b1ca49a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110324-W8hj38TwGsbzF-185&s=KOL2024&nf=P4408&i=17.50&cr=001', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4711, 1, 1198, 2, 0, NULL, 0, '2024-03-08 18:30:00', '2024-03-11 09:39:22', '2024-03-11', 'P4409', '24-05989-03-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Avda de la Constitución, 73 Bajo', 'Don Benito', 'Badajoz', '06400', 'España', 17.50, 0, '2024-03-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110324-eIVAzBv8A0maR-100', 'ac29ec3d-03bf-420e-b7f7-8a083e46dc91', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110324-eIVAzBv8A0maR-100&s=KOL2024&nf=P4409&i=17.50&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4712, 1, 98, 2, 0, NULL, 0, '2024-03-09 09:10:24', '2024-03-11 09:39:33', '2024-03-11', 'P4415', '24-05990-03-09', '', 0.00, 61.06, 13.26, 0.00, 0, 0.00, 2.50, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 76.38, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-110324-Hpe6XQjiiP0hO-094', '46cf158f-4f38-4b84-8598-3ef3dd6bb437', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110324-Hpe6XQjiiP0hO-094&s=KOL2024&nf=P4415&i=76.38&cr=159', '[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
(4713, 1, 204, 2, 0, NULL, 0, '2024-03-09 13:59:45', '2024-03-11 09:38:17', '2024-03-11', 'P4410', '24-05991-03-09', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'nou 23 local 1', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 137.94, 0, '2024-03-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110324-X3Nh9liP+x1mA-153', '30bb3417-7db0-4ce1-b371-5ef341a1d243', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110324-X3Nh9liP%2Bx1mA-153&s=KOL2024&nf=P4410&i=137.94&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4714, 1, 712, 2, 0, NULL, 0, '2024-03-10 10:53:08', '2024-03-11 09:39:49', '2024-03-11', 'P4411', '24-05992-03-10', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Río Cubas 7 5°izda/5°dcha', 'Santander', 'Cantabria', '39004', 'España', 41.50, 0, '2024-03-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110324-PntMfIiE+UhV3-249', '61f8dd5e-55c3-444a-93ef-3ed74392753f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110324-PntMfIiE%2BUhV3-249&s=KOL2024&nf=P4411&i=41.50&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4715, 1, 1199, 2, 0, NULL, 0, '2024-03-10 11:29:59', '2024-03-11 09:39:59', '2024-03-11', 'P4412', '24-05993-03-10', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'MAINERROTA 7, 3D', 'Otxandio', 'Bizkaia', '48210', 'España', 17.50, 0, '2024-03-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-110324-Ex/ll8DYcJ8mp-213', 'ced46803-6fa3-4876-ad9d-228275aeee0f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110324-Ex%2Fll8DYcJ8mp-213&s=KOL2024&nf=P4412&i=17.50&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4716, 1, 1200, 2, 0, NULL, 0, '2024-03-10 18:06:15', '2024-03-11 09:40:13', '2024-03-11', 'P4413', '24-05994-03-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle de valleguerra, 7 Bajo derecha ', 'Madrid', 'Madrid', '28017', 'España', 30.61, 0, '2024-03-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110324-IMobsnMlmvbs6-010', '524a12c7-e6ea-4ccf-97c3-685a76095947', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110324-IMobsnMlmvbs6-010&s=KOL2024&nf=P4413&i=30.61&cr=130', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4717, 1, 834, 2, 0, NULL, 0, '2024-03-10 20:52:35', '2024-03-11 09:40:23', '2024-03-11', 'P4414', '24-05995-03-10', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Cami del Pinar s/n', 'Gavà', 'Barcelona', '08850', 'España', 28.39, 0, '2024-03-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110324-jaNv+agEo4YBS-190', 'a25095c7-e545-46bc-b2c8-cb34b9259b93', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110324-jaNv%2BagEo4YBS-190&s=KOL2024&nf=P4414&i=28.39&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4718, 1, 592, 2, 0, NULL, 0, '2024-03-11 15:37:24', '2024-03-12 09:08:50', '2024-03-12', 'P4421', '24-06000-03-11', 'Llamar antes de entrega', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Madrid', 'Madrid', 'Madrid', '28004', 'España', 17.50, 0, '2024-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120324-XgFTrmTMF4ABr-169', '0358e259-d089-44a2-910a-1a7967f25b51', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120324-XgFTrmTMF4ABr-169&s=KOL2024&nf=P4421&i=17.50&cr=045', '[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
(4719, 1, 696, 1, 0, NULL, 0, '2024-03-11 16:57:11', '2024-03-11 16:58:17', '2024-03-12', 'P4416', '', '', 0.00, 471.90, 99.10, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 571.00, 0, '2024-03-11 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120324-n2NFaIw5a1WW6-035', '7cb4ed70-89d7-43b9-8781-39b4f4325677', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120324-n2NFaIw5a1WW6-035&s=KOL2024&nf=P4416&i=571.00&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4720, 1, 733, 2, 0, NULL, 0, '2024-03-11 16:04:17', '2024-03-12 09:12:51', '2024-03-12', 'P4417', '24-06003-03-11', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Calle Miguel Ángel, 8 - 4ª planta, 402', 'Madrid', 'Madrid', '28010', 'España', 56.82, 0, '2024-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120324-BCqlbOxOA1Xp9-205', '18eb4886-8f70-4fdd-ad14-ad9ee4b44056', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120324-BCqlbOxOA1Xp9-205&s=KOL2024&nf=P4417&i=56.82&cr=110', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4721, 1, 1201, 2, 0, NULL, 0, '2024-03-11 16:10:48', '2024-03-12 09:14:16', '2024-03-12', 'P4418', '24-06006-03-11', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Gregal (Urbanización Altero Mompoi) 8 Urbanizacion altero de mompoy', 'Picassent', 'Valencia', '46220', 'España', 17.50, 0, '2024-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120324-eZ5FpObAFWtT5-069', '63398686-d8b7-4039-8bfb-7d33b30b8dde', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120324-eZ5FpObAFWtT5-069&s=KOL2024&nf=P4418&i=17.50&cr=036', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4722, 1, 635, 2, 0, NULL, 0, '2024-03-11 19:19:15', '2024-03-12 09:23:57', '2024-03-12', 'P4419', '24-06007-03-11', 'SI EL LOCAL ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703 (ESTOY AL LADO). GRACIAS.', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 137.94, 0, '2024-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120324-iYJIUb4O7DKDN-105', 'c0289edc-d1c8-430a-b572-093329055ef7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120324-iYJIUb4O7DKDN-105&s=KOL2024&nf=P4419&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),
(4723, 1, 1035, 2, 0, NULL, 0, '2024-03-11 19:21:09', '2024-03-12 09:26:16', '2024-03-12', 'P4420', '24-06008-03-11', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Ronda Josep Anselm Clavé 2.3-3', 'Canet de Mar', 'Barcelona', '08360', 'España', 52.39, 0, '2024-03-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120324-A1Vt+hiD35aXN-202', '5cc08924-797d-4c6f-85e2-829738d2a1c2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120324-A1Vt%2BhiD35aXN-202&s=KOL2024&nf=P4420&i=52.39&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4724, 1, 331, 2, 0, NULL, 0, '2024-03-12 08:56:14', '2024-03-12 10:09:23', '2024-03-12', 'P4422', '24-06009-03-12', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Plaza Historiador Francisco Domenech 10', 'Caudete', 'Albacete', '02660', 'España', 65.52, 0, '2024-03-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120324-gcEA7MO4Pni7E-154', '2becf057-48e7-4cea-b725-2b3b1a46ca36', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120324-gcEA7MO4Pni7E-154&s=KOL2024&nf=P4422&i=65.52&cr=000', '[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
(4725, 1, 10, 2, 0, NULL, 0, '2024-03-12 10:08:10', '2024-03-12 11:20:42', '2024-03-12', 'P4423', '24-06010-03-12', '', 0.00, 289.04, 60.70, 0.00, 0, 0.00, 0.00, 'Agirre auzunea 1 behea', 'Azpeitia', 'Gipuzkoa', '20730', 'España', 349.74, 0, '2024-03-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120324-D8asSCluswEIm-182', '6c08016e-5432-48cc-bcbd-e26573d9cd84', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120324-D8asSCluswEIm-182&s=KOL2024&nf=P4423&i=349.74&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4726, 1, 912, 2, 0, NULL, 0, '2024-03-12 11:15:34', '2024-03-12 12:19:38', '2024-03-12', 'P4424', '24-06011-03-12', '', 0.00, 52.32, 10.99, 0.00, 0, 0.00, 0.00, 'Vid 2 ', 'Almagro', 'Ciudad Real', '13270', 'España', 63.31, 0, '2024-03-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120324-iNoRQpZfXkROP-067', '87bd6ea3-f1b3-45bf-b001-f1888a390247', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120324-iNoRQpZfXkROP-067&s=KOL2024&nf=P4424&i=63.31&cr=072', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4727, 1, 11, 2, 0, NULL, 0, '2024-03-12 15:16:03', '2024-03-13 09:21:28', '2024-03-13', 'P4426', '24-06012-03-12', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'calle Colomeres 36 local 2', 'Gavà', 'Barcelona', '08840', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130324-mC9BB0ywKVyOq-139', '01e7b86e-d6a0-4cd8-9eaf-0e4e5b98caec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130324-mC9BB0ywKVyOq-139&s=KOL2024&nf=P4426&i=137.94&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4728, 1, 11, 2, 0, NULL, 0, '2024-03-12 17:25:02', '2024-03-12 17:25:02', '2024-03-12', '', '24-06014-03-12', NULL, 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'calle Colomeres 36 local 2', 'Gavà', 'Barcelona', '08840', 'España', 137.94, 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),
(4729, 1, 698, 2, 0, NULL, 0, '2024-03-13 06:16:57', '2024-03-13 09:21:42', '2024-03-13', 'P4425', '24-06015-03-13', 'Entregar en el mostrador de información de la universidad de deusto', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'avenida de las universidades 24', 'Bilbao', 'Bizkaia', '48007', 'España', 43.71, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130324-Ku0JAId7bOTiU-091', '177d81b5-bfc7-4dbe-8a55-e7095f347d73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130324-Ku0JAId7bOTiU-091&s=KOL2024&nf=P4425&i=43.71&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4730, 1, 23, 2, 0, NULL, 0, '2024-03-13 09:02:07', '2024-03-13 10:58:49', '2024-03-13', 'P4427', '24-06016-03-13', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 137.94, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130324-TJq95XonrO+kt-082', '1a332d57-1e72-4261-8fe0-03460ab6e6e7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130324-TJq95XonrO%2Bkt-082&s=KOL2024&nf=P4427&i=137.94&cr=007', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4731, 1, 1202, 2, 0, NULL, 0, '2024-03-13 10:16:55', '2024-03-13 11:24:17', '2024-03-13', 'P4428', '24-06017-03-13', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'PUJADA DE CAL REI 34', 'Porqueres', 'Girona', '17834', 'España', 56.82, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130324-RjUXROIP8HfG+-171', '4fcaa8b7-dc01-4ce4-b143-b4e6ff82d17d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130324-RjUXROIP8HfG%2B-171&s=KOL2024&nf=P4428&i=56.82&cr=082', '[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
(4732, 1, 522, 2, 0, NULL, 0, '2024-03-13 11:42:38', '2024-03-13 12:49:04', '2024-03-13', 'P4429', '24-06018-03-13', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 206.91, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130324-YNraSeUNwYqXL-106', 'ecc9bfe3-6f88-40c3-a300-f76acf5a9ef7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130324-YNraSeUNwYqXL-106&s=KOL2024&nf=P4429&i=206.91&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4733, 1, 556, 2, 0, NULL, 0, '2024-03-13 11:52:03', '2024-03-13 13:05:18', '2024-03-13', 'P4430', '24-06019-03-13', '', 0.00, 16.28, 4.18, 0.00, 0, 0.00, 4.40, 'Calle Izpizua bajo 5', 'Hernani', 'Gipuzkoa', '20120', 'España', 24.10, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130324-ke8QE6bS9F/NP-116', 'f8255828-ddf6-496c-ac78-2fed7fb005c7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130324-ke8QE6bS9F%2FNP-116&s=KOL2024&nf=P4430&i=24.10&cr=135', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4734, 1, 522, 2, 1, 'falta 1 producto por facrturar', 4732, '2024-03-13 12:55:15', '2024-03-13 12:55:15', '2024-03-13', 'R74', 'P4429 RECT.', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 206.91, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-130324-dSQTUDMAiDI6u-163', 'afb2c983-7bfe-46e4-9b0a-a610edc16d9f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130324-dSQTUDMAiDI6u-163&s=KOL2024&nf=R74&i=-206.91&cr=100', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4735, 1, 522, 1, 0, NULL, 0, '2024-03-13 12:59:55', '2024-03-13 13:00:14', '2024-03-13', 'P4431', '', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 206.91, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130324-FbnBgTX1XBQdL-015', '31093477-e681-43fe-befc-48f8709aad5f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130324-FbnBgTX1XBQdL-015&s=KOL2024&nf=P4431&i=206.91&cr=022', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4736, 1, 53, 2, 0, NULL, 0, '2024-03-13 12:44:35', '2024-03-14 10:11:56', '2024-03-14', 'P4439', '24-06020-03-13', '', 0.00, 85.50, 18.39, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 105.96, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-140324-He03/iYwEikbF-093', '8c352136-b172-4ca6-b3bb-e731418de67e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-He03%2FiYwEikbF-093&s=KOL2024&nf=P4439&i=105.96&cr=026', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4737, 1, 520, 2, 0, NULL, 0, '2024-03-13 15:03:39', '2024-03-14 09:44:07', '2024-03-14', 'P4432', '24-06021-03-13', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Calle Andreszar, 34, ZAR Peluqueria', 'Villava/Atarrabia', 'Navarra', '31610', 'España', 68.97, 0, '2024-03-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-140324-Si15E7Uk99geT-165', '279256fb-23cc-48e4-9df0-40cb731b9b3f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-Si15E7Uk99geT-165&s=KOL2024&nf=P4432&i=68.97&cr=182', '[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
(4738, 1, 4, 2, 0, NULL, 0, '2024-03-13 15:13:46', '2024-03-14 09:44:42', '2024-03-14', 'P4433', '24-06022-03-13', '', 0.00, 236.12, 49.59, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 285.71, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140324-F94CR9bKtL2K+-035', 'bb9599f0-e123-4590-8377-8df7410b6e70', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-F94CR9bKtL2K%2B-035&s=KOL2024&nf=P4433&i=285.70&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4739, 1, 68, 2, 0, NULL, 0, '2024-03-13 19:04:10', '2024-03-14 09:45:02', '2024-03-14', 'P4438', '24-06023-03-13', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'Julio cesar 148', 'Ejido (El)', 'Almería', '04700', 'España', 140.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-140324-C6sZKvaeA4toB-241', 'a9c2bdb0-5f02-44d5-a5c1-742d8937eb97', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-C6sZKvaeA4toB-241&s=KOL2024&nf=P4438&i=140.44&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4740, 1, 1203, 2, 0, NULL, 0, '2024-03-13 19:09:15', '2024-03-14 09:45:23', '2024-03-14', 'P4434', '24-06024-03-13', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'C/Cruz del Sur 20, 8 derecha', 'Madrid', 'Madrid', '28007', 'España', 56.82, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140324-W2KpP1Ht4bxB2-084', '9e6ebca4-f176-466e-ab4b-9edc1bdb1d1a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-W2KpP1Ht4bxB2-084&s=KOL2024&nf=P4434&i=56.82&cr=155', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4741, 1, 1204, 2, 0, NULL, 0, '2024-03-13 19:20:01', '2024-03-14 09:45:43', '2024-03-14', 'P4435', '24-06025-03-13', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Eustasio Amilibia 5  local 4 (clínica podológica)', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 65.52, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140324-EZBOzvLOJxuED-145', '02c36974-8b46-4bde-b870-77acc47fc3ff', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-EZBOzvLOJxuED-145&s=KOL2024&nf=P4435&i=65.52&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4742, 1, 1205, 2, 0, NULL, 0, '2024-03-13 21:12:18', '2024-03-14 09:45:56', '2024-03-14', 'P4436', '24-06026-03-13', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Moraña', 'Moraña', 'Pontevedra', '36660', 'España', 28.39, 0, '2024-03-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140324-ddhlHbZ23cou/-164', 'bbc87851-cbb7-486f-a509-c54580f1cb9f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-ddhlHbZ23cou%2F-164&s=KOL2024&nf=P4436&i=28.39&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4743, 1, 40, 2, 0, NULL, 0, '2024-03-14 08:35:04', '2024-03-14 09:46:15', '2024-03-14', 'P4437', '24-06027-03-14', 'martes cerrado y lunes por la mañana tambien', 0.00, 77.34, 16.24, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 93.58, 0, '2024-03-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140324-kHaCUddKETYU8-147', '75a84cf4-81da-4c65-a369-b1fc2b0c755a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-kHaCUddKETYU8-147&s=KOL2024&nf=P4437&i=93.58&cr=209', '[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
(4744, 1, 75, 2, 0, NULL, 0, '2024-03-14 10:14:38', '2024-03-14 11:37:43', '2024-03-14', 'P4440', '24-06028-03-14', 'Horario de martes a viernes de 10 a 19 ', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 103.46, 0, '2024-03-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140324-WqqewwnDctozO-119', '78e8acce-8733-4392-9882-9c3d2ee5f315', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-WqqewwnDctozO-119&s=KOL2024&nf=P4440&i=103.46&cr=101', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4745, 1, 57, 2, 0, NULL, 0, '2024-03-14 11:49:15', '2024-03-14 13:12:02', '2024-03-14', 'P4441', '24-06029-03-14', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 310.37, 0, '2024-03-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140324-hp60lgse4mRL4-253', '36d2b7f1-c098-45a1-b86e-edeccac3bd1c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140324-hp60lgse4mRL4-253&s=KOL2024&nf=P4441&i=310.37&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4746, 1, 754, 2, 0, NULL, 0, '2024-03-14 14:08:41', '2024-03-15 09:23:37', '2024-03-15', 'P4442', '24-06032-03-14', 'tal como quedamos 6+1 regalo otro rubio extraclaro.\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, '2024-03-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150324-TrqGFiYJzx/5o-015', '0bd4d73e-5ba8-4824-b945-dae38ff88088', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150324-TrqGFiYJzx%2F5o-015&s=KOL2024&nf=P4442&i=61.64&cr=154', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4747, 1, 220, 2, 0, NULL, 0, '2024-03-14 16:43:52', '2024-03-15 09:27:01', '2024-03-15', 'P4444', '24-06034-03-14', '', 0.00, 114.00, 24.37, 0.00, 0, 0.00, 2.50, 'Elkano kalea,18', 'Hernani', 'Gipuzkoa', '20120', 'España', 140.44, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-150324-G0YlJKMrNN8Jp-145', '6bce92e8-07c9-4470-bc1b-ce7ec83a0689', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150324-G0YlJKMrNN8Jp-145&s=KOL2024&nf=P4444&i=140.44&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4748, 1, 1108, 2, 0, NULL, 0, '2024-03-14 20:31:33', '2024-03-15 09:29:48', '2024-03-15', 'P4443', '24-06035-03-14', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Novena, 24, Vivienda unifamiliar', 'Madrid', 'Madrid', '28016', 'España', 17.50, 0, '2024-03-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-150324-Nr9rwfG6uHqQC-228', '2e01ee17-3e9e-4543-a08d-f0baa7de4f43', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150324-Nr9rwfG6uHqQC-228&s=KOL2024&nf=P4443&i=17.50&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4749, 1, 65, 2, 0, NULL, 0, '2024-03-15 09:34:07', '2024-07-17 13:17:41', '2024-03-15', 'P4445', '24-06037-03-15', '', 0.00, 916.06, 192.37, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 1108.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-150324-T0J+qkoEz8eva-140', '95b95c27-1782-43f3-820c-1c18e87e6dde', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-150324-T0J%2BqkoEz8eva-140&s=KOL2024&nf=P4445&i=1108.43&cr=208', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
