Largest FA promotion of the year

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
  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
LEFT JOIN fac b ON b.year=a.year AND b.rev_len>a.rev_len
WHERE b.year IS NULL
ORDER BY a.year

SQL

Checking query status...