X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=bigscreen%2Ffetch_list_of_finished_groups.cpp;fp=bigscreen%2Ffetch_list_of_finished_groups.cpp;h=08f953e7bd1dee5069d0cf1ac079b67c95be7623;hp=9d9de9536b1d3a8a91a21838b3eef3861657ae00;hb=f76e1fa762ad0a6b42146bd81e9ad3ca8281dddf;hpb=cce4245e587d9332be98f4371bffe6df85e08167

diff --git a/bigscreen/fetch_list_of_finished_groups.cpp b/bigscreen/fetch_list_of_finished_groups.cpp
index 9d9de95..08f953e 100644
--- a/bigscreen/fetch_list_of_finished_groups.cpp
+++ b/bigscreen/fetch_list_of_finished_groups.cpp
@@ -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;