[Opserty]

[sql]
SELECT p.postid, p.threadid, p.title, p.pagetext, r.*, t.threadtitle
FROM " . TABLE_PREFIX . "erate AS r
LEFT JOIN ".TABLE_PREFIX."post AS p ON(p.postid = r.pid)
LEFT JOIN ".TABLE_PREFIX."thread AS t ON(p.threadid = t.threadid)
WHERE r.rating = '".$rate_id."' AND r.uid = '".$user_id."' AND p.userid = '".$thisUser."'
ORDER BY p.postid DESC
[/sql]
I think that should work, not tested though. Might be a more efficient way of doing it but thats the way I would have done it