X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=bigscreen%2Ffetch_max_score_for_songs.cpp;h=4170e33ea552f3c525680ecf3657022fb231ce44;hp=d9a8841918dfda2a31134e02873668d386201eff;hb=bd55f6835567a11e5a490d4a872bc778c96d1e83;hpb=57c939a53665f808b2429461d547271adf2c5908

diff --git a/bigscreen/fetch_max_score_for_songs.cpp b/bigscreen/fetch_max_score_for_songs.cpp
index d9a8841..4170e33 100644
--- a/bigscreen/fetch_max_score_for_songs.cpp
+++ b/bigscreen/fetch_max_score_for_songs.cpp
@@ -8,7 +8,7 @@ void FetchMaxScoreForSongs::operator() (pqxx::transaction<> &t)
 	score->erase(score->begin(), score->end());
 	
 	pqxx::result res( t.exec("SELECT song,MAX(feetrating)*1000 AS max_score FROM songratings WHERE " 
-		" machine=( SELECT machine FROM tournaments WHERE tournament=" + pqxx::to_string(tournament) + ") GROUP BY song") );
+		" machine=( SELECT machine FROM tournaments WHERE tournament=" + pqxx::to_string(tournament) + ") AND playmode='single' GROUP BY song") );
 	
 	for (pqxx::result::const_iterator i = res.begin(); i != res.end(); ++i) {
 		unsigned song, max_score;