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 20-Jul-2014 
Team Played Won Lost Tied Drawn N/D Points
Eagle C.C A97200042
Star C.C96300036
Conway C.C106400036
Lagaan C.C85300030
BGSC A95400030
Commonwealth A95400030
BGSC B94500024
Guyana C.C94500024
Commonwealth B92700012
Melbourne S.C A9180006
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 20-Jul-2014 
Team Played Won Lost Tied Drawn N/D Points
BGSC C96300036
Merrimack Valley C.C96300036
Umass Dartmouth96300036
Caricom S.C.C95400030
Challengers CC95400030
Eagle C.C B95400024
BGSC E94500024
NECC Hawks94500024
Boston C.C93600018
Commonwealth C9180006
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 20-Jul-2014 
Team Played Won Lost Tied Drawn N/D Points
Colonial CCC87100042
New England Royals97200042
Eagle C.C C96300036
NECC Tigers96300036
St. Columbas CC96300036
Trinidad & Tobago CC96300036
United Athletic106400036
BU Alumni CC95400030
BGSC D104600024
Boston Warriors93600018
Commonwealth D82600012
Middlesex S.C9180006
Melbourne S.C B100100000