From 74f09ee7160c6ec1d2e67e47b91e96ec863be455 Mon Sep 17 00:00:00 2001 From: Sean Molenaar Date: Tue, 4 May 2021 21:05:27 +0200 Subject: db: no longer order by items.last_modified Signed-off-by: Sean Molenaar Signed-off-by: Benjamin Brahmer --- lib/Db/ItemMapperV2.php | 4 ---- 1 file changed, 4 deletions(-) (limited to 'lib') diff --git a/lib/Db/ItemMapperV2.php b/lib/Db/ItemMapperV2.php index 6e50a5fb5..d215b4e26 100644 --- a/lib/Db/ItemMapperV2.php +++ b/lib/Db/ItemMapperV2.php @@ -302,7 +302,6 @@ class ItemMapperV2 extends NewsMapperV2 ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id') ->where('feeds.user_id = :userId') ->setParameter('userId', $userId) - ->orderBy('items.last_modified', 'DESC') ->addOrderBy('items.id', 'DESC') ->setMaxResults(1); @@ -337,7 +336,6 @@ class ItemMapperV2 extends NewsMapperV2 'feedId' => $feedId, 'userId'=> $userId, ]) - ->orderBy('items.last_modified', 'DESC') ->addOrderBy('items.id', 'DESC'); if ($hideRead === true) { @@ -373,7 +371,6 @@ class ItemMapperV2 extends NewsMapperV2 ->andWhere('feeds.deleted_at = 0') ->andWhere('folders.id = :folderId') ->setParameters(['updatedSince' => $updatedSince, 'folderId' => $folderId, 'userId' => $userId]) - ->orderBy('items.last_modified', 'DESC') ->addOrderBy('items.id', 'DESC'); if ($hideRead === true) { @@ -403,7 +400,6 @@ class ItemMapperV2 extends NewsMapperV2 ->andWhere('feeds.deleted_at = 0') ->andWhere('feeds.user_id = :userId') ->setParameters(['updatedSince' => $updatedSince, 'userId' => $userId]) - ->orderBy('items.last_modified', 'DESC') ->addOrderBy('items.id', 'DESC'); switch ($feedType) { -- cgit v1.2.3