Top-importance stubs on enwiki

SQL

USE enwiki_p;
SELECT DISTINCT article.page_title
FROM page AS article
WHERE article.page_namespace = 0
AND article.page_is_redirect = 0
AND article.page_title IN (SELECT DISTINCT talkpage.page_title
  FROM page AS talkpage
  JOIN categorylinks AS cat1
  ON cat1.cl_from = talkpage.page_id
  JOIN categorylinks AS cat2
  ON cat2.cl_from = talkpage.page_id
  WHERE talkpage.page_namespace = 1
  AND cat1.cl_to IN (SELECT catpage1.page_title
    FROM page AS catpage1
    JOIN categorylinks AS cl1
    ON catpage1.page_id = cl1.cl_from
    WHERE catpage1.page_namespace = 14
    AND cl1.cl_to = 'Stub-Class_articles')
  AND cat2.cl_to IN (SELECT catpage2.page_title
    FROM page AS catpage2
    JOIN categorylinks AS cl2
    ON catpage2.page_id = cl2.cl_from
    WHERE catpage2.page_namespace = 14
    AND cl2.cl_to = 'Top-importance_articles')
)
ORDER BY article.page_title;
SQL

Checking query status...
