Merge pull request #3422 from annando/1705-diaspora-comments-2

[friendica.git] / include / notifier.php

diff --git a/include/notifier.php b/include/notifier.php
index e3d7d10d6b2a7595e76143eaf60ae4cf4b6e78d3..370611b4eb438aaf69509aee01622e80d15436a9 100644 (file)
--- a/include/notifier.php
+++ b/include/notifier.php
@@ -516,7 +516,8 @@ function notifier_run(&$argv, &$argc){
                                $r0 = Diaspora::relay_list();
                        }
 
-                       $r1 = q("SELECT DISTINCT(`batch`), `id`, `name`,`network` FROM `contact` WHERE `network` = '%s'
+                       $r1 = q("SELECT `batch`, ANY_VALUE(`id`) AS `id`, ANY_VALUE(`name`) AS `name`, ANY_VALUE(`network`) AS `network`
+                               FROM `contact` WHERE `network` = '%s'
                                AND `uid` = %d AND `rel` != %d AND NOT `blocked` AND NOT `pending` AND NOT `archive` GROUP BY `batch` ORDER BY rand()",
                                dbesc(NETWORK_DIASPORA),
                                intval($owner['uid']),