title: mysql condition in a select
body: <p>My table:</p>
  
  <pre><code>id | elite | pos
  1  |   0   |  9  
  2  |   1   |  8
  3  |   0   |  7
  4  |   1   |  6
  5  |   0   |  5
  6  |   1   |  4
  7  |   0   |  3
  8  |   1   |  2
  9  |   0   |  1
  10 |   1   |  0
  </code></pre>
  
  <p>I have this simple query </p>
  
  <pre><code>SELECT id, elite FROM tbl LIMIT 0, 5 ORDER BY pos DESC
  </code></pre>
  
  <p>It will return the <code>id 1 2 3 4 5</code>. Over time, these values were to change. The result must have always a count of 5, however if on the result there are at least one <code>id</code> with an <code>elite &gt;= 1</code>, the result must not contain any more <code>id</code> with an <code>elite</code> having the <code>1</code> value. So the result must not contain <code>id</code> having more than one <code>elite &gt;= 1</code>.</p>
  
  <p>Is this possible within a query?</p>