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 this 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 DESC
SQL

Checking query status...
