changeset 470:4e185146fc00

Fix SQL for listing all members
author HIROSE Yuuji <yuuji@gentei.org>
date Thu, 24 Aug 2017 07:44:38 +0859
parents f095f639e5bf
children 1dacdf998892
files s4-blog.sh
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
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