Low importance featured articles

SQL

USE enwiki_p;
SELECT
  article.page_id,
  article.page_title,
  SUBSTRING_INDEX(imp.cl_to, "-", 1) AS importance
FROM page tp
INNER JOIN categorylinks imp ON
  imp.cl_from = tp.page_id AND
  (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 "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...