/** * Get SQL for get record count. * Reset left join, group and having parts * * @return Varien_Db_Select */ public function getSelectCountSql() { $countSelect = parent::getSelectCountSql(); if ($this->getFlag('is_customer_count_added')) { $countSelect->reset(Zend_Db_Select::GROUP); $countSelect->reset(Zend_Db_Select::HAVING); $countSelect->resetJoinLeft(); } return $countSelect; }