X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=bigscreen%2Ffetch_max_score_for_players.cpp;h=3a89541aa65a19f50f79145e7ea4cf785eae5ebd;hp=9cc9b2ac71cc3f69dd6c6a8c1af5c4b8d4026b26;hb=33798d738eb88b893f21818275c2f0f4b7f7562e;hpb=8963fce7337a09bdcfea051a81c0c3d9281acd6e diff --git a/bigscreen/fetch_max_score_for_players.cpp b/bigscreen/fetch_max_score_for_players.cpp index 9cc9b2a..3a89541 100644 --- 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"