X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FForum.pm;h=a2f1cb89952e3021cd59ce63854b9a2cebbe366b;hb=fcd1ee7b280d01a082b3a868a56145f970251f5d;hp=a9a1f0d5dc98143bb3d37f8eea870ce947a10307;hpb=acd22833d74158d4b5320578987f372464bef7b7;p=ndwebbie.git

diff --git a/lib/NDWeb/Controller/Forum.pm b/lib/NDWeb/Controller/Forum.pm
index a9a1f0d..a2f1cb8 100644
--- 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