CSD G8 subpages watchlist

SQL

/*
with occur as (
  select page_title, length(page_title) - length(replace(page_title, '/', '')) as occurrence from page
  where page_namespace = 10
)

select occur.page_title, occur.occurrence, subpage.page_title from occur sub
join occur sur on substring(occur.page_title, 1, length(subpage.page_title)) = subpage.page_title
where subpage.occurrence < occur.occurrence
*/

select count(*) from page where page_namespace = 10

-- select page_title, base_name, occurrence, min(occurrence) from occur group by base_name having min(occurrence) > 1;
SQL

Checking query status...
