INSERT ejecutado exitosamente.
INSERT INTO asistencia_estudiante_pregrado_virtual WITH moodle AS ( SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.belindaevelyn.alarcon.aq@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.anderson.alvarado.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.sulmarosaura.alvarez.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.jhanelmarian.alvarez.pa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.joseguillermo.alvarez.sa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.deynarocio.amaru.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.fredyantony.apaza.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.denisselmiley.arguedas.yu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.michellnicoll.astoquilca.gu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.betsypamela.barraza.ja@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.marjorieshady.bellido.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.jhonatanroyer.blanco.ac@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.glendaestefany.cachicatari.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.oliverricardo.calamani.me@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.ghynaselena.calisaya.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.brandonsaul.calla.mo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.delia.calle.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.leonardodiego.ccallo.ri@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.germayhoninicol.chavez.li@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.analizyoshida.chavez.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.giulianastephanie.chihuantito.bu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.cristianreynaldo.choque.ve@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.evamilagros.choquejagua.ac@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.belen.colque.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.leslydiana.colqui.si@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.renzoanthony.colqui.si@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.luisalberto.condori.am@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.kiharakatsumi.condori.ya@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.arantzaanay.condori.yu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.brayanriver.conovilca.de@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.heydinohelia.cossio.su@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.lilian.coyo.ca@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.pierogabriel.cutimbo.to@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.shannymilagros.cutipa.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.ivansmijail.delgado.si@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.adriananicole.echave.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.cristhiangabriel.enriquez.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.stevenfabricio.escobar.ti@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.ayelenmichelle.flores.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.cristiananthony.flores.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.eddyleomar.flores.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.marcoantonio.flores.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.shiriammilagros.flores.su@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.karinakatterine.gonzales.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.claudiosergio.gonzales.su@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.shanthalaraceli.halanoca.fe@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.dianethbriseyda.huanca.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.iumeymagda.jacinto.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.jazminsujeily.jarro.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.mariadelcielo.jorge.pa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.ronnyjohn.justo.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.analisseth.larico.ap@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.sarai.laura.fe@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.dayanarajulissa.llantoy.ti@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.milagrosblanca.machaca.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.jordyanthony.mamani.le@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.deliabaneza.mamani.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.brisaraizel.mamani.ro@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.karenmilagros.mamani.ru@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.marcocaloyero.maseli.ro@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.yaroslava.mayorga.ch@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.yamil.mayta.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.katherinemayra.mercado.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.angelesligia.miranda.oc@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.alessacarmen.mollo.ti@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.valeriapatricia.mota.mo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.luzclara.olivar.ni@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.jhamilmark.paja.ma@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.yoelemerson.paredes.ar@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.dulcemaria.paredes.bl@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.sergiodilan.parra.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.gersondavid.paucar.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.milenmaydel.poma.pe@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.mariafernandanicole.quispe.ha@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.patriciaevelyn.quispe.ma@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.adriana.quispe.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.eidanrick.quispe.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.mishell.quispe.ti@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.sidneyyozeth.ramos.ve@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.abigailcamila.rodriguez.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.yeseniadeysy.rojas.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.dayanadannetzi.romero.de@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.juandaniel.salas.la@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.leonardodavid.salazar.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.yanirarossy.siguayro.uc@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.britaniclariz.ticona.ma@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.kevinjhohamil.ticona.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.karenlizbeth.tito.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.cinthyamilagros.turpo.ti@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.brooke.urquidi.gu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P104' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.sheilistefan.valdez.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.mariaisabel.valencia.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.anelasucel.vasquez.bo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P108' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.noemi.zapana.sa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P171' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 15:00:00' AS fecha_sesion, 'lpze.aldairbrayan.zela.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.jeanetmiriam.andrade.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.shantyyoseth.arce.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.robertocarlos.arevalo.ba@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.hectorivan.arpasi.zu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.fabiolarocio.avila.ar@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.pamelanoelia.barrios.va@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.israelomar.beltran.pa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.juliojavier.calle.lo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.hildanicol.cardenas.ya@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.yessicaamparo.chavez.cc@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.mariana.chiri.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.jenniferjahleel.claros.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.shamirasandra.coaquira.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.danielaangeles.colque.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.deibithamilcar.condori.ti@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.ruthabihail.cruz.fi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.andriymilan.diaz.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.lucianadefatima.enriquez.te@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.belennayra.escobar.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.luciaarihana.espezua.za@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.jasielmichel.figueredo.mo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.jesusjoaquin.flores.an@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.joannaceleste.funes.ba@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.wilsonsamuel.gallardo.cr@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.frankrodrigo.gomez.cc@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.gabrielanashely.gutierrez.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.ivonneerdely.hilasaca.jo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.noeliamadelein.huanca.ll@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.nayelykarol.laqui.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.sandraerika.laura.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.sallylucero.lipa.al@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.gabrielelias.lipa.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.lizethesther.mamani.ac@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.luzmargoth.mamani.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.roussekatherine.mamani.sa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.anyelaxiomara.manrique.ch@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.nadinevanessa.maquera.pi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.diegovidal.martinez.or@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.yinodeyvis.morales.sa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.alexisleonardo.nina.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.elenagrisel.nunez.lu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.zumiyudith.orco.ra@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.carlalizeth.pacosaca.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.omaryofer.paredes.sa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.juandaniel.quelca.cr@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.abrahamenoc.quispe.ar@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.edrianpaul.ramirez.es@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.emilyshemira.ramos.cc@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.joseluis.ramos.cc@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.milton.ramos.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.nicolmiobell.salamanca.lu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.gabrielaesteffany.silva.pi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.mariza.ticona.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.yhadiramaily.toledo.fl@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.joshuaisai.torres.lo@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.aylinsheyla.valle.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P102' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.edisonandre.vega.cc@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.henrymarcelo.veizaga.or@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.luzyluiz.venegas.ar@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S5/102/SEX' AS shortname, 'SALUD EXPLORATORIA I' AS asignatura, '2025-04-05 14:00:00' AS fecha_sesion, 'lpze.jackfernando.yanqui.ha@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jhoelwilson.ala.fl@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.erwineliezer.ali.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.nahirmarianela.aliaga.yu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.manuelrodrigo.angles.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.maryluz.apaza.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.inesevelin.apaza.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.lizeva.apaza.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jamesrembertbillguets.apaza.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jerrydainer.arcos.bu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.yhelkaesther.arias.ma@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.anakatryn.bautista.ma@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.maryorykihara.bolivar.ro@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.milagrosedith.cahuachia.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.kellyfiorela.cahuari.pa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jonsualain.callapina.be@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.dayronyair.caviedes.ch@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jorgeemmanuel.ccorahua.am@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.antonyalbert.ccoya.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.angeloscar.ccuno.at@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.luzmaria.charca.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.angelithmilenkamia.chata.la@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.eloyadonis.chavez.ch@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.marcoantonio.chiclla.me@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.freddygustavo.choquehuanca.ra@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.anhelimabela.chullo.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.mariafernanda.chuquispuma.ga@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.rodrigoeris.coila.ca@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.gerrardfabricio.coillo.ur@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jhonalberth.condori.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.gersonalan.condori.sa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.nelidapaola.cordoba.va@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.luisfernando.cuchillo.po@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.katerinadriana.cuevas.cr@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.xiomaraphamela.cutire.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.brendalyirene.espinoza.bu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.mariafernanda.flores.ag@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.luzmaria.flores.di@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.brizaydalizeth.garate.ap@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jhoncristofer.gomez.ch@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.danelykarol.gonzales.go@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.josiyunso.gutierrez.ga@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.alessandroanthony.gutierrez.ri@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.josefernando.huahualuque.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jhonwaldir.huahuasoncco.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.wilmer.huanca.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.alessandrajhunet.huanca.hu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.nayeliadela.jara.gu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.rodrigosebastian.lamett.ga@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.ximenafernanda.luque.ca@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.analizxiomara.machaca.su@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.josephadilson.mamani.ar@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.evelynlizbeth.mamani.iq@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.brayanenrique.mamani.li@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.elirodrigo.mamani.sa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.frankkleytoon.maquera.fl@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.luismiguel.maquera.fo@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.carlitadalila.marinoz.hi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.maryroxana.mendoza.ap@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.dannyedgardeduardo.mendoza.ap@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.yoeyampier.mendoza.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.brandonmichael.mercado.hu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.valeryandreacandy.miranda.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.florrosariodelpilar.mollisaca.hu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.stefanymartha.naca.ni@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.valeriasharmely.nina.pu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.esther.nobleza.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.helemdaniela.omonte.po@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.misheliara.pacheco.ma@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.miguelanthony.palomino.pa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.sharonsharmely.pari.ja@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.johnaurellsayarik.parisaca.jo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.gonzalofavian.pary.ro@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.anghelengricel.patty.sa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.yermayonibriyit.paye.ch@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.camilaalejandra.pena.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.kevinsmithelmer.penaloza.or@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.ivanluis.poma.ro@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.carolinalizmayely.ponce.cu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.hedudelpiero.puma.go@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.diana.quilla.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.ivanjeremmy.quintana.za@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.blancapilar.quispe.al@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jheidyvanessa.quispe.ca@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.abelardojesus.quispe.ja@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.kennedyalexander.quispe.me@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.erlanlandy.quispe.ra@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.miriansoledad.quispe.va@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.yeremispaul.roque.ca@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.anderssoneduardo.rosello.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.carolina.suarez.ro@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.azumianyely.sucasaca.hu@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.waramikaela.tapia.la@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.yhonlisver.ticona.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.marcibalbrett.ticona.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.flaviosteve.ucsa.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.niltonjos.valencia.ve@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jeffreymack.valera.an@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.bryansalexander.velasquez.ca@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.williamzahid.velasquez.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.anyelirous.vera.ov@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.yulizamilagros.vera.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.camilavaleria.vilca.he@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jadehelen.viscarra.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.alissonnayely.yana.so@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P172' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.jhoneddison.yupa.pa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/170/CRE' AS shortname, 'CREZCO I' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.dahilmatvei.zea.sa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 13:15:00' AS fecha_sesion, 'lpze.allissonariana.zela.ma@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.barbarakhalit.aguilar.be@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, '83490808be3229cd3df9c6ea03f55203' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.lizgabriela.alfonte.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.johairaevelyn.alvarez.ll@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.mariabelen.amaru.am@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.manuelrodrigo.angles.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.miriamdelpilar.angulo.ap@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.diegoenrique.apaza.aj@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.maryluz.apaza.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nelsonjoel.apaza.ca@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.dinofranz.argollo.li@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.kimberlynicole.arohuanca.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jheanlucas.aruquipa.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.yamileyzadit.asencio.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.keikopilar.atencio.ti@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.zulmayuliana.ayala.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P103' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.ricardoandre.balderrama.ar@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.camilamichelle.barrios.va@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.joseluis.benavente.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.aracelyjhenifer.betancourth.oj@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jennifergabriela.bolivar.ra@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.rosselykeiko.boyan.me@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nadiairiel.cabrera.ch@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.claudio.cajchaya.cc@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.mariafernandaveronica.calani.lo@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.johnmichael.calderon.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.yesibelmadelin.calisaya.cu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.cinthiaelizabeth.calla.ay@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.gianpierreandherson.calla.cu@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.gustavogabriel.callan.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.denissmaycol.callata.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.amilkar.cama.to@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.avril.candia.fl@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nicoledayana.candia.fl@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.dorisnelida.cari.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/107/COM' AS shortname, 'COMPRENDO I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jhonniercristian.carita.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.alessandraailyn.carreon.us@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.yenifernayely.castillo.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.vivianapaula.ccosi.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nelva.chacon.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.luzmaria.charca.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.selinamishel.chavez.la@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.bryandaniel.chavez.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.wilmerreynaldo.chejo.me@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.helenmarisol.chino.ob@unifranz.edu.bo' AS email, 'Falta justificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.camilamontserrat.choque.la@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.milenkajazmin.choque.pa@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.gabrielrodrigo.choque.ta@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nayeliariadna.choquehuanca.fl@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.freddygustavo.choquehuanca.ra@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.leydi.choquevillca.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.anhelimabela.chullo.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.danielastephanie.chura.cr@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.tatianagisel.clares.ro@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.zayda.colca.pa@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'est.eibrajanmauricio.colque.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.williamsdiego.condori.ap@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.helenalejandra.condori.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.camilasaomi.cornejo.mi@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.micaelajhanira.cornejo.mi@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.margaritayuliana.cruz.be@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.yhonfrank.cruz.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/107/COM' AS shortname, 'COMPRENDO I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.kendraxiomara.cuba.ov@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.yaserabsalon.cueva.va@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.dareenleonel.cutipa.ar@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/107/COM' AS shortname, 'COMPRENDO I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.ikarodrian.diaz.na@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jhaddevanessa.escobedo.es@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.brendalyirene.espinoza.bu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.niroslavaandrea.fernandez.ca@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.lisbetkelin.fernandez.fi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.mel.fernandez.gu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.rodrigoalonzo.figueroa.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.brayanjosuejaime.flores.ar@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.dannyelvio.flores.es@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.sharlymariel.gonzales.mi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jaireduardo.gutierrez.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nicolsarahi.gutierrez.lo@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.geraldinebelen.gutierrez.or@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.christelalexandra.gutierrez.ve@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.angelalejandro.hilari.to@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.wilmer.huanca.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.vaniaalejandra.huanca.go@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.leny.huanca.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.rodrigofelipe.jimenez.yu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.yulianaestefany.juli.in@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.maribel.julliri.pi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.deynamariel.larico.su@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.sheylaodeth.laura.pr@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.lucerobelen.laura.ya@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.lizethvanessa.leon.me@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nikolmaricielo.leon.ve@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/107/COM' AS shortname, 'COMPRENDO I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.daniela.lima.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.herleswilmer.lipa.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nestorisaac.lipa.ve@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'delete.lpze.camilabelen.llusco.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.gabrielasolcuper.lomas.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.macarenanasaretroxana.lomas.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/107/COM' AS shortname, 'COMPRENDO I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.edgar.lupaca.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.luisgustavo.mamani.ar@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.zenayda.mamani.es@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.brayanenrique.mamani.li@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nayelyxiomara.mamani.li@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.katerinmaritza.mamani.mo@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.karenrosamary.mamani.or@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.shamiranthony.mamani.qu@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.angelesmayumi.mamani.ra@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.sauladrian.mamani.sa.duplicado@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.lenny.mamani.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.luismiguel.maquera.fo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.adriana.marca.ma@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.lucianataly.marquez.di@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.damaris.marquez.re@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.sharelladriane.medina.ll@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.arianaaddy.mendoza.fl@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.mariadelasnieves.mendoza.hu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.franklinsaul.mollocondo.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.milton.montevilla.ti@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jasmin.mullisaca.co@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.ruthkarina.murillo.am@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jhonmarco.nina.ma@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.anthonykamhilo.ordono.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.yermayonibriyit.paye.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.wilsontito.paye.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.henryomar.pelinco.co@unifranz.edu.bo' AS email, 'Falta justificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.sadamsteve.perez.ni@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.piergiancarlo.pineda.al@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.dayanalileth.pomacosi.lo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.mauriciopaul.ponce.su@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.daelinmishel.quisbert.do@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jheidyvanessa.quispe.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P103' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.evelyn.quispe.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.katyrocio.quispe.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jerusalemcarola.quispe.fl@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.abelardojesus.quispe.ja@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.saraiabigail.quispe.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.miriansoledad.quispe.va@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.breyssinaldy.ramos.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.lizeth.ramos.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'delete.lpze.brisajazmin.revilla.va@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.fernandojavier.rios.or@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.rosabell.rodriguez.gu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jesusalexander.romero.te@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P100' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.alvaroalexis.saavedra.ib@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.carlosdarwin.sacaca.va@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.diegoandre.sanchez.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/107/COM' AS shortname, 'COMPRENDO I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.luissantiago.santos.fl@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.andres.sausiri.or@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.juanjose.silva.an@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.carolina.suarez.ro@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.melannibelen.surco.cu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'delete.lpze.heydam.suxo.ro@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.lissyrashiel.tapia.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.vanneryximena.tapia.qu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.anayulissa.ticona.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.rudbelalexis.tito.la@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.ruthjimena.torrez.ir@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.coraima.torrez.tu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jackelinmaynard.ttito.de@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.melvyyoselin.turpo.ti@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.flaviosteve.ucsa.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jeffreymack.valera.an@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S1/107/COM' AS shortname, 'COMPRENDO I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.danielsebastian.vargas.al@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.fernandabrisa.vasquez.vi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.abigailadela.velasquez.ta@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.josephissac.villa.he@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/102/COM' AS shortname, 'COMPRENDO II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.aphrilmilagros.villalta.es@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/ING-111(C)/P103' AS shortname, 'INGLÉS I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.jilleilyn.villamizar.du@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.aaronantonio.villegas.cu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.kevinsamir.washualdo.ti@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.mijaelpaul.yapuchura.qu@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/101/SEN' AS shortname, 'SALUD ENFERMEDAD II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.julianacamila.yujra.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S6/100/SAC' AS shortname, 'SALUD SOCIAL I' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.rauljosets.zambrano.pe@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.josearmando.zea.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S2/100/INT' AS shortname, 'INTERNACIONALÍZATE II' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.camilasofiajicel.zea.ya@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S3/102/INT' AS shortname, 'INTERNACIONALÍZATE III' AS asignatura, '2025-04-05 11:30:00' AS fecha_sesion, 'lpze.nayellikatihusca.zurita.ca@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.rossmerylibertad.abarca.po@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.grobermijael.acero.ti@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.carlalorena.alarcon.ta@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.christianalberto.aliaga.ta@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.brigittenayeli.aliaga.tr@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.zamiraandrea.ayoub.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.lauranaydely.calle.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.camilagrisel.castro.re@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.natalyaracely.cerezo.ap@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.yanirakatherine.choque.ra@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.fabianarturo.escobedo.be@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.danielmauricio.fernandez.ca@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.sarailicely.flores.gu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.analucia.gallinate.mo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.damarislourdes.gonzales.or@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.seanaxel.gutierrez.me@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.josuesebastiam.gutierrez.ve@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.lissethpaola.huanca.ri@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.itamar.hurtado.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.mikebernardo.jaramillo.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.saudajemil.julliri.pi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.jhosethuber.limachi.co@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.rossimary.llipe.me@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.luismauricio.martinez.mo@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.emilenelorena.mejia.or@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.keysi.mercado.cc@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.maytebelen.montero.ca@unifranz.edu.bo' AS email, 'Retraso' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.mauriciojhamil.moya.qu@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.camila.nina.ch@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.paolaibeth.paco.va@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.jhoselinmariela.palomino.on@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.kimkanmeett.paredes.hu@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.marycielo.pilco.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.jadzamirjordanjahaziel.prado.al@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.jhossephantony.quispe.al@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.brayanedward.ramos.ga@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.leonardo.revollo.ma@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.fabiana.revuelta.pa@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.briyinoara.saravia.si@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.micolabigail.soto.pi@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'est.zarellaeliana.tito.ob@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.marisalinda.valdivia.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.ariadnepamela.vargas.al@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.rebeccadesiree.vidaurre.ca@unifranz.edu.bo' AS email, 'Presente' AS descripcion_estado UNION SELECT '01/25/LPZ/MED/S7/102/SEX' AS shortname, 'SALUD EXPLORATORIA III' AS asignatura, '2025-04-05 04:00:00' AS fecha_sesion, 'lpze.dashiandrea.vila.va@unifranz.edu.bo' AS email, 'Falta injustificada' AS descripcion_estado ) SELECT NULL AS id, CASE (SELECT COUNT(nombre) FROM materia WHERE codigo = sub.materia_codigo LIMIT 1) WHEN 0 THEN sub.asignatura END AS asignatura, sub.materia_codigo, sub.fecha_sesion, sub.descripcion_estado, p.persona_id, c.carrera_id, g.gestion_id, s.sede_id FROM (SELECT asignatura, REPLACE(SUBSTRING_INDEX( SUBSTRING_INDEX(shortname,'/',-2) ,'/',1), '(',' (') AS materia_codigo, SUBSTR(shortname,7,3) AS sede_codigo, SUBSTR(shortname,11,3) AS carrera_codigo, CONCAT('20',SUBSTR(shortname,4,2),'-S',SUBSTR(shortname,2,1)) AS gestion, fecha_sesion, descripcion_estado, email FROM moodle) AS sub INNER JOIN persona_contacto pc ON pc.email_institucional = sub.email INNER JOIN persona p ON p.persona_id = pc.persona_id INNER JOIN carrera c ON c.codigo = sub.carrera_codigo INNER JOIN sede s ON s.codigo = sub.sede_codigo INNER JOIN gestion g ON g.codigo_alternativo = sub.gestion