diff s4-blog.sh @ 470:4e185146fc00

Fix SQL for listing all members
author HIROSE Yuuji <yuuji@gentei.org>
date Thu, 24 Aug 2017 07:44:38 +0859
parents 598f00f1b995
children 677597199031
line wrap: on
line diff
--- 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

yatex.org