Underreferenced Sports Biographies - All database sources, excludes Lugnuts

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
),

reference AS (
  SELECT DISTINCT(page_id)
  FROM articles
  JOIN externallinks ON el_from = page_id
  WHERE LEFT(el_index,3) NOT IN ("<ref>", 
                                  "<REF>", 
                                  "<Ref>", 
)

SELECT page_title, CurrentSize
FROM articles
WHERE page_id NOT IN (SELECT * FROM reference)
ORDER BY page_title ASC

SQL

Checking query status...