SELECT sf.*, p.drafted_round, sfp.rank AS sfpRank, floor(datediff('2024-10-10', p.birth_date) / 365) AS age FROM spofo_mag_team_prospects sf JOIN nhl_players p ON sf.player_id = p.player_id LEFT JOIN spofo_mag_fantasy_top_100 sfp ON sf.player_id = sfp.player_id AND sfp.season = '2024-25' WHERE sf.nhl_team_id = 61 AND sf.rank <= 25 AND sf.season = '2024-25' GROUP BY p.player_id ORDER BY team_code, sf.rank ASC;
| Rk. | Name [pos], age | Ready | 2023-24 League |
|---|
|
Division: th Record: --- th Home: --- th Away: --- th 1st Half: --- th 2nd Half: --- th |
OT/SO: -0 th PP%: 0 th PK%: 0 th PIM per game: th GF per game: 0 th GA per game: 0 th |
SH goals: th SF per game: 0 th SA per game: 0 th FaceoffW%: 0 th Hits/60: 0 th Bks/60: 0 th |
| Did not qualify for playoffs |
Goals |
Assists |
Points |
Wins |
Plus/Minus |
Penalty Minutes |