Mercurial > hgrepos > hgweb.cgi > s4
changeset 274:0f7bc60985d6
Count only text in grpaction list
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Mon, 01 Aug 2016 22:30:02 +0859 |
parents | 31fbfcd4fc25 |
children | b82007959b54 |
files | s4-funcs.sh |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-funcs.sh Mon Aug 01 18:14:27 2016 +0859 +++ b/s4-funcs.sh Mon Aug 01 22:30:02 2016 +0859 @@ -2079,7 +2079,7 @@ (SELECT id FROM blog_s WHERE key='owner' AND val=(SELECT gname FROM grp where rowid=$grid)) - AND author=a.name) + AND author=a.name AND key='text') as POST, (SELECT group_concat(val, ',') FROM grp_mem_m