!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 |
1 | 0 | 100.0% |
| 1 | Masters Bocce Plus t3 Captains: Ken Freeman Nancy Freeman |
1 | 0 | 100.0% |
| 1 | Palino Pals t5 Captains: Frank Abt |
1 | 0 | 100.0% |
| 4 | Bocce Barons t4 Captains: Cliff Bickerton |
0 | 1 | 0.0% |
| 4 | Fireballs t2 Captains: Elizabeth Tewey |
0 | 1 | 0.0% |
| 4 | Ready to Roll t1 Captains: Skeeter Seifert |
0 | 1 | 0.0% |