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 importance_link ON
  cl.cl_from = tp.page_id AND
  (cl.cl_to LIKE "Top-importance%articles" OR
   cl.cl_to LIKE "High-importance%articles" OR
   cl.cl_to LIKE "Mid-importance%articles" OR
   cl.cl_to LIKE "Low-importance%articles" OR
   cl.cl_to LIKE "Unknown-importance%articles")
INNER JOIN categorylinks quality_link ON
  cl.cl_from = tp.page_id AND 
  (cl.cl_to LIKE "B-Class_%" OR
   cl.cl_to LIKE "GA-Class_%" OR
   cl.cl_to LIKE "A-Class_%" OR
   cl.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...