SQL
x
USE enwiki_p;
SELECT count(*) AS total_main_redirects
FROM page
JOIN redirect
ON page_id=rd_from
WHERE rd_namespace=0
AND page_namespace=0;
SELECT count(*) AS num_target_redirects
FROM page ps
JOIN redirect
ON page_id=rd_from
JOIN page pt
ON (rd_namespace=pt.page_namespace
AND rd_title=pt.page_title)
WHERE ps.page_namespace=0
AND rd_namespace=0
AND pt.page_is_redirect=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.