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
)

SELECT page_title, articles.rev_timestamp, InitialSize, CurrentSize, SUM(CASE WHEN (parent.rev_len - child.rev_len) > 200 AND child.rev_actor != 482 THEN 1 ELSE 0 END) AS edits
FROM articles
JOIN revision AS child ON page_id = child.rev_page
JOIN revision AS parent ON child.rev_id = parent.rev_parent_id
GROUP BY page_title
SQL

Checking query status...
