SELECT t.teamid, p.lastname, p.firstname, t.teamname, et.tournamentteamid, t.city, s.section, s.sectionid, s.prefix, s.flag, c.name as clubname, c.clubid, sum( r.wins ) + sum( r.losses ) + sum( r.ties ) AS games, sum( r.wins ) / (sum( r.wins ) + sum( r.losses )) AS wpct, sum(r.wins) as wins, sum(r.losses) as losses, sum(r.ties) as ties, sum(points) as points, er.shootout, sum(r.ee_hammer_win) as ee_hammer_win, sum(r.ee_hammer_loss) as ee_hammer_loss, sum(r.one_point_win) as one_point_win, sum(r.one_point_loss) as one_point_loss, sum(r.ee_steal_win) as ee_steal_win, sum(r.ee_steal_loss) as ee_steal_loss, sum(r.fe_hammer_win) as fe_hammer_win, sum(fe_hammer_loss) as fe_hammer_loss, sum(r.fe_steal_win) as fe_steal_win, sum(fe_steal_loss) as fe_steal_loss FROM team t, tournamentteam et, tournamentrecord r, eventrecord er, player p, section s, clubs c WHERE r.tournamentid = 3127 AND et.tournamentteamid = r.tournamentteamid AND et.tournamentid = r.tournamentid AND t.teamid = et.teamid AND p.playerid = t.skip AND s.sectionid = t.sectionid AND c.clubid = t.clubid AND er.teamid = t.teamid GROUP BY t.teamid ORDER By er.orderlock, r.points DESC, r.wins DESC, r.losses ASC, er.shootout ASC, p.lastname[Standings Created] 2010 USA National Championships Coverage on CurlingZone - Everything Curling

 
 

CURLINGZONE

WORLD CURLING TOUR

ONTARIO CURLING TOUR

DISCUSSION FORUMS & CHAT

  
HOME  NEWS & HEADLINES CURLINGZONE BLOG CURLING CLUBS CURLING LINKS CURLING PHOTOS  
 CHAMPION
 Team Erika Brown
  Madison,
Wisconsin
SKIP:  Erika Brown
THIRD:  Nina Spatola
SECOND:  Ann Swisshelm
LEAD:  Laura Hallisey
View Profile
 Win/Loss Record
Team

W

L
Brown (WI) 10 2
Lank (NY) 9 5
Wright (MN) 8 4
Hamilton (WI) 6 4
Walker (MA) 5 4
Wapola (MN) 5 4
Horn (OH) 3 6
Coleman (CA) 3 6
Hambley (WA) 1 8
Heisler (MA) 1 8
 
 American Womens' Curling Championships Champions | Chat
 Order of Merit Teams | Schedule | Money List | Statistics
 2010 USA National Championships Coverage  
Event Home
Participating Teams
Standings
Photo Gallery
Historical Standings
All-Stars
   Round Robin
Tie Breakers
Championship
Event Statistics
Team Statistics
   Kalamazoo, Michigan
Mar 6 - 13, 2010
border=0
 Standings  
border=0
USER CENTRE
 Welcome to CurlingZone, Guest!
  Register Now!
  
Already a member? 
Login...
  
     
 
 CurlingZone NEWSLETTER
Sign-up here to receive the CurlingZone newsletter.

 CURLING PHOTOS
Midweek Men's Action at the 2010 Grey Power Players' Championship in Dawson Creek, BC
Early Week Men's Action at the 2010 Grey Power Players' Championship in Dawson Creek, BC
Early Week Women's Action at the 2010 Grey Power Players' Championship in Dawson Creek, BC.
VIEW ALL PHOTOS

Home     Signup/Login     Media Info     Stats Info     Advertising     Affiliates