Need help in writing a query
 

I'd like to be able to write a query without later doing a php validation "test" where I can find a thread in the thread table that the current user is "allowed" to see. It seems to me from looking at various code that after pulling threads, vbulletin always seem to run "tests" to see if the user can view a thread. That's fine if you pull 20 threads and only show the good ones (look at the "similar threads" code for an example). But if you "LIMIT 1", then why can't you just select a thread that the current viewer can look at?

You mean this?

$fperms = fetch_permissions($simthread['forumid']);
if (($fperms & CANVIEW) AND
(($fperms & CANVIEWOTHERS) OR ($bbuserinfo['userid'] != 0 AND $simthread['postuserid'] == $bbuserinfo['userid']))
)

There's no way to skip that.

That's not good :)