From 8526b3e3925df0065bcb045dfeefcc9b52343d5f Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Sun, 12 Jul 2020 10:30:07 -0400 Subject: Fix active networks ordering --- networks.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'networks.c') 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 -- cgit 1.4.1