dao->select('*')->from(TABLE_PROJECT)->where('deleted')->eq('0')->andWhere('type')->eq('program')->beginIF(!$this->app->user->admin)->andWhere('id')->in($this->app->user->view->programs)->fi()->orderBy('grade desc, `order`')->fetchGroup('parent', 'id');?>