SQL
x
select count(page_title, rd_title) from page join redirect on rd_from = page_id and rd_namespace = 0
where page_namespace = 0 and page_is_redirect = 1
and page_title in (select page_title from page where page_namespace = 1 and page_is_redirect = 0 and page_len = 0)
/*
select count(*) from page where page_namespace = 1 and page_is_redirect = 0
and page_title in (select page_title from page where page_namespace = 0 and page_is_redirect = 1)
and page_len = 0
*/
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.