SELECT t.teamid, p.lastname, p.firstname, t.teamname, et.tournamentteamid, t.city, s.section, s.sectionid, s.prefix, s.flag, c.name as clubname, c.clubid, sum( r.wins ) + sum( r.losses ) + sum( r.ties ) AS games, sum( r.wins ) / (sum( r.wins ) + sum( r.losses )) AS wpct, sum(r.wins) as wins, sum(r.losses) as losses, sum(r.ties) as ties, sum(points) as points, er.shootout, sum(r.ee_hammer_win) as ee_hammer_win, sum(r.ee_hammer_loss) as ee_hammer_loss, sum(r.one_point_win) as one_point_win, sum(r.one_point_loss) as one_point_loss, sum(r.ee_steal_win) as ee_steal_win, sum(r.ee_steal_loss) as ee_steal_loss, sum(r.fe_hammer_win) as fe_hammer_win, sum(fe_hammer_loss) as fe_hammer_loss, sum(r.fe_steal_win) as fe_steal_win, sum(fe_steal_loss) as fe_steal_loss FROM team t, tournamentteam et, tournamentrecord r, eventrecord er, player p, section s, clubs c WHERE r.tournamentid = 3127 AND et.tournamentteamid = r.tournamentteamid AND et.tournamentid = r.tournamentid AND t.teamid = et.teamid AND p.playerid = t.skip AND s.sectionid = t.sectionid AND c.clubid = t.clubid AND er.teamid = t.teamid GROUP BY t.teamid ORDER By er.orderlock, r.points DESC, r.wins DESC, r.losses ASC, er.shootout ASC, p.lastname[Standings Created]