diff options
| -rw-r--r-- | networks.c | 4 |
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 |