title: Can I Select Distinct inside a where and get all selects in mysql?
body: <p>I have this:</p>
  
  <hr>
  
  <pre><code>SELECT FirstName
  FROM MAIN_TABLE_LEVEL100
  WHERE FirstName IN
      (
          SELECT DISTINCT FirstName
          FROM MAIN_TABLE_LEVEL100
      )
  ORDER BY `level` DESC, `time` DESC LIMIT 0,10
  </code></pre>
  
  <hr>
  
  <p>Im trying to get top 10 diferents names order by level and time, but it doesn't work, if someone can help me please, thanks.</p>