title: Combine 2 counts with different where on the same table
body: <p>Is there a better way of doing this ?</p>
  
  <pre><code>SELECT
    (SELECT count(*) FROM `tbl` WHERE `status` = 0) as 'text1',
    (SELECT count(*) FROM `tbl` WHERE `status` &gt; 0) as 'text2'
  </code></pre>
  
  <p>text1 and text2 are headers.</p>