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=42538
                    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=42538
                    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
Jocelyne Grisé

Jocelyne Grisé

#42538 / Passeport Valide / 0
Cote Joueur
W8
Cote Gardien
N/A

Type de saison

Ligue MJ B A P PUN P/P
Coupe Dix10 9 3 3 6 - 0.67
Coupe M-Sports 5 1 0 1 - 0.20
Dek Granby / Dix10 287 162 72 234 26 0.82
Dek Hockey Granby 316 131 86 217 34 0.69
Dekhockey Cowansville 9 7 4 11 - 1.22
Pile ou face 111 61 43 104 10 0.94
Tournée Alex Burrows TAB 3 0 0 0 - 0.00
Pile ou face 2 1 1 2 - 1.00
Pile ou face 11 5 1 6 - 0.55
Pile ou face 1 0 0 0 - 0.00
Pile ou face 1 0 0 0 - 0.00
Total 755 371 210 581 70 0.77

20 dernières parties

Équipe Contre Catégorie Date B A P PUN
Les Mom's Les bagnoles F8 0 0 0 -
Gardens party Gladiatrices F7 0 0 0 -
Phoenix Tradelco F30-B 0 1 1 -
Moms Cheetahs F8 0 0 0 -
Les dragonnes F5 justice league F5 0 1 1 -
Phoenix Cidrerie Milton F30-B 0 1 1 -
Phoenix Les Maudites F30-B 0 1 1 -
Les dragonnes Boo bees F5 0 1 1 2
Moms Les forestières F8 0 1 1 -
Phoenix Tradelco F30-B 0 0 0 -
Les dragonnes Fireball F5 1 0 1 -
Équipe Arès Beer Hunter F6 0 1 1 -
Gardens party Les bombes F7 0 0 0 -
Moms Cheetahs F8 0 0 0 -
Phoenix Mamacitas F30-B 0 0 0 -
Équipe Arès Icebreakers F6 0 0 0 -
Moms Bagnoles F8 0 0 0 -
Les dragonnes ROSEBUD F5 F5 0 0 0 -
Moms Groupe GFE F8 0 0 0 -
Phoenix Cidrerie Milton F30-B 0 2 2 -

Joueurs avec qui elle a joué le plus

Joueur Cote J. Cote G. Matchs Équipes
Luc Lamarche Luc Lamarche H10 N/A 240 47 équipes
Josée Pelletier Josée Pelletier W8 N/A 180 32 équipes
Claudia Thibault Claudia Thibault W8 N/A 171 34 équipes
Jessica Corneau Jessica Corneau W7 N/A 165 32 équipes
Anthony Joyal-Deslandes Anthony Joyal-Deslandes H11 N/A 144 26 équipes
Stéphanie Bourget Stéphanie Bourget W8 N/A 132 29 équipes
Anne-Marie Lecours Anne-Marie Lecours W7 W7 130 38 équipes
Carine Dupaul Carine Dupaul W8 N/A 118 25 équipes
Guylaine Marcoux Guylaine Marcoux W7 N/A 111 24 équipes
Annick Brunelle Annick Brunelle W8 N/A 107 22 équipes

Historique des changements de cotes

Date Type Ancienne cote Nouvelle cote
Cote de joueur W7 W8
Cote de joueur W8 W7
Cote de joueur W7 W8

Connexion requise

Vous devez être connecté pour suivre un joueur.

Pas encore membre? Créer un compte