!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 | Front Runners t6 Captains: Dick Weinand |
5 | 1 | 83.3% |
| 1 | The Dunes t7 Captains: Bruce Barsky |
5 | 1 | 83.3% |
| 3 | Palino Pals t5 Captains: Frank Abt |
4 | 2 | 66.7% |
| 3 | Ready to Roll t1 Captains: Skeeter Seifert |
4 | 2 | 66.7% |
| 5 | Masters Bocce Plus t3 Captains: Ken Freeman Nancy Freeman |
2 | 4 | 33.3% |
| 6 | Fireballs t2 Captains: Elizabeth Tewey |
1 | 5 | 16.7% |
| 7 | Bocce Barons t4 Captains: Cliff Bickerton |
0 | 6 | 0.0% |