1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':3kNcSbqAbEoIHABA&ved=0CDEQFjAH&usg=AFQjCNGV8o5ZtXyRHwHbdYoo6ivo_CkK3Q AND a.id ' at line 28 SQL=SELECT a.id, a.teamid AS teamid, a.fname, a.lname, CONCAT(a.fname, ' ', a.lname) AS name, SUM(s.hitting_pa)-SUM(s.hitting_bb)-SUM(s.hitting_hbp)-SUM(s.hitting_sac) AS ab, SUM(s.running_r) AS r, (SUM(s.hitting_1b)+SUM(s.hitting_2b)+SUM(s.hitting_3b)+SUM(s.hitting_hr)) AS h, SUM(s.hitting_2b) AS dbl, SUM(s.hitting_3b) AS tpl, SUM(s.hitting_hr) AS hr, SUM(s.hitting_rbi) AS rbi, SUM(s.running_sb) AS sb, SUM(s.running_cs) AS cs, SUM(s.hitting_bb) AS bb, SUM(s.hitting_k) AS k, SUM(s.hitting_hbp) AS hbp, SUM(s.hitting_sac) AS sac, SUM(s.hitting_1b)+SUM(s.hitting_2b)*2+SUM(s.hitting_3b)*3+SUM(s.hitting_hr)*4 AS total_bases, FORMAT(ABS((SUM(s.hitting_1b)+SUM(s.hitting_2b)+SUM(s.hitting_3b)+SUM(s.hitting_hr))/(SUM(s.hitting_pa)-SUM(s.hitting_bb)-SUM(s.hitting_hbp)-SUM(s.hitting_sac))), 3) AS ba, FORMAT(ABS(((SUM(s.hitting_1b)+SUM(s.hitting_2b)+SUM(s.hitting_3b)+SUM(s.hitting_hr))+SUM(s.hitting_bb)+SUM(s.hitting_hbp))/((SUM(s.hitting_pa)-SUM(s.hitting_bb)-SUM(s.hitting_hbp)-SUM(s.hitting_sac))+SUM(s.hitting_bb)+SUM(s.hitting_hbp)+SUM(s.hitting_sac))), 3) AS obp, FORMAT(ABS((SUM(s.hitting_1b)+SUM(s.hitting_2b)*2+SUM(s.hitting_3b)*3+SUM(s.hitting_hr)*4)/(SUM(s.hitting_pa)-SUM(s.hitting_bb)-SUM(s.hitting_hbp)-SUM(s.hitting_sac))), 3) AS slg, DATE_FORMAT(g.gamedatetime, '%m/%d/%Y') AS date, g.id AS gameid, g.hometeam, g.visitingteam, (SELECT name FROM #__fastball_team WHERE (id = g.hometeam)) AS hometeamname, (SELECT name FROM #__fastball_team WHERE (id = g.visitingteam)) AS visitingteamname FROM #__fastball_player AS a LEFT JOIN #__fastball_playerstat AS s ON a.id = s.playerid LEFT JOIN #__fastball_schedule AS g ON s.gameid = g.id WHERE (g.season = 2&sa=U&ei=JheIU:3kNcSbqAbEoIHABA&ved=0CDEQFjAH&usg=AFQjCNGV8o5ZtXyRHwHbdYoo6ivo_CkK3Q AND a.id = 11 AND (s.hitting_pa > 0 OR s.running_r > 0 OR s.running_sb > 0 OR s.running_cs > 0 OR s.running_lob > 0)) GROUP BY s.gameid ORDER BY g.gamedatetime