SQL
AخA
USE nlwiki_p;
/* Note: we have to use AS because Quarry cannot handle columns with the same name. */
SELECT pf.page_namespace AS from_ns, pf.page_title AS from_title, pt.page_title AS to_title
FROM page pf, page pt, categorylinks
WHERE pt.page_namespace=14 AND pt.page_is_redirect=1 AND cl_to=pt.page_title AND cl_from=pf.page_id;
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.