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
Patsagorn Y.
.
Query is base on https://github.com/Krinkle/mw-tool-orphantalk/blob/9353b1d1642827c7c812a34e1e69f97644e8c0af/class.php#L303
Toggle Highlighting
SQL
/* OrphanTalk::getOrphans */ SELECT p2.page_title FROM page as p1 RIGHT JOIN page as p2 ON p1.page_title = p2.page_title AND p1.page_namespace = 0 WHERE p2.page_namespace = 1 AND p1.page_title IS NULL ORDER BY p2.page_namespace ASC, p2.page_title ASC LIMIT 10000
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...