Devise\Templates\TemplatesCleaner::getAllLivePageVersionIds PHP Method

    private function getAllLivePageVersionIds($view)
    {
        return DB::table('dvs_page_versions')->join(\DB::raw('(SELECT MAX(starts_at) as max_starts, page_id FROM dvs_page_versions GROUP BY page_id) newest_version'), function ($join) {
            $join->on('newest_version.max_starts', '=', 'dvs_page_versions.starts_at');
            $join->on('newest_version.page_id', '=', 'dvs_page_versions.page_id');
        })->join('dvs_pages', 'dvs_pages.id', '=', 'dvs_page_versions.page_id')->where('dvs_pages.view', $view)->lists('dvs_page_versions.id');
    }