SQL
AخA
USE etwiki_p;
SELECT r.source_title, r.redirect_title FROM
(SELECT fromP.page_title AS redirect_title,
toP.page_id AS source_id,
toP.page_title AS source_title
FROM redirect
JOIN page AS fromP ON fromP.page_id = rd_from
JOIN page AS toP ON toP.page_title = rd_title
WHERE rd_namespace = 0) AS r
JOIN pagelinks ON pl_from = r.source_id AND pl_title = r.redirect_title
LIMIT 99;
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.