Replicas browser and optimizer
This query is marked as a draft
This query has been published
This query gets the most recent revision ID of all featured class articles in English Wikipedia. It was last updated on November 3rd, 2016.
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;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in