SQL : select distinct p.[PlayerID],p.[FIRSTNAME],p.[LASTNAME],p.[HEIGHT],p.[POSITION],p.[BORN],p.[TEAM],p.[FROM],p.[TO],p.[START],p.[NATIONALITY],p.[COLLEGE],'' AS [Agent],p.[Inactive],p.[Nationality2],p.[PhotoPath], p.[E_mail],p.[Junior],p.[LastModified],p.[AcPhoto],p.[EB],p.[UNbr], p.[FarmTeam],p.[Statslookup] ,p.[Weight],p.[NationalTeams],p.[SkillLevel],p.[Graduation],'' AS [Facebook],'' AS [Twitter],p.[HasVideos],p.[DateBorn], p.[CollegeStart],p.[Injured],p.[HighSchool],p.[HS_Graduation],p.[BornCity],p.[BornState],p.[FarmTeam1],p.[Instagram],'' AS [Media2],'' AS [Media3], Team.[SHORTNAME],Team.[FULLNAME],Team.[LEAGUE],Team.[COUNTRY],Team.[CONFERENCE],Team.[TeamNo],Team.[Short],Team.[E-mail],Team.[Logo],'' AS [URL1],'' AS [URL2],Team.[CNF],Team.[LEAGUENAME],'' AS [Stats],Team.[LastModified],Team.[OtherTeam], Team.[OurCode],Team.[CNF1],Team.[LGroup], Team.[Statslookup],Team.[FIBA_FAT],Team.[Champ],Team.[City],Team.[NameComments],Team.[SkillLevel],'' AS [Twitter],Team.[E_mail_Staff],'' AS [VideoURL],'' AS [videoChannelID],Team.[MonitorDate],'' AS [GooglePlus], '' AS [SocialMedia1],'' AS [SocialMedia2],Team.[SeniorTeam],Team.[League1],Team.[JuniorTeam], Team.shortname as CollShortname, p.[TO] AS yeartocase,(select top 1 Ext.TeamID from Player_ExTeams as Ext where Ext.PlayerID = p.PlayerID order by Ext.yearto desc) AS Ex_team1 from Player_ExTeams (nolock) left join Players as p (nolock) on p.playerid = Player_ExTeams.playerid inner join Team (nolock) on p.Team = Team.TeamNo where (Player_ExTeams.TeamID = 52544) Or (p.Team = 52544 AND (p.[TO]<> 2025 or Inactive=1)) order by [yeartocase] DESC, [LASTNAME],[FIRSTNAME]
NBA Academy Latin America basketball, News, Roster, Rumors, Stats, Awards, Transactions, Details - middleeastbasketball
You see it because you are not a subscriber. Subscribe now.
