summary refs log tree commit diff
path: root/networks.c
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-07-19 16:33:12 -0400
committerJune McEnroe <june@causal.agency>2020-07-19 16:33:12 -0400
commit236dbaa81740a7c99bb3b07b4428f792b6c85e98 (patch)
treefb79ce0ba62dfd2fa9d0fd98387d9a6e9c7eb595 /networks.c
parentSpecify litterbox version in readme (diff)
downloadscooper-236dbaa81740a7c99bb3b07b4428f792b6c85e98.tar.gz
scooper-236dbaa81740a7c99bb3b07b4428f792b6c85e98.zip
Filter networks with only private contexts from recents as well
Diffstat (limited to '')
-rw-r--r--networks.c1
1 files changed, 1 insertions, 0 deletions
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 (