[surfhog]

sorry to ask boofo

I am getting db error, can you tell me what i may have done wrong please and thanks

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT user.userid, user.username, COUNT(post.postid) AS postcount
FROM vb3_post
LEFT JOIN vb3_thread ON (post.threadid = thread.threadid)
LEFT JOIN vb3_user ON (post.userid = user.userid)
WHERE thread.forumid=2
GROUP BY post.userid
ORDER BY postcount DESC
LIMIT 1

mysql error: Unknown table 'user' in field list

mysql error number: 1109