SQL
AخA
select
page_id,
replace(page_title, '_', ' ') as page_title,
rd_namespace,
replace(rd_title, '_', ' ') as rd_title,
coalesce(replace(rd_fragment, '_', ' '), '') as rd_fragment
from
page
join redirect on page_id = rd_from
where
page_namespace = 0
and page_is_redirect = 1
and rd_interwiki is null
limit 1000;
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.