League Standings
Filters:   Season:
select sum(home_team_points) as points from matches where home_team = 5 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 6 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 80 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 8 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 10 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 3 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 4 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 16 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 78 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 13 and match_type_code = 'REGSEA' and season = 2013 and result is not null
 1st Division as of 25-Aug-2013 
Team Played Won Lost Tied Drawn N/D Points
BGSC A149500054
Eagle C.C A149500054
Star C.C149500054
Commonwealth A147500248
BGSC B147600145
Lagaan C.C147600145
Conway C.C147700042
Commonwealth B145700236
Boston C.C144900127
Caricom S.C.C1421100115
select sum(home_team_points) as points from matches where home_team = 12 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 82 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 103 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 104 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 9 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 17 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 77 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 11 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 83 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 100 and match_type_code = 'REGSEA' and season = 2013 and result is not null
 2nd Division as of 25-Aug-2013 
Team Played Won Lost Tied Drawn N/D Points
Challengers CC1411300066
Guyana C.C1410400060
Melbourne S.C A149500054
Umass Dartmouth149500054
BGSC MIT147500248
Eagle C.C B147600145
Commonwealth C145800133
Merrimack Valley C.C145800133
Middlesex S.C1421100115
Trinidad & Tobago CC1421200012
select sum(home_team_points) as points from matches where home_team = 7 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 81 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 99 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 116 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 114 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 101 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 102 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 19 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 120 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 123 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 121 and match_type_code = 'REGSEA' and season = 2013 and result is not null
select sum(home_team_points) as points from matches where home_team = 122 and match_type_code = 'REGSEA' and season = 2013 and result is not null
 3rd Division as of 25-Aug-2013 
Team Played Won Lost Tied Drawn N/D Points
NECC Hawks1412200072
Boston Warriors1411300066
BGSC C1410300163
St. Columbas CC149500054
BUCC148400254
New England Royals148500151
United Athletic147700042
Eagle C.C C146800036
Commonwealth D144900127
BGSC D1431100018
NECC Tigers1421200012
Melbourne S.C B141120019