changeset 181:fcfed35ca6d8

Gecos column of NEWS table switched to gecos instead of id
author HIROSE Yuuji <yuuji@gentei.org>
date Fri, 26 Feb 2016 23:12:16 +0859
parents 59bd085848ec
children 5ba50e0850c9
files s4-funcs.sh
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/s4-funcs.sh	Fri Feb 26 22:36:04 2016 +0859
+++ b/s4-funcs.sh	Fri Feb 26 23:12:16 2016 +0859
@@ -1370,7 +1370,8 @@
                  else 0
             end) "新着",
  count(id) "総数", ctime, title,
- owner gecos -- (select gecos from gecoses where name=bl.owner) gecos
+ /* owner gecos */
+ (select gecos from gecoses where name=bl.owner) gecos
  from blogall bl left join acclog_user l
       on bl.rowid=round(l.tblrowid)
  where case when (select name from user where owner=name) is not null

yatex.org