我很难成为足球/足球的前十名得分手。
我有这样的东西：sqlfiddle

SELECT p.*, count(*) as num_goals
FROM match_goals g 
INNER JOIN match_players p ON g.match_player_id = p.id 
INNER JOIN matches m ON m.id = p.match_id
WHERE p.is_deleted = 0 AND 
      g.is_own_goal = 0 AND
      m.season_id = 2
GROUP BY p.id
ORDER BY num_goals DESC
LIMIT 10

我有同一个球员在比赛中进了不同的球。
这和。。显示6个目标和2个目标。。但它是同一个玩家。。在同一个团队里。。