[rob01]

Database error in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:

			SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
			, allowsmilie, pagetext_html, postparsed.hasimages, thread.iconid AS threadiconid, iconpath AS threadiconpath, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
			FROM vbb_thread AS thread
			LEFT JOIN vbb_post AS post ON (post.postid = thread.firstpostid)
			LEFT JOIN vbb_user AS user ON (user.userid = post.userid)
			 LEFT JOIN vbb_postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1) LEFT JOIN vbb_icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN vbb_avatar as avatar ON (avatar.avatarid = user.avatarid)
				LEFT JOIN vbb_customavatar as customavatar ON (customavatar.userid = user.userid) LEFT JOIN vbb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
			WHERE thread.threadid IN(41,39,38,36,34,33,32,24,22,21)
			AND thread.dateline > 1222304002

any idea?