!613 SELECT teamId, teamName, teamAbbreviation, teamCapId, teamCapIdCo, SUM(scoreWon) AS sumWon, SUM(scoreLost) AS sumLoss,SUM(scorePlayed) AS sumPlayed, SUM(scoreTieBreak) AS sumTieBreak FROM `mblScoreLog` LEFT JOIN `mblTeamLog` ON `scoreTeamId` = `teamId` WHERE `scoreHide` = 'no' AND `scoreStatus` = 'played' GROUP BY teamId ORDER BY sumWon DESC, sumLoss ASC,`sumTieBreak` ASC,teamName

Standings !616

Masters Bocce League
PlaceTeam/CaptainWonLostPct 
1Rolling Champs
Captain: George Monahan
24777.4% 
2Wildcats Cats
Captain: Bruce Clark
181358.1% 
3Masters Blasters
Captain: Nancy Freeman
171454.8% 
4The Tootsie Rollers
Captain: Norm Zieg
171651.5% 
5The Rolling Stones
Captain: Kari Vilamaa
151648.4% 
6River Rollers
Captain: Jerry Vasile
141942.4% 
7The Ballberians
Captain: Bill Eliis
121938.7% 
8Ready to Roll
Captains: Lynelle Moscaritolo
               Mike Moscaritolo
112035.5% 
mblAdmin.php v05 2025-03-26 9:14 AM:77