changeset 882:a46e85d50954

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 wrap: on
line diff
--- a/s4-funcs.sh	Wed Dec 16 08:55:04 2020 +0900
+++ b/s4-funcs.sh	Wed Dec 16 09:20:52 2020 +0900
@@ -2854,7 +2854,7 @@
 	 <input type="checkbox" id="dtcheck" checked><label
 	  for="dtcheck">話題一覧表示</label>
 	EOF
-  cond="where a.id in (select id from blog_s where key='owner' and val=$qgrp) order by ctime desc"
+  cond="where a.id in (select id from blog_s where key='owner' and val=$qgrp) order by 稼動状態, ctime desc"
   colstate="state:稼動状態:frozen=rowclass=凍結"
   DT_CHLD=article:blogid \
 	 DT_QOWNER="$qgrp" \

yatex.org