mysql 添加总和_mysql – 如何加入两个计数的总和？

我目前有一个匹配结果表

+----------+----------+--------+-----------+--------+-----------+-----------+-----------+

| hometeam | awayteam | p1home | p2home... | p1away | p2away... | homescore | awayscore |

+----------+----------+--------+-----------+--------+-----------+-----------+-----------+

我用相当笨重的东西查询

SELECT

(SELECT COUNT(hometeam)

FROM fixture_data

WHERE (p1home = '$playerID' OR p2home = '$playerID' OR...)

AND hometeam = '$teamname')

+

(SELECT COUNT(awayteam)

FROM fixture_data

WHERE (p1home = '$playerID' OR p2home = '$playerID' OR...)

AND awayteam= '$teamname')

AS matches_played

获得特定玩家$playerID为特定团队$teamname所玩的匹配数量

桌上玩家很简单

+----------+-----------&