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
Lopullinen
.
Toggle Highlighting
SQL
WITH pages_vg_talk AS ( SELECT page.page_title FROM page JOIN categorylinks AS cat1 ON cat1.cl_to = '任天堂工作组条目' AND cat1.cl_type = 'page' AND cat1.cl_from = page.page_id JOIN categorylinks AS cat2 ON cat2.cl_to = '优良条目讨论' -- '典范条目讨论', '特色列表讨论', '优良条目讨论', '推薦的新條目' AND cat1.cl_from = cat2.cl_from WHERE page.page_namespace = 1 ) SELECT CONCAT(REPLACE(page_title, '_', ' ')) AS result FROM pages_vg_talk
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...