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
Doktor Wu
.
Toggle Highlighting
SQL
SELECT page_to_correct.page_title as to_correct, to_disamb.pl_title as disambiguation_page, to_correct_page.pl_title as correct_page FROM page as page_to_correct, page as disambpage, categorylinks as cl, pagelinks as to_disamb, pagelinks as to_correct_page, pagelinks as from_disamb_page Where disambpage.page_id <= 10000 AND cl.cl_to = 'Begriffsklärung' AND cl.cl_from= disambpage.page_id AND to_disamb.pl_title=disambpage.page_title AND to_disamb.pl_title not like '%Begriffsklärung%' AND to_disamb.pl_from_namespace = 0 AND to_disamb.pl_namespace = 0 AND to_correct_page.pl_namespace = 0 AND to_disamb.pl_from = page_to_correct.page_id AND to_correct_page.pl_from = page_to_correct.page_id AND from_disamb_page.pl_from = disambpage.page_id AND from_disamb_page.pl_title = to_correct_page.pl_title ORDER BY disambpage.page_id DESC Limit 100;
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...