title: Replace "IN" with a JOIN Statement
body: <p>Again I'm having troubles while migrating from <strong>Access</strong> to <strong>MySQL</strong>.</p>
  
  <p>The following SQL Statements works fine with <strong>Access</strong>:</p>
  
  <pre><code>SELECT *
  FROM tbl_content 
  WHERE contentID IN (
       SELECT contentID
       FROM tbl_tags
       WHERE Bezeichnung IN (
                SELECT Bezeichnung
                FROM tbl_tags t2
                WHERE t2.contentID= " &amp; contentID &amp; ")
       AND contentID &lt;&gt; " &amp; contentID &amp; ")
  AND Status = 1
  ORDER BY Datum DESC LIMIT 0,5;
  </code></pre>
  
  <p>In <strong>MySQL</strong>the performance is really slow. Any ideas for help?</p>