1611309805 - 1611309803 = 2 2021-01-22 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 = 4811103 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 = 1182772 and gcd.disc = 24136 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309810 - 1611309808 = 2 2021-01-22 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 = 4811103 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 = 1182772 and gcd.disc = 21114 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309813 - 1611309811 = 2 2021-01-22 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 = 4811103 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 = 1182772 and gcd.disc = 24152 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309820 - 1611309818 = 2 2021-01-22 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 = 4811103 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 = 1182772 and gcd.disc = 24146 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309822 - 1611309820 = 2 2021-01-22 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 = 4811103 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 = 1182772 and gcd.disc = 33623 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309835 - 1611309833 = 2 2021-01-22 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 = 4811103 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 = 1182772 and gcd.disc = 37010 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309838 - 1611309836 = 2 2021-01-22 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 = 4811103 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 = 1182772 and gcd.disc = 37011 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309840 - 1611309838 = 2 2021-01-22 07:04 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 = 4811103 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 = 1182772 and gcd.disc = 37012 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611310000 - 1611309998 = 2 2021-01-22 07:06 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 = 4811103 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 = 1182772 and gcd.disc = 24136 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611310013 - 1611310011 = 2 2021-01-22 07:06 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 = 4811103 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 = 1182772 and gcd.disc = 33623 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611310015 - 1611310013 = 2 2021-01-22 07:06 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 = 4811103 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 = 1182772 and gcd.disc = 33624 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611310018 - 1611310016 = 2 2021-01-22 07:06 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 = 4811103 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 = 1182772 and gcd.disc = 33628 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611310024 - 1611310022 = 2 2021-01-22 07:07 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 = 4811103 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 = 1182772 and gcd.disc = 37010 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 = 4811103 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original