Links to redirects from incomplete disambiguation to non-dabs

SQL

SELECT Pr.page_title AS Redirect, Pt.page_title AS Target, COUNT(*) LinkCount, MIN(Pf.page_title) AS LinkFrom1, MAX(Pf.page_title) AS LinkFrom2
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 lt_namespace=0 AND lt_title=Pr.page_title
JOIN pagelinks ON pl_target_id=lt_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 Cd.cl_from IS NULL
GROUP BY Redirect, Target
ORDER BY Redirect, Target

SQL

Checking query status...