1611309752 - 1611309750 = 2
2021-01-22 07:02
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309762 - 1611309760 = 2
2021-01-22 07:02
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309832 - 1611309830 = 2
2021-01-22 07:03
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 and gcd.disc = 24122
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309836 - 1611309834 = 2
2021-01-22 07:03
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 and gcd.disc = 24123
															 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 = 4815336 
																	 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 '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 and gcd.disc = 24121
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309849 - 1611309847 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309851 - 1611309849 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 and gcd.disc = 24135
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309862 - 1611309860 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309867 - 1611309865 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 and gcd.disc = 24140
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309869 - 1611309867 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309874 - 1611309872 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309876 - 1611309874 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 and gcd.disc = 33626
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309878 - 1611309876 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309881 - 1611309879 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 and gcd.disc = 33636
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309885 - 1611309883 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309888 - 1611309886 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309890 - 1611309888 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309892 - 1611309890 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 and gcd.disc = 21073
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309897 - 1611309895 = 2
2021-01-22 07:04
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309991 - 1611309989 = 2
2021-01-22 07:06
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 and gcd.disc = 24135
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309994 - 1611309992 = 2
2021-01-22 07:06
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original

1611309999 - 1611309997 = 2
2021-01-22 07:06
select '<b>Equivalência Múltipla - ' || te.descr || '</b><br />' || 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 = 4815336 
																		  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 = 1191256
															 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 = 4815336 
																	 and cd1.a_cursar = 'S' 
																	 and cde1.disc_original = gcd.disc) = 0
														group by te.descr,
															     gcd1.descr_original