title: How to get count & other columns for the same table in same query?
body: <p>I am trying the below MySql query - </p>
  
  <pre><code>SELECT count(*), bug_id, 
         bug_status, 
         resolution, 
         short_desc, 
         DATE_FORMAT(deadline, "%m/%d/%Y")AS deadline
  FROM   bugs 
  WHERE  ( bug_status IN ( 'RESOLVED', 'VERIFIED', 'INTEST' ) 
           AND deadline BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY) 
         ) 
          OR ( bug_status IN ( 'RESOLVED', 'VERIFIED', 'INTEST' ) 
               AND deadline BETWEEN DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND 
                                    CURDATE() )        
         ORDER BY deadline ASC
  </code></pre>
  
  <p>but it returns the result with only one column as opposed to all 96 entries..</p>
  
  <p><img src="https://i.stack.imgur.com/5QKaH.png" alt="enter image description here"></p>
  
  <p>What could be the better idea so that I get count first and then all the results ?</p>