a guest May 25th, 2017 157 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select distinct d
  2. from ProfessorTurma pt
  3.     join fetch pt.turma t
  4.     join fetch t.disciplina d
  5. where pt.idprofessor = ?
  6. and t.podelancarnota = 1
  7. and t.idturmateorica is null
  8. and t.status != 9
  9. and t.anosemestre = ?
  10. order by d.nome;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand