From f2ef07c6612291742708260d072aef3848320c45 Mon Sep 17 00:00:00 2001
From: Marco Nassabain <marco.nassabain@hotmail.com>
Date: Tue, 26 Jan 2021 16:23:19 +0100
Subject: =?UTF-8?q?=F0=9F=94=A5=20findAllShared:=20add=20table=20alias=20i?=
 =?UTF-8?q?n=20sql=20statement?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
---
 lib/Db/ItemMapper.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib')

diff --git a/lib/Db/ItemMapper.php b/lib/Db/ItemMapper.php
index 6c804c6ac..f8cc9c4fb 100644
--- a/lib/Db/ItemMapper.php
+++ b/lib/Db/ItemMapper.php
@@ -523,7 +523,7 @@ class ItemMapper extends NewsMapper
      */
     public function findAllShared($limit, $offset, $showAll, $oldestFirst, $userId, $search)
     {
-        $sql = 'SELECT `*` FROM `*PREFIX*news_items`' .
+        $sql = 'SELECT `items`.* FROM `*PREFIX*news_items` `items`' .
             'WHERE `shared_with` = ? ';
         $sql .= $this->buildStatusQueryPart($showAll);       
         
-- 
cgit v1.2.3