[Moosehunter]

I have a vbrc3 tables prefix that i edited it to the queries. Now i get this message:

Invalid SQL:
SELECT COUNT(*) AS referrals, user.username, user.userid
FROM vb3_user AS users
LEFT JOIN vb3_user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1

mysql error: Unknown table 'user' in field list

mysql error number: 1109

Is there anything to edit to get rid of this message?