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 = 13 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. | Seamus Casey [RD], 20 2 44 | 2025-26 | NCAA |
| 2. | Lenni Hameenaho [RW], 19 2 78 | Long term | Liiga |
| 3. | Anton Silayev [LD], 18 1 | Long term | KHL |
| 4. | Josh Filmon [LW], 20 6 | Long term | WHL |
| 5. | Isaac Poulter [G], 23 | Long term | AHL |
| 6. | Topias Vilen [LD], 21 5 | 2025-26 | AHL |
| 7. | Daniil Misyul [LD], 23 3 | 2025-26 | AHL |
| 8. | Mikael Diotte [RD], 21 | Long term | QMJHL |
| 9. | Dylan Wendt [RW], 23 | 2025-26 | NCAA |
| 10. | Jakub Malek [G], 22 4 | Long term | Liiga |
| 11. | Petr Hauser [RW], 21 5 | Long term | Czechia |
| 12. | Ethan Edwards [LD], 22 4 | Long term | NCAA |
| 13. | Daniil Orlov [LD], 20 4 | Long term | KHL |
| 14. | Artyom Barababosha [RD], 20 7 | Long term | KHL |
| 15. | Cam Squires [RW], 19 4 | Long term | QMJHL |
| 16. | Cole Brown [RW], 19 6 | Long term | OHL |
| 17. | Mikhail Yegorov [G], 18 2 | Long term | USHL |
| 18. | Kasper Pikkarainen [RW], 18 3 | Long term | Liiga |
| 19. | Herman Traff [LW/RW], 18 3 | Long term | SHL |
| 20. | Arseni Gritsyuk [RW], 23 5 | Long term | KHL |
| 21. | Samu Salminen [C/LW], 21 3 | Long term | NCAA |
| 22. | Viktor Hurtig [RD], 22 6 | Long term | NCAA |
| 23. | Chase Cheslock [RD], 19 5 | Long term | NCAA |
| 24. | Charlie Leddy [RD], 20 4 | Long term | NCAA |
| 25. | Matyas Melovsky [C/W], 20 6 | Long term | QMJHL |
|
Division: 7th Record: 38-39-3-2 23rd Home: 17-21-1-2 28th Away: 21-18-2-0 12th 1st Half: 22-16-2-1 11th 2nd Half: 16-23-1-1 26th |
OT/SO: 5-5 32nd PP%: 22.5 13th PK%: 80.7 10th PIM per game: 8:51 15th GF per game: 3.22 12th GA per game: 3.43 27th |
SH goals: 3 27th SF per game: 30.7 16th SA per game: 30 18th FaceoffW%: 53.5 4th Hits/60: 20.21 24th Bks/60: 13.53 29th |
| Did not qualify for playoffs |
GoalsT. Meier: 28 63rd J. Bratt: 27 65th N. Hischier: 27 67th J. Hughes: 27 66th D. Mercer: 20 138th |
AssistsJ. Bratt: 56 22nd J. Hughes: 47 41st N. Hischier: 40 63rd L. Hughes: 38 84th T. Meier: 24 196th |
PointsJ. Bratt: 83 24th J. Hughes: 74 41st N. Hischier: 67 62nd T. Meier: 52 126th L. Hughes: 47 150th |
WinsV. Vanecek: 17 32nd J. Allen: 12 52nd N. Daws: 9 62nd K. Kahkonen: 7 69th A. Schmid: 5 71st |
Plus/MinusC. Lazar: 10 150th M. McLeod: 6 206th S. Hatakka: 5 210th K. MacDermid: 4 261st C. Tierney: 3 273rd |
Penalty MinutesK. Bahl: 82 29th K. MacDermid: 73 53rd B. Smith: 61 91st E. Haula: 54 121st T. Meier: 45 167th |
| Skaters | Shoots | Ht/Wt | Age | Country | Round | Pick | 2023-24 League | GP | G | A | Pts | +/- | PIM |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Silayev, Anton [D] | L | 6-7/207 | 18 | RUS | 1 | 10 | KHL | 63 | 3 | 8 | 11 | -9 | 10 |
| Pikkarainen, Kasper [RW] | R | 6-3/198 | 18 | FIN | 3 | 85 | Liiga | 5 | 0 | 0 | 0 | -3 | 0 |
| Melovsky, Matyas [C] | R | 6-1/190 | 20 | CZE | 6 | 171 | QMJHL | 53 | 18 | 42 | 60 | 42 | 27 |
| Goaltenders | Catches | Ht/Wt | Age | Country | Round | Pick | 2023-24 League | GP | W | L | OT | SO | GAA | Sv% |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Yegorov, Mikhail [G] | L | 6-5/181 | 18 | RUS | 2 | 49 | USHL | 43 | 8 | 25 | 3 | 3.86 | .892 | |
| Louhivaara, Veeti [G] | L | 6-4/207 | 18 | FIN | 5 | 146 | Liiga | 1 | 0 | 0 | 0 | 0 | 0 | 1 |