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=48625
                    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=48625
                    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
Yves Paquet

Yves Paquet

#48625 / Passeport Valide / 7
Cote Joueur
H13
Cote Gardien
N/A

Type de saison

Ligue MJ B A P PUN P/P
Championnats NBHPA 4 0 0 0 - 0.00
Classique Zio 14 5 6 11 - 0.79
Dek Hockey Trois-Rivières 490 101 128 229 80 0.47
Dekhockey Relance 48 18 16 34 4 0.71
Tournée Alex Burrows TAB 3 0 0 0 2 0.00
Dek Hockey Trois-Rivières 7 0 1 1 2 0.14
Dek Hockey Trois-Rivières 3 2 0 2 - 0.67
Dek Hockey Trois-Rivières 3 0 0 0 1 0.00
Dek Hockey Trois-Rivières 2 0 0 0 - 0.00
Dek Hockey Trois-Rivières 20 2 5 7 5 0.35
Total 594 128 156 284 94 0.48

20 dernières parties

Équipe Contre Catégorie Date B A P PUN
Mauricie Volkswagen Toiture Alain Therrien MIXTE MASSE SALARIALE 3 VS 3 30M — MMS30M (3 VS 3) Est 0 0 0 -
IG Gestion de Patrimoine M5 Distillerie Mariana M5 — M5 OUEST 0 0 0 -
Gamer's Spot MMS 22 Videotron Cap de la Madelaine MIXTE MASSE SALARIALE 3 VS 3 22M 0 0 0 -
Nice Guys H12 Les Cachalots H12 — H12 Est 1 0 1 -
Mauricie Volkswagen Via Capitale MIXTE MASSE SALARIALE 3 VS 3 30M — MMS30M (3 VS 3) Est 1 0 1 2
Mean Machine H11 Transport J. Gauthier H11 — H11 Ouest 0 2 2 -
Gamer's Spot MMS 22 Requins Blancs MIXTE MASSE SALARIALE 3 VS 3 22M 0 0 0 2
Mauricie Volkswagen M5 Construction Deslandes et fils M5 — M5 EST 0 0 0 -
Havre Saint-Maurice Thaï express M6 — M6 Est 0 0 0 -
Le Trèfle Shinobis H 13 0 0 0 -
Le Trèfle Shinobis H 13 1 0 1 -
Le Trèfle Progi H 13 0 0 0 -
Le Trèfle Icecat H 13 0 1 1 -
Les Marrettes Ordiplus H12 — H12 Ouest 0 0 0 -
Les Marrettes Conteneurs économiques H12 — H12 Ouest 0 0 0 -
Mauricie Volkswagen M5 Les Bas du Cap M5 M5 — M5 EST 0 1 1 -
Mauricie Volkswagen M5 Top Models M5 — M5 EST 0 0 0 -
Mauricie Volkswagen M5 Jokers M5 M5 — M5 EST 0 0 0 -
Havre Saint-Maurice Centre dentaire Beauclair M6 — M6 Est 1 0 1 -
Fix Auto Cognibox HR 1 0 1 -

Joueurs avec qui il a joué le plus

Joueur Cote J. Cote G. Matchs Équipes
Sandra Léonard Sandra Léonard W8 N/A 235 19 équipes
Audrey Matte Audrey Matte W7+ N/A 181 21 équipes
Patrice Painchaud Patrice Painchaud H13 H13 166 22 équipes
François Gélinas François Gélinas H13 N/A 116 17 équipes
Chantal Patry Chantal Patry W8 N/A 98 8 équipes
Steve Boisvert Steve Boisvert H11 N/A 94 13 équipes
Mathieu Tessier Mathieu Tessier H13 N/A 85 15 équipes
Guy Simard Guy Simard H13 N/A 73 11 équipes
Pascal Labrie Pascal Labrie H13 N/A 70 8 équipes
Chad Meunier-Saindon Chad Meunier-Saindon H12 H11 70 9 équipes

Historique des changements de cotes

Date Type Ancienne cote Nouvelle cote
Cote de joueur pending H13
Cote de joueur H13 pending

Connexion requise

Vous devez être connecté pour suivre un joueur.

Pas encore membre? Créer un compte