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 = 47 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. | Rutger McGroarty [W/C], 20 1 15 | 2024-25 | NCAA |
| 2. | Brad Lambert [RW/C], 20 1 47 | 2024-25 | NHL |
| 3. | Colby Barlow [LW], 19 1 51 | 2025-26 | OHL |
| 4. | Elias Salomonsson [RD], 20 2 | 2025-26 | SHL |
| 5. | Nikita Chibrikov [LW/RW], 21 2 | 2025-26 | NHL |
| 6. | Chaz Lucius [C], 21 1 | 2025-26 | AHL |
| 7. | Alfons Freij [RD/LD], 18 2 | Long term | Swe Jr. |
| 8. | Parker Ford [RW/C], 24 | 2024-25 | AHL |
| 9. | Jacob Julien [C], 20 5 | Long term | OHL |
| 10. | Dmitri Rashevsky [RW], 24 5 | 2025-26 | KHL |
| 11. | Domenic DiVincentiis [G], 20 7 | Long term | OHL |
| 12. | Danny Zhilkin [C], 20 3 | Long term | AHL |
| 13. | Dmitri Kuzmin [LD], 21 3 | Long term | ECHL |
| 14. | Fabian Wagner [C/RW], 20 6 | Long term | SHL |
| 15. | Connor Levis [C], 20 7 | Long term | WHL |
| 16. | Kevin He [LW], 18 4 | Long term | OHL |
| 17. | Kieron Walton [C/LW], 18 6 | Long term | OHL |
| 18. | Garrett Brown [RD], 20 4 | Long term | NCAA |
| 19. | Markus Loponen [C], 18 5 | Long term | Fin Jr. |
| 20. | Zach Nehring [RW], 19 3 | Long term | USHL |
| 21. | Tyrel Bauer [RD], 22 6 | Long term | AHL |
| 22. | Henri Nikkanen [C], 23 4 | 2025-26 | AHL |
| 23. | Daniel Torgersson [LW/RW], 22 2 | 2025-26 | AHL |
| 24. | Thomas Milic [G], 21 5 | Long term | AHL |
| 25. | Simon Lundmark [RD], 24 2 | 2024-25 | AHL |
|
Division: 2nd Record: 52-24-5-1 4th Home: 27-11-3-0 6th Away: 25-13-2-1 6th 1st Half: 28-9-3-1 1st 2nd Half: 24-15-2-0 10th |
OT/SO: 6-6 27th PP%: 18.8 22nd PK%: 77.1 21st PIM per game: 7:56 8th GF per game: 3.16 15th GA per game: 2.41 1st |
SH goals: 3 31st SF per game: 30.3 17th SA per game: 29.6 11th FaceoffW%: 47.6 24th Hits/60: 22.46 17th Bks/60: 14.91 21st |
| First Round: L 4-1 vs. Colorado Avalanche |
GoalsK. Connor: 34 26th T. Toffoli: 33 33rd S. Monahan: 26 81st M. Scheifele: 25 84th N. Ehlers: 25 86th |
AssistsJ. Morrissey: 59 18th M. Scheifele: 47 42nd N. Ehlers: 36 99th S. Monahan: 33 125th N. Pionk: 28 158th |
PointsM. Scheifele: 72 47th J. Morrissey: 69 57th K. Connor: 61 87th N. Ehlers: 61 86th S. Monahan: 59 97th |
WinsC. Hellebuyck: 37 2nd L. Brossoit: 15 38th |
Plus/MinusD. DeMelo: 46 2nd J. Morrissey: 34 9th N. Ehlers: 27 19th B. Dillon: 20 42nd M. Scheifele: 19 53rd |
Penalty MinutesB. Dillon: 92 17th N. Pionk: 63 82nd A. Lowry: 57 105th M. Scheifele: 57 106th J. Morrissey: 44 177th |
| Skaters | Shoots | Ht/Wt | Age | Country | Round | Pick | 2023-24 League | GP | G | A | Pts | +/- | PIM |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Freij, Alfons [D] | L | 6-1/196 | 18 | SWE | 2 | 37 | Swe Jr. | 40 | 14 | 19 | 33 | 0 | 14 |
| He, Kevin [LW] | L | 6-0/181 | 18 | CAN | 4 | 109 | OHL | 64 | 31 | 22 | 53 | -13 | 66 |
| Loponen, Markus [C] | L | 6-1/185 | 18 | FIN | 5 | 155 | Fin Jr. | 45 | 25 | 29 | 54 | 40 | 31 |
| Walton, Kieron [C/LW] | L | 6-6/212 | 18 | CAN | 6 | 187 | OHL | 65 | 18 | 25 | 43 | -5 | 18 |