MySQL Error

[Ntenze]

Any help would be appreciated.

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, i.userid AS installed,
user.*, userfield.*
, '' AS field9
FROM vb3_post AS post
LEFT JOIN vb3_user AS user ON(user.userid = post.userid)
LEFT JOIN vb3_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb3_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN vb3_hacks_install AS i ON(i.threadid=2005 AND post.userid=i.userid)
WHERE threadid = 2005 AND post.visible = 1
ORDER BY postid

mysql error: Column: 'threadid' in where clause is ambiguous

mysql error number: 1052


Thanks Ntenze

[Xenon]

change

WHERE threadid = 2005 AND post.visible = 1

into
WHERE post.threadid = 2005 AND post.visible = 1

[Ntenze]

Thank you Xenon. Done the trick. :)

[Xenon]

you're welcome :)