[Stryker412]

I got an error when doing a recount.

Invalid SQL:
SELECT
post.userid, COUNT(userid) AS times
FROM vb3_thread
INNER JOIN vb3_post ON thread.lastpostid=post.postid
WHERE post.userid=1
GROUP BY post.userid
ORDER BY post.dateline DESC, post.userid;

MySQL Error : Unknown column 'post.userid' in 'field list'
Error Number : 1054
Request Date : Friday, February 27th 2009 @ 09:24:13 AM
Error Date : Friday, February 27th 2009 @ 09:24:14 AM