YOB 1898 stubs by creator

SQL

SET @yr='1898_births';
SELECT @yr, COUNT(rev_page), CASE actor_name='Lugnuts' WHEN 0 THEN 'everyone else' WHEN 1 THEN 'Lugnuts' END AS creator
FROM actor_revision
JOIN revision ON rev_actor = actor_id
WHERE rev_id IN
 (SELECT MIN(rev_id)
  FROM revision
  WHERE rev_page IN
   (SELECT DISTINCT birth.cl_from
    FROM categorylinks AS birth
    JOIN categorylinks AS stub ON stub.cl_from = birth.cl_from
    WHERE birth.cl_to = @yr
      AND stub.cl_to = 'All_stub_articles')
  GROUP BY rev_page)
GROUP BY creator;

SELECT @yr, COUNT(rev_page), actor_name
FROM actor_revision
JOIN revision ON rev_actor = actor_id
WHERE rev_id IN
 (SELECT MIN(rev_id)
  FROM revision
  WHERE rev_page IN
   (SELECT DISTINCT birth.cl_from
    FROM categorylinks AS birth
    JOIN categorylinks AS stub ON stub.cl_from = birth.cl_from
    WHERE birth.cl_to = @yr
      AND stub.cl_to = 'All_stub_articles')
  GROUP BY rev_page)
GROUP BY actor_name
ORDER BY COUNT(rev_page) DESC;
SQL

Checking query status...
