Also list boards with no threads

[ndwebbie.git] / lib / NDWeb / Controller / Forum.pm

diff --git a/lib/NDWeb/Controller/Forum.pm b/lib/NDWeb/Controller/Forum.pm
index a9a1f0d5dc98143bb3d37f8eea870ce947a10307..a2f1cb89952e3021cd59ce63854b9a2cebbe366b 100644 (file)
--- a/lib/NDWeb/Controller/Forum.pm
+++ b/lib/NDWeb/Controller/Forum.pm
@@ -33,7 +33,7 @@ SELECT fcid,category,fb.fbid,fb.board
        ,date_trunc('seconds',max(ft.mtime)::timestamp ) AS last_post
 FROM forum_categories fc
        JOIN forum_boards fb USING (fcid)
-       JOIN forum_threads ft USING (fbid)
+       LEFT OUTER JOIN forum_threads ft USING (fbid)
        LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1)
                ftv USING (ftid)
 WHERE fbid IN (SELECT fbid FROM forum_access