View Team Rosters View Season Schedule

Top 10 Scorers

Invalid query: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tmrexecstats.stats_season.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\nstrSQL: SELECT stats_season.*, SUM(stats_season.gp) AS gp, SUM(stats_season.g) AS g, SUM(stats_season.a) AS a, SUM(stats_season.p) AS p, SUM(stats_season.pim) AS pim, SUM(stats_season.ppg) AS ppg, SUM(stats_season.ppa) AS ppa, SUM(stats_season.shg) AS shg, SUM(stats_season.sha) AS sha, SUM(stats_season.gwg) AS gwg, player.last AS last, player.first AS first FROM stats_season LEFT JOIN player ON player.id = stats_season.player WHERE 1=1 AND gametype = '0' AND gp != 0 AND gptype = '0' AND season='35' GROUP BY stats_season.player ORDER BY p DESC, p DESC, g DESC, gp ASC, a DESC, last DESC, first DESC LIMIT 0,10\n