From 236dbaa81740a7c99bb3b07b4428f792b6c85e98 Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Sun, 19 Jul 2020 16:33:12 -0400 Subject: Filter networks with only private contexts from recents as well --- networks.c | 1 + 1 file changed, 1 insertion(+) diff --git a/networks.c b/networks.c index f1f8c89..b5b880d 100644 --- a/networks.c +++ b/networks.c @@ -32,6 +32,7 @@ const char *NetworksQuery = SQL( SELECT network FROM contexts JOIN recentEvents USING (context) + WHERE query <= NOT :public GROUP BY network ORDER BY max(time) DESC ), allNetworks AS ( -- cgit 1.4.1