summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBernhard Posselt <dev@bernhard-posselt.com>2015-11-28 15:30:26 +0100
committerBernhard Posselt <dev@bernhard-posselt.com>2015-11-28 15:30:26 +0100
commit6ca631ff5c0b7d3fef16604ee4ed87354e3bbf72 (patch)
tree5fad4b3ed44675e72d26be22d4b914bf99f961b2
parent41cb0fd7f9c8545dba983fc644a4e9e583b1353d (diff)
Revert "only read duplicated feed items for active user"
-rw-r--r--db/itemmapper.php5
1 files 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);
}