League Standings
Filters:   Season:
select sum(home_team_points) as points from matches where home_team = 9 and match_type_code = 'REGSEA' and season = 2014 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 = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 5 and match_type_code = 'REGSEA' and season = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 117 and match_type_code = 'REGSEA' and season = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 45 and match_type_code = 'REGSEA' and season = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 47 and match_type_code = 'REGSEA' and season = 2014 and result is not null
 1st Division as of 24-Aug-2014 
Team Played Won Lost Tied Drawn N/D Points
Eagle C.C A129200157
Commonwealth A127400145
BGSC A127500042
Lagaan C.C127500042
Star C.C127500042
Conway C.C116500036
Guyana C.C126600036
BGSC B125700030
Commonwealth B112800115
Melbourne S.C A121100019
select sum(home_team_points) as points from matches where home_team = 7 and match_type_code = 'REGSEA' and season = 2014 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 = 2014 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 = 2014 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 = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 12 and match_type_code = 'REGSEA' and season = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 40 and match_type_code = 'REGSEA' and season = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 118 and match_type_code = 'REGSEA' and season = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 127 and match_type_code = 'REGSEA' and season = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 46 and match_type_code = 'REGSEA' and season = 2014 and result is not null
 2nd Division as of 24-Aug-2014 
Team Played Won Lost Tied Drawn N/D Points
Challengers CC128400048
Umass Dartmouth117300145
BGSC C127500042
Caricom S.C.C126500139
Merrimack Valley C.C116500036
Boston C.C126600036
NECC Hawks126600036
BGSC E115600030
Eagle C.C B115600030
Commonwealth C121110006
select sum(home_team_points) as points from matches where home_team = 129 and match_type_code = 'REGSEA' and season = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 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 = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 110 and match_type_code = 'REGSEA' and season = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 128 and match_type_code = 'REGSEA' and season = 2014 and result is not null
select sum(home_team_points) as points from matches where home_team = 111 and match_type_code = 'REGSEA' and season = 2014 and result is not null
 3rd Division as of 24-Aug-2014 
Team Played Won Lost Tied Drawn N/D Points
Colonial CCC1211100066
New England Royals128300151
Eagle C.C C128400048
NECC Tigers128400048
BU Alumni CC127500042
United Athletic127500042
St. Columbas CC116400139
Trinidad & Tobago CC126500139
Boston Warriors125600133
BGSC D114700024
Commonwealth D123900018
Middlesex S.C1221000012
Melbourne S.C B120120000