title: Multiple count functions in a SELECT query
body: <p>I have a select query like this </p>
  
  <pre><code>select count(distinct id)*100/totalcount as freq, count (distinct id) from 
  &lt;few joins, conditions, gorup by here&gt; .....
  </code></pre>
  
  <p>Will this result in 2 calculations of count under MySql 5.0? I can calculate the frequency in my appliation as well if this is a problem. I am aware of the solutions presented in <a href="https://stackoverflow.com/questions/1306112/">Adding percentages to multiple counts in one SQL SELECT Query</a> but I just want to avoid nested queries</p>