|
|
|
|
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Error: Unable to perform query: SELECT g.season, n.SeasonName, COUNT( s.player_id ) AS Matches, SUM( s.runs ) AS Runs, (SELECT CONCAT(s1.runs,n1.NotoutReplace) FROM scorecard_batting_details s1 INNER JOIN notout n1 ON s1.notout = n1.NotoutID WHERE s1.player_id = s.player_id AND s1.season = s.season AND s1.team = s.team ORDER BY s1.runs DESC LIMIT 1) AS HS, SUM( s.fours) as Fours, SUM( s.sixes) AS Sixes, SUM( s.notout ) AS Notouts, COUNT( s.player_id ) - SUM( s.notout ) AS Innings, SUM( s.runs ) / (COUNT( s.player_id ) - SUM( s.notout )) AS Average, s.player_id, p.PlayerID, LEFT(p.PlayerFName,1) AS PlayerInitial, p.PlayerFName, p.PlayerLName, p.PlayerLAbbrev, p.picture FROM scorecard_batting_details s INNER JOIN players p ON s.player_id = p.PlayerID INNER JOIN scorecard_game_details g ON s.game_id = g.game_id INNER JOIN seasons n ON g.season = n.SeasonID WHERE s.team = AND n.SeasonName LIKE '%2009%' AND g.league_id <> 4 AND s.how_out NOT IN ('1','14','15') GROUP BY s.player_id ORDER BY Runs DESC, p.PlayerLName, p.PlayerFName LIMIT 1 :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND n.SeasonName LIKE '%2009%' AND g.league_id <> 4 AND s.how_out NOT IN ('1','1' at line 12
