Untitled query #83869

SQL

SELECT
  p.page_title AS Title,
  MAX(CASE WHEN cl2.cl_to LIKE 'FA-Class%' THEN 'FA'
           WHEN cl2.cl_to LIKE 'GA-Class%' THEN 'GA'
           WHEN cl2.cl_to LIKE 'B-Class%' THEN 'B'
           WHEN cl2.cl_to LIKE 'C-Class%' THEN 'C'
           WHEN cl2.cl_to LIKE 'Start-Class%' THEN 'Start'
           WHEN cl2.cl_to LIKE 'Stub-Class%' THEN 'Stub'
           WHEN cl2.cl_to LIKE 'List-Class%' THEN 'List'
           ELSE 'NA' END) AS Quality,
  MAX(CASE WHEN cl2.cl_to LIKE '%-Top-importance%' THEN 'Top'
           WHEN cl2.cl_to LIKE '%-High-importance%' THEN 'High'
           WHEN cl2.cl_to LIKE '%-Mid-importance%' THEN 'Mid'
           WHEN cl2.cl_to LIKE '%-Low-importance%' THEN 'Low'
           ELSE 'NA' END) AS Importance
FROM
  categorylinks cl
JOIN
  page p ON cl.cl_from = p.page_id
LEFT JOIN
  categorylinks cl2 ON cl2.cl_from = p.page_id
WHERE
  cl.cl_to = 'WikiProject_Climate_change_articles'
GROUP BY
  p.page_title
ORDER BY
  Quality, Importance;
SQL

Checking query status...
