!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
| Place | Team/Captain | Won | Lost | Pct |
|---|---|---|---|---|
| 1 | River Rollers t2 Captain: Tom Barbieri |
13 | 5 | 72.2% |
| 2 | The Rolling Stones t1 Captain: Kari Vilamaa |
12 | 6 | 66.7% |
| 3 | The Ballberians t4 Captain: Al Scott |
9 | 8 | 52.9% |
| 4 | Wildcats Cats t3 Captain: Bruce Clark |
9 | 9 | 50.0% |
| 5 | The Tootsie Rollers t5 Captain: Norm Zieg |
7 | 10 | 41.2% |
| 6 | Rolling Champs t6 Captain: Grace Spence |
3 | 15 | 16.7% |