SQL
AخA
select sp.page_title, tp.page_title, rd_namespace, rd_interwiki from redirect
join page sp on sp.page_id = rd_from
join page tp on tp.page_title = rd_title and tp.page_namespace = rd_namespace and tp.page_is_direct = 1
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.