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
Bdijkstra
.
Talk page redirects where the corresponding content page exists, but isn't also a redirect.
Toggle Highlighting
SQL
USE nlwiki_p; SELECT s.page_namespace AS subject_ns, t.page_namespace AS talk_ns, s.page_title AS title, pp_propname<=>'disambiguation' AS disambig FROM `page` t INNER JOIN `page` s ON (s.page_namespace=(t.page_namespace-1) AND s.page_title=t.page_title) LEFT JOIN page_props ON (s.page_id=pp_page AND pp_propname='disambiguation') WHERE t.page_namespace != 3 AND # exclude user talk t.page_title NOT REGEXP '^(Lijst_van_|[0-9]+(-[0-9]+)?$)' AND # exclude year talk pages and lists t.page_is_redirect=1 AND (t.page_namespace MOD 2)=1 AND s.page_is_redirect=0 ORDER BY s.page_namespace, s.page_title
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...