title: using count and suppress/ignore group by
body: <p>Is it possible to have <code>count</code> in the select clause with a <code>group by</code> which is suppressed in the count? I need the <code>count</code> to ignore the <code>group by</code> clause</p>
  
  <p>I got this query which is counting the total entries. The query is generic generated and therefore I can't make any comprehensive changes like subqueries etc.</p>
  
  <p>In some specific cases a group by is needed to retrieve the correct rows and because of this the group by can't be removed</p>
  
  <pre><code>SELECT count(dv.id) num
  FROM `data_voucher` dv
  LEFT JOIN `data_voucher_enclosure` de ON de.data_voucher_id=dv.id
  WHERE IF(de.id IS NULL,0,1)=0
  GROUP BY dv.id
  </code></pre>