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
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 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=1067 :
