SQL
AخA
USE fawiki_p;
SELECT COUNT(DISTINCT(page_title))
FROM pagelinks JOIN page
WHERE page_is_redirect=1
AND page_namespace=0
AND page_id IN (
SELECT rd_from
FROM redirect
WHERE rd_namespace=0
AND rd_title IN (
SELECT page_title
FROM page
WHERE page_id IN (
SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation')
)
)
AND pl_from IN (
SELECT page_id
FROM page
WHERE page_is_redirect=0)
AND pl_title=page_title
AND pl_namespace = 0
AND pl_from_namespace=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.