Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- -- COUNT(*),
- matriculas.PK_matricula AS codMatricula,
- situacaoalunos.dsNome AS situacaoAluno,
- relacao_meio_rural.dsNome AS relacaoMeioRural,
- cursos.dsNome AS nomeCurso,
- turmas.dhFim AS dataFimTurma
- FROM matriculas
- LEFT JOIN turmas ON (turmas.PK_turma = matriculas.FK_turma)
- LEFT JOIN disciplinas ON (disciplinas.PK_disciplina = turmas.FK_disciplina)
- LEFT JOIN cursos ON (cursos.PK_curso = disciplinas.FK_curso)
- LEFT JOIN usuarios ON (usuarios.PK_usuario = matriculas.FK_usuario)
- LEFT JOIN relacao_meio_rural ON (relacao_meio_rural.PK_relacaoMeioRural = usuarios.FK_relacaoMeioRural)
- LEFT JOIN situacaoalunos ON (situacaoalunos.PK_situacaoaluno = matriculas.FK_situacaoaluno)
- WHERE
- matriculas.dhMatricula BETWEEN '2015-08-01' AND '2015-11-20' AND
- matriculas.flAtivo = 1 AND
- matriculas.FK_situacaoaluno = 5 AND
- disciplinas.FK_curso = 8 AND
- NOW() BETWEEN turmas.dhInicio AND turmas.dhFim AND -- turmas em andamento
- NOW() > turmas.dhFim AND -- turmas finalizadas
- relacao_meio_rural.PK_relacaoMeioRural = 1
- LIMIT 100;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement