From 6ca631ff5c0b7d3fef16604ee4ed87354e3bbf72 Mon Sep 17 00:00:00 2001 From: Bernhard Posselt Date: Sat, 28 Nov 2015 15:30:26 +0100 Subject: Revert "only read duplicated feed items for active user" This reverts commit 41cb0fd7f9c8545dba983fc644a4e9e583b1353d. --- db/itemmapper.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/db/itemmapper.php b/db/itemmapper.php index ca80b5b79..6033832a0 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -138,13 +138,14 @@ class ItemMapper extends NewsMapper { WHERE `a`.`feed_id` = ? AND `a`.`id` <= ? AND `a`.`fingerprint` = `b`.`fingerprint` - AND `b`.`feed_id` IN ( + AND EXISTS ( SELECT `id` FROM `*PREFIX*news_feeds` WHERE `user_id` = ? + AND `id` = ? ) )'; $params = [~StatusFlag::UNREAD, $time, $feedId, $highestItemId, - $userId]; + $userId, $feedId]; $this->execute($sql, $params); } -- cgit v1.2.3