add to favourites | español help | admin | home  
 
 Home
 Contact Us
 SCHEDULE & RESULTS
 2017 Schedule
 2017 Scorecards
 2017 Standings
 2017 Statistics
 NEWS & DOCUMENTS
 News Archives
 CTCL Documents
 History
 CLUBS & GROUNDS
 Clubs
 Teams
 Grounds
 PLAYERS & OFFICERS
 Players
 CTCL Officers
 ARCHIVES
 Scorecards
 Champions
 CRICKET COMMUNITY
 Join CTCL on Facebook
 REGIONAL LEAGUES
 Houston CL
 Colorado CL
 Dallas CL
 3rd Umpire

 

 


Error: Unable to fetch data from query: SELECT s.*, o.SeasonName, l.LeagueName, a.TeamID AS AwayID, a.TeamName AS AwayName, a.TeamAbbrev AS AwayAbbrev, h.TeamID AS HomeID, h.TeamName AS HomeName, h.TeamAbbrev AS HomeAbbrev, u.TeamID AS UmpireID, u.TeamName AS UmpireName, u.TeamAbbrev AS UmpireAbbrev, t.TeamID AS WonTossID, t.TeamName AS WonTossName, t.TeamAbbrev AS WonTossAbbrev, b.TeamID AS BatFirstID, b.TeamName AS BatFirstName, b.TeamAbbrev AS BatFirstAbbrev, n.TeamID AS BatSecondID, n.TeamName AS BatSecondName, n.TeamAbbrev AS BatSecondAbbrev, p.PlayerID AS MomID, p.PlayerLName AS MomLName, p.PlayerFName AS MomFName, u1.PlayerID AS Ump1ID, u1.PlayerLName AS Ump1LName, u1.PlayerFName AS Ump1FName, u2.PlayerID AS Ump2ID, u2.PlayerLName AS Ump2LName, u2.PlayerFName AS Ump2FName, g.GroundID, g.GroundName FROM scorecard_game_details s INNER JOIN grounds g ON s.ground_id = g.GroundID INNER JOIN teams a ON s.awayteam = a.TeamID INNER JOIN teams h ON s.hometeam = h.TeamID LEFT JOIN teams u ON s.umpires = u.TeamID LEFT JOIN teams t ON s.toss_won_id = t.TeamID INNER JOIN teams b ON s.batting_first_id = b.TeamID INNER JOIN teams n ON s.batting_second_id = n.TeamID INNER JOIN seasons o ON s.season = o.SeasonID INNER JOIN leaguemanagement l ON s.league_id = l.LeagueID LEFT JOIN players p ON s.mom = p.PlayerID LEFT JOIN players u1 ON s.umpire1 = u1.PlayerID LEFT JOIN players u2 ON s.umpire2 = u2.PlayerID WHERE s.game_id=2032 :