首页  >   法甲   >   射手榜
Unknown column 'P.teamId' in 'on clause'
SELECT p.id,p.title AS pname,p.goals,p.penalty,p.assists,t.title AS tname FROM ***_ecms_player AS p LEFT JOIN ***_ecms_team AS t ON t.id = P.teamId WHERE t.category = 'fajia' AND p.assists > 0 ORDER BY p.assists DESC limit 30
排名 球员 进球数 点球数 助攻数 球队