SELECT * FROM disciplina d 
WHERE d.curso = 1219 AND d.id NOT IN(SELECT da.disciplina FROM disciplina_aluno da WHERE da.cursoDestino = 1219 AND da.status = 0)
OR d.id IN(SELECT da.disciplina FROM disciplina_aluno da WHERE da.cursoDestino = 1219 AND da.status = 1)