diff options
author | Bernhard Posselt <bernhard@posselt.at> | 2015-11-28 14:56:02 +0100 |
---|---|---|
committer | Bernhard Posselt <bernhard@posselt.at> | 2015-11-28 14:56:02 +0100 |
commit | 41cb0fd7f9c8545dba983fc644a4e9e583b1353d (patch) | |
tree | 65e63cc156f9ad044b27a959eb39e130a0220f45 /db/itemmapper.php | |
parent | 30e66657b8709e95240da4f252a3fce6797acfda (diff) |
only read duplicated feed items for active user
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r-- | db/itemmapper.php | 5 |
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); } |