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 TalkCat.cl_to = "Sports_and_games_work_group_articles"

    AND Article.page_len < 3000

),

​

reference AS (

  SELECT page_title, el_to_domain_index AS ref

  FROM articles

  JOIN externallinks ON el_from = page_id

)

​

SELECT ref, COUNT(ref) as number, page_title as example

FROM reference

GROUP BY ref

ORDER BY number DESC