return to home page
- Lakes Schedule
- Lakes Standings
- Lakes Scores
- Sound Schedule
- Sound Standings
- Sound Scores
- River Schedule
- River Standings
- River Scores
- all divisions printable standings
- Captains
- Teams
- League Rules
- Pelican Sound Rules
- Competitive League Home Page
- Pelican Sound Bocce
- set scores!301
requires password
!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`=1 AND `scoreHide` = 'no' AND `scoreStatus` = 'played'
GROUP BY teamId,divId ORDER BY sumWon DESC, sumLoss ASC,`sumTieBreak` ASC,teamName
Standings !616
Lakes
| Place | Team/Captain | Won | Lost | Pct |
|---|---|---|---|---|
| 1 | Masters 1 L04 Captains: Terry Mountford Kurt Blumenthal |
11 | 2 | 84.6% |
| 2 | Palmetto Dunes D L06 Captains: Jack Sulentich |
10 | 3 | 76.9% |
| 3 | Palmetto Dunes A L01 Captains: Nancy Walter |
9 | 4 | 69.2% |
| 4 | Hammock Green B L10 Captains: Roger Weinand |
7 | 6 | 53.8% |
| 4 | Masters 2 L05 Captains: Jim Van Auken |
7 | 6 | 53.8% |
| 4 | Turnberry 2 L07 Captains: Gary Mougin |
7 | 6 | 53.8% |
| 7 | Island Sound 2B L03 Captains: Bill Dickinson |
5 | 8 | 38.5% |
| 8 | Edgewater 2 L08 Captains: Sallie Cochran Debby Smith |
4 | 9 | 30.8% |
| 9 | Palmetto Dunes B L02 Captains: Steve Rudd |
3 | 10 | 23.1% |
| 10 | Torrey Pines L09 Captains: Howard Warren Jim Matlock |
2 | 11 | 15.4% |