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 = 21 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 |
|---|---|---|---|
| 1. | Macklin Celebrini [C], 18 1 2 | 2024-25 | NCAA |
| 2. | Will Smith [C], 19 1 4 | 2024-25 | NCAA |
| 3. | Yaroslav Askarov [G], 22 1 14 | 2024-25 | NHL |
| 4. | Sam Dickinson [LD], 18 1 | 2025-26 | OHL |
| 5. | Quentin Musty [LW], 19 1 50 | 2025-26 | OHL |
| 6. | Shakir Mukhamadullin [RD/LD], 22 1 57 | 2024-25 | NHL |
| 7. | Filip Bystedt [C], 20 1 65 | 2025-26 | SHL |
| 8. | Kasper Halttunen [RW], 19 2 79 | 2025-26 | OHL |
| 9. | Igor Chernyshov [LW], 18 2 88 | Long term | KHL |
| 10. | Danil Gushchin [RW/LW], 22 3 | 2025-26 | NHL |
| 11. | Collin Graf [RW/C], 22 | 2025-26 | NHL |
| 12. | Jack Thompson [RD], 22 3 | 2025-26 | NHL |
| 13. | Jake Furlong [LD], 20 5 | Long term | QMJHL |
| 14. | Luca Cagnoni [LD], 19 4 | Long term | WHL |
| 15. | Christian Kirsch [G], 18 4 | Long term | Swi U20 |
| 16. | Mattias Havelid [RD], 20 2 | Long term | SHL |
| 17. | Leo Sahlin Wallenius [LD], 18 2 | Long term | Swe Jr. |
| 18. | Yegor Rimashevsky [LW/RW], 19 7 | Long term | KHL |
| 19. | Valtteri Pulli [LD], 23 | 2025-26 | AHL |
| 20. | Ethan Cardwell [C/RW], 22 4 | 2025-26 | AHL |
| 21. | Carson Wetsch [RW], 18 3 | Long term | WHL |
| 22. | Cameron Lund [C], 20 2 | Long term | NCAA |
| 23. | Theo Jacobsson [C], 21 6 | Long term | SHL |
| 24. | Eric Pohlkamp [RD], 20 5 | Long term | NCAA |
| 25. | Eli Barnett [RD], 23 2 | Long term | NHL |
|
Division: 8th Record: 19-54-4-5 32nd Home: 11-25-3-2 32nd Away: 8-29-1-3 31st 1st Half: 9-29-0-3 32nd 2nd Half: 10-25-4-2 32nd |
OT/SO: 5-9 31st PP%: 20.2 20th PK%: 75.4 28th PIM per game: 9:21 21st GF per game: 2.2 31st GA per game: 3.98 32nd |
SH goals: 3 28th SF per game: 25.2 32nd SA per game: 35.1 32nd FaceoffW%: 49 22nd Hits/60: 22.64 14th Bks/60: 18 4th |
| Did not qualify for playoffs |
GoalsF. Zetterlund: 24 94th W. Eklund: 16 180th F. Zadina: 13 235th M. Granlund: 12 241st L. Kunin: 11 290th |
AssistsM. Granlund: 48 38th W. Eklund: 29 146th F. Zetterlund: 20 249th M. Ferraro: 18 307th C. Addison: 16 344th |
PointsM. Granlund: 60 93rd W. Eklund: 45 165th F. Zetterlund: 44 172nd M. Hoffman: 23 366th F. Zadina: 23 367th |
WinsM. Blackwood: 10 60th D. Cooley: 2 81st M. Chrona: 1 82nd G. Romanov: 0 96th |
Plus/MinusS. Sabourin: 0 380th G. Romanov: 0 454th D. Cooley: 0 451st M. Blackwood: 0 446th L. Couture: 0 441st |
Penalty MinutesL. Kunin: 83 28th C. Addison: 72 56th K. Burroughs: 71 58th K. Kostin: 53 126th G. Smith: 40 214th |
| Skaters | Shoots | Ht/Wt | Age | Country | Round | Pick | 2023-24 League | GP | G | A | Pts | +/- | PIM |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Celebrini, Macklin [C] | L | 6-0/190 | 18 | CAN | 1 | 1 | NCAA | 38 | 32 | 32 | 64 | 25 | 18 |
| Dickinson, Sam [D] | L | 6-3/200 | 18 | CAN | 1 | 11 | OHL | 68 | 18 | 52 | 70 | 56 | 30 |
| Chernyshov, Igor [LW] | R | 6-3/204 | 18 | RUS | 2 | 33 | KHL | 34 | 3 | 1 | 4 | -3 | 2 |
| Sahlin Wallenius, Leo [D] | L | 6-0/183 | 18 | SWE | 2 | 53 | Swe Jr. | 43 | 11 | 31 | 42 | 20 | 38 |
| Wetsch, Carson [RW] | R | 6-2/203 | 18 | CAN | 3 | 82 | WHL | 67 | 25 | 25 | 50 | -4 | 89 |
| Roberts, Colton [D] | R | 6-4/194 | 18 | CAN | 5 | 131 | WHL | 62 | 7 | 20 | 27 | -30 | 49 |
| Misskey, Nate [D] | R | 6-3/198 | 19 | CAN | 5 | 143 | WHL | 44 | 7 | 27 | 34 | 11 | 54 |
| Goaltenders | Catches | Ht/Wt | Age | Country | Round | Pick | 2023-24 League | GP | W | L | OT | SO | GAA | Sv% |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Kirsch, Christian [G] | L | 6-4/192 | 18 | SUI | 4 | 116 | Swi U20 | 30 | 22 | 5 | 1 | 3 | 2.32 | |
| Korostelyov, Yaroslav [G] | L | 6-2/168 | 19 | RUS | 7 | 194 | Rus Jr. | 16 | 8 | 8 | 0 | 2 | 3.07 | .931 |