From: Michael Andreen <harv@ruin.nu>
Date: Sun, 18 Jan 2009 12:25:29 +0000 (+0100)
Subject: Also list boards with no threads
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=f60a1ba9b292e2881bbeecd9edc1515156c59a86

Also list boards with no threads
---

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