Ticket 2895: exclude silenced users from popular notice lists

1 files changed, 1 insertions, 0 deletions

diff --git a/lib/popularity.php b/lib/popularity.php
index c5b795b8d..b6987138b 100644
--- a/lib/popularity.php
+++ b/lib/popularity.php
@@ -76,6 +76,7 @@ class Popularity
                 'notice.rendered,notice.url,notice.created,notice.modified,' .
                 'notice.reply_to,notice.is_local,notice.source,notice.conversation, ' .
                 'notice.lat,notice.lon,location_id,location_ns,notice.repeat_of';
+        $qry .= ' HAVING \'silenced\' NOT IN (SELECT role FROM profile_role WHERE profile_id=notice.profile_id)';
         $qry .= ' ORDER BY weight DESC';
 
         $offset = $this->offset;