" AND song IS NOT NULL" +
" AND ( chosen='t' OR round=" + pqxx::to_string(round) + " )"
" )"
+ " AND playmode='single'"
" ORDER BY feetrating DESC LIMIT 1"
" ) * 1000 AS max_score FROM tournamentparticipation") );
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;