public function getSelectCountSql()
{
if ($this->_isGroupSql) {
$this->_renderFilters();
$countSelect = clone $this->getSelect();
$countSelect->reset(Zend_Db_Select::ORDER);
$countSelect->reset(Zend_Db_Select::LIMIT_COUNT);
$countSelect->reset(Zend_Db_Select::LIMIT_OFFSET);
$countSelect->reset(Zend_Db_Select::COLUMNS);
if (count($this->getSelect()->getPart(Zend_Db_Select::GROUP)) > 0) {
$countSelect->reset(Zend_Db_Select::GROUP);
$countSelect->distinct(true);
$group = $this->getSelect()->getPart(Zend_Db_Select::GROUP);
$countSelect->columns("COUNT(DISTINCT " . implode(", ", $group) . ")");
} else {
$countSelect->columns('COUNT(*)');
}
return $countSelect;
}
return parent::getSelectCountSql();
}
/**
* Init collection count select
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
return parent::getSelectCountSql()->reset(Zend_Db_Select::GROUP);
}
