Links to redirects from incomplete disambiguation to non-dabs

SQL

SELECT Pf.page_title, Pr.page_title, Pt.page_title
FROM categorylinks Cr
JOIN redirect ON rd_from=Cr.cl_from AND rd_namespace=0
JOIN page Pr ON Pr.page_id=Cr.cl_from AND Pr.page_namespace=0
JOIN page Pt ON Pt.page_namespace=0 AND Pt.page_title=rd_title
LEFT JOIN categorylinks Cd ON Cd.cl_from=Pt.page_id AND Cd.cl_type="page" AND Cd.cl_to="All_disambiguation_pages"
JOIN linktarget ON tl_namespace=0 AND tl_title=Pr.page_title
JOIN pagelinks ON pl_target_id=tl_id AND pl_from_namespace=0
JOIN page Pf ON Pf.page_id=pl_from AND Pf.page_namespace=0
WHERE Cr.cl_type="page" AND Cr.cl_to="Redirects_from_incomplete_disambiguation" AND Cr.cl_from_namespace=0
AND Cd.cl_from IS NULL
LIMIT 10;

SQL

Checking query status...