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
(6608, 1, 1648, 2, 0, NULL, 0, '2025-01-29 18:28:28', '2025-01-30 09:12:40', '2025-01-30', 'P6208', '25-08072-01-29', 'Cerrado lunes', 0.00, 168.00, 35.28, 0.00, 0, 0.00, 0.00, 'Lucano 30', 'Madrid', 'Madrid', '28022', 'España', 203.28, 0, '2025-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300125-Y5+kHf8FpkBrJ-058', '1a9b69cb-224c-4c84-8024-a87f0a3a3904', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300125-Y5%2BkHf8FpkBrJ-058&s=KOL2025&nf=P6208&i=203.28&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6609, 1, 4, 2, 0, NULL, 0, '2025-01-29 18:46:37', '2025-01-30 09:15:51', '2025-01-30', 'P6209', '25-08073-01-29', '', 0.00, 206.29, 43.32, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 249.61, 0, '2025-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300125-bQ0HZC17urE4j-189', '7ebdb7f7-2736-44e8-b3e2-a2ab5ccedf24', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300125-bQ0HZC17urE4j-189&s=KOL2025&nf=P6209&i=249.61&cr=080', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6610, 1, 453, 2, 0, NULL, 0, '2025-01-29 21:26:05', '2025-01-30 09:16:34', '2025-01-30', 'P6210', '25-08074-01-29', '', 0.00, 31.70, 7.42, 0.00, 0, 0.00, 4.40, 'Plaza Fray Luis Colomer numero 10 puerta 13', 'Valencia', 'Valencia', '46021', 'España', 42.76, 0, '2025-01-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-300125-fUHzgOy5AOb/G-041', 'fb6c46aa-baad-46e4-9bbd-9d1e97344735', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300125-fUHzgOy5AOb%2FG-041&s=KOL2025&nf=P6210&i=42.76&cr=095', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6611, 1, 77, 1, 0, NULL, 0, '2025-01-30 09:32:06', '2025-01-30 11:31:44', '2025-01-30', 'P6212', '', '', 0.00, 777.00, 163.17, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 940.17, 0, '2025-01-30 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-300125-eG9rnk/BqH9u5-048', 'aa013dc8-ef61-4ce6-88bc-f312a8e70054', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300125-eG9rnk%2FBqH9u5-048&s=KOL2025&nf=P6212&i=940.17&cr=053', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6612, 1, 110, 2, 0, NULL, 0, '2025-01-30 11:51:24', '2025-01-30 13:02:18', '2025-01-30', 'P6213', '25-08075-01-30', '', 0.00, 176.82, 37.57, 0.00, 0, 0.00, 2.50, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 216.45, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-300125-Stfh3ljjqliOu-161', '468acb04-c7a0-439e-a722-0e06b63d20f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-300125-Stfh3ljjqliOu-161&s=KOL2025&nf=P6213&i=216.45&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6613, 1, 1649, 2, 0, NULL, 0, '2025-01-30 13:39:06', '2025-01-31 09:09:53', '2025-01-31', 'P6214', '25-08077-01-30', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Aixin Zolua, 11-2ºB', 'Irun', 'Gipuzkoa', '20304', 'España', 31.50, 0, '2025-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310125-TsStbRqhxspL2-053', '8dbb59b9-5ba9-44ef-91b4-dbefbcd7d67f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-TsStbRqhxspL2-053&s=KOL2025&nf=P6214&i=31.50&cr=111', '[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
(6614, 1, 1650, 2, 0, NULL, 0, '2025-01-30 15:33:36', '2025-01-31 09:14:13', '2025-01-31', 'P6218', '25-08078-01-30', '', 0.00, 168.00, 35.28, 0.00, 0, 0.00, 0.00, 'Avenida Balaidos 70, Vigo', 'Vigo', 'Pontevedra', '36210', 'España', 203.28, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-310125-M0rmjUe4YgFQN-071', 'd6c0c58a-c47f-45a4-abd0-9eec3f4e9cfe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-M0rmjUe4YgFQN-071&s=KOL2025&nf=P6218&i=203.28&cr=163', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6615, 1, 1651, 2, 0, NULL, 0, '2025-01-30 15:35:30', '2025-01-30 15:35:30', '2025-01-30', '', '25-08078-01-30', '', 0.00, 168.00, 35.28, 0.00, 0, 0.00, 0.00, 'Avenida Balaidos 70, Vigo', 'Vigo', 'Pontevedra', '36210', 'España', 203.28, 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),
(6616, 1, 1652, 2, 0, NULL, 0, '2025-01-30 16:20:42', '2025-01-31 09:17:09', '2025-01-31', 'P6215', '25-08079-01-30', '', 0.00, 20.50, 5.07, 0.00, 0, 0.00, 4.40, 'Avenida de Madrid número ocho portal 3 primero C', 'Talamanca de Jarama', 'Madrid', '28160', 'España', 29.21, 0, '2025-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310125-aIaH2KpBM6wqh-050', 'd570bace-44f7-4434-8b96-98de54847069', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-aIaH2KpBM6wqh-050&s=KOL2025&nf=P6215&i=29.21&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6617, 1, 1531, 2, 0, NULL, 0, '2025-01-30 19:30:17', '2025-01-31 09:17:54', '2025-01-31', 'P6216', '25-08080-01-30', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Concepción Arenal 6 - 1° izquierda. Santa Cruz.', 'Oleiros', 'A Coruña', '15179', 'España', 31.50, 0, '2025-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310125-dUEi+VuWiZqJs-148', '88f96204-ca42-42ed-98df-40fb78371185', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-dUEi%2BVuWiZqJs-148&s=KOL2025&nf=P6216&i=31.50&cr=081', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6618, 1, 1647, 2, 0, NULL, 0, '2025-01-30 19:49:50', '2025-01-31 09:19:15', '2025-01-31', 'P6219', '25-08082-01-30', '', 0.00, 50.52, 11.04, 0.00, 0, 0.00, 2.50, 'Hernán Cortés 48', 'Villanueva de la Ser', 'Badajoz', '06700', 'España', 63.63, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-310125-NTeafBDCa/sj3-047', '41a3f346-38e0-4f25-a0c0-6a8cdccedff2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-NTeafBDCa%2Fsj3-047&s=KOL2025&nf=P6219&i=63.63&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6619, 1, 1227, 2, 0, NULL, 0, '2025-01-30 20:15:40', '2025-01-31 09:19:49', '2025-01-31', 'P6217', '25-08084-01-30', 'Entrega a partir de las 15:30 horas', 0.00, 56.00, 11.76, 0.00, 0, 0.00, 0.00, 'Calle los cantos 24 2° B', 'Alcorcón', 'Madrid', '28922', 'España', 67.76, 0, '2025-01-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310125-b5FQGoy+M9dns-083', '888542be-0e5b-404a-9b68-668a390cadf3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-b5FQGoy%2BM9dns-083&s=KOL2025&nf=P6217&i=67.76&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6620, 1, 152, 1, 0, NULL, 0, '2025-01-31 09:45:30', '2025-01-31 09:47:09', '2025-01-31', 'P6220', '', '', 0.00, 134.94, 28.34, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 163.28, 0, '2025-01-31 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-310125-UIFOxIZK+C6ce-105', '488ea8a9-e2e4-48d5-ad23-fdd8716bc23b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-UIFOxIZK%2BC6ce-105&s=KOL2025&nf=P6220&i=163.28&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 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
(6621, 1, 776, 2, 0, NULL, 0, '2025-01-31 09:55:02', '2025-01-31 10:57:12', '2025-01-31', 'P6221', '25-08085-01-31', 'Si no abren en el 10°C, tocar el timbre del 6°B.', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Calle Miguel Astrain 18, 10°C', 'Pamplona/Iruña', 'Navarra', '31006', 'España', 31.50, 0, '2025-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310125-R1dIcV878a92x-102', '1134d82d-8f36-4bb5-91fb-58afa4066e7a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-R1dIcV878a92x-102&s=KOL2025&nf=P6221&i=31.50&cr=212', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6622, 1, 1259, 2, 0, NULL, 0, '2025-01-31 10:06:43', '2025-01-31 11:19:10', '2025-01-31', 'P6222', '25-08086-01-31', '', 0.00, 11.20, 3.12, 0.00, 0, 0.00, 4.40, 'Calle Doctor Pedro Barceló 18, Bloque4, bajo izquierda', 'Málaga', 'Málaga', '29016', 'España', 17.95, 0, '2025-01-31 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-310125-ewvDjuZJLBQM4-174', '89fd08ce-7ec6-4edb-85e0-8eca366b9163', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-ewvDjuZJLBQM4-174&s=KOL2025&nf=P6222&i=17.95&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6623, 1, 1372, 2, 0, NULL, 0, '2025-01-31 10:33:09', '2025-01-31 11:52:44', '2025-01-31', 'P6223', '25-08087-01-31', 'DEPURADORA DE LOGROÑO', 0.00, 41.00, 9.37, 0.00, 0, 0.00, 4.40, 'CAMINO  MADRE DE DIOS 3', 'Logroño', 'La Rioja', '26006', 'España', 54.01, 0, '2025-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310125-TEIvxF2+Vm4p2-241', '297853b6-477c-408a-b931-f527d1074ed8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-TEIvxF2%2BVm4p2-241&s=KOL2025&nf=P6223&i=54.01&cr=000', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6624, 1, 87, 2, 0, NULL, 0, '2025-01-31 11:14:01', '2025-01-31 12:33:41', '2025-01-31', 'P6224', '25-08089-01-31', '', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'Cc arcco local p 17', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 142.63, 0, '2025-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310125-BI05d9innqE46-244', 'fa592762-ba1f-427d-9a88-0b8dbcce175b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-BI05d9innqE46-244&s=KOL2025&nf=P6224&i=142.63&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6625, 1, 166, 1, 0, NULL, 0, '2025-01-31 12:47:23', '2025-01-31 12:48:53', '2025-01-31', 'P6225', '2025-01-31', '', 0.00, 93.24, 19.58, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 112.82, 0, '2025-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-310125-dqNCeP0K9lU+9-168', 'cc4a0469-1d27-41a6-8c05-2e0914a95b8b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-dqNCeP0K9lU%2B9-168&s=KOL2025&nf=P6225&i=112.82&cr=126', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6626, 1, 166, 1, 1, 'El precio de uno de los productos está mal', 6625, '2025-01-31 12:52:43', '2025-01-31 12:53:02', '2025-01-31', 'R99', 'P6225 RECT.', '', 0.00, 93.24, 19.58, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 112.82, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-310125-eeLTGE3eTYjuq-150', '30487275-3b09-4ebb-9f18-a6fb2cf77633', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-eeLTGE3eTYjuq-150&s=KOL2025&nf=R99&i=-112.82&cr=244', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 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
(6627, 1, 166, 1, 0, NULL, 0, '2025-01-31 12:56:49', '2025-01-31 12:56:49', '2025-01-31', 'P6226', '2025-01-31', '', 0.00, 111.00, 23.31, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 134.31, 0, '2025-01-31 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-310125-DBIJ4/mK+XVxh-017', 'ad9be69b-cac5-4ef5-9eb0-4b324bdf41ad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-310125-DBIJ4%2FmK%2BXVxh-017&s=KOL2025&nf=P6226&i=134.31&cr=214', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6628, 1, 262, 2, 0, NULL, 0, '2025-01-31 14:06:45', '2025-02-03 09:18:08', '2025-02-03', 'P6227', '25-08091-01-31', '', 0.00, 46.31, 9.73, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 56.04, 0, '2025-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-KVEQajfHcFgPq-032', 'b6145d2d-0318-4d29-808d-be09d5c0cc7e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-KVEQajfHcFgPq-032&s=KOL2025&nf=P6227&i=56.04&cr=116', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6629, 1, 1532, 2, 0, NULL, 0, '2025-01-31 17:03:03', '2025-02-03 09:19:09', '2025-02-03', 'P6228', '25-08092-01-31', '', 0.00, 11.20, 3.12, 0.00, 0, 0.00, 4.40, 'Calle Carmen Conde n 9 2-A', 'Valdemoro', 'Madrid', '28342', 'España', 17.95, 0, '2025-01-31 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-HiF5B3vZfpHc3-055', '8054c608-1c99-48b3-86e8-84c8e17a2246', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-HiF5B3vZfpHc3-055&s=KOL2025&nf=P6228&i=17.95&cr=170', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6630, 1, 938, 2, 0, NULL, 0, '2025-02-01 10:10:19', '2025-02-03 09:19:49', '2025-02-03', 'P6229', '25-08095-02-01', '', 0.00, 20.50, 5.07, 0.00, 0, 0.00, 4.40, 'Comandante Fortea, 60, 60', 'Madrid', 'Madrid', '28008', 'España', 29.21, 0, '2025-02-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-R4Fza7S5WoCoQ-074', '3a54289f-23fe-4b9c-9c75-a930ed157679', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-R4Fza7S5WoCoQ-074&s=KOL2025&nf=P6229&i=29.21&cr=150', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6631, 1, 1653, 2, 0, NULL, 0, '2025-02-01 22:28:12', '2025-02-03 09:20:39', '2025-02-03', 'P6230', '25-08097-02-01', '', 0.00, 41.00, 9.37, 0.00, 0, 0.00, 4.40, 'Francisco de Rojas, 2. 2E', 'Madrid', 'Madrid', '28010', 'España', 54.01, 0, '2025-02-01 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-QNLtTitvYWLHB-113', '3157e4f8-0b14-4983-9733-344c93825363', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-QNLtTitvYWLHB-113&s=KOL2025&nf=P6230&i=54.01&cr=138', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6632, 1, 630, 2, 0, NULL, 0, '2025-02-02 10:25:02', '2025-02-03 09:21:39', '2025-02-03', 'P6231', '25-08099-02-02', 'AZULMARINO VIAJES (ENTREGA)', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'avenida de navarra 9 bajo', 'Beasain', 'Gipuzkoa', '20200', 'España', 31.50, 0, '2025-02-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-Mf38E+ipazUvK-080', '23b5500f-5960-4ad7-a35b-8caf7672beaf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-Mf38E%2BipazUvK-080&s=KOL2025&nf=P6231&i=31.50&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
(6633, 1, 878, 2, 0, NULL, 0, '2025-02-02 18:13:57', '2025-02-03 09:23:44', '2025-02-03', 'P6232', '25-08100-02-02', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Plaza Anzaran, 11 - 1Izda', 'Irun', 'Gipuzkoa', '20301', 'España', 31.50, 0, '2025-02-02 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-O0wt3pn5A3efy-252', '8943d171-a839-4f2f-867b-fd7a287508be', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-O0wt3pn5A3efy-252&s=KOL2025&nf=P6232&i=31.50&cr=082', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6634, 1, 1437, 2, 0, NULL, 0, '2025-02-02 20:47:00', '2025-02-03 09:24:50', '2025-02-03', 'P6234', '25-08101-02-02', '', 0.00, 20.50, 5.50, 0.00, 0, 0.00, 6.90, 'Tienda Bodegas Muga - Avda. Vizcaya - Acceso por la rotonda', 'Haro', 'La Rioja', '26200', 'España', 31.71, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-030225-RCXNn46IzjuOS-107', '528d2689-46f2-48bd-a2ca-4a21b0950f3b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-RCXNn46IzjuOS-107&s=KOL2025&nf=P6234&i=31.71&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6635, 1, 1336, 2, 0, NULL, 0, '2025-02-03 06:55:32', '2025-02-03 09:25:44', '2025-02-03', 'P6233', '25-08102-02-03', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Rua Uno Angustia número 84 ', 'Pobra do Caramiñal (', 'A Coruña', '15948', 'España', 31.50, 0, '2025-02-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-Dv66B7gkEyMku-132', 'fa74cc1c-5850-49c1-b4df-e224f602a78f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-Dv66B7gkEyMku-132&s=KOL2025&nf=P6233&i=31.50&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6636, 1, 1076, 2, 0, NULL, 0, '2025-02-03 08:29:42', '2025-02-03 09:30:50', '2025-02-03', 'P6235', '25-08103-02-03', 'Horario comercial', 0.00, 33.60, 7.82, 0.00, 0, 0.00, 4.40, 'Calle san Andrés, 3. Bajo', 'Estella/Lizarra', 'Navarra', '31200', 'España', 45.06, 0, '2025-02-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-PqBem0UIjkVFq-197', '9f6712a8-9d43-4c88-9363-d3409595d48b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-PqBem0UIjkVFq-197&s=KOL2025&nf=P6235&i=45.06&cr=123', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6637, 1, 248, 2, 0, NULL, 0, '2025-02-03 08:50:10', '2025-02-03 10:11:34', '2025-02-03', 'P6237', '25-08104-02-03', '', 0.00, 67.36, 14.58, 0.00, 0, 0.00, 2.50, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 84.01, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-030225-Z+eKG6OGTdxiz-197', 'e5cf012a-56e4-4c0a-9064-282b2a7c3a56', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-Z%2BeKG6OGTdxiz-197&s=KOL2025&nf=P6237&i=84.01&cr=157', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6638, 1, 754, 2, 0, NULL, 0, '2025-02-03 09:05:25', '2025-02-03 10:12:40', '2025-02-03', 'P6236', '25-08105-02-03', '6+1 GRATIS\r\nREGALO COLOR COBRE\r\nGRACIAS', 0.00, 50.52, 10.61, 0.00, 1, 2.63, 0.00, 'JOSEP TARRADELLAS 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 63.76, 0, '2025-02-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-U+M6Nk/EdZEMa-090', '7d1ba5a7-e27f-458f-9b1d-9d67ac122ca5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-U%2BM6Nk%2FEdZEMa-090&s=KOL2025&nf=P6236&i=63.76&cr=116', '[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
(6639, 1, 956, 2, 0, NULL, 0, '2025-02-03 09:29:05', '2025-02-03 10:39:39', '2025-02-03', 'P6238', '25-08106-02-03', '', 0.00, 147.35, 30.95, 0.00, 0, 0.00, 0.00, 'Santo Domingo 1 bajo', 'Vigo', 'Pontevedra', '36204', 'España', 178.29, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030225-Naq+LrNEQJk8d-068', '9f2f7eaa-1c3c-41f3-8e42-2bc22cad96ca', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-Naq%2BLrNEQJk8d-068&s=KOL2025&nf=P6238&i=178.29&cr=229', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6640, 1, 635, 2, 0, NULL, 0, '2025-02-03 09:48:49', '2025-02-03 10:59:37', '2025-02-03', 'P6239', '25-08107-02-03', 'SI ESTÁ CERRADO, LLAMAR POR FAVOR AL 620776703 (estoy al lado). GRACIAS.', 0.00, 206.29, 43.32, 0.00, 0, 0.00, 0.00, 'Plaza Rafael Alberti 8, Bajo 2, Peluquería Ecológica.', 'Ansoáin', 'Navarra', '31013', 'España', 249.61, 0, '2025-02-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030225-YSZ7KYbh3OupY-083', 'f0a85560-dfd1-488a-bc7e-2371fb1a8020', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-YSZ7KYbh3OupY-083&s=KOL2025&nf=P6239&i=249.61&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6641, 1, 152, 1, 1, 'error en precio de dúos', 6620, '2025-02-03 12:35:58', '2025-02-03 12:36:12', '2025-02-03', 'R100', 'P6220 RECT.', '', 0.00, 134.94, 28.34, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 163.28, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-030225-DSneJLV8lYo1w-194', '6534a7af-1545-489c-acbc-a1d262920307', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030225-DSneJLV8lYo1w-194&s=KOL2025&nf=R100&i=-163.28&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(6642, 1, 152, 1, 0, NULL, 0, '2025-02-03 12:41:27', '2025-02-03 12:41:27', '2025-02-04', 'P6240', '', '', 0.00, 133.14, 27.96, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 161.10, 0, '2025-02-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040225-N/ZYEd7+c+41h-123', 'd99deb46-17dc-4c05-8b7a-416069f0acad', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-N%2FZYEd7%2Bc%2B41h-123&s=KOL2025&nf=P6240&i=161.10&cr=104', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6643, 1, 1214, 2, 0, NULL, 0, '2025-02-03 15:34:26', '2025-02-04 09:10:13', '2025-02-04', 'P6241', '25-08108-02-03', '', 0.00, 41.00, 9.37, 0.00, 0, 0.00, 4.40, '`LAZA POETA AUSIAS MARCH NUM 20 PTA 1', 'Ontinyent', 'Valencia', '46870', 'España', 54.01, 0, '2025-02-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040225-c3t7AqK8pSP3V-165', '4697b924-a714-48e3-8914-b80f2daf636f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-c3t7AqK8pSP3V-165&s=KOL2025&nf=P6241&i=54.01&cr=017', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6644, 1, 1514, 2, 0, NULL, 0, '2025-02-03 16:44:22', '2025-02-04 09:10:58', '2025-02-04', 'P6242', '25-08109-02-03', 'Llamar antes de dejarlo al móvil por favor ', 0.00, 20.50, 5.07, 0.00, 0, 0.00, 4.40, 'Urbanización Casquero Calle N 4 C', 'Dos Hermanas', 'Sevilla', '41703', 'España', 29.21, 0, '2025-02-03 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040225-MSkC8Ojm/y0Lw-247', '5206f85b-b408-4cde-9532-be1d7462fa99', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-MSkC8Ojm%2Fy0Lw-247&s=KOL2025&nf=P6242&i=29.21&cr=245', '[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
(6645, 1, 1654, 2, 0, NULL, 0, '2025-02-03 17:34:00', '2025-02-04 09:12:03', '2025-02-04', 'P6243', '25-08110-02-03', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'C/Martín Luther King n 4-4A ', 'Vitoria-Gasteiz', 'Álava', '01015', 'España', 31.50, 0, '2025-02-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040225-T+WYLNmysUpxQ-107', '0e551d2a-4bd9-4728-ba52-be431adb886e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-T%2BWYLNmysUpxQ-107&s=KOL2025&nf=P6243&i=31.50&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6646, 1, 1655, 2, 0, NULL, 0, '2025-02-04 07:53:01', '2025-02-04 09:12:42', '2025-02-04', 'P6244', '25-08113-02-04', '', 0.00, 11.20, 3.12, 0.00, 0, 0.00, 4.40, 'Balejo 5 8A ', 'Barakaldo', 'Bizkaia', '48903', 'España', 17.95, 0, '2025-02-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040225-e+sTMnIkME01w-141', 'e0b3fc11-885b-478a-b68d-e482cafc88bf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-e%2BsTMnIkME01w-141&s=KOL2025&nf=P6244&i=17.95&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6647, 1, 76, 1, 0, NULL, 0, '2025-02-04 09:30:09', '2025-02-04 09:30:09', '2025-02-04', 'P6245', '', '', 0.00, 266.40, 55.94, 0.00, 0, 0.00, 0.00, 'VELLUTERS, 1 NAVE 1', 'PATERNA', 'VALENCIA', '46980', 'ESPAÑA', 322.34, 0, '2025-02-04 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040225-IF+SdKp9JFoCO-032', '2cdea626-d714-44a8-9a5f-f7b1816bce37', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-IF%2BSdKp9JFoCO-032&s=KOL2025&nf=P6245&i=322.33&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6648, 1, 1288, 2, 0, NULL, 0, '2025-02-04 09:22:18', '2025-02-04 10:28:33', '2025-02-04', 'P6246', '25-08114-02-04', '', 0.00, 11.20, 3.12, 0.00, 0, 0.00, 4.40, 'Bartolomé de Urdinso n°9 3°izd', 'Irun', 'Gipuzkoa', '20301', 'España', 17.95, 0, '2025-02-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040225-DhnBaqzwbYSIU-121', '96f9a9b7-46c2-4ab5-8bb8-d485d09a6702', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-DhnBaqzwbYSIU-121&s=KOL2025&nf=P6246&i=17.95&cr=232', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6649, 1, 522, 2, 0, NULL, 0, '2025-02-04 11:51:37', '2025-02-04 12:55:25', '2025-02-04', 'P6247', '25-08115-02-04', '', 0.00, 96.83, 20.33, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 117.16, 0, '2025-02-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040225-fgpPIxbW++kQ+-060', '7f8030b7-74cb-4160-95d4-3be157a118a1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-fgpPIxbW%2B%2BkQ%2B-060&s=KOL2025&nf=P6247&i=117.16&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6650, 1, 208, 2, 0, NULL, 0, '2025-02-04 11:58:42', '2025-02-04 13:02:19', '2025-02-04', 'P6248', '25-08116-02-04', '', 0.00, 29.47, 6.95, 0.00, 0, 0.00, 4.40, 'Calle Hernandez Lazaro n3, pta 5', 'Albal', 'Valencia', '46470', 'España', 40.06, 0, '2025-02-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040225-QHj1DQF5BvDrO-062', 'a7c187d5-1e77-41ab-bd35-c6156550711d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-QHj1DQF5BvDrO-062&s=KOL2025&nf=P6248&i=40.06&cr=015', '[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
(6651, 1, 1656, 2, 0, NULL, 0, '2025-02-04 12:25:57', '2025-02-04 15:36:15', '2025-02-04', 'P6249', '25-08117-02-04', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'carrer Sant Genis 4', 'Vilassar de Mar', 'Barcelona', '08340', 'España', 31.50, 0, '2025-02-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-040225-UgSiuXPKtVPTq-011', '27d02036-09a2-4752-98c8-c6654a88cad5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-UgSiuXPKtVPTq-011&s=KOL2025&nf=P6249&i=31.50&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6652, 1, 568, 2, 0, NULL, 0, '2025-02-04 12:41:46', '2025-02-04 15:37:05', '2025-02-04', 'P6251', '25-08125-02-04', '', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'larramendi 8', 'Donostia-San Sebasti', 'Gipuzkoa', '20006', 'España', 213.95, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-040225-W5WY7qTuoATPr-070', '30e19b34-b35e-4c39-b813-cfe9923e4f06', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-W5WY7qTuoATPr-070&s=KOL2025&nf=P6251&i=213.95&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6653, 1, 1330, 2, 0, NULL, 0, '2025-02-04 14:33:15', '2025-02-04 15:37:38', '2025-02-04', 'P6250', '25-08127-02-04', 'Si no hay nadie, deje debajo felpudo 4a, llamar antes de ir.617456401', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Avenida de Cádiz 27 4A', 'Sevilla', 'Sevilla', '41004', 'España', 31.50, 0, '2025-02-04 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-040225-DJnXNhg+rNdWC-193', '1c43b2e7-64bc-48bf-9725-6d66289497c3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-040225-DJnXNhg%2BrNdWC-193&s=KOL2025&nf=P6250&i=31.50&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6654, 1, 1296, 2, 0, NULL, 0, '2025-02-04 19:09:01', '2025-02-05 09:10:49', '2025-02-05', 'P6252', '25-08128-02-04', '', 0.00, 22.40, 5.47, 0.00, 0, 0.00, 4.40, 'Avd navarra 30', 'Lodosa', 'Navarra', '31580', 'España', 31.50, 0, '2025-02-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-050225-MYaqk8LsBVc3u-068', '8ad60d64-2d87-4d83-82ac-1f27f1ee5c4d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050225-MYaqk8LsBVc3u-068&s=KOL2025&nf=P6252&i=31.50&cr=165', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6655, 1, 391, 2, 0, NULL, 0, '2025-02-05 08:36:00', '2025-02-05 09:48:27', '2025-02-05', 'P6253', '25-08129-02-05', 'Peluquería \r\nCerrada lunes y jueves por tarde', 0.00, 58.94, 12.38, 0.00, 0, 0.00, 0.00, 'Paseo Santxiki num14', 'Pamplona/Iruña', 'Navarra', '31192', 'España', 71.32, 0, '2025-02-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-050225-JK0ulFJfWM6Kn-250', '9a06e969-5712-4993-8dc6-05ff5a75ff59', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050225-JK0ulFJfWM6Kn-250&s=KOL2025&nf=P6253&i=71.31&cr=121', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6656, 1, 152, 1, 0, NULL, 0, '2025-02-05 10:18:47', '2025-02-05 10:24:13', '2025-02-05', 'P6254', '', '', 0.00, 124.21, 26.08, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 150.29, 0, '2025-02-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050225-T92cAYFb6/jY3-022', '50e7982e-3542-4809-8e91-89c8adbeb78b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050225-T92cAYFb6%2FjY3-022&s=KOL2025&nf=P6254&i=150.29&cr=196', '[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
(6657, 1, 79, 1, 0, NULL, 0, '2025-02-05 10:53:45', '2025-02-05 10:53:45', '2025-02-05', 'P6255', '', '', 0.00, 206.29, 43.75, 0.00, 0, 0.00, 2.50, 'Calle María Paya 8, planta baja', 'Biar', 'Alicante', '03410', 'España', 252.11, 0, '2025-02-05 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-050225-Fx79pSFIGCxe5-045', '9e993420-90dc-4f87-acbe-20714c73994f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050225-Fx79pSFIGCxe5-045&s=KOL2025&nf=P6255&i=252.11&cr=119', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6658, 1, 1657, 2, 0, NULL, 0, '2025-02-05 11:28:03', '2025-02-05 12:28:55', '2025-02-05', 'P6256', '25-08131-02-05', '', 0.00, 20.50, 5.07, 0.00, 0, 0.00, 4.40, 'C/. Areso. 3.   2A', 'Lazkao', 'Gipuzkoa', '20210', 'España', 29.21, 0, '2025-02-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-050225-EOMw0++oJZsY8-211', '901cb9eb-08fb-44ed-80a7-d428485639f0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050225-EOMw0%2B%2BoJZsY8-211&s=KOL2025&nf=P6256&i=29.21&cr=106', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6659, 1, 1387, 2, 0, NULL, 0, '2025-02-05 13:53:15', '2025-02-06 08:28:48', '2025-02-06', 'P6257', '25-08132-02-05', '', 0.00, 147.35, 30.94, 0.00, 0, 0.00, 0.00, 'Calle monasterio de sigena 2 esc2 4D', 'Huesca', 'Huesca', '22005', 'España', 178.29, 0, '2025-02-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060225-Y98iNjCrA/6/I-070', '3e4dad24-0175-40a8-8ad6-ecc9a8066ff0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060225-Y98iNjCrA%2F6%2FI-070&s=KOL2025&nf=P6257&i=178.29&cr=201', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6660, 1, 1423, 2, 0, NULL, 0, '2025-02-05 14:48:20', '2025-02-06 08:32:49', '2025-02-06', 'P6258', '25-08133-02-05', '', 0.00, 265.23, 55.70, 0.00, 0, 0.00, 0.00, 'Avenida Ferrocarril 2b lonja, peluqueria Bilbo', 'Bilbao', 'Bizkaia', '48013', 'España', 320.93, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060225-GsWpHUQbfCbsm-037', 'd537049b-2e82-4b12-b754-d775e7705bb2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060225-GsWpHUQbfCbsm-037&s=KOL2025&nf=P6258&i=320.93&cr=041', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6661, 1, 145, 2, 0, NULL, 0, '2025-02-05 15:29:28', '2025-02-06 08:34:03', '2025-02-06', 'P6259', '25-08134-02-05', '', 0.00, 214.71, 45.52, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 262.30, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-060225-Gzna0s2aUIgKf-045', '27d84275-7850-4507-a8d7-49a1501d25d0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060225-Gzna0s2aUIgKf-045&s=KOL2025&nf=P6259&i=262.30&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6662, 1, 1605, 1, 0, NULL, 0, '2025-02-06 11:46:57', '2025-02-06 11:53:14', '2025-02-06', 'P6260', '', '', 0.00, 404.16, 84.87, 0.00, 0, 0.00, 0.00, 'San Joan 19. Esparreguera.  Barcelona', 'Esparreguera', 'Barcelona', '08092', 'España', 489.03, 0, '2025-02-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060225-dq3Q8/0+NdI9k-098', '7d382014-5f81-4f33-b644-83ff1a9169fe', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060225-dq3Q8%2F0%2BNdI9k-098&s=KOL2025&nf=P6260&i=489.03&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
