[The-Ensemble]

Whoops that was the error message from after I tried editing it to get it to work,
here the error message from when Its using the original query.

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT user.*, user.options
FROM vb_user AS user
LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
WHERE vb_user.usergroupid = 8;

MySQL Error : Unknown table 'vb_user' in where clause
Error Number : 1109