1896-1904 Lugnuts Olympian Biographies

SQL

WITH articles AS (
  SELECT DISTINCT(Article.page_title), Article.page_id, rev_timestamp, rev_len as "InitialSize", Article.page_len as "CurrentSize"
FROM revision_userindex
JOIN page AS Article ON Article.page_id = rev_page AND Article.page_namespace = 0 
JOIN page AS Talk ON Article.page_title = Talk.page_title AND Talk.page_namespace = 1
JOIN categorylinks AS ArticleCat ON ArticleCat.cl_from = Article.page_id
JOIN categorylinks AS TalkCat ON TalkCat.cl_from = Talk.page_id
WHERE rev_parent_id = 0
	AND Article.page_is_redirect = 0
  	AND rev_actor = 482
  	AND (ArticleCat.cl_to LIKE '%1896_Summer_Olympics'
    	OR ArticleCat.cl_to LIKE '%1900_Summer_Olympics'
        OR ArticleCat.cl_to LIKE '%1904_Summer_Olympics'
        OR ArticleCat.cl_to LIKE '%1908_Summer_Olympics'
        OR ArticleCat.cl_to LIKE '%1912_Summer_Olympics')
  	AND (TalkCat.cl_to LIKE '%iography%')
  	AND Article.page_len < 2500
),

WITH articlessansmedalists AS (
  SELECT page_title, page_id, rev_timestamp, InitialSize, CurrentSize
  FROM articles
  LEFT JOIN categorylinks as ArticleCatExc ON ArticleCatExc.cl_from = page_id AND ArticleCatExc.cl_to IN (
      'Medalists at the 1896 Summer Olympics',
      'Medalists at the 1900 Summer Olympics',
      'Medalists at the 1904 Summer Olympics',
      'Medalists at the 1908 Summer Olympics',
      'Medalists at the 1912 Summer Olympics')
  WHERE ArticleCatExc.cl_to IS NULL
),

articledaycount AS (
  SELECT LEFT(rev_timestamp, 8) AS date, COUNT(*) as datecount
	FROM revision_userindex
	JOIN page ON page_id = rev_page
	WHERE rev_parent_id = 0
  		AND page_is_redirect = 0
  		AND rev_actor = 482
  		AND page_namespace = 0
    GROUP BY date
),

contributions AS (
  SELECT articlessansmedalists.page_title, articlessansmedalists.page_id, articlessansmedalists.InitialSize, articlessansmedalists.CurrentSize, articlessansmedalists.rev_timestamp, childRev.rev_len as "ChildRevLen", parentRev.rev_len as "ParentRevLen"
  FROM articlessansmedalists
  LEFT JOIN revision_userindex AS childRev ON page_id = childRev.rev_page AND rev_actor != 482
  LEFT JOIN revision AS parentRev ON childRev.rev_parent_id = parentRev.rev_id
  LEFT JOIN change_tag ON childRev.rev_id = ct_rev_id AND (ct_tag_id = 590 OR ct_tag_id = 1) #reverted or undo
  WHERE ct_tag_id IS NULL
)

SELECT page_title, InitialSize, CurrentSize, (CAST(CurrentSize AS SIGNED) - CAST(InitialSize AS SIGNED)) as Growth, rev_timestamp, datecount, SUM(CASE WHEN (CAST(ParentRevLen as SIGNED) - CAST(ChildRevLen as SIGNED)) > 200 THEN 1 ELSE 0 END) as ContributorCount
FROM contributions
JOIN articledaycount ON date = LEFT(rev_timestamp, 8)
GROUP BY page_id
SQL

Checking query status...
