1611309908 - 1611309906 = 2 2021-01-22 07:05 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 = 4815184 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 = 1190985 and gcd.disc = 24128 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309914 - 1611309912 = 2 2021-01-22 07:05 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 = 4815184 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 = 1190985 and gcd.disc = 24130 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309920 - 1611309918 = 2 2021-01-22 07:05 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 = 4815184 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 = 1190985 and gcd.disc = 24134 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309924 - 1611309922 = 2 2021-01-22 07:05 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 = 4815184 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 = 1190985 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309930 - 1611309928 = 2 2021-01-22 07:05 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 = 4815184 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 = 1190985 and gcd.disc = 24157 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309935 - 1611309933 = 2 2021-01-22 07:05 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 = 4815184 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 = 1190985 and gcd.disc = 24151 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309945 - 1611309943 = 2 2021-01-22 07:05 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 = 4815184 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 = 1190985 and gcd.disc = 33974 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309951 - 1611309949 = 2 2021-01-22 07:05 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 = 4815184 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 = 1190985 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309955 - 1611309953 = 2 2021-01-22 07:05 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 = 4815184 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 = 1190985 and gcd.disc = 37015 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309961 - 1611309959 = 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 = 4815184 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 = 1190985 and gcd.disc = 34124 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309964 - 1611309962 = 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 = 4815184 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 = 1190985 and gcd.disc = 37312 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611310035 - 1611310033 = 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 = 4815184 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 = 1190985 and gcd.disc = 24126 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611310049 - 1611310047 = 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 = 4815184 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 = 1190985 and gcd.disc = 24149 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611310058 - 1611310056 = 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 = 4815184 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 = 1190985 and gcd.disc = 33627 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 = 4815184 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original