From 0ec5d194ee1838759b2a79c574ebfdca30bc7404 Mon Sep 17 00:00:00 2001
From: Mischa POSLAWSKY <perl@shiar.org>
Date: Sun, 23 May 2021 14:50:29 +0200
Subject: [PATCH] issue/activity: ignore messages moved to spam page

---
 widget/issue/activity.php | 1 +
 1 file changed, 1 insertion(+)

diff --git a/widget/issue/activity.php b/widget/issue/activity.php
index 9ce6d53..919ce77 100644
--- a/widget/issue/activity.php
+++ b/widget/issue/activity.php
@@ -6,6 +6,7 @@ $limit = $Page->place['n'] ?? 50;
 $cols = 'm.*, i.subject, i.updated, i.closed';
 $sql = "SELECT $cols FROM messages m JOIN issues i ON i.id = issue";
 $sql .= " WHERE message IS NOT NULL";
+$sql .= " AND i.page <> 'spam'";
 $sql .= " ORDER BY m.created DESC LIMIT $limit";
 $query = $Db->query($sql);
 $rows = $query->fetchall();
-- 
2.30.0