diff options
author | Bernhard Posselt <dev@bernhard-posselt.com> | 2016-04-07 00:11:20 +0200 |
---|---|---|
committer | Bernhard Posselt <dev@bernhard-posselt.com> | 2016-04-07 00:11:20 +0200 |
commit | 75839b01dd1a8224f033876b2cacd6b1d2c97cb2 (patch) | |
tree | 0d5e8c5f68024a631702d79c8cc0b0f70cd939d7 /db | |
parent | c552533794a24ee8fd431b2307a2b1610746c657 (diff) |
revert it
Diffstat (limited to 'db')
-rw-r--r-- | db/itemmapper.php | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index db7505a5e..8ccb3ca06 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -386,11 +386,11 @@ class ItemMapper extends NewsMapper { // marking an item as unread should only mark the selected instance // as unread if ($isRead) { - $sql = 'UPDATE `*PREFIX*news_items` AS `items` - SET `items`.`status` = `items`.`status` & ? - AND `items`.`last_modified` = ? - WHERE `items`.`fingerprint` = ? - AND `items`.`feed_id` IN ( + $sql = 'UPDATE `*PREFIX*news_items` + SET `status` = `status` & ? + AND `last_modified` = ? + WHERE `fingerprint` = ? + AND `feed_id` IN ( SELECT `f`.`id` FROM `*PREFIX*news_feeds` AS `f` WHERE `f`.`user_id` = ? )'; |