[steven s]

Am I missing a table?

Database error in vBulletin 3.5.4:

Invalid SQL:

			SELECT AVG(MonthlyPostCount) AS 'PostCountAvg' 
			FROM 
			(
				SELECT count(*) AS 'MonthlyPostCount' 
				FROM post 
				WHERE dateline < UNIX_TIMESTAMP(NOW()) - DAYOFMONTH(NOW()) * 86400
				GROUP BY YEAR(FROM_UNIXTIME(dateline)), MONTH(FROM_UNIXTIME(dateline))
			)
			AS posts;

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(*) AS 'MonthlyPostCount' 
				FROM post 
				WHE
Error Number : 1064