Quality category of articles in cawiki_p

SQL

SELECT
	cl_from AS Page_ID,
    cl_to AS Category,
    CASE WHEN cl_to LIKE "%Llistes%qualitat%" THEN 1 ELSE 0 END AS FL,
    CASE WHEN cl_to LIKE "%Articles%qualitat%" THEN 1 ELSE 0 END AS FA,
    CASE WHEN cl_to LIKE "%Articles%bons%" THEN 1 ELSE 0 END AS GA,
    COUNT(DISTINCT rev_id) AS Edit_count,
    COUNT(DISTINCT rev_user) AS Editors
FROM
	cawiki_p.categorylinks
INNER JOIN
	cawiki_p.revision 
    ON revision.rev_page = cl_from
WHERE
	cl_to LIKE "%Articles%bons%"
    OR cl_to LIKE "%Articles%qualitat%"
    OR cl_to LIKE "%Llistes%qualitat%"
GROUP BY
	cl_from
limit 20 #testing

SQL

Checking query status...