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=75348
                    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=75348
                    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
Alexandre Lacroix

Alexandre Lacroix

#75348 / Passeport Valide / 0
Cote Joueur
H12
Cote Gardien
H12

Type de saison

Ligue MJ B A P PUN P/P
Coupe Bob Bissonnette 3 1 0 1 - 0.33
Coupe M-Sports 10 0 0 0 1 0.00
Dek Bouch 5 5 0 5 1 1.00
Dek Granby / Dix10 200 140 100 240 70 1.20
Dek Hockey Granby 252 168 132 300 108 1.19
Dek-Nation 2 1 0 1 - 0.50
Pile ou face 36 9 11 20 10 0.56
Tournée Alex Burrows TAB 8 4 1 5 - 0.63
Tournois Esthellika 3 0 0 0 - 0.00
Tournois TAL 3 2 1 3 1 1.00
Total 522 330 245 575 191 1.10

20 dernières parties

Équipe Contre Catégorie Date B A P PUN
Theglass Jelly Beans M7-AMICALE 0 0 0 -
Theglass Les Remparts D3 2 1 3 -
Theglass So 6 D3 0 0 0 -
Les poules de Luxe Les Paparmanes M8 0 0 0 -
Theglass Les Marsouins de Granby D3 1 0 1 2
Theglass Transport Ménard D3 0 0 0 -
Theglass Jelly Beans M7-AMICALE 2 0 2 -
Theglass Les alcooliques M7-AMICALE 0 0 0 -
Theglass Gladiateurs D3 0 1 1 -
Theglass Lassonde M7-AMICALE 0 0 0 -
Theglass Les Remparts D3 0 1 1 2
Theglass Jelly Beans M7-AMICALE 0 1 1 -
Theglass Les alcooliques M7-AMICALE 1 0 1 -
Theglass Gladiateurs D3 0 1 1 -
Theglass Hockey 2.0 D3 0 1 1 -
Toit C.L. Assaut D4 2 0 2 2
Theglass Lassonde M7-AMICALE 0 1 1 -
Angry Groots Summum Dek Hockey MR 0 0 0 -
Angry Groots Les Paparmanes MR 1 0 1 -
Angry Groots SUICIDE SQUAD MR 0 0 0 -

Joueurs avec qui il a joué le plus

Joueur Cote J. Cote G. Matchs Équipes
Karolane Beaudry Karolane Beaudry W7 W8 223 41 équipes
Nicholas Marquis Nicholas Marquis H12 N/A 144 26 équipes
Kevin Blanchard-Rivard Kevin Blanchard-Rivard H11 N/A 138 28 équipes
Nadeige Simoneau-Roy Nadeige Simoneau-Roy W7+ W8 132 26 équipes
Sebastien Frenière Sebastien Frenière H12 N/A 131 27 équipes
Kevin Coulombe Kevin Coulombe H11 N/A 125 23 équipes
Cindy Surprenant Cindy Surprenant W8 N/A 116 22 équipes
Annie Dugrenier Annie Dugrenier W8 N/A 112 22 équipes
Karolane Bourget Karolane Bourget W8 N/A 99 21 équipes
Frédéric Labonté Frédéric Labonté H12 H11 97 28 équipes

Historique des changements de cotes

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

Connexion requise

Vous devez être connecté pour suivre un joueur.

Pas encore membre? Créer un compte