Strul med JOIN

SELECT Forumtopic.topic, Forumtopic.id as Forumid, forumthreads.id AS 
tradid, forumthreads.rubrik, forumthreads.inlagg, forumthreads.datum, 
forumsvar.id, forumsvar.svar, forumsvar.datum FROM forumthreads INNER 
JOIN forumsvar ON forumthreads.id = forumsvar.ticketid WHERE 
forumsvar.datetime = (SELECT MAX(forumsvar.datetime) FROM forumsvar 
WHERE topicid = forumthreads.ID) INNER JOIN Forumtopic ON 
forumthreads.catid = Forumtopic.id WHERE ((rubrik LIKE '%test%') OR (inlagg 
LIKE '%test%') OR (svar LIKE '%test%')) ORDER BY forumthreads.datum asc 
limit 100

får felmeddelande:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN Forumtopic ON forumthreads.catid = Forumtopic.id WHERE ((rubrik LIKE ' at line 1

Kan ju erkänna att jag inte har riktigt pejling på de olika joinsen och vad de gör..

SELECT Forumtopic.topic, 
       Forumtopic.id as Forumid, 
       forumthreads.id AS tradid, 
       forumthreads.rubrik, 
       forumthreads.inlagg, 
       forumthreads.datum, 
       forumsvar.id, 
       forumsvar.svar, 
       forumsvar.datum 
  FROM forumtopics 
   INNER JOIN forumthreads 
     on  Forumtopic.id = forumthreads.catid
  INNER JOIN forumsvar 
    ON forumthreads.id = forumsvar.ticketid 
 WHERE forumsvar.datetime = 
   (SELECT MAX(forumsvar.datetime) 
     FROM forumsvar 
    WHERE topicid = forumthreads.ID) 
  and (rubrik LIKE '%test%'
   OR inlagg LIKE '%test%'
   OR svar LIKE '%test%') 
ORDER BY forumthreads.datum asc 
limit 100

über! :bire