subscribe thread sql?

Hi guys, just checked out the new forum, two thumbs up!


What is the sql (or even just the requirements) for a subscribed thread?

For example, I'm trying to display all the subscribed threads for a given user, but it appears I'm missing something.

I tried

select thread.title 
from thread, subscribethread 
where userid=$userid 
and subscribethread.threadid = thread.threadid 
and thread.visible=1 
and thread.open = 1

but what it returned was a lot different from the subscribed thread display in the user cp.

[Admin]

Take a look at usercp.php, this part:

// ############################### start new subscribed to threads ###############################