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
DatGuy
.
List of GAs to be used when updating the "promote an eighth of the following articles to GA" TODO in User:DatGuy
Toggle Highlighting
SQL
SELECT page_title FROM page JOIN categorylinks ON page_id = cl_from WHERE page_namespace = 0 AND cl_to = 'Nations_at_the_2016_Summer_Olympics' AND NOT (page_title LIKE 'Chad%' OR page_title LIKE 'East Timor%' OR page_title LIKE 'Federated States of Micronesia%' OR page_title LIKE 'Israel%' OR page_title LIKE 'Ivory Coast%' OR page_title LIKE 'Kuwait%' OR page_title LIKE 'Maldives%' OR page_title LIKE 'Republic of the Congo%' OR page_title LIKE 'Somalia%' OR page_title LIKE 'South Sudan%' OR page_title like 'Swaziland%' OR page_title like 'Tanzania%') AND page_title IN ( SELECT page_title FROM page JOIN categorylinks ON page_id = cl_from WHERE page_namespace = 0 AND cl_to = 'Good_articles' OR cl_to = 'Featured_articles' );
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...