SELECT distinct(roles.user_id), users.username,users.first_name,users.middle_name,users.last_name FROM users,roles WHERE users.user_id=roles.user_id AND (roles.role_id=64 OR roles.role_id=128) AND roles.sched_conf_id=29 ORDER BY first_name,middle_name,last_name
login | Nome | Certificado |
cwagner | Carlos Wagner Oliveira | |
clmarko | Cláudia Araújo Marco | |
dtiufca | DTI Cariri | |
felipecamaraa | Felipe Thomaz da Camara | |
feitosa | josé valmir feitosa |