Chess Cards Datenbank | |||||||
|
Failed to execute query: Duplicate column name 'Spieler' SQL: SELECT Spieler, w AS Weiss, s AS Schwarz, w + s AS Summe FROM ( SELECT * FROM ( SELECT position.`White` AS Spieler, COUNT( position.`White` ) AS w FROM position GROUP BY Spieler ) AS T1 INNER JOIN ( SELECT * FROM ( SELECT position.`Black` AS Spieler, COUNT( position.`Black` ) AS s FROM position GROUP BY Spieler ) AS T3 ) AS T2 ON T1.`Spieler` = T2.`Spieler` ) AS MainTable GROUP BY Spieler ORDER BY Summe DESC |