- Season Schedule
- Season Standings
- Season Scores
- Captains
- Teams
- Masters League Rules
- Pelican Sound Rules
- Pelican Sound Bocce
- set scores!440
requires password
Masters League
Home Page
Home Page
!613
SELECT teamId, teamName, teamAbbreviation, teamCapId, teamCapIdCo,
SUM(scoreWon) AS sumWon, SUM(scoreLost) AS sumLoss,SUM(scorePlayed) AS sumPlayed, SUM(scoreTieBreak) AS sumTieBreak FROM `mblScoreLog`
LEFT JOIN `mblTeamLog` ON `scoreTeamId` = `teamId`
WHERE `scoreHide` = 'no' AND `scoreStatus` = 'played'
GROUP BY teamId ORDER BY sumWon DESC, sumLoss ASC,`sumTieBreak` ASC,teamName
Standings !616
No results to report
SELECT teamId, teamName, teamAbbreviation, teamCapId, teamCapIdCo,
SUM(scoreWon) AS sumWon, SUM(scoreLost) AS sumLoss,SUM(scorePlayed) AS sumPlayed, SUM(scoreTieBreak) AS sumTieBreak FROM `mblScoreLog`
LEFT JOIN `mblTeamLog` ON `scoreTeamId` = `teamId`
WHERE `scoreHide` = 'no' AND `scoreStatus` = 'played'
GROUP BY teamId ORDER BY sumWon DESC, sumLoss ASC,`sumTieBreak` ASC,teamName