/** * @return mixed */ private function baseQuery() { $page_model = $this->repository->getPageModel(); $query = $page_model->select('pages.*')->where('is_trashed', '=', '0')->where('is_home', '=', '0'); if ($this->parent_page_id !== null) { $query->where('pages.parent_page_id', $this->parent_page_id); } $query->join('pageversions', 'pages.id', '=', 'pageversions.page_id'); $query->where('pageversions.version', '=', \DB::raw('pages.current_version')); return $query; }