Fix max score for players; only chosen songs can't be selected twice.

[ccbs] / bigscreen / fetch_max_score_for_players.cpp

diff --git a/bigscreen/fetch_max_score_for_players.cpp b/bigscreen/fetch_max_score_for_players.cpp
index 9cc9b2ac71cc3f69dd6c6a8c1af5c4b8d4026b26..3a89541aa65a19f50f79145e7ea4cf785eae5ebd 100644 (file)
--- a/bigscreen/fetch_max_score_for_players.cpp
+++ b/bigscreen/fetch_max_score_for_players.cpp
@@ -18,6 +18,7 @@ void FetchMaxScoreForPlayers::operator() (pqxx::transaction<> &t)
                "         WHERE tournament=" + pqxx::to_string(tournament) +
                "         AND song IS NOT NULL"
                "         AND parallel=0"
+               "         AND chosen='f'"
                "     )"
                "     AND (player,song) NOT IN ("             // not a song the player has chosen before, or is a random song in this round
                "       SELECT player,song FROM scores"