/**
* Get sql for get record count
*
* @return string
*/
public function getSelectCountSql()
{
$select = parent::getSelectCountSql();
$select->reset(Zend_Db_Select::COLUMNS);
$select->reset(Zend_Db_Select::GROUP);
$select->reset(Zend_Db_Select::HAVING);
$select->columns('COUNT(DISTINCT main_table.news_id)');
return $select;
}
/**
* Account for group and having clauses, if any
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
if (!$this->_interferWithCountSql) {
return parent::getSelectCountSql();
}
$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);
//$countSelect->columns('COUNT(*)');
return $countSelect;
}
/**
* Get SQL for get record count.
* Extra GROUP BY strip added.
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
$countSelect = parent::getSelectCountSql();
$countSelect->reset(Zend_Db_Select::GROUP);
return $countSelect;
}
/**
* Returns select count sql
*
* @return string
*/
public function getSelectCountSql()
{
$select = parent::getSelectCountSql();
$countSelect = clone $this->getSelect();
$countSelect->reset(Zend_Db_Select::HAVING);
return $select;
}
/**
* Minimize usual count select
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
return parent::getSelectCountSql()->resetJoinLeft();
}
/**
* Get SQL for get record count
* Modified because model uses GROUP BY
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
return parent::getSelectCountSql()->reset(Zend_Db_Select::GROUP);
}
