SELECT user.*,userfield.field5 FROM subscribethread,user,userfield WHERE subscribethread.threadid
SELECT user.*,userfield.field5 FROM subscribethread,user,userfield,usergroup WHERE subscribethread.threadid