Mercurial > hgrepos > hgweb.cgi > s4
changeset 257:5d0dbbf9310c
Show text in the table of recent writing articles
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Mon, 18 Jul 2016 19:52:41 +0859 |
parents | e9b33033d95f |
children | a967788f7ad8 |
files | s4-funcs.sh |
diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-funcs.sh Mon Jul 18 19:52:13 2016 +0859 +++ b/s4-funcs.sh Mon Jul 18 19:52:41 2016 +0859 @@ -1502,7 +1502,8 @@ (SELECT $shortval FROM blog_s WHERE key='title' AND id=b.id) title, (SELECT gecos FROM gecoses WHERE name=(SELECT val FROM blog_s - WHERE key='owner' AND id=b.id)) owner + WHERE key='owner' AND id=b.id)) owner, + (SELECT $shortval val FROM article_s WHERE id=m.aid AND key='text') text FROM blog b JOIN (SELECT distinct blogid, a.id aid, max(val) ctime