summaryrefslogtreecommitdiffstats
path: root/lib/Db
diff options
context:
space:
mode:
authorMarco Nassabain <marco.nassabain@hotmail.com>2021-01-26 16:23:19 +0100
committerSean Molenaar <SMillerDev@users.noreply.github.com>2021-04-08 22:31:21 +0200
commitf2ef07c6612291742708260d072aef3848320c45 (patch)
tree8cb8b96cc2b15e5fd353e3542a11eddf918d86ce /lib/Db
parentf908df15b89712d1b08db8522723a44998edc018 (diff)
🔥 findAllShared: add table alias in sql statement
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
Diffstat (limited to 'lib/Db')
-rw-r--r--lib/Db/ItemMapper.php2
1 files changed, 1 insertions, 1 deletions
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);