Magento Toolbar not working with custom Sorting code

Question

I was trying to Sort product listing with created_at and group by Name, that why i added

$this->_productCollection->addAttributeToSort('created_at', 'desc')
                ->getSelect()->group('name');;

before

return $this->_productCollection;

in function _getProductCollection()

//app/code/local/Mage/Catalog/Block/Product/list.php

sorting is working fine but pagination and item quantity showing wrong.

enter image description here It looks like only 1 products but i have much product here and i have not changed anything in toolbar page.

Dushyant Joshi Dushyant Joshi · Accepted Answer · 2013-05-17T05:34:25

The following url will be useful.

Checkout the function

getSelectCountSql