diff options
| author | June McEnroe <june@causal.agency> | 2020-07-12 10:30:07 -0400 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2020-07-12 10:30:07 -0400 |
| commit | 8526b3e3925df0065bcb045dfeefcc9b52343d5f (patch) | |
| tree | ddedff95804417ad9e248c0ceff38c161f7e6f80 /networks.c | |
| parent | Lower default limit to 50 (diff) | |
| download | scooper-8526b3e3925df0065bcb045dfeefcc9b52343d5f.tar.gz scooper-8526b3e3925df0065bcb045dfeefcc9b52343d5f.zip | |
Fix active networks ordering
Diffstat (limited to 'networks.c')
| -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 |