Determine destinations of various redirects on the English Wikipedia

Fork of Determine destinations of various redirects on the English Wikipedia by Mahir256

This query is marked as a draft This query has been published by Edgars2007.

Not sure if it could be made more efficient...

SQL

use enwiki_p;
select page_title as page_origin, rd_title as page_destination
from redirect
inner join page on redirect.rd_from=page.page_id
where replace(page_title, "_", " ") in (
  "Constitution (France)", "Constitution of france", "Constitution of the Fifth Republic", "Constitution of the French Fifth Republic", "France constitution", "French Constitution", "French constitution", "French Constitution of 1958", "French constitution of 4 October 1958"
);

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...