# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1477064419 -32374
# Node ID 08165f6b7828629827e3bc1d590d39c65d472b70
# Parent  a120ba2d719bbbe43c6703b2e8f1185c01d0f8d1
Searching into file names cause JOIN failure,... disabled.

diff -r a120ba2d719b -r 08165f6b7828 s4-blog.sh
--- 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;"