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
.
Project pages, help pages, categories, templates and Scribunto modules on Dutch non-Wikipedia wikis that are not linked in Wikidata but have a page of the same (sub)name in Dutch Wikipedia. Monstrous query with REGEXPs across 7 databases, but executes in ~10 s.
Toggle Highlighting
SQL
SELECT 'nlwikibooks' AS db, page_namespace, page_title, page_is_new, page_len FROM nlwikibooks_p.page b WHERE page_is_redirect=0 AND page_namespace IN (10, 14, 828) AND page_title NOT REGEXP '/doc$' AND NOT EXISTS (SELECT * FROM nlwikibooks_p.page_props WHERE page_id=pp_page AND pp_propname='wikibase_item') AND EXISTS (SELECT * FROM nlwiki_p.page w WHERE b.page_namespace=w.page_namespace AND b.page_title=w.page_title) UNION SELECT 'nlwikinews' AS db, page_namespace, page_title, page_is_new, page_len FROM nlwikinews_p.page b WHERE page_is_redirect=0 AND page_namespace IN (10, 14, 828) AND page_title NOT REGEXP '/doc$' AND NOT EXISTS (SELECT * FROM nlwikinews_p.page_props WHERE page_id=pp_page AND pp_propname='wikibase_item') AND EXISTS (SELECT * FROM nlwiki_p.page w WHERE b.page_namespace=w.page_namespace AND b.page_title=w.page_title) UNION SELECT 'nlwikiquote' AS db, page_namespace, page_title, page_is_new, page_len FROM nlwikiquote_p.page b WHERE page_is_redirect=0 AND page_namespace IN (10, 14, 828) AND page_title NOT REGEXP '/doc$' AND NOT EXISTS (SELECT * FROM nlwikiquote_p.page_props WHERE page_id=pp_page AND pp_propname='wikibase_item') AND EXISTS (SELECT * FROM nlwiki_p.page w WHERE b.page_namespace=w.page_namespace AND b.page_title=w.page_title) UNION SELECT 'nlwikisource' AS db, page_namespace, page_title, page_is_new, page_len FROM nlwikisource_p.page b WHERE page_is_redirect=0 AND page_namespace IN (10, 14, 828) AND page_title NOT REGEXP '/doc$' AND NOT EXISTS (SELECT * FROM nlwikisource_p.page_props WHERE page_id=pp_page AND pp_propname='wikibase_item') AND EXISTS (SELECT * FROM nlwiki_p.page w WHERE b.page_namespace=w.page_namespace AND b.page_title=w.page_title) ORDER BY page_namespace, page_title, db
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...