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 diff
1.1 --- a/s4-blog.sh Wed Jun 17 13:59:50 2020 +0900 1.2 +++ b/s4-blog.sh Thu Jun 18 08:05:01 2020 +0900 1.3 @@ -1187,7 +1187,7 @@ 1.4 SELECT blg.rid, blg.*, blog_s.val TITLE 1.5 FROM readableblogs blg JOIN blog_s ON blg.id=blog_s.id AND blog_s.key='title' 1.6 ) 1.7 -SELECT bl.rid||'#'||ar.id '', 1.8 +SELECT bl.rid||'+n:all#'||ar.id '', 1.9 bl.title TITLE, 1.10 (SELECT gecos FROM gecoses WHERE name=ar.author) AUTHOR, 1.11 substr(ctime, 0, 11) DATE,