!613 SELECT divId, divName, teamId, teamName, teamAbbreviation, teamCapId, teamCapIdCo, SUM(scoreWon) AS sumWon, SUM(scoreLoss) AS sumLoss,SUM(scorePlayed) AS sumPlayed, SUM(scoreTieBreak) AS sumTieBreak FROM `scoreLog` LEFT JOIN `teamLog` ON `scoreTeamId` = `teamId` LEFT JOIN `divisionLog` ON `teamDivId` = `divId` WHERE `divId`=1 AND `scoreHide` = 'no' AND `scoreStatus` = 'played' GROUP BY teamId,divId ORDER BY sumWon DESC, sumLoss ASC,`sumTieBreak` ASC,teamName