Mercurial > hgrepos > hgweb.cgi > s4
changeset 366:884cd7c66917
Use gecoses table instead of coalesce().
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Wed, 23 Nov 2016 15:54:05 +0859 |
parents | be652501ca71 |
children | 037b514bb6ae |
files | s4-blog.sh |
diffstat | 1 files changed, 1 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-blog.sh Tue Nov 22 09:20:54 2016 +0859 +++ b/s4-blog.sh Wed Nov 23 15:54:05 2016 +0859 @@ -320,9 +320,7 @@ sql="with arts as (select id,author from article \ where blogid=(select id from blog where rowid=$2))\ select (select rowid from user where name=c0.user)||' '|| \ - coalesce((select val from user_s where name=c0.user \ - and key='gecos'),\ - c0.user) as 'メンバー',\ + (select gecos from gecoses where name=c0.user) as 'メンバー',\ sum(case when c1.key is not null then 1 else 0 end)\ as 'コメント記入',\ sum(case when c2.key is not null then 1 else 0 end)\