High quality article importance classes for English Wikipedia

SQL

USE enwiki_p;
SELECT
  article.page_id,
  article.page_title,
  SUBSTRING_INDEX(cl.cl_to, "-", 1) AS importance
FROM page tp 
INNER JOIN categorylinks imp ON
  imp.cl_from = tp.page_id AND
  (imp.cl_to LIKE "Top-importance%articles" OR
   imp.cl_to LIKE "High-importance%articles" OR
   imp.cl_to LIKE "Mid-importance%articles" OR
   imp.cl_to LIKE "Low-importance%articles" OR
   imp.cl_to LIKE "Unknown-importance%articles")
INNER JOIN categorylinks qual ON
  qual.cl_from = tp.page_id AND 
  (qual.cl_to LIKE "B-Class_%" OR
   qual.cl_to LIKE "GA-Class_%" OR
   qual.cl_to LIKE "A-Class_%" OR
   qual.cl_to LIKE "FA-Class_%")
JOIN page article ON
  article.page_title = tp.page_title AND
  article.page_namespace = 0
WHERE
  tp.page_namespace = 1
GROUP BY article.page_id, importance;

SQL

Checking query status...