Quality category of articles in enwiki_p

SQL

SELECT
	cl_from AS Page_ID,
    cl_to AS Category,
    
    # lists
    CASE WHEN UPPER(cl_to) LIKE "%LIST%CLASS%" THEN 1 ELSE 0 END AS 'List',
    CASE WHEN UPPER(cl_to) LIKE "%CL%CLASS%" THEN 1 ELSE 0 END AS CL,
    CASE WHEN UPPER(cl_to) LIKE "%BL%CLASS%" THEN 1 ELSE 0 END AS BL,
    CASE WHEN UPPER(cl_to) LIKE "%AL%CLASS%" THEN 1 ELSE 0 END AS AL,
    CASE WHEN UPPER(cl_to) LIKE "%FL%CLASS%" THEN 1 ELSE 0 END AS FL,
    
    # miscellaneous
    CASE WHEN UPPER(cl_to) LIKE "%FUTURE%CLASS%" THEN 1 ELSE 0 END AS Future,
    CASE WHEN UPPER(cl_to) LIKE "%CURRENT%CLASS%" THEN 1 ELSE 0 END AS 'Current',
    
    # articles
    CASE WHEN UPPER(cl_to) LIKE "%STUB%CLASS%" THEN 1 ELSE 0 END AS Stub,
    CASE WHEN UPPER(cl_to) LIKE "%START%CLASS%" THEN 1 ELSE 0 END AS 'Start',
    CASE WHEN UPPER(cl_to) LIKE "%C%CLASS%" THEN 1 ELSE 0 END AS C,
    CASE WHEN UPPER(cl_to) LIKE "%B%CLASS%" THEN 1 ELSE 0 END AS B,
    CASE WHEN UPPER(cl_to) LIKE "%GA%CLASS%" THEN 1 ELSE 0 END AS GA,
    CASE WHEN UPPER(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
	UPPER(cl_to) LIKE "%LIST%CLASS%"
    OR UPPER(cl_to) LIKE "%CL%CLASS%"
    OR UPPER(cl_to) LIKE "%BL%CLASS%"
    OR UPPER(cl_to) LIKE "%AL%CLASS%"
    OR UPPER(cl_to) LIKE "%FL%CLASS%"
    OR UPPER(cl_to) LIKE "%FUTURE%CLASS%"
    OR UPPER(cl_to) LIKE "%CURRENT%CLASS%"
    OR UPPER(cl_to) LIKE "%STUB%CLASS%"
    OR UPPER(cl_to) LIKE "%START%CLASS%"
    OR UPPER(cl_to) LIKE "%C%CLASS%"
    OR UPPER(cl_to) LIKE "%B%CLASS%"
    OR UPPER(cl_to) LIKE "%GA%CLASS%"
    OR UPPER(cl_to) LIKE "%FA%CLASS%"
GROUP BY
	cl_from
limit 20 #testing
SQL

Checking query status...
