USE enwiki_p;

​

SELECT page_id, page_title

FROM page

JOIN categorylinks

ON page_id=cl_from

WHERE page_namespace IN (0,1)

AND cl_to IN ('Top-importance_Africa_articles',

              'High-importance_Africa_articles',

              'Mid-importance_Africa_articles',

              'Low-importance_Africa_articles',

              'NA-importance_Africa_articles',

              'Unknown-importance_Africa_articles');