SELECT
[Project1].[Usuario_Id] AS [Usuario_Id],
[Project1].[C1] AS [C1],
[Project1].[CPF] AS [CPF],
[Project1].[Matricula] AS [Matricula],
[Project1].[Nome] AS [Nome],
[Project1].[Empresa] AS [Empresa],
[Project1].[Situacao] AS [Situacao],
[Project1].[Telefone] AS [Telefone],
[Project1].[Cidade] AS [Cidade],
[Project1].[Gerencia] AS [Gerencia],
[Project1].[Lotacao] AS [Lotacao],
[Project1].[Pais] AS [Pais],
[Project1].[DataInscricao] AS [DataInscricao],
[Project1].[Login] AS [Login],
[Project1].[ParticipacaoAprovada] AS [ParticipacaoAprovada],
[Project1].[HorarioDoPalpite] AS [HorarioDoPalpite],
[Project1].[PrimeiroColocado_Id] AS [PrimeiroColocado_Id],
[Project1].[SegundoColocado_Id] AS [SegundoColocado_Id],
[Project1].[TerceiroColocado_Id] AS [TerceiroColocado_Id],
[Project1].[QuartoColocado_Id] AS [QuartoColocado_Id],
[Project1].[DecimoSetimoColocado_Id] AS [DecimoSetimoColocado_Id],
[Project1].[DecimoOitavoColocado_Id] AS [DecimoOitavoColocado_Id],
[Project1].[DecimoNonoColocado_Id] AS [DecimoNonoColocado_Id],
[Project1].[VigesimoColocado_Id] AS [VigesimoColocado_Id],
[Project1].[Time_Id] AS [Time_Id],
[Project1].[C2] AS [C2],
[Project1].[Id] AS [Id],
[Project1].[PlacarTimeDaCasa] AS [PlacarTimeDaCasa],
[Project1].[PlacarTimeVisitante] AS [PlacarTimeVisitante],
[Project1].[Jogo_Id] AS [Jogo_Id],
[Project1].[HorarioDoPalpite1] AS [HorarioDoPalpite1],
[Project1].[Usuario_Id1] AS [Usuario_Id1],
[Project1].[Id1] AS [Id1],
[Project1].[Rodada] AS [Rodada],
[Project1].[Turno] AS [Turno],
[Project1].[EstaAtivo] AS [EstaAtivo],
[Project1].[Visivel] AS [Visivel],
[Project1].[ContaParaORanking] AS [ContaParaORanking],
[Project1].[PlacarTimeDaCasa1] AS [PlacarTimeDaCasa1],
[Project1].[PlacarTimeVisitante1] AS [PlacarTimeVisitante1],
[Project1].[HorarioDoJogo] AS [HorarioDoJogo],
[Project1].[Estadio] AS [Estadio],
[Project1].[Estado] AS [Estado],
[Project1].[DesativacaoAutomatica] AS [DesativacaoAutomatica],
[Project1].[Id2] AS [Id2],
[Project1].[Nome1] AS [Nome1],
[Project1].[CaminhoImagem] AS [CaminhoImagem],
[Project1].[Id3] AS [Id3],
[Project1].[Nome2] AS [Nome2],
[Project1].[CaminhoImagem1] AS [CaminhoImagem1]
FROM ( SELECT
	[Extent1].[CPF] AS [CPF],
	[Extent1].[Matricula] AS [Matricula],
	[Extent1].[Nome] AS [Nome],
	[Extent1].[Empresa] AS [Empresa],
	[Extent1].[Situacao] AS [Situacao],
	[Extent1].[Telefone] AS [Telefone],
	[Extent1].[Cidade] AS [Cidade],
	[Extent1].[Gerencia] AS [Gerencia],
	[Extent1].[Lotacao] AS [Lotacao],
	[Extent1].[Pais] AS [Pais],
	[Extent1].[DataInscricao] AS [DataInscricao],
	[Extent1].[Login] AS [Login],
	[Extent1].[ParticipacaoAprovada] AS [ParticipacaoAprovada],
	[Extent1].[Time_Id] AS [Time_Id],
	[Extent2].[Usuario_Id] AS [Usuario_Id],
	[Extent2].[HorarioDoPalpite] AS [HorarioDoPalpite],
	[Extent2].[PrimeiroColocado_Id] AS [PrimeiroColocado_Id],
	[Extent2].[SegundoColocado_Id] AS [SegundoColocado_Id],
	[Extent2].[TerceiroColocado_Id] AS [TerceiroColocado_Id],
	[Extent2].[QuartoColocado_Id] AS [QuartoColocado_Id],
	[Extent2].[DecimoSetimoColocado_Id] AS [DecimoSetimoColocado_Id],
	[Extent2].[DecimoOitavoColocado_Id] AS [DecimoOitavoColocado_Id],
	[Extent2].[DecimoNonoColocado_Id] AS [DecimoNonoColocado_Id],
	[Extent2].[VigesimoColocado_Id] AS [VigesimoColocado_Id],
	1 AS [C1],
	[Join5].[Id1] AS [Id],
	[Join5].[PlacarTimeDaCasa1] AS [PlacarTimeDaCasa],
	[Join5].[PlacarTimeVisitante1] AS [PlacarTimeVisitante],
	[Join5].[Jogo_Id] AS [Jogo_Id],
	[Join5].[HorarioDoPalpite] AS [HorarioDoPalpite1],
	[Join5].[Usuario_Id] AS [Usuario_Id1],
	[Join5].[Id2] AS [Id1],
	[Join5].[Rodada1] AS [Rodada],
	[Join5].[Turno1] AS [Turno],
	[Join5].[EstaAtivo1] AS [EstaAtivo],
	[Join5].[Visivel1] AS [Visivel],
	[Join5].[ContaParaORanking1] AS [ContaParaORanking],
	[Join5].[PlacarTimeDaCasa2] AS [PlacarTimeDaCasa1],
	[Join5].[PlacarTimeVisitante2] AS [PlacarTimeVisitante1],
	[Join5].[HorarioDoJogo1] AS [HorarioDoJogo],
	[Join5].[Estadio1] AS [Estadio],
	[Join5].[Estado1] AS [Estado],
	[Join5].[DesativacaoAutomatica1] AS [DesativacaoAutomatica],
	[Join5].[Id3] AS [Id2],
	[Join5].[Nome1] AS [Nome1],
	[Join5].[CaminhoImagem1] AS [CaminhoImagem],
	[Join5].[Id4] AS [Id3],
	[Join5].[Nome2] AS [Nome2],
	[Join5].[CaminhoImagem2] AS [CaminhoImagem1],
	CASE WHEN ([Join5].[Id1] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C2]
	FROM   [dbo].[Usuarios] AS [Extent1]
	LEFT OUTER JOIN [dbo].[PalpiteCampeaos] AS [Extent2] ON [Extent1].[PalpiteCampeao_Usuario_Id] = [Extent2].[Usuario_Id]
	LEFT OUTER JOIN  (SELECT [Extent3].[Id] AS [Id1], [Extent3].[PlacarTimeDaCasa] AS [PlacarTimeDaCasa1], [Extent3].[PlacarTimeVisitante] AS [PlacarTimeVisitante1], [Extent3].[Jogo_Id] AS [Jogo_Id], [Extent3].[HorarioDoPalpite] AS [HorarioDoPalpite], [Extent3].[Usuario_Id] AS [Usuario_Id], [Extent4].[Id] AS [Id2], [Extent4].[Rodada] AS [Rodada1], [Extent4].[Turno] AS [Turno1], [Extent4].[EstaAtivo] AS [EstaAtivo1], [Extent4].[Visivel] AS [Visivel1], [Extent4].[ContaParaORanking] AS [ContaParaORanking1], [Extent4].[PlacarTimeDaCasa] AS [PlacarTimeDaCasa2], [Extent4].[PlacarTimeVisitante] AS [PlacarTimeVisitante2], [Extent4].[HorarioDoJogo] AS [HorarioDoJogo1], [Extent4].[Estadio] AS [Estadio1], [Extent4].[Estado] AS [Estado1], [Extent4].[DesativacaoAutomatica] AS [DesativacaoAutomatica1], [Extent6].[Id] AS [Id3], [Extent6].[Nome] AS [Nome1], [Extent6].[CaminhoImagem] AS [CaminhoImagem1], [Extent7].[Id] AS [Id4], [Extent7].[Nome] AS [Nome2], [Extent7].[CaminhoImagem] AS [CaminhoImagem2]
		FROM     [dbo].[Palpites] AS [Extent3]
		INNER JOIN [dbo].[Jogos] AS [Extent4] ON [Extent3].[Jogo_Id] = [Extent4].[Id]
		LEFT OUTER JOIN [dbo].[Jogos] AS [Extent5] ON [Extent3].[Jogo_Id] = [Extent5].[Id]
		LEFT OUTER JOIN [dbo].[Times] AS [Extent6] ON [Extent5].[TimeDaCasa_Id] = [Extent6].[Id]
		LEFT OUTER JOIN [dbo].[Times] AS [Extent7] ON [Extent5].[TimeVisitante_Id] = [Extent7].[Id] ) AS [Join5] ON [Extent1].[CPF] = [Join5].[Usuario_Id]
)  AS [Project1]
ORDER BY [Project1].[Usuario_Id] ASC, [Project1].[CPF] ASC, [Project1].[C2] ASC