protected function _buildQueryJoins(KDatabaseQuery $query) { if ($this->_state->task) { $query->join('left', 'jedi_tasks AS tasks', 'tasks.jedi_task_id = tbl.jedi_task_id'); } if ($this->_state->member) { $query->join('left', 'jedi_members AS members', 'members.jedi_member_id = tbl.jedi_member_id'); } parent::_buildQueryJoins($query); }
protected function _buildQueryJoins(KDatabaseQuery $query) { $query->join('LEFT', 'jedi_ranks AS r', 'tbl.jedi_rank_id = r.jedi_rank_id'); parent::_buildQueryJoins($query); }