Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- *,
- COUNT(1) OVER() AS TOTAL_COUNT
- FROM
- (SELECT * FROM (
- SELECT
- a.aluno_cod,
- a.aluno_pescod,
- a.aluno_escolcod,
- b.pes_nome,
- b.pes_nome_afetivo,
- b.pes_nome_social,
- a.aluno_ra,
- b.pes_dtnasc,
- esc.pes_fantasia AS escol_nome
- FROM edu_aluno a
- INNER JOIN bas_pessoa b
- ON b.pes_cod = a.aluno_pescod
- LEFT JOIN (
- SELECT
- max(em.matric_data) AS matric_data,
- em.matric_alunocod
- FROM edu_matricula em
- INNER JOIN edu_matricula_status ems
- ON em.matric_cod = ems.matricst_matriccod
- AND ems.matricst_ativo = 1
- INNER JOIN edu_classe ec
- ON em.matric_classecod = ec.classe_cod
- AND ec.classe_tipo IS NULL
- WHERE
- 1 = 1
- GROUP BY
- em.matric_alunocod
- ) AS matricula
- ON matricula.matric_alunocod = a.aluno_cod
- LEFT JOIN edu_matricula e
- ON a.aluno_cod = e.matric_alunocod
- AND matricula.matric_alunocod = e.matric_alunocod
- AND e.matric_data = matricula.matric_data
- LEFT JOIN edu_classe ec
- ON e.matric_classecod = ec.classe_cod
- AND ec.classe_tipo IS NULL
- LEFT JOIN edu_escola c
- ON c.escol_cod = ec.classe_escolcod
- LEFT JOIN bas_pessoa esc
- ON esc.pes_cod = c.escol_pescod
- WHERE
- 1 = 1
- AND (esc.pes_cod IS NOT NULL OR (esc.pes_cod IS NULL AND matricula.matric_alunocod IS NULL))
- ORDER BY
- b.pes_nome
- ) as view_filter WHERE 1=1
- AND ALUNO_ESCOLCOD = 15) as view_pagging
- LIMIT 30 OFFSET 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement