[Logician]

ok I am not writing this at home so I cant access my vbulletin db and I may be wrong, but this should work:

There is pre-definded object in vb code that make queries for you in vb db and you can use it for your queries. Eg.

Defeine your query like that:
$your_query=$DB_site->query("
SELECT s.userid, u.username FROM subscribethread s, user u WHERE u.userid=s.userid AND s.threadid='$threadid' ORDER BY u.username");

Then get the result like this:
$your_result=$DB_site->fetch_array($your_query);

As for profile fields I need to take a look at table structure, but if I'm not wrong it was in "user(s)" table.

Regards,