SELECT 
                    s.season_name, 
                    s.season_id,
                    s.league_id,
                    l.league_name,
                    l.site_url,
                    l.public_site_urls,
                    c.full_category_name,
                    SUM(overide_nd_games) as mj,
                    SUM(goals_total) as b,
                    SUM(assists) as a,
                    SUM(goals_total)+SUM(assists) AS p,
                    SUM(penalties) AS pun,
                    ROUND((SUM(goals_total)+SUM(assists))/SUM(overide_nd_games),2) AS pp,
                    SUM(pp_goals) as ban,
                    SUM(pp_goals)+SUM(pp_assists) as pan,
                    SUM(pk_goals) as bin,
                    SUM(pk_goals)+SUM(pk_assists) as pin,
                    SUM(winning_goal) AS bg,
                    SUM(overtime_goal) as bp

                FROM rosters r 
                    JOIN roster_stats rs ON (r.roster_id=rs.roster_id)
                    JOIN games g ON (g.game_id=r.game_id)
                    JOIN players p ON (p.player_id=r.player_id)
                    JOIN seasons s ON (r.season_id=s.season_id)
                    JOIN leagues l ON (l.league_id=s.league_id)
                    JOIN categories c ON (c.category_id=r.category_id)
                    JOIN teams t ON (t.team_id=r.team_id)
                WHERE 
                    p.nbhpa_player_id=90511
                    AND g.is_playoff=0
                    AND r.gets_decision=0
                    AND s.status != 'hidden_from_site'
                    AND s.visible = 1
                    AND g.visible = 1
                    AND t.visible = 1
                    AND c.hide_stats = 0
                GROUP BY l.league_id

                ORDER BY 
                    l.league_name ASC
SELECT 
                    s.season_name, 
                    s.season_id,
                    s.league_id,
                    l.league_name,
                    l.site_url,
                    l.public_site_urls,
                    c.full_category_name,
                    SUM(overide_nd_games) as mj,
                    SUM(goals_total) as b,
                    SUM(assists) as a,
                    SUM(goals_total)+SUM(assists) AS p,
                    SUM(penalties) AS pun,
                    ROUND((SUM(goals_total)+SUM(assists))/SUM(overide_nd_games),2) AS pp,
                    SUM(pp_goals) as ban,
                    SUM(pp_goals)+SUM(pp_assists) as pan,
                    SUM(pk_goals) as bin,
                    SUM(pk_goals)+SUM(pk_assists) as pin,
                    SUM(winning_goal) AS bg,
                    SUM(overtime_goal) as bp

                FROM rosters r 
                    JOIN roster_stats rs ON (r.roster_id=rs.roster_id)
                    JOIN games g ON (g.game_id=r.game_id)
                    JOIN players p ON (p.player_id=r.player_id)
                    JOIN seasons s ON (r.season_id=s.season_id)
                    JOIN leagues l ON (l.league_id=s.league_id)
                    JOIN categories c ON (c.category_id=r.category_id)
                    JOIN teams t ON (t.team_id=r.team_id)
                WHERE 
                    p.nbhpa_player_id=90511
                    AND g.is_playoff=1
                    AND r.gets_decision=0
                    AND s.status != 'hidden_from_site'
                    AND s.visible = 1
                    AND g.visible = 1
                    AND t.visible = 1
                    AND c.hide_stats = 0
                GROUP BY l.league_id

                ORDER BY 
                    l.league_name ASC
NBHPA - Joueur
Léa Bisaillon

Léa Bisaillon

#90511 / Passeport expiré / 0
Cote Joueur
W8
Cote Gardien
N/A

Type de saison

Ligue MJ B A P PUN P/P
Dek Hockey Trois-Rivières 59 39 19 58 15 0.98
DekHockey Shawinigan 3 0 0 0 - 0.00
Total 62 39 19 58 15 0.94

20 dernières parties

Équipe Contre Catégorie Date B A P PUN
Bucks Les boys (M4) M4 ( Shawi ) 0 0 0 -
Bucks Lessard Gm M4 ( Shawi ) 0 0 0 -
Bucks Le globe steakhouse M4 ( Shawi ) 0 0 0 -
Mustangs F7 Roger F7 F7 — F7 Ouest 1 0 1 -
Mustangs F7 La Tribu - Café Gourmet F7 — F7 Ouest 0 0 0 2
Mustangs F7 Kègle CPA F7 — F7 Ouest 1 0 1 -
Mustangs F7 Kègle CPA F7 — F7 Ouest 1 0 1 -
Mustangs F7 Restaurant Le Grec F7 F7 — F7 Ouest 1 1 2 -
Mustangs F7 Hashtag F7 F7 — F7 Ouest 0 1 1 -
Mustangs F7 Les Capitaines F7 — F7 Ouest 1 0 1 -
Mario Bros Shark Attack F8 — F8 Ouest 0 0 0 -
Mustangs F7 Restaurant Le Grec F7 F7 — F7 Ouest 1 0 1 -
Mustangs F7 La Tribu - Café Gourmet F7 — F7 Ouest 0 0 0 2
Mustangs F7 Hashtag F7 F7 — F7 Ouest 2 1 3 -
Mustangs F7 Bar le Chav F7 — F7 Ouest 2 0 2 -
Mustangs F7 Centre Dentaire Alain Isabelle F7 F7 — F7 Ouest 0 0 0 -
Mustangs F7 Roger F7 F7 — F7 Ouest 1 1 2 -
Mustangs F7 Les Capitaines F7 — F7 Ouest 1 0 1 2
Mustangs F7 Kègle CPA F7 — F7 Ouest 0 0 0 -
Mustangs F7 Neuractiv F7 F7 — F7 Ouest 0 0 0 -

Joueurs avec qui elle a joué le plus

Joueur Cote J. Cote G. Matchs Équipes
Sophie Gervais Sophie Gervais W7 N/A 37 6 équipes
Sabrina Thibault Sabrina Thibault W8 W8 17 2 équipes
Karine Robert-Fugère Karine Robert-Fugère W8 N/A 16 2 équipes
Sarah Krystel Gauthier-Doucet Sarah Krystel Gauthier-Doucet W8 N/A 15 3 équipes
Noémie Auger Noémie Auger W8 N/A 14 1 équipe
Laurence Dubois Laurence Dubois W7 N/A 13 2 équipes
Vincent Lessard Vincent Lessard H10 N/A 11 1 équipe
Laurence Gratton Laurence Gratton W8 N/A 11 2 équipes
Edith Lussier Edith Lussier N/A N/A 11 2 équipes
Alicia Laroche Alicia Laroche W6 N/A 10 1 équipe

Historique des changements de cotes

Date Type Ancienne cote Nouvelle cote
Cote de joueur pending W8
Cote de joueur N/A pending

Connexion requise

Vous devez être connecté pour suivre un joueur.

Pas encore membre? Créer un compte