1611136972 - 1611136970 = 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 = 4810960 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 = 1182393 and gcd.disc = 26247 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611136974 - 1611136972 = 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 = 4810960 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 = 1182393 and gcd.disc = 26248 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611136978 - 1611136976 = 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 = 4810960 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 = 1182393 and gcd.disc = 31617 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611136985 - 1611136983 = 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 = 4810960 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 = 1182393 and gcd.disc = 22649 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611136991 - 1611136989 = 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 = 4810960 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 = 1182393 and gcd.disc = 26279 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611136993 - 1611136991 = 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 = 4810960 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 = 1182393 and gcd.disc = 23099 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611137000 - 1611136998 = 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 = 4810960 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 = 1182393 and gcd.disc = 20408 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611137004 - 1611137002 = 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 = 4810960 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 = 1182393 and gcd.disc = 22776 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611137013 - 1611137011 = 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 = 4810960 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 = 1182393 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611137019 - 1611137017 = 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 = 4810960 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 = 1182393 and gcd.disc = 31620 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611137026 - 1611137024 = 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 = 4810960 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 = 1182393 and gcd.disc = 25089 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611137036 - 1611137034 = 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 = 4810960 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 = 1182393 and gcd.disc = 26283 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original 1611137039 - 1611137037 = 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 = 4810960 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 = 1182393 and gcd.disc = 26372 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 = 4810960 and cd1.a_cursar = 'S' and cde1.disc_original = gcd.disc) = 0 group by te.descr, gcd1.descr_original