1611309716 - 1611309714 = 2 2021-01-22 07:01 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 = 4810959 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 = 1182392 and gcd.disc = 37014 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309803 - 1611309801 = 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 = 4810959 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 = 1182392 and gcd.disc = 24158 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309815 - 1611309813 = 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 = 4810959 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 = 1182392 and gcd.disc = 33639 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309817 - 1611309815 = 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 = 4810959 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 = 1182392 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309821 - 1611309819 = 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 = 4810959 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 = 1182392 and gcd.disc = 34300 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309823 - 1611309821 = 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 = 4810959 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 = 1182392 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309827 - 1611309825 = 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 = 4810959 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 = 1182392 and gcd.disc = 37013 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309829 - 1611309827 = 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 = 4810959 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 = 1182392 and gcd.disc = 37014 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309833 - 1611309831 = 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 = 4810959 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 = 1182392 and gcd.disc = 20495 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 = 4810959 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 = 4810959 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 = 1182392 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 = 4810959 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 = 4810959 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 = 1182392 and gcd.disc = 37313 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 = 4810959 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 = 4810959 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 = 1182392 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 = 4810959 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 = 4810959 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 = 1182392 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309958 - 1611309956 = 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 = 4810959 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 = 1182392 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611309960 - 1611309958 = 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 = 4810959 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 = 1182392 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 = 4810959 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original