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,