table join to multiple join

[hinksta]

I have a query that has two tables with a join and works fine, the tables are from a vbulletin database and the query is from an old unsupported mod.
I’m trying to add a third table to the query, I’m a bit new to joins and having a bit of trouble getting it to work.

This is the original query

[PHP]$NewestThreads = $vbdb->query("
select t.*,p.pagetext
from ".TABLE_PREFIX."thread t
left join ".TABLE_PREFIX."post p on(p.postid=t.firstpostid)
{$SQL}
order by lastpost desc
limit 0,$Amount");[/PHP]

Here is my attempt trying to add a third join, the “forum” table.

[PHP]$NewestThreads = $vbdb->query("
SELECT t.*, p.pagetext, f.*
FROM ".TABLE_PREFIX."thread t, ".TABLE_PREFIX."post p, ".TABLE_PREFIX."forum f
WHERE `p`.`postid` = `t`.`firstpostid` AND `t`.`forumid` = `f`.`forumid`
{$SQL}
ORDER BY lastpost DESC
LIMIT 0,$Amount");[/PHP]

Hope you can help me learn a thing or two about multiple joins.