/** * Search trainings */ protected function searchTrainings() { $this->TotalNumberOfTrainings = DB::getInstance()->query('SELECT COUNT(*) FROM `' . PREFIX . 'training` AS `t` ' . $this->getWhere() . $this->getOrder() . ' LIMIT 1')->fetchColumn(); $this->Page = (int) Request::param('page'); if (($this->Page - 1) * $this->ResultsPerPage > $this->TotalNumberOfTrainings) { $this->Page--; } $this->DatasetQuery->resetJoins(); $this->Trainings = DB::getInstance()->query('SELECT DISTINCT `t`.`id`, `t`.`time` ' . ($this->multiEditorRequested() ? '' : ', ' . $this->DatasetQuery->queryToSelectAllKeys() . ' ' . $this->DatasetQuery->queryToSelectJoinedFields()) . ' FROM `' . PREFIX . 'training` AS `t` ' . $this->DatasetQuery->queryToJoinTables() . ' ' . $this->getWhere() . ' ' . $this->DatasetQuery->queryToGroupByActivity() . $this->getOrder() . $this->getLimit())->fetchAll(); }