s4

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 diff
     1.1 --- a/s4-blog.sh	Tue Aug 22 21:04:16 2017 +0859
     1.2 +++ b/s4-blog.sh	Thu Aug 24 07:44:38 2017 +0859
     1.3 @@ -684,7 +684,7 @@
     1.4                 atime
     1.5  	FROM grpmem g LEFT JOIN acctime t
     1.6  	ON   g.user = t.user
     1.7 -	GROUP BY t.user
     1.8 +	GROUP BY g.user
     1.9  	ORDER BY atime DESC;
    1.10  	EOF
    1.11    while IFS='|' read u uid hexge time; do