!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`=4 AND `scoreHide` = 'no' AND `scoreStatus` = 'played'
GROUP BY teamId,divId ORDER BY sumWon DESC, sumLoss ASC,`sumTieBreak` ASC,teamName
Standings !616
Competitive
| Place | Team/Captain | Won | Lost | Pct |
|---|---|---|---|---|
| 1 | The Dunes t6 Captains: Bruce Barsky |
5 | 1 | 83.3% |
| 2 | Masters Bocce Plus t5 Captains: Bruce Clark Nancy Freeman |
4 | 2 | 66.7% |
| 3 | Fireballs t1 Captains: Elizabeth Tewey |
3 | 3 | 50.0% |
| 3 | Front Runners t4 Captains: Dick Weinand |
3 | 3 | 50.0% |
| 3 | Palino Pals t3 Captains: Frank Abt |
3 | 3 | 50.0% |
| 6 | Bocce Barons t7 Captains: Cliff Bickerton |
2 | 4 | 33.3% |
| 7 | Ready to Roll t2 Captains: Skeeter Seifert |
1 | 5 | 16.7% |