summary refs log tree commit diff
diff options
context:
space:
mode:
-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