s4

changeset 882:a46e85d50954

find changesets by author, revision, files, or words in the commit message
Burry frozen state blog with ORDER BY clause
author HIROSE Yuuji <yuuji@gentei.org>
date Wed, 16 Dec 2020 09:20:52 +0900
parents a240c8988c65
children 8593ff2579f4
files s4-funcs.sh
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Wed Dec 16 08:55:04 2020 +0900
     1.2 +++ b/s4-funcs.sh	Wed Dec 16 09:20:52 2020 +0900
     1.3 @@ -2854,7 +2854,7 @@
     1.4  	 <input type="checkbox" id="dtcheck" checked><label
     1.5  	  for="dtcheck">話題一覧表示</label>
     1.6  	EOF
     1.7 -  cond="where a.id in (select id from blog_s where key='owner' and val=$qgrp) order by ctime desc"
     1.8 +  cond="where a.id in (select id from blog_s where key='owner' and val=$qgrp) order by 稼動状態, ctime desc"
     1.9    colstate="state:稼動状態:frozen=rowclass=凍結"
    1.10    DT_CHLD=article:blogid \
    1.11  	 DT_QOWNER="$qgrp" \