Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Certes
.
Toggle Highlighting
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
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...