title: mySQL subquery limit
body: <p>This is probably an easy one... how can I achieve what i want with this query:</p>
  
  <pre><code>delete from posts where id not in
  (SELECT id FROM posts order by timestamp desc limit 0, 15)
  </code></pre>
  
  <p>so, to put it in a nutshell, I want to delete every post that isn't on the latest 15.</p>
  
  <p>When I try that query, I get that </p>
  
  <blockquote>
    <p>MySQL doesn't yet support 'LIMIT &amp; IN/ALL/ANY/SOME subquery</p>
  </blockquote>
  
  <p>EDIT</p>
  
  <pre><code>mySQL Server version: 5.5.8
  mySQL Client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $
  </code></pre>
  
  <blockquote>
    <p>Error: #1235 - This version of MySQL doesn't yet support 'LIMIT &amp;
    IN/ALL/ANY/SOME subquery'</p>
  </blockquote>