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