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=91691
                    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=91691
                    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
Vincent Boulet

Vincent Boulet

#91691 / Passeport Valide / 0
Cote Joueur
N/A
Cote Gardien
N/A

Type de saison

Ligue MJ B A P PUN P/P
Dekhockey Lévis 51 29 29 58 16 1.14
DekHockey Thetford 1 1 0 1 2 1.00
Total 52 30 29 59 18 1.13

20 dernières parties

Équipe Contre Catégorie Date B A P PUN
Ameublement design MB Goal Diggers B2 1 1 2 -
Ameublement design MB Projet Rénovation Denoncourt B2 0 0 0 -
Ameublement design MB Nos Bêtes Noires B2 0 0 0 -
Ameublement design MB Dusenza B2 1 2 3 -
Ameublement design MB Nordiques (B2) B2 0 0 0 -
Ameublement design MB La Table du Hockey B2 0 0 0 -
Ameublement design MB Mustangs B2 1 2 3 -
Ameublement design MB Ours B2 1 0 1 1
IGA Marché Gagnon Sanitaire Fortier - B2 B2 1 0 1 2
Ameublement design MB Dusenza B2 0 0 0 -
Ameublement design MB La Pologne B2 0 2 2 1
Ameublement design MB La Table du Hockey B2 2 0 2 -
Ameublement design MB La Maison Du Routier B2 1 1 2 -
Ameublement design MB La Table du Hockey B2 3 1 4 -
Ameublement design MB Nos Bêtes Noires B2 0 0 0 -
Ameublement design MB Dusenza B2 0 1 1 1
Ameublement design MB Benchwarmers B2 1 1 2 1
Ameublement design MB La Table du Hockey B2 0 1 1 -
Ameublement design MB salon de quilles St-nicolas b2 B2 0 0 0 1
Ameublement design MB Dusenza B2 1 0 1 -

Joueurs avec qui il a joué le plus

Joueur Cote J. Cote G. Matchs Équipes
Zachary Marquis-Laflamme Zachary Marquis-Laflamme H5 H6 43 6 équipes
Théo Lemieux Théo Lemieux H6 N/A 40 6 équipes
Philippe Fauchon Philippe Fauchon pending N/A 38 6 équipes
Thomas Gauthier Thomas Gauthier H7 N/A 38 6 équipes
Nathaniel Aubert Nathaniel Aubert pending N/A 37 6 équipes
Jonathan Fauchon Jonathan Fauchon H4 N/A 28 5 équipes
Jérome Nadeau Jérome Nadeau H9 N/A 20 6 équipes
Alexandre Boucher Alexandre Boucher H7 H12 5 3 équipes
Yohan Cliche Yohan Cliche H7 N/A 3 2 équipes
Alexandre Charest Alexandre Charest H10 N/A 3 3 é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