|
 |
|
|
| Kobe Bryant, SG, LAL |
| |
2006-07 Regular Season |
| FG% |
FT% |
Pts |
Reb |
Ast |
Stl |
Blk |
3s |
FSPI |
| .463 |
.868 |
31.6 |
5.7 |
5.4 |
1.4 |
.5 |
1.8 |
6.15 |
 |
ok
1
select rtrim(tm.abbreviation) as abbreviation, isnull(s1.player_stat, 0) as pts, isnull(s2.player_stat, 0) as reb, isnull(s3.player_stat, 0) as ast, isnull(s4.player_stat, 0) as stl, isnull(s5.player_stat, 0) as blk, isnull(s6.player_stat, 0) as tpm from player_map wp, team_map tm, game gm, player_stats_game s1, player_stats_game s2, player_stats_game s3, player_stats_game s4, player_stats_game s5, player_stats_game s6 where wp.person_id=1733 and tm.team_id in ( select team_id from player_team where person_id=wp.person_id and season='2006' and jersey_num is not null ) and gm.date_est = (select convert(varchar, max(gm.date_est), 101) from game gm, game_stats_live gsl where gm.date_est <= convert(varchar, dateadd(dd, -1, getdate()), 101) and substring(season,2,4) = '2006' and gsl.game_status > 2 and gsl.game_id = gm.game_id) and (gm.home_team_id = tm.team_id or gm.visitor_team_id = tm.team_id) and wp.person_id *= s1.person_id and gm.game_id *= s1.game_id and s1.stat_type_id=20 and wp.person_id *= s2.person_id and gm.game_id *= s2.game_id and s2.stat_type_id=52 and wp.person_id *= s3.person_id and gm.game_id *= s3.game_id and s3.stat_type_id=13 and wp.person_id *= s4.person_id and gm.game_id *= s4.game_id and s4.stat_type_id=14 and wp.person_id *= s5.person_id and gm.game_id *= s5.game_id and s5.stat_type_id=16 and wp.person_id *= s6.person_id and gm.game_id *= s6.game_id and s6.stat_type_id=5
How is the Top Performer determined? |
| Stat |
# |
Yesterday's Leaders |
|
|
|
 |
|
|
|
 |
|
|
|
|
|
|
|
 |
 |
|
|
|
|
|
 |
|
|
|
|