Current revision of featured articles (enwiki - Nov. 2016)

This query is marked as a draft This query has been published by EpochFail.

This query gets the most recent revision ID of all featured class articles in English Wikipedia.  It was last updated on November 3rd, 2016.

SQL

SELECT DISTINCT article.page_latest AS rev_id
FROM page AS talk
INNER JOIN page AS article ON
  talk.page_title = article.page_title
INNER JOIN categorylinks ON
  cl_from = talk.page_id AND 
  cl_to LIKE "FA-Class_%"
WHERE
  talk.page_namespace = 1 AND
  article.page_namespace = 0
ORDER BY RAND()
LIMIT 10000;

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.

SQL

Checking query status...