SELECT main.page_namespace, main.page_title

FROM page AS talk

JOIN categorylinks AS v5

  ON v5.cl_from = talk.page_id

  AND v5.cl_to = 'All_Wikipedia_level-5_vital_articles'

JOIN page AS main

  ON main.page_namespace = talk.page_namespace - 1

  AND main.page_title = talk.page_title

LEFT JOIN categorylinks AS sdesc

  ON sdesc.cl_from = main.page_id

  AND sdesc.cl_to = 'Articles_with_short_description'

WHERE sdesc.cl_from IS NULL;

​