title: MySQL Inner Join With LIMIT to left table
body: <p>I have this database query</p>
  
  <pre><code>SELECT *
  FROM (`metadata` im)
  INNER JOIN `content` ic ON `im`.`rev_id`  = `ic`.`rev_id`
  WHERE `im`.`id` = '00039'
  AND `current_revision` = 1
  ORDER BY `timestamp` DESC
  LIMIT 5, 5 
  </code></pre>
  
  <p>The query limits the total rows in the result to 5. I want to limit the left table <code>metadata</code> to 5 without limiting the entire result-set.</p>
  
  <p>How should I write the query?</p>