Largest FA promotion of the year 2014-2023

SQL

WITH fac AS (
  SELECT SUBSTR(rev_timestamp,1,4) AS year, page_title, rev_timestamp, rev_len
  FROM actor
  JOIN revision_userindex ON rev_actor=actor_id AND rev_timestamp>='2003'
  JOIN `comment` ON comment_id=rev_comment_id AND comment_text LIKE "Promoting '%' to Featured Article status"
  JOIN page ON page_id=rev_page AND page_namespace=0
  WHERE actor_name='FACBot'
)
SELECT a.year, a.page_title, a.rev_timestamp, a.rev_len
FROM fac a
WHERE rev_len = (SELECT max(rev_len) FROM fac b WHERE b.year=a.year)
ORDER BY a.year, a.page_title

SQL

Checking query status...