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
Diffstat (limited to '')
-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
e 2017-08-17Remove scala syntax fileJune McEnroe 2017-08-06Add wakeJune McEnroe 2017-08-04Use $() in install.shJune McEnroe 2017-08-02Create Code Tarmak 3 layoutJune McEnroe 2017-07-31Add tupJune McEnroe 2017-07-31Use designated initializer for hnel tableJune McEnroe 2017-07-30Add juneJune McEnroe 2017-07-30Play nethack as ValkyrieJune McEnroe 2017-07-28Add toggle to hnelJune McEnroe 2017-07-28Install slJune McEnroe 2017-07-25Add up, supJune McEnroe 2017-07-24Autopickup ringsJune McEnroe 2017-07-24Name dogJune McEnroe 2017-07-23Add nethackrcJune McEnroe 2017-07-23Remove useless setuid in briJune McEnroe 2017-07-23Clean up hnel a tiny bitJune McEnroe 2017-07-21Set window size in hnelJune McEnroe 2017-07-21Add hnelJune McEnroe 2017-07-19chmod 600 in dtchJune McEnroe