most linked redirects (space to non-space)

SQL

use fawiki_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 ( # pl_from in non-redirect ids
    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...