User:DatGuy Olympics GAs

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'
  -- exclude ones that were already done when the list was created
  AND NOT (page_title REGEXP '^(Chad|East_Timor|Federated_States_of_Micronesia|Israel|Ivory_Coast|Kuwait|Maldives|Republic_of_the_Congo|Somalia|South_Sudan|Swaziland|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'
  )
ORDER BY page_title;
SQL

Checking query status...
