An Error Was Encountered
Error Number: 1064
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 A.ID_PLAYER = '180' ORDER BY M.match_date' at line 16
SELECT * , t.team_name AS opponent, HT.team_name AS hometeam, AT.team_name AS awayteam, M.home_goals AS goals_home, M.away_goals AS goals_away, S.season_name, DATE_FORMAT(M.match_date, '%d/%m/%y') AS date FROM core_player_appearances A JOIN core_matches M ON M.ID_MATCH = A.ID_MATCH JOIN core_seasons S ON S.ID_SEASON = A.ID_SEASON JOIN core_teams t ON ( t.ID_TEAM = IF( M.ID_HOME_TEAM = '', M.ID_AWAY_TEAM, M.ID_HOME_TEAM ) ) JOIN core_teams HT ON HT.ID_TEAM = M.ID_HOME_TEAM JOIN core_teams AT ON AT.ID_TEAM = M.ID_AWAY_TEAM WHERE A.ID_SEASON = '4' AND A.ID_TEAM = AND A.ID_PLAYER = '180' ORDER BY M.match_date