1611136965 - 1611136963 = 2
2021-01-20 07:02
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 25981
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611136970 - 1611136968 = 2
2021-01-20 07:02
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 26035
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611136975 - 1611136973 = 2
2021-01-20 07:02
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 26087
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611136992 - 1611136990 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 25618
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137001 - 1611136999 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 25489
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137005 - 1611137003 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 26101
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137008 - 1611137006 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 26098
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137015 - 1611137013 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 31214
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137018 - 1611137016 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 31176
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137023 - 1611137021 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 26832
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137025 - 1611137023 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 26817
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137029 - 1611137027 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 22498
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137032 - 1611137030 = 2
2021-01-20 07:03
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 21108
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611137332 - 1611137330 = 2
2021-01-20 07:08
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 25484
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1611138295 - 1611138293 = 2
2021-01-20 07:24
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 25296
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1614606848 - 1614606846 = 2
2021-03-01 10:54
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 22424
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1614606871 - 1614606869 = 2
2021-03-01 10:54
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 31213
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original
1614606874 - 1614606872 = 2
2021-03-01 10:54
select 'Equivalência Múltipla - ' || te.descr || '
' || gcd1.descr_original as descr,
sum((select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
join gc_ciclo_disc_equiv gcde1 on gcde1.gc_ciclo_disc_equiv = cde1.gc_ciclo_disc_equiv
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd3.disc
and gcde1.tipo_equivalencia = 3)) as ja_matriculado
from aluno_curso ac
join gc on gc.gc = ac.gc
join gc_ciclo gcc on gcc.gc = gc.gc
join gc_ciclo_disc gcd on gcd.gc_ciclo = gcc.gc_ciclo
join gc_ciclo_disc_equiv gcde on gcde.gc_ciclo_disc = gcd.gc_ciclo_disc
join tipo_equivalencia te on te.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd1 on gcd1.gc_ciclo_disc = gcde.gc_ciclo_disc_equivalente
join gc_ciclo_disc gcd2 on gcd2.disc = gcd1.disc
join gc_ciclo_disc_equiv gcde2 on gcde2.gc_ciclo_disc_equivalente = gcd2.gc_ciclo_disc and gcde2.tipo_equivalencia = gcde.tipo_equivalencia
join gc_ciclo_disc gcd3 on gcd3.gc_ciclo_disc = gcde2.gc_ciclo_disc and gcd3.disc <> gcd.disc
join gc_ciclo gcc3 on gcc3.gc_ciclo = gcd3.gc_ciclo and gcc3.gc = ac.gc
where ac.aluno_curso = 1201151
and gcd.disc = 26832
and gcde.tipo_equivalencia = 3
and (select count(*)
from contrato_disc_equiv cde1
join contrato_disc cd1 on cd1.contrato_disc = cde1.contrato_disc
where cd1.contrato = 4810257
and cd1.a_cursar = 'S'
and cde1.disc_original = gcd.disc) = 0
group by te.descr,
gcd1.descr_original