most linked redirects (space to non-space)

SQL

USE enwiki_p;
SELECT COUNT(DISTINCT(page_title))
FROM pagelinks 
LEFT JOIN page ON pl_namespace = page_namespace AND pl_title = page_title
LEFT JOIN redirect ON page_id = rd_from
WHERE page_is_redirect = 1 
AND page_namespace = 0 
AND rd_namespace = 0 
AND pl_from_namespace = 0
AND EXISTS (
    SELECT null 
    FROM page
    WHERE pl_from = page_id 
    AND page_is_redirect=0
)
AND EXISTS (
    SELECT null
    FROM page
    WHERE page_title = rd_title 
    AND EXISTS (
        SELECT null
        FROM page_props
        WHERE page_id = pp_page AND pp_propname = 'disambiguation'
    )
);

SQL

Checking query status...