protected function _buildQueryJoins(KDatabaseQuery $query) { parent::_buildQueryJoins($query); $query->join('LEFT', 'categories AS categories', 'categories.id = tbl.catid'); $query->join('LEFT', 'users AS user', 'user.id = tbl.user_id'); }
protected function _buildQueryJoins(KDatabaseQuery $query) { parent::_buildQueryJoins($query); $query->join('LEFT', 'menu_types AS menu', 'tbl.menutype = menu.menutype') ->join('LEFT', 'components AS component', 'component.id = tbl.componentid AND tbl.type = "component"') ->join('LEFT', 'groups AS group', 'group.id = tbl.access'); }
protected function _buildQueryJoins(KDatabaseQuery $query) { parent::_buildQueryJoins($query); $query->join('LEFT', 'menu AS page', 'tbl.menutype = page.menutype'); }