Sacramento Kings

2020-21 Roster

SELECT yearID as year,_uni,playerMaster._nameLast as _nameLast,playerID as playerID,_nameFull,playerSlug,pos,_playerHeight as height,_playerHeight as inches,_playerWeight,yearID-_birthYear as age,_yearInCareer,CONCAT(_birthYear,'-',RIGHT(CONCAT('00',_birthMonth),2),'-',RIGHT(CONCAT('00',_birthDay),2)) as birthDate,CONCAT(_birthYear,'-',RIGHT(CONCAT('00',_birthMonth),2),'-',RIGHT(CONCAT('00',_birthDay),2)) as birthSort,_college,_yearOnTeam,_isFirstSeason,_isFinalSeason,_yearOnTeam=_yearOnTeamMax as isFinalTeamSeason,_isRookieSeason,_yearInCareer>=10 as isVeteran,_isKeyPlayer as isKeyPlayer FROM playerMaster, playerStatsK_scoringAll, teamMappings WHERE playerStatsK_scoringAll.teamID = teamMappings.dbTeamID AND playerStatsK_scoringAll.playerID = playerMaster.playerSourceID AND playerStatsK_scoringAll.yearID = :yearID AND teamMappings.teamCode = :teamID AND playerDataSet = :sportID AND round = 'REG' GROUP BY playerSourceID ORDER BY _nameLast,_nameFull;