From bef5be827d15bc54c9b88bc10313b28172069fef Mon Sep 17 00:00:00 2001
From: Mario Vavti <mario@mariovavti.com>
Date: Mon, 16 Apr 2018 11:42:13 +0200
Subject: remove some more distinct in queries and observe any regressions.
this is related to issue #1079 and commit
d47ea20aa8bb8219f7a0760e81ba3db542392390
---
Zotlabs/Module/Pubstream.php | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
(limited to 'Zotlabs/Module/Pubstream.php')
diff --git a/Zotlabs/Module/Pubstream.php b/Zotlabs/Module/Pubstream.php
index 79f205a22..45487e3a4 100644
--- a/Zotlabs/Module/Pubstream.php
+++ b/Zotlabs/Module/Pubstream.php
@@ -224,7 +224,7 @@ class Pubstream extends \Zotlabs\Web\Controller {
);
}
else {
- $r = q("SELECT distinct parent AS item_id, $ordering FROM item
+ $r = q("SELECT parent AS item_id FROM item
left join abook on item.author_xchan = abook.abook_xchan
$net_query
WHERE true $uids $item_normal_update
--
cgit v1.2.3