User:WhatamIdoing/Med redirects

SELECT
  pg1.page_title
FROM page AS pg1
JOIN categorylinks
ON cl_from = pg1.page_id
WHERE pg1.page_namespace = 1
AND cl_to = 'Top-importance_medicine_articles'
AND EXISTS (SELECT
              1
            FROM page AS pg2
            WHERE pg2.page_title = pg1.page_title
            AND pg2.page_namespace = 0
            AND pg2.page_is_redirect = 1);