summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMatthias Andreas Benkard <code@mail.matthias.benkard.de>2018-05-27 09:20:34 +0200
committerMatthias Andreas Benkard <code@mail.matthias.benkard.de>2018-05-27 09:20:34 +0200
commit6ebd6036445a0a4527bd5bec67fa97528272b1a2 (patch)
treeea7aa42c3c1942bce75d75d35cb5618604fcb999
parentdd0cece91f3b5b083ea910650d7b40d44d887921 (diff)
Also sort by ID in article overview.
This is good because it puts new articles on top so you can edit them faster.
-rw-r--r--mulkcms.lisp2
1 files changed, 1 insertions, 1 deletions
diff --git a/mulkcms.lisp b/mulkcms.lisp
index 062fe8f..852b8e5 100644
--- a/mulkcms.lisp
+++ b/mulkcms.lisp
@@ -986,7 +986,7 @@
LEFT OUTER JOIN article_publishing_dates pd
ON pd.article = a.id
GROUP BY a.id, pd.publishing_date
- ORDER BY pd.publishing_date DESC"
+ ORDER BY pd.publishing_date DESC, a.id DESC"
:rows))
(article-data (mapcar #'paramify-article-row articles)))
(expand-page (template "article_summary_page")