Error with SQL, Help?

[The-Ensemble]

I have a hack that is meant to show a certain usergroups's members and it keeps giving SQL errors, first it was a table didn't exist then something else after that, I can't get it to work.

The Original SQL Query

PHP Code:

$users = $db->query_read("
    SELECT $locationfieldselect user.*, user.options
    FROM " . TABLE_PREFIX . "user AS user
    LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
    WHERE " . TABLE_PREFIX . "user.usergroupid = 12
"); 


I'm using VB 3.6.7 if that helps at all.

Thanks in advance.