title: Limit not working on count distinct? mysql
body: <p>I have this to count how many messages an user has:</p>
  
  <pre><code>SELECT count(distinct `from`) FROM chat WHERE `to`=? and recd='0' limit 100
  </code></pre>
  
  <p>it is retorning 120.418. The limit 100 is not working. any ideas?</p>
  
  <p>if an user has more than 100 messages I'd like to count only 100.</p>