diff options
author | Mike Cochrane <mikec@mikenz.geek.nz> | 2008-07-20 05:48:32 -0400 |
---|---|---|
committer | Mike Cochrane <mikec@mikenz.geek.nz> | 2008-07-20 05:48:32 -0400 |
commit | fdfb8068014176a2443265018a0a53027d535506 (patch) | |
tree | 61c55403e3091f7ad1f67bb27d2e8ca5e0dc59bc | |
parent | e20362a60aa670a734f73449bffa96ba1492d9e2 (diff) |
Sort tags by highest frequency then most recent
darcs-hash:20080720094832-533db-91b0cf2e0589ca4008b3011d5acd41449caa0904.gz
-rw-r--r-- | actions/tag.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/actions/tag.php b/actions/tag.php index e073a4837..9e0b09324 100644 --- a/actions/tag.php +++ b/actions/tag.php @@ -90,7 +90,7 @@ class TagAction extends StreamAction { $tags->selectAdd('count(1) as num'); $tags->selectAdd('max(notice_id) as last_notice_id'); $tags->groupBy('tag'); - $tags->orderBy('num DESC'); + $tags->orderBy('num DESC, last_notice_id DESC'); $tags->whereAdd('created > "' . strftime('%Y-%m-%d %H:%M:%S', strtotime('-1 WEEK')) . '"'); $page = ($this->arg('page')) ? ($this->arg('page')+0) : 1; |