From 6ebd6036445a0a4527bd5bec67fa97528272b1a2 Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard Date: Sun, 27 May 2018 09:20:34 +0200 Subject: Also sort by ID in article overview. This is good because it puts new articles on top so you can edit them faster. --- mulkcms.lisp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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") -- cgit v1.2.3