diff options
Diffstat (limited to 'apioforum/forum.py')
| -rw-r--r-- | apioforum/forum.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/apioforum/forum.py b/apioforum/forum.py index d13f1fe..79bb3ee 100644 --- a/apioforum/forum.py +++ b/apioforum/forum.py @@ -155,7 +155,8 @@ def view_forum(forum,page=1): most_recent_posts.content as mrp_content, most_recent_posts.deleted as mrp_deleted FROM threads - INNER JOIN most_recent_posts ON most_recent_posts.thread = threads.id + LEFT JOIN most_recent_posts ON + most_recent_posts.thread = threads.id AND most_recent_posts.deleted = 0 INNER JOIN number_of_posts ON number_of_posts.thread = threads.id LEFT OUTER JOIN thread_tags ON threads.id = thread_tags.thread WHERE threads.forum = ? {tagfilter_clause} |