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`=2 AND `scoreHide` = 'no' AND `scoreStatus` = 'played'
GROUP BY teamId,divId ORDER BY sumWon DESC, sumLoss ASC,`sumTieBreak` ASC,teamName
Standings !616
Sound
| Place | Team/Captain | Won | Lost | Pct |
|---|---|---|---|---|
| 1 | Southern Hills 2 S07 Captains: Eric Dany |
12 | 3 | 80.0% |
| 2 | Palmetto Dunes B S01 Captains: Virgil Kirskey |
10 | 5 | 66.7% |
| 3 | Hammock Green A S08 Captains: Denis Slaby |
8 | 7 | 53.3% |
| 3 | Oak Run S09 Captains: Bill Shaw |
8 | 7 | 53.3% |
| 3 | Pinehurst A S10 Captains: Steve Ettinger |
8 | 7 | 53.3% |
| 6 | Edgewater 1 S04 Captains: Jon Steele Robert Krause |
7 | 8 | 46.7% |
| 6 | Edgewater 2 S03 Captains: Sallie Cochran Debbie Smith |
7 | 8 | 46.7% |
| 8 | Torrey Pines S02 Captains: Howard Warren Jim Matlock |
6 | 9 | 40.0% |
| 9 | Island Sound 2A S05 Captains: Duane Maslowski |
5 | 10 | 33.3% |
| 10 | Seaside 2 S06 Captains: Bud Stoneburner |
4 | 11 | 26.7% |