MySQL Help Please?

[Ntenze]

I received this email

Database error in vBulletin 3.0.1:

Invalid SQL: 
SELECT count(threadid) AS articles,
SUM(IF(lastpost>=1086532361 AND open<>10,1,0)) AS newarticle
FROM vb3_thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN (3)
        AND visible = 1
        AND open != 10
        
        AND deletionlog.primaryid IS NULL

mysql error: Unknown table 'thread' in on clause

mysql error number: 1109

Date: Sunday 06th of June 2004 04:35:40 PM
Script: http://www.forthebayarea.com/

I can clear all cookies etc. and go back to site with no problems. Others seem to get DB error. Thanks in advance for any help

[Xenon]

replace

FROM vb3_thread

with

FROM vb3_thread AS thread