Fork of
Orphaned subpages
by HTinC23
This query is marked as a draft
This query has been published
by EqJjgOa8rVvsRmZL.
SQL
AخA
select p1.page_namespace, p1.page_title
from page p1
where p1.page_namespace in (10, 828) and p1.page_is_redirect = 0
and p1.page_title rlike "/sandbox[^/]*" collate utf8_general_ci
and substring_index(p1.page_title, '/', 1) not in (
select p2.page_title from page p2 where p2.page_namespace = p1.page_namespace
)
limit 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.