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 ArticleCat.cl_to NOT 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')
  	AND (TalkCat.cl_to LIKE '%iography%')
  	AND Article.page_len < 2500
),

contributions AS (
  SELECT articles.page_title, articles.page_id, articles.InitialSize, articles.CurrentSize, articles.rev_timestamp, childRev.rev_len as "ChildRevLen", parentRev.rev_len as "ParentRevLen"
  FROM articles
  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 = ct_rev_id AND (ct_tag_id = 590 OR ct_tag_id = 1) #reverted or undo
  WHERE ct_rev_id IS NULL
)

SELECT page_title, page_id, InitialSize, CurrentSize, rev_timestamp, SUM(CASE WHEN (CAST(ParentRevLen as SIGNED) - CAST(ChildRevLen as SIGNED)) > 200 THEN 1 ELSE 0 END) as ContributorCount
FROM contributions
GROUP BY page_id
SQL

Checking query status...
