update as

1 files changed, 6 insertions, 6 deletions

diff --git a/db/itemmapper.php b/db/itemmapper.php
index a2ad70a67..db7505a5e 100644
--- a/db/itemmapper.php
+++ b/db/itemmapper.php
@@ -386,12 +386,12 @@ class ItemMapper extends NewsMapper {
         // marking an item as unread should only mark the selected instance
         // as unread
         if ($isRead) {
-            $sql = 'UPDATE `*PREFIX*news_items`
-                SET `status` = `status` & ?
-                    AND `last_modified` = ?
-                WHERE `fingerprint` = ?
-                    AND feed_id IN (
-                        SELECT `f`.`id` FROM `*PREFIX*news_feeds` `f`
+            $sql = 'UPDATE `*PREFIX*news_items` AS `items`
+                SET `items`.`status` = `items`.`status` & ?
+                    AND `items`.`last_modified` = ?
+                WHERE `items`.`fingerprint` = ?
+                    AND `items`.`feed_id` IN (
+                        SELECT `f`.`id` FROM `*PREFIX*news_feeds` AS `f`
                             WHERE `f`.`user_id` = ?
                     )';
             $params = [~StatusFlag::UNREAD, $lastModified,