Fix list of finished groups; don't show elimination/seeding groups, show finished...
[ccbs] / bigscreen / fetch_list_of_finished_groups.cpp
index 9d9de95..08f953e 100644 (file)
@@ -10,7 +10,7 @@ void FetchListOfFinishedGroups::operator() (pqxx::transaction<> &t)
 
        // find all groups with no empty scores that are not already shown on the bigscreen
        pqxx::result res( t.exec("SELECT tournament,round,parallel FROM scores WHERE tournament=" +
-               pqxx::to_string(tournament) + " GROUP BY tournament,round,parallel HAVING COUNT(*)=COUNT(score) AND (tournament,round) NOT IN ( SELECT tournament,round FROM bigscreen.active_groups ) ORDER BY tournament,round,parallel") );
+               pqxx::to_string(tournament) + " GROUP BY tournament,round,parallel HAVING COUNT(*)=COUNT(score) AND (tournament,round,parallel) NOT IN ( SELECT tournament,round,parallel FROM bigscreen.active_groups ) AND parallel<>0 ORDER BY tournament,round,parallel") );
 
        for (pqxx::result::const_iterator i = res.begin(); i != res.end(); ++i) {
                SkeletonGroup g;