Mercurial > hgrepos > hgweb.cgi > s4
changeset 819:b64e18808bb6
Links from keyword search should contain n:all
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Thu, 18 Jun 2020 08:05:01 +0900 |
parents | de988b0a7afa |
children | e64d18e78507 |
files | s4-blog.sh |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-blog.sh Wed Jun 17 13:59:50 2020 +0900 +++ b/s4-blog.sh Thu Jun 18 08:05:01 2020 +0900 @@ -1187,7 +1187,7 @@ SELECT blg.rid, blg.*, blog_s.val TITLE FROM readableblogs blg JOIN blog_s ON blg.id=blog_s.id AND blog_s.key='title' ) -SELECT bl.rid||'#'||ar.id '', +SELECT bl.rid||'+n:all#'||ar.id '', bl.title TITLE, (SELECT gecos FROM gecoses WHERE name=ar.author) AUTHOR, substr(ctime, 0, 11) DATE,