[cono1717]

That gave me the following database error

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT COUNT(p.postid) AS total
,p.userid
,u.username
,u.joindate
,f.field7
FROM
post AS p,
userfield AS f
LEFT JOIN
user as u
ON
u.userid = p.userid
WHERE
p.dateline > 1243814400
AND p.userid = f.userid
AND p.dateline < 1246320000
GROUP BY
userid
ORDER BY
total DESC
LIMIT
30000;

MySQL Error : Unknown column 'p.userid' in 'on clause'
Error Number : 1054
Request Date : Monday, June 22nd 2009 @ 09:11:30 AM
Error Date : Monday, June 22nd 2009 @ 09:11:30 AM
Script : http://www.geekstep.com/activity.php
Referrer :
IP Address : 80.47.176.108
Username : Connor
Classname : vB_Database
MySQL Version : 5.0.81-community