[pogo]

It's getting complicated.

Try this query instead of the above one

PHP Code:

SELECT threadid,title,lastpost,replycount,postusername,thread.forumid
                          FROM thread
                          LEFT JOIN forumpermission USING(forumid)
                          WHERE visible=1
                          AND (forumpermission.forumid IS NULL OR forumpermission.canview=1)
                          ORDER BY lastpost DESC LIMIT