Ron Moroz #4

Team:Americans Member Since:September 1st, 2000
Position: D   
Invalid query: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '' 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( 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 = stats_season.player WHERE 1=1 AND gametype = '0' AND gp != 0 AND gptype = '0' AND season='35' AND stats_season.player = '192' GROUP BY stats_season.player,, stats_season.season ORDER BY p DESC, p DESC, g DESC, gp ASC, a DESC, last DESC, first DESC\n