php - 降序在查询中不起作用，但它应该起作用？

Question

已关闭。这个问题是 not reproducible or was caused by typos 。目前不接受答案。

---

这个问题是由拼写错误或无法再重现的问题引起的。虽然类似的问题可能是 on-topic在这里，这个问题的解决方式不太可能帮助 future 的读者。

已关闭 4 年前。

Improve this question

我正在为我的实习以及我们在休息时玩的游戏制作记分牌。我有一个非常大的查询来获取所有游戏的结果并计算玩家获胜的总数。

SELECT winner, SUM(total) AS total 
FROM (SELECT pw.name AS `winner`, COUNT(*) AS total 
      FROM billiard_games g 
      INNER JOIN players p1 
          ON p1.id = g.player_1 
      INNER JOIN players p2 
          ON p2.id = g.player_2 
      LEFT JOIN billiard_winners w 
          ON w.id = g.id 
      LEFT JOIN players pw 
          ON pw.id = w.winner 
      WHERE winner IS NOT NULL 
      GROUP BY winner 

      UNION ALL 

      SELECT pw.name AS `winner`, COUNT(*) AS total 
      FROM dart_games g 
      INNER JOIN players p1 
          ON p1.id = g.player_1 
      INNER JOIN players p2 
          ON p2.id = g.player_2 
      LEFT JOIN dart_winners w 
          ON w.id = g.id 
      LEFT JOIN players pw 
          ON pw.id = w.winner 
      GROUP BY winner 

      UNION ALL 

      SELECT pw.name AS `winner`, COUNT(*) AS total 
      FROM fifa_games g 
      INNER JOIN players p1 
          ON p1.id = g.player_1 
      INNER JOIN players p2 
          ON p2.id = g.player_2 
      LEFT JOIN fifa_winners w 
          ON w.id = g.id 
      LEFT JOIN players pw 
          ON pw.id = w.winner 
      WHERE winner IS NOT NULL 
      GROUP BY winner ) A 
WHERE winner IS NOT NULL 
group by winner DESC 
LIMIT 5

输出:

Player_1 | 5
Player_2 | 1
Player_3 | 3

这不是正确的顺序。有什么问题吗？

Answer 1

最后一部分应该是

WHERE winner IS NOT NULL group by winner order by total DESC LIMIT 5

因为您刚刚错过了ORDER BY