Kunne ikke udføre: SELECT MIN(players.playerID) AS playerID, MIN(playername) AS playername, MIN(teams.teamID) AS teamID, MIN(teamname) AS teamname, count(*) AS goals FROM matches, goals, players, teams, seasons WHERE goals.matchID=matches.matchID AND matches.seasonyear= AND seasons.year= AND teams.teamID=seasons.teamID AND players.playerID=goals.scorerID AND teams.teamID=goals.teamID AND matches.type='h1' GROUP BY players.playerID ORDER BY goals desc LIMIT 0,10


The error is: 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 seasons.year= AND teams.teamID=seasons.teamID AND players.playerID=goals.sco' at line 1