s4
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 diff
1.1 --- a/s4-funcs.sh Mon Jun 20 18:56:42 2016 +0859 1.2 +++ b/s4-funcs.sh Thu Jun 23 21:05:56 2016 +0859 1.3 @@ -1404,7 +1404,7 @@ 1.4 else 1 1.5 end 1.6 group by bl.id 1.7 - having "新着" > 0 order by "新着" desc, bl.id 1.8 + having "新着" > 0 order by ctime desc, "新着" desc, bl.id 1.9 limit 10; 1.10 EOF 1.11 }