aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/queries.h2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/queries.h b/src/queries.h
index 7fbe898..9e90581 100644
--- a/src/queries.h
+++ b/src/queries.h
@@ -6,7 +6,7 @@ const char *q_select_entry =
const char *q_select_entries =
"SELECT id, title, created_at::DATE, updated_at::DATE, body "
"FROM entries "
-"ORDER BY updated_at DESC;";
+"ORDER BY updated_at DESC, created_at DESC;";
const char *q_search_entries =
"WITH query AS "