Code:
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT count(inthread) as viewers, inthread, thread.title FROM vb3_session
LEFT JOIN vb3_thread as thread ON thread.threadid=session.inthread
WHERE inthread > 0
AND lastactivity >= 1119495417
GROUP BY inthread ORDER BY viewers DESC
mysql error: Unknown table 'session' in on clause
mysql error number: 1109
works with . TABLE_PREFIX . added to to session.inforum