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=138396
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=138396
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
Samuel L'Espérance
Marie-Ève Chénier
Camille Pelletier
Simon Pelletier
Émilie Corbin
Pierre-Luc Roberge
Jérémy Garceau
Justine Pelletier
Yannick Levesque
Tanya Marier