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