SELECT SQL_CALC_FOUND_ROWS SQL_CACHE (SELECT DISTINCT COUNT(RosterID) FROM `MJAHL-2012-2013`.GameRosters WHERE SubSeasonID = 5 AND GameRosters.PlayerID=Players.PlayerID) As `GP`, (SELECT COUNT(GoalID) FROM `MJAHL-2012-2013`.Goals WHERE Goals.PlayerID = Players.PlayerID AND SubSeasonID = 5 GROUP BY Goals.PlayerID LIMIT 1) As `G`, (SELECT COUNT(AssistsID) FROM `MJAHL-2012-2013`.Assists Where SubSeasonID = 5 AND Assists.PlayerID = Players.PlayerID GROUP BY Assists.PlayerID LIMIT 1) As `A`, COALESCE((SELECT COUNT(GoalID) FROM `MJAHL-2012-2013`.Goals WHERE Goals.PlayerID = Players.PlayerID AND SubSeasonID = 5 GROUP BY Players.PlayerID LIMIT 1),0) + COALESCE((SELECT COUNT(AssistsID) FROM `MJAHL-2012-2013`.Assists Where SubSeasonID = 5 AND Assists.PlayerID = Players.PlayerID GROUP BY Assists.PlayerID LIMIT 1), 0) As `PTS`, (COALESCE((SELECT COUNT(GoalID) FROM `MJAHL-2012-2013`.Goals WHERE Goals.PlayerID = Players.PlayerID AND SubSeasonID = 5 GROUP BY Players.PlayerID LIMIT 1),0) + COALESCE((SELECT COUNT(AssistsID) FROM `MJAHL-2012-2013`.Assists Where SubSeasonID = 5 AND Assists.PlayerID = Players.PlayerID GROUP BY Assists.PlayerID LIMIT 1), 0))/(SELECT COUNT(RosterID) FROM `MJAHL-2012-2013`.GameRosters WHERE SubSeasonID = 5 AND GameRosters.PlayerID=Players.PlayerID LIMIT 1) As `PTSPG`, (SELECT COUNT(GoalID) FROM `MJAHL-2012-2013`.Goals Where SubSeasonID = 5 AND Goals.PlayerID = Players.PlayerID GROUP BY Goals.PlayerID LIMIT 1)/(SELECT COUNT(RosterID) FROM `MJAHL-2012-2013`.GameRosters WHERE SubSeasonID = 5 AND GameRosters.PlayerID=Players.PlayerID LIMIT 1) As `GPG`, (SELECT COUNT(GoalID) FROM `MJAHL-2012-2013`.Goals Where SubSeasonID = 5 AND Goals.PlayerID = Players.PlayerID AND Goals.GoalTypeID=2 GROUP BY Goals.PlayerID LIMIT 1) As `PPG`, (SELECT COUNT(GoalID) FROM `MJAHL-2012-2013`.Goals Where SubSeasonID = 5 AND Goals.PlayerID = Players.PlayerID AND Goals.GoalTypeID=3 GROUP BY Goals.PlayerID LIMIT 1) As `SHG`, (SELECT COUNT(GoalID) FROM `MJAHL-2012-2013`.Goals Where SubSeasonID = 5 AND Goals.PlayerID = Players.PlayerID AND Goals.GoalTypeID=1 GROUP BY Goals.PlayerID LIMIT 1) As `ENG`, (SELECT SUM(PenaltyLength) FROM `MJAHL-2012-2013`.Penalties Where SubSeasonID = 5 AND Penalties.PlayerID = Players.PlayerID GROUP BY Penalties.PlayerID LIMIT 1) As `PIMS`, (SELECT SUM(PenaltyLength) FROM `MJAHL-2012-2013`.Penalties Where SubSeasonID = 5 AND Penalties.PlayerID = Players.PlayerID GROUP BY Penalties.PlayerID LIMIT 1)/(SELECT COUNT(RosterID) FROM `MJAHL-2012-2013`.GameRosters WHERE SubSeasonID = 5 AND GameRosters.PlayerID=Players.PlayerID LIMIT 1) As `PIMPG`, Teams.ShortName, Teams.TeamID, Players.FirstName, Players.LastName, Players.PlayerID, Players.Rookie, Players.AP, Players.`No`, Players.`Position` FROM `MJAHL_LeaugeDB`.Players INNER JOIN `MJAHL_LeaugeDB`.Teams ON Players.TeamID = Teams.TeamID WHERE Players.`Position` != 'Goalie'   AND Players.`Position` != 'Asst. Coach' AND Players.`Position` != 'Head Coach' AND (SELECT DISTINCT COUNT(RosterID) FROM `MJAHL-2012-2013`.GameRosters WHERE SubSeasonID = 5 AND GameRosters.PlayerID=Players.PlayerID LIMIT 1) > 0 GROUP BY Players.PlayerID ORDER BY TeamName  DESC, `G` DESC LIMIT 250, 50<br>Mysql Said: Unknown column 'TeamName' in 'order clause'<br>/var/www/vhosts/themhl.ca/httpdocs/lib/stats_functions.php on line 1271
<br>