Quality category of articles in enwiki_p

SQL

SELECT
	cl_from AS Page_ID,
    cl_to AS Category,
    
    # lists
    CASE WHEN cl_to LIKE "%List%Class%" THEN 1 ELSE 0 END AS 'List',
    CASE WHEN cl_to LIKE "%CL%Class%" THEN 1 ELSE 0 END AS CL,
    CASE WHEN cl_to LIKE "%BL%Class%" THEN 1 ELSE 0 END AS BL,
    CASE WHEN cl_to LIKE "%AL%Class%" THEN 1 ELSE 0 END AS AL,
    CASE WHEN cl_to LIKE "%FL%Class%" THEN 1 ELSE 0 END AS FL,
    
    # miscellaneous
    CASE WHEN cl_to LIKE "%Future%Class%" THEN 1 ELSE 0 END AS Future,
    CASE WHEN cl_to LIKE "%Current%Class%" THEN 1 ELSE 0 END AS 'Current',
    
    # articles
    CASE WHEN cl_to LIKE "%Stub%Class%" THEN 1 ELSE 0 END AS Stub,
    CASE WHEN cl_to LIKE "%Start%Class%" THEN 1 ELSE 0 END AS 'Start',
    CASE WHEN cl_to LIKE "%C%Class%" THEN 1 ELSE 0 END AS C,
    CASE WHEN cl_to LIKE "%B%Class%" THEN 1 ELSE 0 END AS B,
    CASE WHEN cl_to LIKE "%GA%Class%" THEN 1 ELSE 0 END AS GA,
    CASE WHEN cl_to LIKE "%FA%Class%" THEN 1 ELSE 0 END AS FA,
    
    COUNT(DISTINCT rev_id) AS Edit_count,
    COUNT(DISTINCT rev_user) AS Editors
FROM
	enwiki_p.categorylinks
INNER JOIN
	enwiki_p.revision 
    ON revision.rev_page = cl_from
WHERE
	cl_to LIKE "%List%Class%"
    OR cl_to LIKE "%CL%Class%"
    OR cl_to LIKE "%BL%Class%"
    OR cl_to LIKE "%AL%Class%"
    OR cl_to LIKE "%FL%Class%"
    OR cl_to LIKE "%Future%Class%"
    OR cl_to LIKE "%Current%Class%"
    OR cl_to LIKE "%Stub%Class%"
    OR cl_to LIKE "%Start%Class%"
    OR cl_to LIKE "%C%Class%"
    OR cl_to LIKE "%B%Class%"
    OR cl_to LIKE "%GA%Class%"
    OR cl_to LIKE "%FA%Class%"
GROUP BY
	cl_from
limit 20 #testing
SQL

Checking query status...
