CSD G8 subpages watchlist

SQL

select p1.page_title from page p1
where p1.page_namespace = 10 and p1.page_title like '%/%' and p1.page_is_redirect = 0
and not exists (
  select 1 from page p2
  where p2.page_namespace = p1.page_namespace -- and length(p2.page_title) < length(p1.page_title)
  and substring(p1.page_title, 1, length(p2.page_title) + 1) = concat(p2.page_title, '/')
)
/*
and p1.page_id not in (
  select cl_from from categorylinks
  where cl_to in ('Wikipedia_orphaned_talk_pages_that_should_not_be_speedily_deleted',
                  'Non-orphaned_pages_tagged_with_G8-exempt', 'Candidates_for_speedy_deletion')
)
*/
limit 10
SQL

Checking query status...
