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 *
FROM articles

#SELECT page_title, articles.rev_timestamp, InitialSize, CurrentSize, parent.rev_len, child.rev_len, child.rev_actor
#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...
