Untitled query #4655

SQL

use dewiki_p;
SELECT  (SELECT pa.page_title from page as pa where pa.page_id=pl.pl_from) as lemma, pl.pl_title as disambiguation
FROM pagelinks as pl
INNER JOIN page as p ON p.page_namespace=pl.pl_namespace and p.page_title=pl.pl_title 
INNER JOIN page_props as pp ON p.page_id=pp.pp_page
WHERE pp.pp_propname='disambiguation' 
AND pl.pl_from_namespace=0 
AND NOT EXISTS (SELECT 1 FROM page_props as pc WHERE pc.pp_propname='disambiguation' and  pl.pl_from=pc.pp_page)
AND NOT EXISTS (SELECT 1 FROM page as pr WHERE pr.page_is_redirect=1 and pl.pl_from=pr.page_id )
limit 100 offset 0;
SQL

Checking query status...
