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
Vexations
.
Toggle Highlighting
SQL
#reviewed pages without talk pages that are not dismambiguation pages SELECT DISTINCT page_title FROM pagetriage_page JOIN enwiki_p.page ON page_id = ptrp_page_id JOIN templatelinks ON tl_from = page_id WHERE ptrp_last_reviewed_by = 120801 AND page_namespace = 0 AND NOT EXISTS (SELECT * FROM page AS talk WHERE talk.page_title = page.page_title AND talk.page_namespace = 1) AND tl_title NOT IN ('Disambiguation', 'disambiguation' ,'Hndis', 'human name disambiguation', 'geodis', 'Disambig', 'disambig' 'Dab', 'Disambiguation_page_short_description', ' Disambiguation/cat', 'Title_disambig_text') AND tl_namespace = 10;
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...