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=125604
                    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=125604
                    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
Maude Dupéré

Maude Dupéré

#125604 / Passeport expiré / 0
Cote Joueur
N/A
Cote Gardien
N/A

Type de saison

Ligue MJ B A P PUN P/P
Dek Hockey Trois-Rivières 21 4 7 11 6 0.52
Total 21 4 7 11 6 0.52

20 dernières parties

Équipe Contre Catégorie Date B A P PUN
Mustangs MR Le 920 MR 0 0 0 1
Mustangs MR Les Requins Blancs MR 0 0 0 -
Mustangs MR DJ Plam MR 0 0 0 -
Mustangs MR Predator Hunting Canada MR 0 0 0 2
Mustangs MR Predator Hunting Canada MR 0 0 0 -
Mustangs MR Panthères MR MR 0 2 2 2
Mustangs MR DJ Plam MR 0 0 0 2
Mustangs MR Dek Ergo MR 0 0 0 -
Mustangs MR Le 920 MR 0 1 1 -
Mustangs MR Pourvoirie du Lac Blanc MR 0 0 0 -
Mustangs MR Hammerheads MR 0 0 0 -
Mustangs MR DJ Plam MR 0 1 1 -
Mustangs MR Jimmace MR 0 1 1 -
Mustangs MR Red Stars MR 0 0 0 -
Mustangs MR Jokers MR 0 0 0 -
Mustangs MR Flying Squirrel MR 2 0 2 -
Mustangs MR BDeB Avocats MR 0 0 0 -
Mustangs MR Predator Hunting Canada MR 0 0 0 -
Mustangs MR Raiders MR 0 0 0 -
Mustangs/Centre Dentaire Alain Isabelle Fritolay F8 F8 — F8 Est 0 1 1 -

Joueurs avec qui elle a joué le plus

Joueur Cote J. Cote G. Matchs Équipes
Catherine Courchesne Catherine Courchesne W7 N/A 21 3 équipes
Sandra Léonard Sandra Léonard W8 N/A 20 2 équipes
Yves Paquet Yves Paquet H13 N/A 19 2 équipes
Ivan Brown Ivan Brown H13 N/A 18 2 équipes
Pascal Labrie Pascal Labrie H13 N/A 18 2 équipes
Léonie Coulombe Léonie Coulombe W8 N/A 12 2 équipes
Steeve Dupéré Steeve Dupéré H12 N/A 12 2 équipes
Chantal Patry Chantal Patry W8 N/A 9 2 équipes
Joanie Milette Joanie Milette pending N/A 8 1 équipe
Guillaume Beauchemin Guillaume Beauchemin H11 N/A 4 2 équipes

Historique des changements de cotes

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

Connexion requise

Vous devez être connecté pour suivre un joueur.

Pas encore membre? Créer un compte