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 ') GROUP BY p.id ORDER BY p.lname,s.id DESC,p.position_short ASC' at line 1
SELECT p.id AS player,p.team_id,p.lname,p.fname,p.salary1,p.fppg,p.position_short,ht.id,s.away_team_id,s.home_team_id,i.id as injury,i.status AS inj_stat,fp.id AS fav FROM fs_SD_mlb_players p JOIN fs_SD_mlb_teams ht JOIN fs_SD_mlb_teams at JOIN fs_SD_mlb_schedule s LEFT JOIN fs_SD_mlb_injuries i ON i.id = p.id LEFT JOIN fs_user_fav_players fp ON fp.player_id = p.id AND fp.user_id = 12394455 WHERE (p.team_id = s.home_team_id OR p.team_id = s.away_team_id) AND at.id = s.away_team_id AND ht.id = s.home_team_id AND s.start_date >= '2012-08-01 13:00:00' AND s.start_date <= '2012-10-14 20:30:00' AND p.position_short in () GROUP BY p.id ORDER BY p.lname,s.id DESC,p.position_short ASC

Pos	Player	Match	Sal	FPPG