Need Help with double LEFT JOIN SQL Query

[ZomgStuff]

Originally Posted by Boofo

How does the query look now? I'm curious to see what you came up with.

[SQL] SELECT p.postid, p.threadid, p.pagetext, t.threadid, t.title, r.*
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(t.threadid = p.threadid)
WHERE r.rating = '".$rate_id."' AND r.uid = '".$user_id."' AND p.userid = '".$thisUser."'
ORDER BY p.postid DESC
[/SQL]