Untitled query #76931

SQL

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 TalkCat1 ON TalkCat.cl_from = Talk.page_id
JOIN categorylinks AS TalkCat2 ON TalkCat.cl_from = Talk.page_id
WHERE rev_parent_id = 0
	AND Article.page_is_redirect = 0
	AND rev_actor = 482
	AND TalkCat1.cl_to = "WikiProject_Biography_articles"
	AND TalkCat2.cl_to = "WikiProject_Football_articles"
	AND Article.page_len < 2500
SQL

Checking query status...
