# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1476367499 -32374
# Node ID ab11a49bd64e55468ce9787d42aae6d1a7adef91
# Parent  170fd6b81a9596dfdd86b2301bf7c6a285531e49
Sort search result by "DATE DESC, TITLE, x.ctime"

diff -r 170fd6b81a95 -r ab11a49bd64e s4-blog.sh
--- a/s4-blog.sh	Thu Oct 13 12:18:07 2016 +0859
+++ b/s4-blog.sh	Thu Oct 13 23:04:33 2016 +0859
@@ -458,6 +458,9 @@
 	# Not sure GROUP BY a.blogid is comfortable for searchers...?
 	kc=$kc${kc:+" AND "}"s.ctime GLOB '${ctime}*'"
 	##### kwdgrp=" GROUP BY a.blogid"
+      elif [ x"$k" = x"@today" -o x"$k" = x"@今日" ]; then
+	ctime=`date +%F`
+	kc=$kc${kc:+" AND "}"s.ctime GLOB '${ctime}*'"
       else
 	kc=$kc${kc:+" AND "}"s.text LIKE '%$k%'"
       fi
@@ -503,7 +506,7 @@
 	       ON a.id=s.id WHERE $kc$kwdgrp)
 	     x ON b.id=x.blogid
 	 WHERE b.id IN (SELECT id FROM blog_s $cond)
-       ORDER by x.ctime DESC;"
+       ORDER by DATE DESC, TITLE, x.ctime;"
   sedopt="s,<TR><TD>\([^<]*\)</TD>,<TR><TD><a\
  href=\"?replyblog+\1\">VIEW</a></TD>,"