vb db error

[KJThaDon]

I usually can get these type of errors fixed but this thing is just a pain in my ass, and I cannot figure out what it is wanting. Anyone got a clue?

Getting this anytime trying to access the usercp.php
Thanks

Database error in vBulletin 3.8.0:

Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
						d.*, gm.*, user.*,
						gm.ipaddress AS itemipaddress, d.lastpost AS lastpost, d.lastpostid AS lastpostid	,deletionlog.userid AS del_userid, deletionlog.username AS del_username,
						deletionlog.reason AS del_reason ,IF(d.lastpost <= discussionread.readtime,1,0) AS is_read, discussionread.readtime AS readtime ,subscribediscussion.emailupdate		
					FROM vb_discussion AS d
					INNER JOIN vb_groupmessage AS gm
						ON (gm.gmid = d.firstpostid)
					LEFT JOIN vb_user AS user ON (gm.postuserid = user.userid) LEFT JOIN vb_discussionread AS discussionread
						ON (discussionread.discussionid = d.discussionid
						AND discussionread.userid = 2) INNER JOIN vb_subscribediscussion AS subscribediscussion
						ON (subscribediscussion.discussionid = d.discussionid
						AND subscribediscussion.userid = 2)	LEFT JOIN vb_deletionlog AS deletionlog
									ON (gm.gmid = deletionlog.primaryid AND deletionlog.type = 'groupmessage')
					
					WHERE 1=1 AND (gm.state IN ('visible','moderation','deleted')) 
						 ORDER BY d.lastpost ASC;

MySQL Error   : Unknown column 'd.lastpost' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, February 17th 2009 @ 02:05:45 AM
Error Date    : Tuesday, February 17th 2009 @ 02:05:47 AM
Script        : http://**********.com/usercp.php
Referrer      : http://**********.com/
IP Address    : **.***.**.***
Username      : KJThaDon
Classname     : vB_Database
MySQL Version : 5.0.67-community