YOB 1914 Olympian stubs by creator

Pages in both [[Category:1914 births]], [[Category:All stub articles]], and at least one category containing "Olympi", broken down by creator.

SQL

SET @yr='1914_births';

WITH results AS
(SELECT COUNT(rev_page) AS pages, actor_name 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
     JOIN categorylinks AS olym ON olym.cl_from = birth.cl_from
     WHERE birth.cl_to = @yr
       AND stub.cl_to = 'All_stub_articles'
       AND olym.cl_to LIKE '%Olympi%')
   GROUP BY rev_page)
 GROUP BY actor_name)
SELECT SUM(pages) AS pages, 'TOTAL' AS creator FROM results
UNION
SELECT * FROM results ORDER BY pages DESC, creator ASC;

SQL

Checking query status...