# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1468839162 -32399
# Node ID 5d0dbbf9310cf989edc87364adaa9b16da48ba36
# Parent  e9b33033d95f9e9a060c0a8ecf724264ea6876ad
Show text in the table of recent writing articles

diff -r e9b33033d95f -r 5d0dbbf9310c s4-funcs.sh
--- a/s4-funcs.sh	Mon Jul 18 19:52:13 2016 +0859
+++ b/s4-funcs.sh	Mon Jul 18 19:52:41 2016 +0859
@@ -1502,7 +1502,8 @@
        (SELECT $shortval FROM blog_s WHERE key='title' AND id=b.id) title,
        (SELECT gecos FROM gecoses
         WHERE name=(SELECT val FROM blog_s
-                   WHERE key='owner' AND id=b.id)) owner
+                   WHERE key='owner' AND id=b.id)) owner,
+       (SELECT $shortval val FROM article_s WHERE id=m.aid AND key='text') text
     FROM blog b
      JOIN
      (SELECT distinct blogid, a.id aid, max(val) ctime