WordPress database error: [Table 'tenthumbsup.vb3_thread' doesn't exist]
SELECT
a.*, b.*, customavatar.filename as customavatar, user.avatarrevision, (
SELECT COUNT(x.postid) FROM vb3_post x WHERE x.threadid = a.threadid
) as scVBTotalPosts
FROM
vb3_thread a
LEFT OUTER JOIN
vb3_post b
ON
b.threadid = a.threadid
LEFT OUTER JOIN
vb3_customavatar customavatar
ON
customavatar.userid = b.userid
LEFT OUTER JOIN
vb3_user user
ON
user.userid = b.userid
WHERE
a.forumid='78' AND
a.title='Test'
ORDER BY
b.dateline DESC
LIMIT 20
test
Recent Comments