add to favourites | español help | search | admin | home | CricClubs  
  
 - Home
 - Sponsors
 - Calendar
 SCHEDULE & RESULTS
 - League Schedule
 - League Scorecards
 - League Standings
 - League Stats
 - CricClubs Premier Scorecard
 - CricClubs T20 Scorecard
 - CricClubs Practice Scorecard
 NEWS & DOCUMENTS
 - News Archives
 - Feature Articles
 - Todays Yesterdays
 - CCL Documents
 - Video Highlights
 - History
 CLUBS & GROUNDS
 - Clubs
 - Teams
 - Grounds
 PLAYERS & OFFICERS
 - Players
 - Player Of The Week
 - Player Awards
 - Champions
 - CCL Officers
 UMPIRING
 - Certified Umpires
 - Umpiring Quiz
 CRICKET COMMUNITY
 - Team Colorado
 - Tennis Cricket
 REGIONAL LEAGUES
 - CTCL (Austin)
 - HCL (Houston)
 - NTCA (Dallas)
 - Heartland(Nebraska)
 - USA Cricket
 - ICC
 - MCC Cricket Laws

 

 


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, p2.PlayerID AS MomID2, p2.PlayerLName AS MomLName2, p2.PlayerFName AS MomFName2, 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 LEFT 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 LEFT JOIN teams b ON s.batting_first_id = b.TeamID LEFT 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 p2 ON s.mom2 = p2.PlayerID LEFT JOIN players u1 ON s.umpire1 = u1.PlayerID LEFT JOIN players u2 ON s.umpire2 = u2.PlayerID WHERE s.game_id=2754. :