title: MySQL LIMIT not working
body: <p>I have a MySQL 5.0 server, and I'm running this query:</p>
  
  <pre><code>    SELECT *
      FROM deals
      WHERE expires &gt; "2012-05-25 19:37:58"
      AND city =2
      ORDER BY UIN
      LIMIT 48 , 57
  </code></pre>
  
  <p>And it's returning:</p>
  
  <blockquote>
    <p>Showing rows 0 - 29 (57 total, Query took 0.0036 sec)</p>
  </blockquote>
  
  <p>Am I doing something wrong? I expect 9 rows, 48-57..</p>