protected function _getListCount($query) { if ($query instanceof JDatabaseQuery && $query->type == 'select' && ($query->group !== null || $query->having !== null)) { $query = clone $query; $query->clear('select')->clear('order')->select('1'); } return parent::_getListCount($query); }