Mercurial > hgrepos > hgweb.cgi > s4
changeset 336:08165f6b7828
Searching into file names cause JOIN failure,... disabled.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sat, 22 Oct 2016 00:39:53 +0859 |
parents | a120ba2d719b |
children | 48d0b6c4de65 |
files | s4-blog.sh |
diffstat | 1 files changed, 4 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-blog.sh Sat Oct 22 00:15:09 2016 +0859 +++ b/s4-blog.sh Sat Oct 22 00:39:53 2016 +0859 @@ -521,19 +521,20 @@ (SELECT a.id, a.blogid, s.ctime, - s.text || ' ' || m.filenames content + s.text /* || ' ' || m.filenames */ content FROM article a JOIN (SELECT id, /* Create [id, ctime, text] from article_s */ max(CASE key WHEN 'ctime' THEN val END) ctime, max(CASE key WHEN 'text' THEN val END) text FROM article_s GROUP BY id) s + /* JOIN (SELECT id, group_concat(val) filenames FROM article_m WHERE type LIKE 'file:%' - GROUP BY id) m - ON a.id=s.id AND a.id=m.id WHERE $kc$kwdgrp) x + GROUP BY id) m */ + ON a.id=s.id /* AND a.id=m.id */ WHERE $kc$kwdgrp) x ON b.id=x.blogid WHERE b.id IN (SELECT id FROM blog_s $cond) ORDER by DATE DESC, TITLE, x.ctime;"