select tp.idregistro ,codigo ,tema , resumen, palabra_clave
from esq_conv_2020.tbl_ponencias tp
join esq_conv_2020.tbl_congreso_linea tcl on tcl.idregistro = tp.id_congreso_linea
join esq_conv_2020.tbl_congreso tc on tc.idregistro = tcl.id_congreso
where tc.id_convencion  = 9
and tp.id_estado in (61,63,64)
and tp.codigo not in('CCIUTM-REG-ADM')
and tc.idregistro not in (128)
order by tc.nombre, tcl.nombre_area , tp.tema