title: using group() breaks getSelectCountSql in magento
body: <p>When I'm using </p>
  
  <pre><code>$collection-&gt;getSelect()-&gt;group('entity_id')
  </code></pre>
  
  <p>or </p>
  
  <pre><code>$collection-&gt;groupByAttribute('entity_id')
  </code></pre>
  
  <p>It breaks getSelectCountSql and I'm getting 1 record and 1 page.
  Magento does </p>
  
  <pre><code>$countSelect-&gt;columns('COUNT(DISTINCT e.entity_id)');
  </code></pre>
  
  <p>Is there a way to fix it?</p>
  
  <p>I run into it,While overriding _prepareCollection of Mage_Adminhtml_Block_Catalog_Product_Grid</p>
  
  <p>Thanks</p>