/** * Minimize usual count select * * @return \Magento\Framework\DB\Select */ public function getSelectCountSql() { /* @var $countSelect \Magento\Framework\DB\Select */ $countSelect = parent::getSelectCountSql(); $countSelect->resetJoinLeft(); return $countSelect; }