changeset 229:787a577cc3ce

order by ctime in latest news
author HIROSE Yuuji <yuuji@gentei.org>
date Thu, 23 Jun 2016 21:05:56 +0859
parents ab1693ac909a
children 67c8b9558572
files s4-funcs.sh
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/s4-funcs.sh	Mon Jun 20 18:56:42 2016 +0859
+++ b/s4-funcs.sh	Thu Jun 23 21:05:56 2016 +0859
@@ -1404,7 +1404,7 @@
             else 1
        end
  group by bl.id
- having "新着" > 0 order by "新着" desc, bl.id
+ having "新着" > 0 order by ctime desc, "新着" desc, bl.id
  limit 10;
 EOF
 }

yatex.org