Mercurial > hgrepos > hgweb.cgi > s4

changeset 257:5d0dbbf9310c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Show text in the table of recent writing articles
author HIROSE Yuuji <yuuji@gentei.org>
date Mon, 18 Jul 2016 19:52:41 +0859
parents e9b33033d95f
children a967788f7ad8
files s4-funcs.sh
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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

yatex.org