/** * get select count sql * * @return \Zend_Db_Select */ public function getSelectCountSql() { if (!$this->_countSelect instanceof \Zend_Db_Select) { $this->setSelectCountSql(parent::getSelectCountSql()); } return $this->_countSelect; }
/** * Get SQL for get record count. * Extra GROUP BY strip added. * * @return \Magento\Framework\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; }
/** * @inheritdoc */ public function getSelectCountSql() { $countSelect = parent::getSelectCountSql(); $countSelect->reset(\Zend_Db_Select::COLUMNS); $countSelect->columns('COUNT(DISTINCT main_table.attribute_id)'); return $countSelect; }
/** * Get SQL for get record count * * Extra GROUP BY strip added. * * @return \Magento\Framework\DB\Select */ public function getSelectCountSql() { $countSelect = parent::getSelectCountSql(); $countSelect->reset(\Magento\Framework\DB\Select::GROUP); return $countSelect; }