Short top-importance articles 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_len < 3000
AND NOT EXISTS (SELECT 1
  FROM categorylinks AS cl1
  WHERE cl1.cl_from = article.page_id
  AND cl1.cl_to = 'All_disambiguation_pages'
)
AND article.page_title IN (SELECT DISTINCT talkpage.page_title
  FROM page AS talkpage
  JOIN categorylinks AS talkcat
  ON talkcat.cl_from = talkpage.page_id
  WHERE talkpage.page_namespace = 1
  AND talkcat.cl_to IN (SELECT catpage.page_title
    FROM page AS catpage
    JOIN categorylinks AS cl2
    ON catpage.page_id = cl2.cl_from
    WHERE catpage.page_namespace = 14
    AND cl2.cl_to = 'Top-importance_articles')
)
ORDER BY article.page_title;
SQL

Checking query status...
