summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-07-12 10:30:07 -0400
committerJune McEnroe <june@causal.agency>2020-07-12 10:30:07 -0400
commit8526b3e3925df0065bcb045dfeefcc9b52343d5f (patch)
treeddedff95804417ad9e248c0ceff38c161f7e6f80
parentLower default limit to 50 (diff)
downloadscooper-8526b3e3925df0065bcb045dfeefcc9b52343d5f.tar.gz
scooper-8526b3e3925df0065bcb045dfeefcc9b52343d5f.zip
Fix active networks ordering
-rw-r--r--networks.c4
1 files changed, 2 insertions, 2 deletions
diff --git a/networks.c b/networks.c
index c0f171a..ff877d7 100644
--- a/networks.c
+++ b/networks.c
@@ -28,10 +28,10 @@ const char *NetworksQuery = SQL(
 		ORDER BY event DESC
 		LIMIT :recent
 	), activeNetworks AS (
-		SELECT DISTINCT network
+		SELECT network
 		FROM contexts
 		JOIN recentEvents USING (context)
-		GROUP BY context
+		GROUP BY network
 		ORDER BY max(time) DESC
 	), allNetworks AS (
 		SELECT DISTINCT network