/**
* 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();
}
