[1mdiff --git a/model.py b/model.py[m
[1mindex 2ddf23b..ac89e72 100644[m
[1m--- a/model.py[m
[1m+++ b/model.py[m
[36m@@ -1467,12 +1467,16 @@[m [mclass Database:[m
(fol.type={FOLLOW_SUBSPACE} AND fol.target=p.subspace) OR[m
(fol.type={FOLLOW_USER} AND fol.target=p.user))[m
"""[m
[31m- MUTE_COND_JOIN = f"""[m
[32m+[m[32m MUTE_ALL_COND_JOIN = f"""[m
LEFT JOIN mute mt[m
ON mt.user=? AND[m
[31m- ((mt.type={MUTE_POST} AND mt.target=p.id) OR[m
[31m- (mt.type={MUTE_SUBSPACE} AND mt.target=p.subspace) OR[m
[31m- (mt.type={MUTE_USER} AND mt.target=p.user))[m
[32m+[m[32m ((mt.type={MUTE_SUBSPACE} AND mt.target=p.subspace) OR[m
[32m+[m[32m (mt.type={MUTE_USER} AND mt.target=p.user))[m
[32m+[m[32m """[m
[32m+[m[32m MUTE_SUBSPACE_COND_JOIN = f"""[m
[32m+[m[32m LEFT JOIN mute mt[m
[32m+[m[32m ON mt.user=? AND[m
[32m+[m[32m (mt.type={MUTE_USER} AND mt.target=p.user)[m
"""[m
TAG_FILTER_JOIN = "JOIN tags tg ON tg.post=p.id"[m
[m
[36m@@ -1489,7 +1493,8 @@[m [mclass Database:[m
filter = Database.FOLLOW_FILTER_JOIN[m
values.append(filter_by_followed.id)[m
if muted_by_user_id:[m
[31m- filter += Database.MUTE_COND_JOIN[m
[32m+[m[32m filter += Database.MUTE_ALL_COND_JOIN if subspace is None \[m
[32m+[m[32m else Database.MUTE_SUBSPACE_COND_JOIN[m
values.append(muted_by_user_id)[m
if filter_tag:[m
filter += Database.TAG_FILTER_JOIN[m
[36m@@ -1632,7 +1637,8 @@[m [mclass Database:[m
filter = Database.FOLLOW_FILTER_JOIN[m
values.append(filter_by_followed.id)[m
if muted_by_user_id:[m
[31m- filter += Database.MUTE_COND_JOIN[m
[32m+[m[32m filter += Database.MUTE_ALL_COND_JOIN if subspace is None \[m
[32m+[m[32m else Database.MUTE_SUBSPACE_COND_JOIN[m
values.append(muted_by_user_id)[m
cond.append('mt.user IS NULL')[m
if filter_tag:[m
text/plain
This content has been proxied by September (ba2dc).