1896-1904 Lugnuts Olympian Biographies

SQL

WITH Articles AS (
	SELECT DISTINCT(Article.page_title), Article.page_id, rev_timestamp, Article.page_len
	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
	)

SELECT page_title, rev_timestamp, page_len, count(el_from)
FROM Articles
JOIN externallinks ON page_id = el_from
GROUP BY page_title
SQL

Checking query status...
