David Cloutier #6

Team:Americans Member Since:
Position: D   
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' AND stats_season.player = '387' GROUP BY stats_season.player, stats_season.team, stats_season.season ORDER BY p DESC, p DESC, g DESC, gp ASC, a DESC, last DESC, first DESC\n