Fork of
Orphaned archive pages
by Aidan9382
This query is marked as a draft
This query has been published
by Aidan9382.
SQL
AخA
select distinct CONCAT("{{User:Aidan9382//adle|1=Talk:",SUBSTR(page_title,1,LENGTH(page_title)-4),"}}") as basepage_title
from page
where page_namespace = 1
and page_is_redirect = 0
and page_title rlike "/GA[1-9]$" -- Covers enough cases
and exists (
select 1
from page as basepage
where basepage.page_namespace = 1
and basepage.page_is_redirect = 1
and basepage.page_title = SUBSTR(page.page_title,1,LENGTH(page.page_title)-4)
)
order by basepage_title asc;
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.