# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1503528305 -32373
# Node ID 4e185146fc00f3e3749f3cbde6b1288f8b944b63
# Parent  f095f639e5bfd2fe938fc6b27d92997bdbb41704
Fix SQL for listing all members

diff -r f095f639e5bf -r 4e185146fc00 s4-blog.sh
--- a/s4-blog.sh	Tue Aug 22 21:04:16 2017 +0859
+++ b/s4-blog.sh	Thu Aug 24 07:44:38 2017 +0859
@@ -684,7 +684,7 @@
                atime
 	FROM grpmem g LEFT JOIN acctime t
 	ON   g.user = t.user
-	GROUP BY t.user
+	GROUP BY g.user
 	ORDER BY atime DESC;
 	EOF
   while IFS='|' read u uid hexge time; do