From 5c7838e9bdd7081008483913def07a3233daa9fd Mon Sep 17 00:00:00 2001
From: anoy <anoymouserver+github@mailbox.org>
Date: Wed, 3 Feb 2021 19:45:03 +0100
Subject: fix result ordering for purging query

updated_date is currently always NULL

Signed-off-by: anoy <anoymouserver+github@mailbox.org>
---
 CHANGELOG.md            | 3 +++
 lib/Db/ItemMapperV2.php | 2 +-
 2 files changed, 4 insertions(+), 1 deletion(-)

diff --git a/CHANGELOG.md b/CHANGELOG.md
index ba9be14d1..865095975 100644
--- a/CHANGELOG.md
+++ b/CHANGELOG.md
@@ -3,10 +3,13 @@ All notable changes to this project will be documented in this file.
 The format is almost based on [Keep a Changelog](https://keepachangelog.com/en/1.0.0/), older entries don't fully match.
 
 ## [Unreleased]
+
 ### Changed
 
 ### Fixed
 - Release: create signature file (#1117)
+- Articles are refetched after purging leaving them unread again (#1122)
+
 ## [15.2.2] - 2021-02-02
 
 ### Fixed
diff --git a/lib/Db/ItemMapperV2.php b/lib/Db/ItemMapperV2.php
index 1525d6941..ecc635e32 100644
--- a/lib/Db/ItemMapperV2.php
+++ b/lib/Db/ItemMapperV2.php
@@ -167,7 +167,7 @@ class ItemMapperV2 extends NewsMapperV2
             ->from($this->tableName)
             ->where('feed_id = :feedId')
             ->andWhere('starred = false')
-            ->orderBy('updated_date', 'DESC');
+            ->orderBy('last_modified', 'DESC');
 
         if ($removeUnread === false) {
             $rangeQuery->andWhere('unread = false');
-- 
cgit v1.2.3