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);
}
