summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBernhard Posselt <bernhard@posselt.at>2015-11-28 14:56:02 +0100
committerBernhard Posselt <bernhard@posselt.at>2015-11-28 14:56:02 +0100
commit41cb0fd7f9c8545dba983fc644a4e9e583b1353d (patch)
tree65e63cc156f9ad044b27a959eb39e130a0220f45
parent30e66657b8709e95240da4f252a3fce6797acfda (diff)
only read duplicated feed items for active user
-rw-r--r--db/itemmapper.php5
1 files changed, 2 insertions, 3 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php
index 6033832a0..ca80b5b79 100644
--- a/db/itemmapper.php
+++ b/db/itemmapper.php
@@ -138,14 +138,13 @@ class ItemMapper extends NewsMapper {
WHERE `a`.`feed_id` = ?
AND `a`.`id` <= ?
AND `a`.`fingerprint` = `b`.`fingerprint`
- AND EXISTS (
+ AND `b`.`feed_id` IN (
SELECT `id` FROM `*PREFIX*news_feeds`
WHERE `user_id` = ?
- AND `id` = ?
)
)';
$params = [~StatusFlag::UNREAD, $time, $feedId, $highestItemId,
- $userId, $feedId];
+ $userId];
$this->execute($sql, $params);
}