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`=3 AND `scoreHide` = 'no' AND `scoreStatus` = 'played'
GROUP BY teamId,divId ORDER BY sumWon DESC, sumLoss ASC,`sumTieBreak` ASC,teamName
Standings !616
River
| Place | Team/Captain | Won | Lost | Pct |
|---|---|---|---|---|
| 1 | Island Sound 2C R06 Captain: Marilyn Goodsman Marsey Shuman |
6 | 1 | 85.7% |
| 2 | Seaside 2 R01 Captain: Bud Stoneburner |
6 | 2 | 75.0% |
| 3 | Island Sound 1A R07 Captain: Judy Schele Marilyn Carter |
5 | 3 | 62.5% |
| 4 | Oak Run B R09 Captain: Lynn Schenck |
4 | 3 | 57.1% |
| 5 | Gleneagles A R04 Captain: Rick Redman |
4 | 4 | 50.0% |
| 5 | Palmetto Dunes C R08 Captain: Jon Van Stone |
4 | 4 | 50.0% |
| 5 | Southern Hills 1 R03 Captain: Victor Dortona |
4 | 4 | 50.0% |
| 8 | Island Sound 2A R02 Captain: Danny O`Brien |
3 | 4 | 42.9% |
| 8 | Palmetto Dunes E R10 Captain: Ted Rosner |
3 | 4 | 42.9% |
| 10 | Gleneagles B R05 Captain: David Garfield |
3 | 5 | 37.5% |
| 10 | Turnberry 3 R11 Captain: Cyndi Soles |
3 | 5 | 37.5% |
| 12 | Island Sound 3 R12 Captain: Nick Licari |
1 | 7 | 12.5% |